PREVIEW / futures_1hour / 2012-12-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-13.parquet
  size:    48 KB
  rows:    1,491

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2012-12-13 00:00:00	ES	Futures	1460.74	1460.74	1459.46	1459.72	2465.0
2012-12-13 01:00:00	ES	Futures	1459.46	1459.72	1458.44	1459.21	3109.0
2012-12-13 02:00:00	ES	Futures	1458.95	1461.25	1458.95	1460.49	5427.0
2012-12-13 03:00:00	ES	Futures	1460.23	1461.0	1456.91	1457.42	23911.0
2012-12-13 04:00:00	ES	Futures	1457.42	1457.93	1456.65	1456.91	13079.0
2012-12-13 05:00:00	ES	Futures	1457.16	1457.42	1454.61	1457.16	25639.0
2012-12-13 06:00:00	ES	Futures	1456.91	1457.68	1455.89	1456.91	14695.0
2012-12-13 07:00:00	ES	Futures	1457.16	1458.7	1456.65	1457.68	19666.0
2012-12-13 08:00:00	ES	Futures	1457.68	1462.79	1457.16	1457.68	53598.0
2012-12-13 09:00:00	ES	Futures	1457.68	1460.74	1456.91	1459.72	126407.0
2012-12-13 10:00:00	ES	Futures	1459.46	1462.79	1458.7	1458.95	160649.0
2012-12-13 11:00:00	ES	Futures	1458.95	1459.46	1453.84	1456.14	238118.0
2012-12-13 12:00:00	ES	Futures	1456.4	1456.4	1449.76	1451.03	169737.0
2012-12-13 13:00:00	ES	Futures	1451.03	1451.8	1448.22	1450.27	94629.0
2012-12-13 14:00:00	ES	Futures	1450.27	1450.52	1446.69	1449.25	137749.0
2012-12-13 15:00:00	ES	Futures	1449.25	1454.35	1447.2	1451.03	246117.0
2012-12-13 16:00:00	ES	Futures	1451.29	1451.8	1448.22	1448.48	59704.0
2012-12-13 17:00:00	ES	Futures	1448.22	1448.99	1447.97	1448.48	1824.0
2012-12-13 18:00:00	ES	Futures	1447.71	1453.84	1447.2	1453.33	9495.0
2012-12-13 19:00:00	ES	Futures	1453.33	1453.84	1447.97	1448.99	6957.0
2012-12-13 20:00:00	ES	Futures	1448.73	1453.08	1448.22	1453.08	4631.0
2012-12-13 21:00:00	ES	Futures	1453.08	1453.84	1452.82	1453.59	3774.0
2012-12-13 22:00:00	ES	Futures	1453.59	1454.1	1452.57	1453.59	2719.0
2012-12-13 23:00:00	ES	Futures	1453.84	1454.1	1452.82	1453.59	2018.0
2012-12-13 00:00:00	NQ	Futures	3109.75	3112.36	3109.46	3111.49	577.0
2012-12-13 01:00:00	NQ	Futures	3110.62	3111.2	3108.88	3110.91	360.0
2012-12-13 02:00:00	NQ	Futures	3110.33	3114.11	3110.33	3112.65	690.0
2012-12-13 03:00:00	NQ	Futures	3112.65	3114.11	3104.23	3105.1	2721.0
2012-12-13 04:00:00	NQ	Futures	3104.81	3105.97	3102.19	3102.77	1944.0
2012-12-13 05:00:00	NQ	Futures	3102.77	3104.23	3098.71	3104.23	1891.0
2012-12-13 06:00:00	NQ	Futures	3104.23	3104.81	3101.03	3103.36	1167.0
2012-12-13 07:00:00	NQ	Futures	3102.77	3105.97	3101.03	3103.94	1572.0
2012-12-13 08:00:00	NQ	Futures	3103.94	3114.4	3099.87	3100.45	6695.0
2012-12-13 09:00:00	NQ	Futures	3100.45	3112.94	3100.16	3105.39	28875.0
2012-12-13 10:00:00	NQ	Futures	3105.1	3125.73	3102.48	3114.98	45881.0
2012-12-13 11:00:00	NQ	Futures	3114.98	3116.43	3093.48	3098.42	42722.0
2012-12-13 12:00:00	NQ	Futures	3098.13	3099.87	3077.2	3079.53	34113.0
2012-12-13 13:00:00	NQ	Futures	3079.53	3085.05	3075.75	3082.14	21730.0
2012-12-13 14:00:00	NQ	Futures	3082.14	3082.43	3071.39	3078.95	20882.0
2012-12-13 15:00:00	NQ	Futures	3078.66	3090.28	3073.14	3085.34	32428.0
2012-12-13 16:00:00	NQ	Futures	3085.34	3086.21	3078.95	3080.4	5431.0
2012-12-13 17:00:00	NQ	Futures	3080.11	3081.56	3079.82	3081.56	202.0
2012-12-13 18:00:00	NQ	Futures	3080.4	3090.86	3079.24	3090.28	679.0
2012-12-13 19:00:00	NQ	Futures	3089.41	3089.7	3078.66	3080.4	656.0
2012-12-13 20:00:00	NQ	Futures	3080.98	3089.12	3080.11	3089.12	341.0
2012-12-13 21:00:00	NQ	Futures	3089.41	3090.86	3087.96	3088.83	823.0
2012-12-13 22:00:00	NQ	Futures	3089.41	3089.99	3087.37	3089.99	298.0
2012-12-13 23:00:00	NQ	Futures	3089.99	3090.57	3088.25	3089.99	332.0
2012-12-13 00:00:00	YM	Futures	13266.5	13269.5	13262.4	13264.4	79.0
2012-12-13 01:00:00	YM	Futures	13262.4	13262.4	13254.4	13260.4	39.0

> showing 50 of 1,491 rows — these rows as CSV

> unlock the full archive -- $79 one-time