Hello, Cloud/Amazon AthenaのCREATE TABLE AS (CTAS) を検証してみる
Posted on
ピースが揃ってきたのでは
昨今AWSを使ってサーバーレスな分析のインフラを組むときはKinesis Data Firehoseに適当にデータを突っ込めば適当な粒度で.parquet.snappyに落とし込んでくれて後はそれをAthenaで読めるようにすれば良い感じにクエリできます。
しかし出力先に柔軟性がなくてレコードに含まれる情報から日別にパーティションを切ったりするのが難しく今ひとつ惜しい感じでありました。ところが先月AthenaにCTASが入ってクエリからテーブルを作れるようになったので適当に集めたデータに対してAthenaでパーティションを切り直せるか試してみました。
対象のデータ
%sh aws s3 ls --human-readable --recursive s3://hatena-bookmark-analysis/data/user_bookmarks | grep sh19910711
2018-11-04 10:41:54 1.8 MiB data/user_bookmarks/id=sh19910711/user_bookmarks.parquet.snappy
はてブした記事のURL、タイトル、コメント、ブックマーク数などをparquetに変換してsnappyで圧縮したもの(全期間分)。
Glueの準備
%sh cat << EOF > /tmp/database.yml Resources: Database: Type: AWS::Glue::Database Properties: DatabaseInput: Name: hatebu CatalogId: !Ref AWS::AccountId UserBookmarks: Type: AWS::Glue::Table Properties: CatalogId: !Ref AWS::AccountId DatabaseName: hatebu TableInput: Name: user_bookmarks TableType: EXTERNAL_TABLE Parameters: { "parquet.compress": "SNAPPY" } StorageDescriptor: Location: 's3://hatena-bookmark-analysis/data/user_bookmarks' InputFormat: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat SerdeInfo: SerializationLibrary: org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe Parameters: { "serialization.format": "1" } Columns: - Name: title Type: string - Name: comment Type: string - Name: url Type: string - Name: user_num Type: bigint - Name: time Type: timestamp PartitionKeys: - Name: id Type: string EOF aws cloudformation deploy --stack-name hatena-bookmark-analysis-database --template-file /tmp/database.yml
Waiting for changeset to be created.. Waiting for stack create/update to complete Successfully created/updated stack - hatena-bookmark-analysis-database
GlueのData Catalogにテーブルを追加。TableInputのParametersがCREATE TABLEするときの tblproperties
に対応していて、SerdeInfoのParametersが serdeproperties
に対応している(最初どれがどれか分からなかった)。
パーティションの読み込み
%athena msck repair table hatebu.user_bookmarks
Query executed successfully. Affected rows : -1
圧縮形式やSerdeの設定に注意してください。
クエリしてみる
%athena select date, count(1) from (select date(time) as date from hatebu.user_bookmarks where id = 'sh19910711' ) where year(date) between 2016 and 2018 group by date order by date
date _col1 2016-01-03 1 2016-01-04 7 2016-01-05 7 2016-01-07 6 2016-01-09 55 2016-01-10 21 2016-01-11 1 2016-01-12 27 2016-01-13 3 2016-01-14 7 2016-01-16 4 2016-01-19 1 2016-01-20 2 2016-01-21 2 2016-01-22 7 2016-01-23 2 2016-01-24 14 2016-01-25 1 2016-01-26 3 2016-01-30 1 2016-01-31 8 2016-02-01 4 2016-02-03 2 2016-02-08 4 2016-02-09 1 2016-02-10 1 2016-02-11 1 2016-02-12 1 2016-02-13 2 2016-02-15 3 2016-02-16 11 2016-02-18 9 2016-02-19 24 2016-02-20 6 2016-02-21 8 2016-02-22 27 2016-02-23 24 2016-02-28 4 2016-02-29 7 2016-03-01 16 2016-03-02 6 2016-03-03 1 2016-03-04 5 2016-03-05 12 2016-03-06 16 2016-03-07 6 2016-03-08 8 2016-03-09 2 2016-03-11 5 2016-03-12 8 2016-03-13 8 2016-03-14 6 2016-03-15 5 2016-03-16 3 2016-03-17 2 2016-03-18 4 2016-03-19 5 2016-03-20 7 2016-03-21 16 2016-03-22 13 2016-03-23 2 2016-03-24 4 2016-03-25 12 2016-03-26 9 2016-03-27 5 2016-03-29 1 2016-03-30 7 2016-03-31 3 2016-04-01 11 2016-04-02 1 2016-04-03 3 2016-04-04 1 2016-04-05 1 2016-04-06 2 2016-04-07 3 2016-04-08 2 2016-04-09 1 2016-04-10 6 2016-04-11 1 2016-04-12 2 2016-04-13 2 2016-04-14 8 2016-04-15 1 2016-04-18 7 2016-04-19 4 2016-04-20 2 2016-04-21 7 2016-04-22 1 2016-04-23 2 2016-04-24 5 2016-04-25 5 2016-04-26 5 2016-04-27 1 2016-04-28 1 2016-04-29 1 2016-04-30 3 2016-05-01 1 2016-05-02 2 2016-05-03 4 2016-05-04 6 2016-05-05 12 2016-05-06 14 2016-05-07 9 2016-05-08 1 2016-05-09 8 2016-05-10 4 2016-05-11 1 2016-05-12 3 2016-05-13 2 2016-05-14 5 2016-05-15 3 2016-05-16 4 2016-05-17 7 2016-05-18 12 2016-05-22 3 2016-05-23 1 2016-05-24 1 2016-05-25 3 2016-05-26 5 2016-05-27 2 2016-06-03 3 2016-06-04 3 2016-06-06 14 2016-06-07 5 2016-06-09 5 2016-06-10 5 2016-06-11 3 2016-06-12 10 2016-06-13 5 2016-06-14 22 2016-06-15 27 2016-06-16 3 2016-06-17 6 2016-06-18 5 2016-06-19 5 2016-06-20 2 2016-06-21 16 2016-06-22 8 2016-06-23 16 2016-06-24 2 2016-06-26 2 2016-06-27 5 2016-06-29 6 2016-06-30 3 2016-07-04 18 2016-07-05 10 2016-07-07 1 2016-07-08 7 2016-07-10 18 2016-07-11 2 2016-07-12 8 2016-07-13 1 2016-07-14 30 2016-07-15 16 2016-07-16 8 2016-07-17 17 2016-07-18 17 2016-07-19 13 2016-07-20 11 2016-07-21 7 2016-07-22 4 2016-07-23 15 2016-07-24 16 2016-07-25 2 2016-07-26 10 2016-07-27 20 2016-07-28 22 2016-07-29 7 2016-07-30 1 2016-07-31 4 2016-08-01 11 2016-08-02 8 2016-08-03 1 2016-08-04 8 2016-08-05 7 2016-08-06 21 2016-08-07 1 2016-08-08 2 2016-08-09 2 2016-08-10 12 2016-08-11 2 2016-08-13 3 2016-08-14 14 2016-08-15 2 2016-08-16 3 2016-08-17 6 2016-08-18 9 2016-08-19 7 2016-08-20 1 2016-08-21 2 2016-08-22 6 2016-08-23 38 2016-08-24 33 2016-08-25 3 2016-08-26 19 2016-08-27 5 2016-08-28 5 2016-08-29 11 2016-08-30 17 2016-08-31 2 2016-09-01 14 2016-09-02 15 2016-09-03 5 2016-09-04 2 2016-09-05 42 2016-09-06 1 2016-09-07 2 2016-09-08 18 2016-09-09 15 2016-09-10 25 2016-09-11 3 2016-09-12 11 2016-09-13 15 2016-09-14 8 2016-09-15 15 2016-09-17 17 2016-09-18 1 2016-09-19 11 2016-09-20 9 2016-09-21 14 2016-09-22 1 2016-09-23 3 2016-09-24 1 2016-09-27 2 2016-09-28 1 2016-09-29 2 2016-09-30 9 2016-10-04 5 2016-10-05 2 2016-10-06 10 2016-10-07 11 2016-10-08 17 2016-10-09 12 2016-10-10 5 2016-10-11 6 2016-10-12 3 2016-10-13 5 2016-10-14 2 2016-10-15 3 2016-10-16 3 2016-10-17 7 2016-10-18 2 2016-10-19 1 2016-10-20 2 2016-10-21 16 2016-10-23 3 2016-10-24 12 2016-10-26 13 2016-10-27 14 2016-10-28 9 2016-10-30 1 2016-11-01 1 2016-11-04 1 2016-11-09 4 2016-11-10 8 2016-11-13 23 2016-11-14 17 2016-11-16 1 2016-11-17 3 2016-11-18 11 2016-11-19 14 2016-11-20 7 2016-11-21 5 2016-11-22 17 2016-11-23 4 2016-11-24 19 2016-11-25 9 2016-11-26 21 2016-11-27 10 2016-11-28 1 2016-11-29 18 2016-12-01 23 2016-12-02 1 2016-12-03 33 2016-12-04 3 2016-12-05 5 2016-12-06 29 2016-12-07 2 2016-12-09 34 2016-12-10 7 2016-12-14 20 2016-12-19 14 2016-12-22 14 2016-12-25 23 2016-12-26 12 2016-12-28 13 2017-01-01 22 2017-01-04 24 2017-01-06 14 2017-01-24 2 2017-01-27 1 2017-02-01 1 2017-02-02 1 2017-02-25 2 2017-03-01 2 2017-03-05 1 2017-03-10 1 2017-03-18 1 2017-03-19 2 2017-03-21 4 2017-03-22 1 2017-03-26 1 2017-03-28 1 2017-03-29 3 2017-03-30 1 2017-03-31 11 2017-04-01 5 2017-04-02 2 2017-04-04 8 2017-04-05 11 2017-04-07 1 2017-04-08 1 2017-04-09 3 2017-04-11 3 2017-04-13 7 2017-04-16 1 2017-04-17 1 2017-04-18 6 2017-04-19 3 2017-04-20 4 2017-04-21 3 2017-04-22 3 2017-04-24 2 2017-04-26 9 2017-04-28 4 2017-04-29 3 2017-04-30 4 2017-05-01 2 2017-05-02 3 2017-05-04 1 2017-05-05 3 2017-05-08 26 2017-05-09 2 2017-05-10 2 2017-05-11 1 2017-05-12 3 2017-05-15 1 2017-05-16 1 2017-05-17 3 2017-05-18 4 2017-05-19 1 2017-05-20 16 2017-05-21 5 2017-05-22 7 2017-05-23 1 2017-05-24 2 2017-05-25 1 2017-05-26 5 2017-05-27 33 2017-05-28 2 2017-05-29 1 2017-05-30 6 2017-05-31 2 2017-06-01 8 2017-06-02 8 2017-06-05 3 2017-06-07 4 2017-06-08 4 2017-06-09 3 2017-06-10 8 2017-06-11 25 2017-06-12 10 2017-06-13 4 2017-06-14 19 2017-06-15 5 2017-06-16 2 2017-06-17 6 2017-06-18 5 2017-06-19 2 2017-06-20 4 2017-06-22 29 2017-06-23 8 2017-06-24 28 2017-06-25 4 2017-06-26 1 2017-06-27 6 2017-06-28 1 2017-06-30 3 2017-07-01 28 2017-07-02 1 2017-07-03 5 2017-07-04 11 2017-07-05 8 2017-07-06 4 2017-07-07 5 2017-07-08 3 2017-07-09 35 2017-07-10 1 2017-07-11 11 2017-07-12 5 2017-07-13 11 2017-07-14 6 2017-07-16 24 2017-07-17 2 2017-07-18 7 2017-07-20 2 2017-07-21 9 2017-07-22 68 2017-07-23 7 2017-07-24 4 2017-07-25 2 2017-07-26 15 2017-07-28 2 2017-07-29 25 2017-07-30 3 2017-07-31 7 2017-08-01 3 2017-08-02 15 2017-08-04 7 2017-08-05 26 2017-08-06 1 2017-08-07 11 2017-08-08 9 2017-08-10 3 2017-08-12 1 2017-08-14 5 2017-08-15 10 2017-08-16 5 2017-08-17 27 2017-08-18 2 2017-08-23 1 2017-08-26 6 2017-08-27 1 2017-08-28 7 2017-08-29 2 2017-08-30 2 2017-08-31 1 2017-09-01 1 2017-09-03 26 2017-09-04 1 2017-09-05 3 2017-09-06 2 2017-09-08 1 2017-09-09 1 2017-09-11 1 2017-09-12 4 2017-09-14 1 2017-09-17 1 2017-09-20 1 2017-09-22 3 2017-09-25 1 2017-09-28 1 2017-09-29 1 2017-09-30 1 2017-10-01 2 2017-10-02 2 2017-10-03 1 2017-10-04 1 2017-10-05 4 2017-10-06 4 2017-10-07 4 2017-10-08 23 2017-10-09 38 2017-10-10 4 2017-10-11 1 2017-10-12 4 2017-10-16 6 2017-10-18 3 2017-10-19 6 2017-10-24 5 2017-10-25 3 2017-10-26 2 2017-10-27 26 2017-10-28 2 2017-10-29 13 2017-10-30 2 2017-10-31 1 2017-11-01 3 2017-11-02 2 2017-11-03 1 2017-11-04 21 2017-11-05 3 2017-11-07 3 2017-11-08 8 2017-11-09 10 2017-11-10 23 2017-11-11 1 2017-11-12 4 2017-11-13 1 2017-11-14 18 2017-11-15 2 2017-11-16 2 2017-11-18 3 2017-11-20 8 2017-11-21 2 2017-11-22 5 2017-11-26 1 2017-12-04 1 2017-12-06 2 2017-12-09 2 2017-12-10 1 2017-12-11 2 2017-12-12 1 2017-12-13 1 2017-12-14 22 2017-12-15 2 2017-12-16 2 2017-12-17 1 2017-12-18 1 2017-12-20 3 2017-12-21 1 2017-12-22 22 2017-12-23 2 2017-12-24 10 2017-12-25 2 2017-12-30 14 2017-12-31 2 2018-01-01 9 2018-01-02 17 2018-01-03 1 2018-01-04 3 2018-01-05 4 2018-01-06 1 2018-01-07 3 2018-01-08 4 2018-01-09 3 2018-01-10 5 2018-01-11 5 2018-01-13 28 2018-01-14 2 2018-01-15 1 2018-01-16 4 2018-01-17 7 2018-01-18 2 2018-01-19 4 2018-01-22 4 2018-01-23 3 2018-01-25 3 2018-01-26 6 2018-01-27 2 2018-01-28 5 2018-01-29 1 2018-01-30 3 2018-01-31 2 2018-02-02 2 2018-02-04 5 2018-02-05 1 2018-02-06 2 2018-02-07 4 2018-02-08 2 2018-02-09 1 2018-02-10 1 2018-02-11 2 2018-02-14 1 2018-02-16 1 2018-02-17 1 2018-02-18 1 2018-02-19 1 2018-02-21 2 2018-02-22 2 2018-02-25 3 2018-02-26 2 2018-02-27 1 2018-02-28 1 2018-03-02 2 2018-03-05 7 2018-03-06 4 2018-03-07 1 2018-03-08 3 2018-03-09 2 2018-03-10 15 2018-03-12 3 2018-03-14 1 2018-03-15 1 2018-03-20 2 2018-03-21 3 2018-03-23 2 2018-03-27 2 2018-04-04 1 2018-04-07 1 2018-04-20 1 2018-04-21 9 2018-04-22 2 2018-04-23 1 2018-04-24 4 2018-04-26 1 2018-04-27 2 2018-05-01 5 2018-05-03 11 2018-05-04 11 2018-05-05 6 2018-05-06 10 2018-05-07 2 2018-05-08 1 2018-05-10 23 2018-05-11 2 2018-05-12 15 2018-05-13 18 2018-05-14 4 2018-05-15 2 2018-05-16 7 2018-05-17 4 2018-05-18 1 2018-05-19 17 2018-05-20 19 2018-05-25 1 2018-05-26 3 2018-05-30 4 2018-05-31 2 2018-06-02 2 2018-06-03 1 2018-06-04 10 2018-06-05 4 2018-06-07 1 2018-06-08 1 2018-06-09 23 2018-06-10 3 2018-06-11 6 2018-06-12 5 2018-06-13 13 2018-06-14 15 2018-06-15 4 2018-06-16 12 2018-06-17 6 2018-06-18 11 2018-06-20 3 2018-06-22 19 2018-06-23 3 2018-06-24 4 2018-06-25 4 2018-06-27 7 2018-06-28 5 2018-06-29 7 2018-06-30 2 2018-07-01 7 2018-07-03 2 2018-07-05 2 2018-07-06 1 2018-07-09 4 2018-07-10 2 2018-07-11 1 2018-07-13 1 2018-07-14 1 2018-07-18 2 2018-07-19 4 2018-07-20 1 2018-07-23 5 2018-07-25 1 2018-07-27 1 2018-07-28 1 2018-07-29 1 2018-07-30 1 2018-07-31 1 2018-08-01 2 2018-08-05 1 2018-08-06 1 2018-08-07 3 2018-08-08 2 2018-08-10 1 2018-08-14 3 2018-08-15 3 2018-08-24 1 2018-08-25 11 2018-08-26 7 2018-08-27 1 2018-08-28 4 2018-08-29 3 2018-09-01 9 2018-09-02 7 2018-09-03 10 2018-09-04 1 2018-09-05 18 2018-09-08 1 2018-09-09 20 2018-09-10 3 2018-09-11 1 2018-09-19 2 2018-09-21 1 2018-09-22 8 2018-09-23 3 2018-09-24 1 2018-09-26 1 2018-09-29 5 2018-09-30 2 2018-10-03 8 2018-10-04 1 2018-10-06 11 2018-10-07 1 2018-10-08 2 2018-10-10 2 2018-10-11 1 2018-10-12 1 2018-10-13 1 2018-10-14 1 2018-10-15 1 2018-10-16 2 2018-10-18 2 2018-10-25 1 2018-11-02 1 2018-11-03 2 2018-11-04 2
よさそう👌
CTASでデータ整形
%athena create table hatebu.daily_bookmarks with ( format='PARQUET', external_location='s3://hatena-bookmark-analysis/data/daily_bookmarks/', partitioned_by = ARRAY['date'] ) as select * from (select *, date(time) as date from hatebu.user_bookmarks ) where date between date('2018-01-01') and date('2018-03-31')
Query executed successfully. Affected rows : -1
本題のCTASクエリです。年月日だと一度に追加できるパーティションの上限(100件)に引っかかります(HIVE_TOO_MANY_OPEN_PARTITIONS
)。微妙に不便だけど増える見込みはあるのだろうか。
年ごとでやり直す
%athena create table hatebu.yearly_bookmarks with ( format='PARQUET', parquet_compression = 'SNAPPY', external_location='s3://hatena-bookmark-analysis/data/yearly_bookmarks/', partitioned_by = ARRAY['y'] ) as (select *, year(time) as y from hatebu.user_bookmarks )
Query executed successfully. Affected rows : -1
%sh aws s3 ls --human-readable --recursive s3://hatena-bookmark-analysis/data/yearly_bookmarks/
2018-11-11 08:04:08 76.9 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_04e002f3-da0c-49d2-8832-5836d4a5bfc5 2018-11-11 08:04:08 52.1 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_0a97f437-a7d2-4b2b-9a6e-bc3fdde5191e 2018-11-11 08:04:06 1.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_1719ff27-3786-43ca-901e-a9e3400b7f70 2018-11-11 08:04:06 48.0 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_18126607-2181-4b85-9354-058680b3a9cd 2018-11-11 08:04:08 352.0 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_19e6c8c9-ce30-479b-94b2-b833131b7a37 2018-11-11 08:04:08 94.0 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_36cff8dd-1dee-49d2-9d77-1f5c39fbba03 2018-11-11 08:04:08 17.1 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_383f1a76-6464-4c3a-a3a9-eddec70b3327 2018-11-11 08:04:07 35.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_3bd52ae3-68d3-47e5-91a8-a7f8b03dd07f 2018-11-11 08:04:08 154.2 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_3ee2df52-2862-4771-8362-d24c081ec664 2018-11-11 08:04:07 53.7 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_42af4591-b270-497c-8b77-8796d9695490 2018-11-11 08:04:08 218.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_44663a5f-5dc2-43b5-b983-2234932a7f04 2018-11-11 08:04:09 104.8 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_5247e3fe-9c6f-438d-aff4-eaca9e599fd3 2018-11-11 08:04:08 20.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_59b20c63-4370-4c31-b425-768a5626e97a 2018-11-11 08:04:08 6.1 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_70e5fd40-251e-4f3c-9104-c2adaae299ed 2018-11-11 08:04:08 6.3 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_7dd55261-e670-4ee2-9c4d-f687ac672a03 2018-11-11 08:04:08 81.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_83f53b27-732c-4246-9fa3-4159cd356526 2018-11-11 08:04:08 141.7 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_9c531b68-fabe-47ac-a2eb-67efc54ad05a 2018-11-11 08:04:07 45.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_a33d0f5c-c3a9-4513-b044-16e4d3fc0cfd 2018-11-11 08:04:08 265.5 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_b0d04b04-0644-4aca-9a18-246997041290 2018-11-11 08:04:09 219.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_b81f02f1-ae12-4f22-8f52-f57a3f13fa33 2018-11-11 08:04:08 79.2 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_c6da8f22-0b22-4bc3-9c22-05e036f32e99 2018-11-11 08:04:08 107.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_d56683b2-cd85-4c28-b25f-9807f86d6c4c 2018-11-11 08:04:08 77.9 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_f237cd5a-265a-4972-98de-627405d56c3c 2018-11-11 08:04:08 329.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_f25de931-0201-4c44-bf98-ba90e0c701d7 2018-11-11 08:04:08 21.2 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_f5a223fd-01c8-43a5-bb0c-b2f8790d70cb 2018-11-11 08:04:06 332.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_02fc5810-4200-4163-b311-6a12196e0b2a 2018-11-11 08:04:07 98.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_13636537-b974-423f-831c-26c5ede8174c 2018-11-11 08:04:08 24.2 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_21ada576-8b09-4ba6-98a0-b0edd995548f 2018-11-11 08:04:08 247.4 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_42036ebe-aa29-4a2b-88c9-60b62cfed54d 2018-11-11 08:04:08 562.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_51998063-9217-4e28-a86b-015f7bc0f01e 2018-11-11 08:04:08 228.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_6b84a1d6-e915-4e02-a64e-c461509d1f4a 2018-11-11 08:04:07 661.5 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_702c3e90-8104-410d-adb7-81f7b1d7d8da 2018-11-11 08:04:08 752.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_77efc71f-1400-4ff1-a82e-57209a08f80e 2018-11-11 08:04:07 261.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_7dd788c8-1111-4c50-8ca9-850dbd497371 2018-11-11 08:04:08 697.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_7deaf09e-e367-4cd3-b732-8c5702140762 2018-11-11 08:04:08 489.6 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_829f8885-6cd6-4319-b1f8-702930c8d6ef 2018-11-11 08:04:08 405.3 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_86a9d440-24ac-410d-a6ee-fed4869ee9b8 2018-11-11 08:04:08 376.7 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_897926c2-de2d-4a8b-a8d4-e9297cfa7a94 2018-11-11 08:04:08 368.2 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_9494655b-574c-4197-aaf4-5e8f5e65292d 2018-11-11 08:04:07 39.2 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_9795385a-6752-4f01-959e-9ae04e04cb4b 2018-11-11 08:04:08 252.6 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_a4ad1d6f-3e96-42d0-b232-755c11ce50c4 2018-11-11 08:04:07 338.3 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_a7d3a751-af52-4edd-94dc-d78850db7fa9 2018-11-11 08:04:08 520.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_a8f69ed1-4fb0-4995-9c40-b1f47d9d356f 2018-11-11 08:04:08 342.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b06623f3-6967-4b72-bade-cbdff12eb9b2 2018-11-11 08:04:08 214.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b22536bb-b33d-4a8a-9275-452bb544c6d9 2018-11-11 08:04:06 51.6 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b3ac0a0a-8534-4e48-9041-31c849528347 2018-11-11 08:04:07 266.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b76dd605-5ccd-445b-bcba-6ae0abfe9ffa 2018-11-11 08:04:10 240.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_bec02128-5783-4d50-be5c-88c342d74000 2018-11-11 08:04:08 307.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_c4ebb0a9-346d-40ed-8949-44cb8bdc66d1 2018-11-11 08:04:08 546.3 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_02827f6d-8f2f-45a9-9f76-bb6c2fe0aa2b 2018-11-11 08:04:07 526.0 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_09e5ca4e-05ed-4c87-9505-d4884022d8f2 2018-11-11 08:04:07 533.5 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_0f104c5c-ca56-442b-adf2-16822a75fa1e 2018-11-11 08:04:08 338.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_1071845d-b422-4bc8-8d55-0fd8a13a7697 2018-11-11 08:04:07 734.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_27d44a8f-7b86-47d0-a6c9-1e054d7d31a3 2018-11-11 08:04:08 801.8 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_2a73c365-d597-4e80-b8bc-168b31614080 2018-11-11 08:04:08 737.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_38cfd901-3d74-4398-887f-aa485ae8be0b 2018-11-11 08:04:09 427.0 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_38f43fea-8c25-4b90-8fb2-e1af5e5a9a7c 2018-11-11 08:04:08 697.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_3bb7082c-f5ff-4dd6-afed-3f47471485b0 2018-11-11 08:04:08 824.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_47767d52-816d-456c-8530-6aa490eaf17e 2018-11-11 08:04:06 548.7 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_4ec42972-3727-49a2-bbc1-e5428aa15663 2018-11-11 08:04:08 342.7 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_5189b3ee-6f31-483a-a797-08c534393144 2018-11-11 08:04:08 1.1 MiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_5207a353-4e29-4456-b132-111a81fbdab4 2018-11-11 08:04:08 586.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_69eebd76-3db9-4cbb-a9b5-19570b03ccac 2018-11-11 08:04:09 298.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_6fdbdae5-60a2-4691-ad15-e42d2e308117 2018-11-11 08:04:08 459.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_8b4f74a2-0f31-45c1-a6ee-3d88d9c8df9e 2018-11-11 08:04:07 585.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_990d7f69-fdb1-4b47-b832-3b0ca7cce505 2018-11-11 08:04:07 211.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_9960dfb6-eb0d-4299-baef-e07fce000a50 2018-11-11 08:04:07 191.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_9dd60268-49e5-403b-951b-8a0b21409cbc 2018-11-11 08:04:07 394.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_a6592fe0-6d57-4c7a-9fae-060b00f91b10 2018-11-11 08:04:08 686.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_a70660e7-ebd7-478c-9255-6b7c28e9b2b9 2018-11-11 08:04:08 485.3 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_b4c0623a-728a-4729-8752-687154b32372 2018-11-11 08:04:07 930.5 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_c1289a96-7933-4700-b202-0e24967b533d 2018-11-11 08:04:08 1.5 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_1534b6f5-0928-4799-8628-00405bae4d8f 2018-11-11 08:04:08 857.4 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_161eb02c-11c9-4e8f-b7b6-de342509b826 2018-11-11 08:04:08 826.1 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_173bd548-efb0-4456-bcc6-1654a37a5d2a 2018-11-11 08:04:07 1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_187feb41-3f2c-426c-ae2d-194b63d38058 2018-11-11 08:04:06 1.4 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_3fe2348c-8df5-42a9-b49c-82c7eae58c13 2018-11-11 08:04:07 1.2 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_574a807a-fd52-4916-a1bf-a875e03dfab5 2018-11-11 08:04:08 1.8 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_64a6808b-7c2d-4151-b566-ab428c7aa277 2018-11-11 08:04:08 724.8 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_7957510a-d534-4abf-ac48-e551b2d4f1db 2018-11-11 08:04:07 695.9 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_8b8e339d-76c9-4313-bb4d-cc59923b338b 2018-11-11 08:04:07 111.3 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_8b98e8bc-4b64-44ac-9f39-dfa9f4b6dbff 2018-11-11 08:04:08 757.0 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_8e7afc10-d70e-4118-9212-74904ef185d6 2018-11-11 08:04:08 301.6 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_bab9cd36-02fc-44b6-86ec-aece10325649 2018-11-11 08:04:07 729.5 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_bc9bc343-1280-44e4-9ccc-06bb77025c68 2018-11-11 08:04:08 860.8 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_c111d187-edb5-4b97-94ae-68a120bbcb02 2018-11-11 08:04:07 662.2 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_c29258be-f91f-4ff4-a58e-be3624e91faf 2018-11-11 08:04:08 1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_cb08b7b9-6009-4374-96a6-9d275b753223 2018-11-11 08:04:06 1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_d5b8e655-9fdc-4c21-9f4f-5dbec326a58f 2018-11-11 08:04:06 1.5 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_e47f96c1-0d4b-47f8-9f58-598f785c5439 2018-11-11 08:04:07 20.3 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_e55fbe56-1b3f-48ee-a48b-6f3853565d51 2018-11-11 08:04:09 773.6 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_ec297b83-b42c-4266-87c9-8600a1c75609 2018-11-11 08:04:07 1002.3 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_ee73a7c7-6f97-49e7-9dfd-f4b64cc3b6f8 2018-11-11 08:04:08 1.4 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_f1a60840-4c48-47ca-a546-778ddc585f12 2018-11-11 08:04:08 1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_f775195a-db51-4def-a170-75dd9d45cd60 2018-11-11 08:04:07 760.7 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_f7f6e9c3-49dc-4b81-8e12-3fe7af00e405 2018-11-11 08:04:08 1.8 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_0ba50b0b-2513-4850-a568-dd1184c115ac 2018-11-11 08:04:07 1.3 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_0ba72447-528e-4b02-bb71-6d026114efd1 2018-11-11 08:04:08 1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_206389ec-db59-4c1b-bc70-2cba81e2bbe0 2018-11-11 08:04:07 1.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_26b8c05a-1794-4296-92b6-d30afafafdbd 2018-11-11 08:04:08 2.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_47375585-8701-4130-bd3d-e13f194087dc 2018-11-11 08:04:07 348.4 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_537b2a63-12ee-44ea-86b7-e264039426bb 2018-11-11 08:04:07 2.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_5991530f-2444-4986-aced-fc8d7f3eaa2f 2018-11-11 08:04:07 1.6 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_6df9bbb7-5412-4c94-a20b-ea7c9e08ed31 2018-11-11 08:04:06 1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_734fdd1e-65b2-4e6e-a73d-cbb07f4358e5 2018-11-11 08:04:07 1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_793c2b89-f60f-40a7-9472-879236f4a2cc 2018-11-11 08:04:06 1.8 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_81508157-2e68-45ed-b02f-75d74220df95 2018-11-11 08:04:07 1.1 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_8dc57663-d45f-49bb-80a8-f348d24773ed 2018-11-11 08:04:08 662.5 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_9051b0c7-1106-4186-a3a4-77f21559d04c 2018-11-11 08:04:07 1.4 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_9253b98b-ab60-40e3-a461-c329535c2fb4 2018-11-11 08:04:07 1.5 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_9fa869ab-3340-4bf6-8425-01e90aee02fe 2018-11-11 08:04:07 17.7 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_a188eee2-1ee6-4fcd-842c-3ae5053ffda9 2018-11-11 08:04:08 1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_a8d655c1-4271-4770-82b1-04cfe55b0d1a 2018-11-11 08:04:08 1.1 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_b9a081d9-9338-4e8b-a342-2dc60691683b 2018-11-11 08:04:08 1.3 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_cdca8e97-8586-4cd4-849f-997dfbcc2819 2018-11-11 08:04:07 1.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_d409ed01-bea2-4469-b363-717df4275003 2018-11-11 08:04:07 1.6 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_d6bf0d45-7d98-4242-9c68-82e5345dfe5a 2018-11-11 08:04:07 970.1 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_dfe4b17c-a4bf-4076-8eaa-3640551ed4ff 2018-11-11 08:04:06 1.8 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_e69e9358-fd10-4cd4-8389-fc704930fef6 2018-11-11 08:04:07 1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_eca7f106-a235-4e93-816b-b138855c3da9 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_00cd1a17-6b73-40be-86f0-c53f9d6749b6 2018-11-11 08:04:08 1.9 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_109c3d88-cced-4350-962d-b0772acef0c4 2018-11-11 08:04:07 1.3 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_1a67f153-a492-45ec-8736-6c373b86f05b 2018-11-11 08:04:07 1.7 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_1df84264-64ed-4188-817d-66e7171a7cca 2018-11-11 08:04:08 1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_232c7e12-f836-493d-8246-c04dbad190a4 2018-11-11 08:04:07 1.5 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_27541470-827f-445f-827a-6ff7abcd158f 2018-11-11 08:04:07 1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_4b14b22e-2541-4281-8056-3b08160f91e2 2018-11-11 08:04:06 2.2 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_500c870d-48ce-42ec-a696-9c60454c7522 2018-11-11 08:04:07 1.4 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_541520b5-5f38-4bb6-8a73-b3b638fc7356 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_681b1aac-a499-4720-a89e-045d7238bc0e 2018-11-11 08:04:08 1.4 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_688bbcb2-725c-42f0-bdf3-695477201acb 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_86c3d1a7-751c-4138-a9ac-09dcc280f7d4 2018-11-11 08:04:08 1.2 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_891b2acf-cfc5-4ab0-814e-86a5e961ef06 2018-11-11 08:04:08 1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9335de7d-ddd2-4557-99dd-07503307f981 2018-11-11 08:04:08 2.3 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_96b63189-513c-4f49-9b7a-476b4d86aabb 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9b9ff1c5-10a0-4cf1-8e1d-4c10c425d2e4 2018-11-11 08:04:08 1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9c1e85ef-5a12-4b39-ba73-5c1c104d6a43 2018-11-11 08:04:07 113.8 KiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9db0ddfe-f160-4ffa-ad60-8ebe29d0ee5c 2018-11-11 08:04:08 1.9 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_ad78b837-eaf3-4139-8359-d4cffa96b068 2018-11-11 08:04:08 1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_b3ed9900-4f2a-4081-bc09-b106a0d42bc3 2018-11-11 08:04:07 1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_cfcbdec4-64ef-46ef-82ef-178c52934a5b 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_d294928a-bee4-458b-bac4-6f571f525b95 2018-11-11 08:04:07 1.9 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_e97a44ec-e49c-46c6-9541-12ca8b86b22c 2018-11-11 08:04:07 403.1 KiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_fe57ab1a-fc82-4611-b2e8-9ea68564de14 2018-11-11 08:04:06 496.5 KiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_0ee74598-f61c-4adb-880c-57128ad00314 2018-11-11 08:04:07 2.7 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_222ab9db-6d80-49e3-9be5-efca97fb35fd 2018-11-11 08:04:08 2.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_229df017-e768-4662-b078-30a217849a2f 2018-11-11 08:04:08 1.9 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_238ca4c3-1166-4e1c-9091-a4cf5b0bb12d 2018-11-11 08:04:08 2.0 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_2443b78a-67a3-49d6-91b6-3f3ec8d32129 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_2695471a-146a-432e-b776-e036c2d9e112 2018-11-11 08:04:08 2.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_2ead8e25-b93c-4945-82a2-7e25b5a7c428 2018-11-11 08:04:07 1.7 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_3251c3a5-937e-4e38-8dc4-a190944db4f2 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_5627a3cb-58ca-4b12-b6d8-8bfa63baaa13 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_7f5b6da1-cb49-4b25-a7cb-fc177e90035e 2018-11-11 08:04:06 3.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_7f70548e-b9cd-460d-a80e-f446d9505dc5 2018-11-11 08:04:08 2.1 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_915bf966-3cfa-45c7-ab09-e805f7dcc37c 2018-11-11 08:04:06 1.6 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9359137c-98af-4a5e-b8ae-3a3b97a7477e 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9825e701-f6a5-4f44-baff-6c7a9a190aab 2018-11-11 08:04:08 1.9 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9890b071-d48a-4f7e-b0a3-2149d2036f57 2018-11-11 08:04:06 2.4 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9e1ab752-ab20-41e6-8271-4377c0ba1779 2018-11-11 08:04:08 2.5 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9e64fe6e-3746-47b6-bc36-9fed8cca0e54 2018-11-11 08:04:06 2.4 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_a438d61f-eb2a-4e5d-aeb9-689727a25df4 2018-11-11 08:04:07 1.6 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_cd149b6e-df31-4654-bf59-048439d9e169 2018-11-11 08:04:07 2.1 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_d824ed46-04de-4dd3-89c0-1fb0b6613735 2018-11-11 08:04:08 2.9 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_e68c1cbf-9276-4ba2-8e88-41f8685d885d 2018-11-11 08:04:06 1.8 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_e8cedecd-3aeb-482c-89e6-c4f795085640 2018-11-11 08:04:08 2.2 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_e9b9a9a5-87c0-47b5-b381-c390ac7eb09d 2018-11-11 08:04:08 2.4 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_0740ef2c-9364-4383-999f-2cbacaa2a79b 2018-11-11 08:04:07 2.4 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_07c7ae8f-f52a-476b-8912-f44b8909504f 2018-11-11 08:04:08 3.7 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_09ae43c2-4d45-4df5-ab03-91e15cb34caa 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_0eb7653a-70b5-4dbd-a7f0-ff7006aa1c1f 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_1774061d-3288-4999-bf59-133f28979c8f 2018-11-11 08:04:07 578.5 KiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_438f94a0-d5a9-48d4-98f8-ed1ad420df0e 2018-11-11 08:04:07 2.7 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_457624d4-0ce4-4c4d-b557-ac86a4fc360c 2018-11-11 08:04:09 2.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_46b72fc2-91cf-4b39-8299-8dba1f9ce33e 2018-11-11 08:04:07 2.6 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_565ce5df-f555-4eac-94a1-61ab0960e85f 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_57ef43c9-e64f-4329-862b-5b9437fbf957 2018-11-11 08:04:07 2.0 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_5bcd59c2-0970-420f-8178-62335caeb659 2018-11-11 08:04:08 1.7 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_5d0c2cb6-1f1f-4757-994f-efa7b952e64b 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_5dcb4588-c69c-4d3f-8714-9d45a4737f42 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_6487b8f4-72c2-4d19-817f-097f34bdd966 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_6b152c79-6694-40c5-a2fd-f905b7d72f98 2018-11-11 08:04:08 2.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_a3baf7b9-6cab-4976-9edd-1040b93cd7fb 2018-11-11 08:04:07 2.9 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_a4f7b14e-b335-4875-9159-42913261cb63 2018-11-11 08:04:07 2.0 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_c8fabc15-4925-48f2-9ab7-b3a561d1ee4b 2018-11-11 08:04:08 3.1 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_c94429d4-c89f-47ed-b248-589befb6bb16 2018-11-11 08:04:08 2.5 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_cc78f5af-5e81-40b5-abea-29798cbd3cdf 2018-11-11 08:04:06 3.0 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_ddb6cc16-e04a-4c02-82f5-14c4cf7ed83f 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_e8c8245b-2bea-488e-a92d-703bbb3b6513 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_f4298a42-a324-4f72-b90f-acc079f6a8c4 2018-11-11 08:04:06 117.8 KiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_fb0bd58b-2aee-48ef-9843-f3ac11eb518d 2018-11-11 08:04:07 3.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_16263d4c-7e8e-4ea1-92b7-6444cc1ed602 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_18733a8c-62cf-4f33-8dab-d7090d0a333a 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_21fc5444-724d-45d2-9e45-61f8e0d5a27e 2018-11-11 08:04:08 2.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_2c6b2878-933a-48e1-a19b-14d41d27d7a7 2018-11-11 08:04:06 3.9 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_3545a4c8-b299-41ed-b932-40492aa0f66d 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_3725a5f3-9314-4b62-b0ed-8a8021e81639 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_46bd5b79-8578-4f61-b352-4ba64606b80e 2018-11-11 08:04:07 3.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_516e23d7-ec72-456f-be30-35b94e8af915 2018-11-11 08:04:07 3.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_5b06778a-76d5-4054-b970-c62b4c436298 2018-11-11 08:04:06 4.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_5d6b2dc9-2321-4a3f-abf2-9c2fc240ce98 2018-11-11 08:04:08 2.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_70b675de-9a3b-4e1e-95f3-46104a6594fe 2018-11-11 08:04:08 3.0 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_92b8b15c-1042-480c-8167-690f333b8980 2018-11-11 08:04:07 2.9 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_96905278-5222-4bf8-8384-f34a0ea334be 2018-11-11 08:04:07 3.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_98335f8d-3e78-4c7a-adcd-257372d40750 2018-11-11 08:04:07 2.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_a04a1fcf-1d41-497a-9007-92fe5ac3dec3 2018-11-11 08:04:08 2.0 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_b026f146-feac-4261-b22c-f3cfe5cd1fb0 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_b8d5939a-f936-43f2-99d2-42cfd503c314 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_b980c141-d675-4a7a-afe2-5539b2e2c888 2018-11-11 08:04:08 2.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_bcb9e489-f1db-423c-99c2-c7118404dbbd 2018-11-11 08:04:07 828.8 KiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_bd4d1cc1-d2b3-4fee-924a-f66dff072cfe 2018-11-11 08:04:07 3.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_d6efecc8-2766-4bb4-b6c9-d1a6fdabb529 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_d900b0bd-cdef-4060-901c-d809c247c634 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_fd831dd3-2d70-4262-a506-8703de5bbdca 2018-11-11 08:04:07 4.1 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_352f7ecd-0c57-4718-a25b-250f502f391d 2018-11-11 08:04:08 3.1 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_428e40c9-de87-4a1d-96a5-408c5d0469e6 2018-11-11 08:04:07 2.9 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_49222d52-c156-4f09-8255-b6216510a7ee 2018-11-11 08:04:08 2.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_5225ff50-406c-4198-a230-da9e87fecd9f 2018-11-11 08:04:07 3.5 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_5355d1b9-5183-46ae-9a09-b2586a54eebe 2018-11-11 08:04:08 3.6 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_576abcc1-121e-4966-b33a-521efd12c98b 2018-11-11 08:04:07 3.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_67711d06-8271-4806-b73b-b000be0989be 2018-11-11 08:04:08 2.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_6d0f3ecc-b75a-4d53-b888-5f2146a5fc6e 2018-11-11 08:04:07 3.0 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_7704d68c-ea23-4d4e-a636-ffd0f1d851d1 2018-11-11 08:04:07 832.1 KiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_90a90cb1-d384-4a5c-9a30-c802aa183788 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_9b092d3e-7341-41d2-aad1-06d03b898dae 2018-11-11 08:04:07 3.8 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_a7f4b6f5-e97b-406d-9382-522e8fd88900 2018-11-11 08:04:07 2.5 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_c75d6ba1-87c9-4ca3-a70e-1879e5c1c0dc 2018-11-11 08:04:08 3.3 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_cdd0d958-ab37-42d4-a854-079bc853aef4 2018-11-11 08:04:07 1.9 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_d3bdebf1-c02f-490f-b7a4-b891ba49b461 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_d4c1f2cc-5344-473b-ae88-a745b1ee7cbc 2018-11-11 08:04:07 4.2 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_d6bbdcf2-9b47-460c-9550-ce80eb562390 2018-11-11 08:04:08 2.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_da48b17c-3152-4f70-b62d-c6d26d21f5c6 2018-11-11 08:04:07 3.4 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_e856b5da-82fe-4de4-b122-10982c18e4d9 2018-11-11 08:04:06 3.5 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_f09ed12d-dcd8-4ff3-b079-a7847d1f96fb 2018-11-11 08:04:08 2.2 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_f5cda716-b41e-4cf8-9ca8-b650b9d87990 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_fd14a6e0-4954-47f6-8fc1-cbb37f17938c 2018-11-11 08:04:08 3.4 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_fd3a0b43-e488-4485-bb14-f37cb4a44bf9 2018-11-11 08:04:07 3.0 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_018c6d80-3931-479e-abd3-baca95880eb9 2018-11-11 08:04:08 2.7 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_0336aea7-48c7-4b07-8d68-67001ddf8b08 2018-11-11 08:04:06 2.5 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_05b4194b-6848-4c86-b907-5ef860751ff0 2018-11-11 08:04:07 3.3 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_0984ddfa-0727-49d0-a4c0-f7e3350add63 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_11d70bb8-ba9c-4fdd-a55d-ffd2c87eeb3b 2018-11-11 08:04:07 4.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_197d262f-22c3-4b23-bc2d-ef70ad1c78de 2018-11-11 08:04:08 3.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_1fdfc221-b3d3-442d-90c8-17f0e613f026 2018-11-11 08:04:08 2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_283500c9-261e-40b4-be0c-6e3b646aae9f 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_388acfc6-edb8-4865-b396-4de238c5fe8a 2018-11-11 08:04:07 2.3 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_3ba30bf8-cfcb-49cd-86c1-b1b1f9ad5ca8 2018-11-11 08:04:07 3.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_4301c511-caea-49a1-b659-35d0c1ac18a6 2018-11-11 08:04:08 3.0 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_4a725315-0740-4b33-8881-ebeddec0790d 2018-11-11 08:04:06 60.0 KiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_4c9e2d8d-9d66-4647-8e9c-7ff1dbe7f277 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_5307daa5-7d89-437c-b76a-40e1327a5d17 2018-11-11 08:04:07 3.7 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_6c251481-85ab-4b02-b152-65c8a21c3b72 2018-11-11 08:04:07 2.7 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_6d3bb0aa-efb8-4f51-bb13-04d6227641f7 2018-11-11 08:04:07 3.6 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_6fd66b6d-629a-46ba-99f5-75f03194c88b 2018-11-11 08:04:08 4.2 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_708c4c97-9be3-4b64-9a94-000cb5ac0e79 2018-11-11 08:04:07 2.5 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_96e967e4-3675-49bf-be5c-79a9f94e67aa 2018-11-11 08:04:06 2.9 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_a814d15d-044c-409d-be8c-e27565a23cd3 2018-11-11 08:04:08 2.1 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_d7cf210c-1cc3-42d2-8e17-e5ef4a0d017b 2018-11-11 08:04:07 591.9 KiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_dfaf750e-d8ab-472a-930f-946c0910bb27 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_f154e762-35e4-484a-99aa-af9d31dd3478 2018-11-11 08:04:07 2.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_ffbab7f0-de5f-4a9c-8e30-3d7f580d2fc3 2018-11-11 08:04:07 585.2 KiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_02c168da-dbe5-401f-9ecb-90a1f51a1bb5 2018-11-11 08:04:08 3.2 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_0fda6db5-c235-4efa-b143-f963fd26aa0d 2018-11-11 08:04:07 2.6 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_2586ce90-e904-421c-acf5-72579379dbb9 2018-11-11 08:04:07 2.8 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_2d9351f2-bc77-4f4f-8477-623e9036cb42 2018-11-11 08:04:07 2.5 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_532ab222-a620-4e30-be88-2c8b58d18603 2018-11-11 08:04:06 3.3 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_69e13475-61fa-4a27-9b9c-c1bafa3a541b 2018-11-11 08:04:06 64.9 KiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_7cb6dee1-6d09-49d4-a740-0b5a420793f8 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_816ad00b-e56c-4d1d-81d8-385b64e4fac4 2018-11-11 08:04:07 4.0 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_85808400-6db6-4750-bbcd-4b5f817559bf 2018-11-11 08:04:08 2.6 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_85d1b7a1-d9af-4e8d-8023-82ae373ebfdc 2018-11-11 08:04:07 2.6 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_8be7a2cb-e872-472e-b091-93837c1044bb 2018-11-11 08:04:07 3.9 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_8f2eaf80-1cd0-4515-91cd-3585bba549a1 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_9c3bef79-b3b1-41c4-b933-b07472e25606 2018-11-11 08:04:08 2.5 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_a3317523-bbd2-45cd-a6fc-b7293f54276f 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_a49fefee-eb5f-407f-a2a2-aadd2d02d3aa 2018-11-11 08:04:07 1.9 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_a9c7408b-8fa3-4fae-8941-6c6e0450703e 2018-11-11 08:04:08 1.3 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_b0b589c8-064a-4039-b4c3-b4e26a541d61 2018-11-11 08:04:07 2.4 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_bed10386-be28-4c87-ad8e-3c6d6401db23 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_c45d42ec-193c-48d1-8c94-4c7e4d9dfe77 2018-11-11 08:04:07 3.5 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_c4e93639-5fb7-418c-9cf0-e5a60c0f4fe7 2018-11-11 08:04:07 3.7 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_dbee165c-0aa1-419b-93df-f0f827b6a5eb 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_e0c93864-e064-4406-96c2-07c26e4e966d 2018-11-11 08:04:08 2.4 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_f0864330-cb07-4489-b382-fd92005ba2d4 2018-11-11 08:04:06 2.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_fcac1a15-e9b9-4fa5-bfc1-b9b5e6730fc2 2018-11-11 08:04:08 3.5 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_1d5ab93d-d91f-4d0e-b9a0-3ece473c81db 2018-11-11 08:04:07 2.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_1e0d6872-e8c9-4f4b-8e34-f42b54f80ba5 2018-11-11 08:04:07 259.0 KiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_2216aae9-4b2c-4b8e-8223-93dac486e0bc 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_36d5ae63-e434-44d3-ba41-fe0f525d8ba8 2018-11-11 08:04:06 3.0 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_50b98de7-7213-407b-865a-447410616ccb 2018-11-11 08:04:07 2.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_67d650d1-df74-462f-abc3-eebe6b5a53ed 2018-11-11 08:04:06 3.6 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_6b10fa27-80ac-4a7d-a982-c134d16c6d9c 2018-11-11 08:04:07 1.9 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_6d98b606-04f7-477a-a6ca-7e658142ec43 2018-11-11 08:04:07 2.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_742ed90e-a6b1-458c-a953-aeba41f330b2 2018-11-11 08:04:07 3.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_919eeac6-d720-4aca-bf9b-4d59e67cbe3e 2018-11-11 08:04:08 3.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_9604b0aa-1f50-40fc-96c3-ee6c16aed494 2018-11-11 08:04:07 3.2 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_a4b14870-53ba-4a8e-8517-1cecf876080d 2018-11-11 08:04:07 2.2 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_a74d73e9-3d32-4fa0-b19d-a5744d277c1c 2018-11-11 08:04:07 1.3 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_aeba4592-f0e1-4cc2-9bab-034782fb47b3 2018-11-11 08:04:07 2.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_af211827-2fed-4d12-a278-23c58896b94e 2018-11-11 08:04:09 3.2 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_cb8d3f7c-41e4-423e-a6c2-97943c673562 2018-11-11 08:04:07 2.9 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_cc0df267-3ec7-48a9-a89c-dce89151fa99 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_cf436ada-1d1e-4740-a831-31de8d019c56 2018-11-11 08:04:08 826.2 KiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_d13ced65-339d-4181-bb5c-fd81033589a8 2018-11-11 08:04:07 3.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_d3b9f823-5bbb-4d73-abe9-af7bd91e6b72 2018-11-11 08:04:09 2.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_d47fedcb-049e-4a16-92b8-85c3249b61e5 2018-11-11 08:04:08 2.9 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_dc17218d-4f52-48c1-af79-d8c2621980f9 2018-11-11 08:04:07 2.0 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_eeeb4042-d56e-4370-9c84-aa7fd6964e66 2018-11-11 08:04:08 1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_0f9e57cc-64da-4d2f-ba60-853081119845 2018-11-11 08:04:09 4.7 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_0f9f9edc-4a4b-43ff-a16c-b64b1c17c04c 2018-11-11 08:04:08 3.1 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_15f4e737-ef59-48ab-abbf-97617672a6e1 2018-11-11 08:04:06 5.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_26532d9c-fd73-4ccf-9fc1-8a2824ae8dba 2018-11-11 08:04:07 1.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_32de1448-59da-4a49-bff0-c1caeba9a595 2018-11-11 08:04:08 2.9 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_35b37043-e624-438d-8500-5fec32b228bd 2018-11-11 08:04:07 3.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_3b9227e4-f3d4-4040-98c9-7844581a4bd9 2018-11-11 08:04:08 2.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_46d3630a-261f-4915-9275-1794dce729e2 2018-11-11 08:04:08 1.7 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_4ed2fada-110d-42db-bc7e-7d5645aebab1 2018-11-11 08:04:08 2.0 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_5c036633-ac38-4d70-ac90-7b0d00fcb88f 2018-11-11 08:04:09 1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_7f5c3f22-9ac1-4dbc-bace-2f2c3986e839 2018-11-11 08:04:08 194.7 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_a327aa5b-f194-4c6f-9e61-d5e557e43611 2018-11-11 08:04:07 970.3 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_aa2eef35-9b50-4e79-a158-dae77df4c480 2018-11-11 08:04:07 1.2 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_b2bb6f66-18d8-43d1-8865-4caf17a1c08b 2018-11-11 08:04:07 3.8 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_b3172343-153b-4772-84f8-0c218fc5f861 2018-11-11 08:04:09 1.1 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_bbc2ecdd-8780-442a-8634-664dba483293 2018-11-11 08:04:09 3.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_bdc85753-fbd3-4cb0-81c9-c71699447f5c 2018-11-11 08:04:08 1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_be900f62-f89a-4a29-983f-66fc822b731d 2018-11-11 08:04:07 1.1 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_cf90d860-d118-4e8f-a301-a17959a4dbc8 2018-11-11 08:04:08 1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_d0645c66-1285-48b3-8a7c-fb248b938126 2018-11-11 08:04:07 1.8 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_d94607e5-052c-4395-9062-f5cc786e5221 2018-11-11 08:04:07 833.3 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_e88c9072-9bad-4f9f-82aa-3e3fd8e3a142 2018-11-11 08:04:07 166.4 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_f84e17d2-0516-4a2b-91c1-ab2ddf02c35c
Query executed successfully. Affected rows : -1
クエリしてみる
%athena select date, count(1) from (select date(time) as date from hatebu.yearly_bookmarks where id = 'sh19910711' and y between 2016 and 2018 ) group by date order by date
date _col1 2016-01-03 1 2016-01-04 7 2016-01-05 7 2016-01-07 6 2016-01-09 55 2016-01-10 21 2016-01-11 1 2016-01-12 27 2016-01-13 3 2016-01-14 7 2016-01-16 4 2016-01-19 1 2016-01-20 2 2016-01-21 2 2016-01-22 7 2016-01-23 2 2016-01-24 14 2016-01-25 1 2016-01-26 3 2016-01-30 1 2016-01-31 8 2016-02-01 4 2016-02-03 2 2016-02-08 4 2016-02-09 1 2016-02-10 1 2016-02-11 1 2016-02-12 1 2016-02-13 2 2016-02-15 3 2016-02-16 11 2016-02-18 9 2016-02-19 24 2016-02-20 6 2016-02-21 8 2016-02-22 27 2016-02-23 24 2016-02-28 4 2016-02-29 7 2016-03-01 16 2016-03-02 6 2016-03-03 1 2016-03-04 5 2016-03-05 12 2016-03-06 16 2016-03-07 6 2016-03-08 8 2016-03-09 2 2016-03-11 5 2016-03-12 8 2016-03-13 8 2016-03-14 6 2016-03-15 5 2016-03-16 3 2016-03-17 2 2016-03-18 4 2016-03-19 5 2016-03-20 7 2016-03-21 16 2016-03-22 13 2016-03-23 2 2016-03-24 4 2016-03-25 12 2016-03-26 9 2016-03-27 5 2016-03-29 1 2016-03-30 7 2016-03-31 3 2016-04-01 11 2016-04-02 1 2016-04-03 3 2016-04-04 1 2016-04-05 1 2016-04-06 2 2016-04-07 3 2016-04-08 2 2016-04-09 1 2016-04-10 6 2016-04-11 1 2016-04-12 2 2016-04-13 2 2016-04-14 8 2016-04-15 1 2016-04-18 7 2016-04-19 4 2016-04-20 2 2016-04-21 7 2016-04-22 1 2016-04-23 2 2016-04-24 5 2016-04-25 5 2016-04-26 5 2016-04-27 1 2016-04-28 1 2016-04-29 1 2016-04-30 3 2016-05-01 1 2016-05-02 2 2016-05-03 4 2016-05-04 6 2016-05-05 12 2016-05-06 14 2016-05-07 9 2016-05-08 1 2016-05-09 8 2016-05-10 4 2016-05-11 1 2016-05-12 3 2016-05-13 2 2016-05-14 5 2016-05-15 3 2016-05-16 4 2016-05-17 7 2016-05-18 12 2016-05-22 3 2016-05-23 1 2016-05-24 1 2016-05-25 3 2016-05-26 5 2016-05-27 2 2016-06-03 3 2016-06-04 3 2016-06-06 14 2016-06-07 5 2016-06-09 5 2016-06-10 5 2016-06-11 3 2016-06-12 10 2016-06-13 5 2016-06-14 22 2016-06-15 27 2016-06-16 3 2016-06-17 6 2016-06-18 5 2016-06-19 5 2016-06-20 2 2016-06-21 16 2016-06-22 8 2016-06-23 16 2016-06-24 2 2016-06-26 2 2016-06-27 5 2016-06-29 6 2016-06-30 3 2016-07-04 18 2016-07-05 10 2016-07-07 1 2016-07-08 7 2016-07-10 18 2016-07-11 2 2016-07-12 8 2016-07-13 1 2016-07-14 30 2016-07-15 16 2016-07-16 8 2016-07-17 17 2016-07-18 17 2016-07-19 13 2016-07-20 11 2016-07-21 7 2016-07-22 4 2016-07-23 15 2016-07-24 16 2016-07-25 2 2016-07-26 10 2016-07-27 20 2016-07-28 22 2016-07-29 7 2016-07-30 1 2016-07-31 4 2016-08-01 11 2016-08-02 8 2016-08-03 1 2016-08-04 8 2016-08-05 7 2016-08-06 21 2016-08-07 1 2016-08-08 2 2016-08-09 2 2016-08-10 12 2016-08-11 2 2016-08-13 3 2016-08-14 14 2016-08-15 2 2016-08-16 3 2016-08-17 6 2016-08-18 9 2016-08-19 7 2016-08-20 1 2016-08-21 2 2016-08-22 6 2016-08-23 38 2016-08-24 33 2016-08-25 3 2016-08-26 19 2016-08-27 5 2016-08-28 5 2016-08-29 11 2016-08-30 17 2016-08-31 2 2016-09-01 14 2016-09-02 15 2016-09-03 5 2016-09-04 2 2016-09-05 42 2016-09-06 1 2016-09-07 2 2016-09-08 18 2016-09-09 15 2016-09-10 25 2016-09-11 3 2016-09-12 11 2016-09-13 15 2016-09-14 8 2016-09-15 15 2016-09-17 17 2016-09-18 1 2016-09-19 11 2016-09-20 9 2016-09-21 14 2016-09-22 1 2016-09-23 3 2016-09-24 1 2016-09-27 2 2016-09-28 1 2016-09-29 2 2016-09-30 9 2016-10-04 5 2016-10-05 2 2016-10-06 10 2016-10-07 11 2016-10-08 17 2016-10-09 12 2016-10-10 5 2016-10-11 6 2016-10-12 3 2016-10-13 5 2016-10-14 2 2016-10-15 3 2016-10-16 3 2016-10-17 7 2016-10-18 2 2016-10-19 1 2016-10-20 2 2016-10-21 16 2016-10-23 3 2016-10-24 12 2016-10-26 13 2016-10-27 14 2016-10-28 9 2016-10-30 1 2016-11-01 1 2016-11-04 1 2016-11-09 4 2016-11-10 8 2016-11-13 23 2016-11-14 17 2016-11-16 1 2016-11-17 3 2016-11-18 11 2016-11-19 14 2016-11-20 7 2016-11-21 5 2016-11-22 17 2016-11-23 4 2016-11-24 19 2016-11-25 9 2016-11-26 21 2016-11-27 10 2016-11-28 1 2016-11-29 18 2016-12-01 23 2016-12-02 1 2016-12-03 33 2016-12-04 3 2016-12-05 5 2016-12-06 29 2016-12-07 2 2016-12-09 34 2016-12-10 7 2016-12-14 20 2016-12-19 14 2016-12-22 14 2016-12-25 23 2016-12-26 12 2016-12-28 13 2017-01-01 22 2017-01-04 24 2017-01-06 14 2017-01-24 2 2017-01-27 1 2017-02-01 1 2017-02-02 1 2017-02-25 2 2017-03-01 2 2017-03-05 1 2017-03-10 1 2017-03-18 1 2017-03-19 2 2017-03-21 4 2017-03-22 1 2017-03-26 1 2017-03-28 1 2017-03-29 3 2017-03-30 1 2017-03-31 11 2017-04-01 5 2017-04-02 2 2017-04-04 8 2017-04-05 11 2017-04-07 1 2017-04-08 1 2017-04-09 3 2017-04-11 3 2017-04-13 7 2017-04-16 1 2017-04-17 1 2017-04-18 6 2017-04-19 3 2017-04-20 4 2017-04-21 3 2017-04-22 3 2017-04-24 2 2017-04-26 9 2017-04-28 4 2017-04-29 3 2017-04-30 4 2017-05-01 2 2017-05-02 3 2017-05-04 1 2017-05-05 3 2017-05-08 26 2017-05-09 2 2017-05-10 2 2017-05-11 1 2017-05-12 3 2017-05-15 1 2017-05-16 1 2017-05-17 3 2017-05-18 4 2017-05-19 1 2017-05-20 16 2017-05-21 5 2017-05-22 7 2017-05-23 1 2017-05-24 2 2017-05-25 1 2017-05-26 5 2017-05-27 33 2017-05-28 2 2017-05-29 1 2017-05-30 6 2017-05-31 2 2017-06-01 8 2017-06-02 8 2017-06-05 3 2017-06-07 4 2017-06-08 4 2017-06-09 3 2017-06-10 8 2017-06-11 25 2017-06-12 10 2017-06-13 4 2017-06-14 19 2017-06-15 5 2017-06-16 2 2017-06-17 6 2017-06-18 5 2017-06-19 2 2017-06-20 4 2017-06-22 29 2017-06-23 8 2017-06-24 28 2017-06-25 4 2017-06-26 1 2017-06-27 6 2017-06-28 1 2017-06-30 3 2017-07-01 28 2017-07-02 1 2017-07-03 5 2017-07-04 11 2017-07-05 8 2017-07-06 4 2017-07-07 5 2017-07-08 3 2017-07-09 35 2017-07-10 1 2017-07-11 11 2017-07-12 5 2017-07-13 11 2017-07-14 6 2017-07-16 24 2017-07-17 2 2017-07-18 7 2017-07-20 2 2017-07-21 9 2017-07-22 68 2017-07-23 7 2017-07-24 4 2017-07-25 2 2017-07-26 15 2017-07-28 2 2017-07-29 25 2017-07-30 3 2017-07-31 7 2017-08-01 3 2017-08-02 15 2017-08-04 7 2017-08-05 26 2017-08-06 1 2017-08-07 11 2017-08-08 9 2017-08-10 3 2017-08-12 1 2017-08-14 5 2017-08-15 10 2017-08-16 5 2017-08-17 27 2017-08-18 2 2017-08-23 1 2017-08-26 6 2017-08-27 1 2017-08-28 7 2017-08-29 2 2017-08-30 2 2017-08-31 1 2017-09-01 1 2017-09-03 26 2017-09-04 1 2017-09-05 3 2017-09-06 2 2017-09-08 1 2017-09-09 1 2017-09-11 1 2017-09-12 4 2017-09-14 1 2017-09-17 1 2017-09-20 1 2017-09-22 3 2017-09-25 1 2017-09-28 1 2017-09-29 1 2017-09-30 1 2017-10-01 2 2017-10-02 2 2017-10-03 1 2017-10-04 1 2017-10-05 4 2017-10-06 4 2017-10-07 4 2017-10-08 23 2017-10-09 38 2017-10-10 4 2017-10-11 1 2017-10-12 4 2017-10-16 6 2017-10-18 3 2017-10-19 6 2017-10-24 5 2017-10-25 3 2017-10-26 2 2017-10-27 26 2017-10-28 2 2017-10-29 13 2017-10-30 2 2017-10-31 1 2017-11-01 3 2017-11-02 2 2017-11-03 1 2017-11-04 21 2017-11-05 3 2017-11-07 3 2017-11-08 8 2017-11-09 10 2017-11-10 23 2017-11-11 1 2017-11-12 4 2017-11-13 1 2017-11-14 18 2017-11-15 2 2017-11-16 2 2017-11-18 3 2017-11-20 8 2017-11-21 2 2017-11-22 5 2017-11-26 1 2017-12-04 1 2017-12-06 2 2017-12-09 2 2017-12-10 1 2017-12-11 2 2017-12-12 1 2017-12-13 1 2017-12-14 22 2017-12-15 2 2017-12-16 2 2017-12-17 1 2017-12-18 1 2017-12-20 3 2017-12-21 1 2017-12-22 22 2017-12-23 2 2017-12-24 10 2017-12-25 2 2017-12-30 14 2017-12-31 2 2018-01-01 9 2018-01-02 17 2018-01-03 1 2018-01-04 3 2018-01-05 4 2018-01-06 1 2018-01-07 3 2018-01-08 4 2018-01-09 3 2018-01-10 5 2018-01-11 5 2018-01-13 28 2018-01-14 2 2018-01-15 1 2018-01-16 4 2018-01-17 7 2018-01-18 2 2018-01-19 4 2018-01-22 4 2018-01-23 3 2018-01-25 3 2018-01-26 6 2018-01-27 2 2018-01-28 5 2018-01-29 1 2018-01-30 3 2018-01-31 2 2018-02-02 2 2018-02-04 5 2018-02-05 1 2018-02-06 2 2018-02-07 4 2018-02-08 2 2018-02-09 1 2018-02-10 1 2018-02-11 2 2018-02-14 1 2018-02-16 1 2018-02-17 1 2018-02-18 1 2018-02-19 1 2018-02-21 2 2018-02-22 2 2018-02-25 3 2018-02-26 2 2018-02-27 1 2018-02-28 1 2018-03-02 2 2018-03-05 7 2018-03-06 4 2018-03-07 1 2018-03-08 3 2018-03-09 2 2018-03-10 15 2018-03-12 3 2018-03-14 1 2018-03-15 1 2018-03-20 2 2018-03-21 3 2018-03-23 2 2018-03-27 2 2018-04-04 1 2018-04-07 1 2018-04-20 1 2018-04-21 9 2018-04-22 2 2018-04-23 1 2018-04-24 4 2018-04-26 1 2018-04-27 2 2018-05-01 5 2018-05-03 11 2018-05-04 11 2018-05-05 6 2018-05-06 10 2018-05-07 2 2018-05-08 1 2018-05-10 23 2018-05-11 2 2018-05-12 15 2018-05-13 18 2018-05-14 4 2018-05-15 2 2018-05-16 7 2018-05-17 4 2018-05-18 1 2018-05-19 17 2018-05-20 19 2018-05-25 1 2018-05-26 3 2018-05-30 4 2018-05-31 2 2018-06-02 2 2018-06-03 1 2018-06-04 10 2018-06-05 4 2018-06-07 1 2018-06-08 1 2018-06-09 23 2018-06-10 3 2018-06-11 6 2018-06-12 5 2018-06-13 13 2018-06-14 15 2018-06-15 4 2018-06-16 12 2018-06-17 6 2018-06-18 11 2018-06-20 3 2018-06-22 19 2018-06-23 3 2018-06-24 4 2018-06-25 4 2018-06-27 7 2018-06-28 5 2018-06-29 7 2018-06-30 2 2018-07-01 7 2018-07-03 2 2018-07-05 2 2018-07-06 1 2018-07-09 4 2018-07-10 2 2018-07-11 1 2018-07-13 1 2018-07-14 1 2018-07-18 2 2018-07-19 4 2018-07-20 1 2018-07-23 5 2018-07-25 1 2018-07-27 1 2018-07-28 1 2018-07-29 1 2018-07-30 1 2018-07-31 1 2018-08-01 2 2018-08-05 1 2018-08-06 1 2018-08-07 3 2018-08-08 2 2018-08-10 1 2018-08-14 3 2018-08-15 3 2018-08-24 1 2018-08-25 11 2018-08-26 7 2018-08-27 1 2018-08-28 4 2018-08-29 3 2018-09-01 9 2018-09-02 7 2018-09-03 10 2018-09-04 1 2018-09-05 18 2018-09-08 1 2018-09-09 20 2018-09-10 3 2018-09-11 1 2018-09-19 2 2018-09-21 1 2018-09-22 8 2018-09-23 3 2018-09-24 1 2018-09-26 1 2018-09-29 5 2018-09-30 2 2018-10-03 8 2018-10-04 1 2018-10-06 11 2018-10-07 1 2018-10-08 2 2018-10-10 2 2018-10-11 1 2018-10-12 1 2018-10-13 1 2018-10-14 1 2018-10-15 1 2018-10-16 2 2018-10-18 2 2018-10-25 1 2018-11-02 1 2018-11-03 2 2018-11-04 2
よさそう👌 上限を超えそうな期間について月別や日別にパーティションを切りたいときはちょっと頑張る必要がありそうです。
%md