PREVIEW / futures_1hour / 2012-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-23.parquet
  size:    47 KB
  rows:    1,448

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-04-23 00:00:00	ES	Futures	1389.14	1389.64	1388.63	1389.39	677.0
2012-04-23 01:00:00	ES	Futures	1389.39	1389.64	1388.38	1388.88	1260.0
2012-04-23 02:00:00	ES	Futures	1388.88	1389.14	1385.34	1387.37	8427.0
2012-04-23 03:00:00	ES	Futures	1387.37	1387.37	1380.28	1380.54	62384.0
2012-04-23 04:00:00	ES	Futures	1380.54	1381.04	1377.25	1379.27	36048.0
2012-04-23 05:00:00	ES	Futures	1379.02	1379.27	1376.23	1378.26	32191.0
2012-04-23 06:00:00	ES	Futures	1378.01	1378.76	1376.74	1377.75	19441.0
2012-04-23 07:00:00	ES	Futures	1377.75	1378.76	1375.73	1377.5	44873.0
2012-04-23 08:00:00	ES	Futures	1377.5	1378.76	1375.98	1378.01	49752.0
2012-04-23 09:00:00	ES	Futures	1377.75	1378.01	1371.68	1373.71	315521.0
2012-04-23 10:00:00	ES	Futures	1373.96	1374.46	1370.16	1373.2	415969.0
2012-04-23 11:00:00	ES	Futures	1372.95	1375.48	1372.44	1375.22	207668.0
2012-04-23 12:00:00	ES	Futures	1375.22	1377.5	1374.46	1375.48	127737.0
2012-04-23 13:00:00	ES	Futures	1375.48	1376.99	1374.72	1375.48	73912.0
2012-04-23 14:00:00	ES	Futures	1375.73	1380.28	1373.2	1376.49	164414.0
2012-04-23 15:00:00	ES	Futures	1376.49	1380.03	1376.23	1379.02	177530.0
2012-04-23 16:00:00	ES	Futures	1378.76	1380.79	1378.26	1380.54	79282.0
2012-04-23 17:00:00	ES	Futures	1380.54	1380.79	1379.78	1380.79	2271.0
2012-04-23 18:00:00	ES	Futures	1380.54	1381.04	1380.03	1380.28	3146.0
2012-04-23 19:00:00	ES	Futures	1380.28	1380.54	1379.27	1379.78	2725.0
2012-04-23 20:00:00	ES	Futures	1379.78	1382.56	1379.52	1381.8	7406.0
2012-04-23 21:00:00	ES	Futures	1381.8	1382.31	1379.78	1382.31	5061.0
2012-04-23 22:00:00	ES	Futures	1382.31	1383.82	1381.29	1381.29	9065.0
2012-04-23 23:00:00	ES	Futures	1381.29	1381.55	1379.52	1380.54	4937.0
2012-04-23 00:00:00	NQ	Futures	3088.66	3090.11	3088.08	3089.24	205.0
2012-04-23 01:00:00	NQ	Futures	3089.53	3090.4	3088.37	3088.95	237.0
2012-04-23 02:00:00	NQ	Futures	3088.95	3089.53	3081.14	3083.75	1215.0
2012-04-23 03:00:00	NQ	Futures	3083.75	3083.75	3072.47	3073.33	5869.0
2012-04-23 04:00:00	NQ	Futures	3073.33	3073.62	3066.1	3070.15	3064.0
2012-04-23 05:00:00	NQ	Futures	3069.86	3070.44	3063.21	3068.13	2757.0
2012-04-23 06:00:00	NQ	Futures	3067.84	3068.42	3063.79	3065.24	1678.0
2012-04-23 07:00:00	NQ	Futures	3064.95	3068.42	3061.48	3066.68	4124.0
2012-04-23 08:00:00	NQ	Futures	3066.68	3071.31	3064.08	3069.86	6103.0
2012-04-23 09:00:00	NQ	Futures	3070.15	3070.15	3049.91	3056.56	61635.0
2012-04-23 10:00:00	NQ	Futures	3056.56	3057.43	3036.61	3041.23	80641.0
2012-04-23 11:00:00	NQ	Futures	3041.23	3053.67	3037.47	3053.67	34853.0
2012-04-23 12:00:00	NQ	Futures	3053.38	3063.5	3051.64	3055.11	28227.0
2012-04-23 13:00:00	NQ	Futures	3055.11	3064.66	3054.25	3061.19	16955.0
2012-04-23 14:00:00	NQ	Futures	3061.48	3069.29	3051.64	3059.16	29460.0
2012-04-23 15:00:00	NQ	Futures	3059.16	3068.71	3058.58	3066.1	30334.0
2012-04-23 16:00:00	NQ	Futures	3066.1	3071.89	3064.95	3071.6	8884.0
2012-04-23 17:00:00	NQ	Futures	3071.6	3071.89	3069.86	3071.31	257.0
2012-04-23 18:00:00	NQ	Futures	3071.02	3071.31	3069.86	3070.44	215.0
2012-04-23 19:00:00	NQ	Futures	3070.15	3071.02	3068.13	3068.42	234.0
2012-04-23 20:00:00	NQ	Futures	3068.42	3073.62	3068.13	3072.76	580.0
2012-04-23 21:00:00	NQ	Futures	3072.76	3073.33	3068.71	3073.33	533.0
2012-04-23 22:00:00	NQ	Futures	3073.04	3076.52	3070.44	3070.44	1007.0
2012-04-23 23:00:00	NQ	Futures	3070.44	3071.02	3067.26	3069.0	534.0
2012-04-23 00:00:00	YM	Futures	12913.0	12919.0	12911.0	12916.0	140.0
2012-04-23 01:00:00	YM	Futures	12916.0	12918.0	12910.0	12911.0	144.0

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

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