PREVIEW / futures_1hour / 2011-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-19.parquet
  size:    49 KB
  rows:    1,450

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
2011-09-19 00:00:00	ES	Futures	1197.12	1197.37	1194.86	1195.11	2787.0
2011-09-19 01:00:00	ES	Futures	1195.36	1196.62	1193.86	1195.36	6168.0
2011-09-19 02:00:00	ES	Futures	1195.36	1196.37	1192.86	1193.61	22269.0
2011-09-19 03:00:00	ES	Futures	1193.86	1198.12	1191.1	1191.1	44457.0
2011-09-19 04:00:00	ES	Futures	1191.1	1195.11	1190.35	1191.6	33040.0
2011-09-19 05:00:00	ES	Futures	1191.35	1194.86	1190.85	1194.36	24886.0
2011-09-19 06:00:00	ES	Futures	1194.36	1197.87	1193.11	1197.12	23417.0
2011-09-19 07:00:00	ES	Futures	1197.12	1199.63	1196.37	1196.87	43097.0
2011-09-19 08:00:00	ES	Futures	1196.87	1197.87	1194.11	1194.11	62878.0
2011-09-19 09:00:00	ES	Futures	1194.11	1195.87	1186.09	1186.34	347835.0
2011-09-19 10:00:00	ES	Futures	1186.34	1190.6	1185.08	1187.59	290318.0
2011-09-19 11:00:00	ES	Futures	1187.59	1197.12	1187.59	1194.36	313032.0
2011-09-19 12:00:00	ES	Futures	1194.11	1196.62	1189.09	1190.1	194399.0
2011-09-19 13:00:00	ES	Futures	1190.1	1192.86	1188.09	1192.61	108934.0
2011-09-19 14:00:00	ES	Futures	1192.61	1198.62	1190.1	1193.61	190384.0
2011-09-19 15:00:00	ES	Futures	1193.61	1207.4	1191.85	1201.38	579358.0
2011-09-19 16:00:00	ES	Futures	1201.38	1203.39	1200.13	1201.13	92690.0
2011-09-19 17:00:00	ES	Futures	1201.38	1201.38	1199.38	1200.63	2335.0
2011-09-19 18:00:00	ES	Futures	1200.38	1201.63	1190.35	1190.6	22814.0
2011-09-19 19:00:00	ES	Futures	1190.35	1194.11	1189.09	1193.61	11525.0
2011-09-19 20:00:00	ES	Futures	1193.61	1196.62	1190.6	1194.61	12739.0
2011-09-19 21:00:00	ES	Futures	1194.61	1198.37	1194.36	1195.11	11857.0
2011-09-19 22:00:00	ES	Futures	1195.11	1195.36	1189.35	1190.85	11063.0
2011-09-19 23:00:00	ES	Futures	1190.35	1194.61	1188.84	1191.35	7250.0
2011-09-19 00:00:00	NQ	Futures	2624.89	2624.89	2621.14	2622.0	271.0
2011-09-19 01:00:00	NQ	Futures	2622.0	2623.73	2618.83	2621.43	696.0
2011-09-19 02:00:00	NQ	Futures	2621.72	2624.89	2617.1	2619.12	2757.0
2011-09-19 03:00:00	NQ	Futures	2618.83	2628.35	2613.35	2613.64	3484.0
2011-09-19 04:00:00	NQ	Futures	2613.64	2619.99	2611.05	2613.07	3057.0
2011-09-19 05:00:00	NQ	Futures	2612.78	2619.41	2611.34	2618.26	1567.0
2011-09-19 06:00:00	NQ	Futures	2618.26	2624.02	2615.37	2623.16	1774.0
2011-09-19 07:00:00	NQ	Futures	2622.87	2626.62	2621.14	2622.58	3188.0
2011-09-19 08:00:00	NQ	Futures	2622.87	2624.02	2618.83	2619.99	8241.0
2011-09-19 09:00:00	NQ	Futures	2619.7	2623.45	2600.09	2601.25	52030.0
2011-09-19 10:00:00	NQ	Futures	2600.96	2616.53	2599.8	2611.62	40845.0
2011-09-19 11:00:00	NQ	Futures	2611.91	2648.53	2611.62	2637.57	48017.0
2011-09-19 12:00:00	NQ	Futures	2637.86	2642.76	2625.75	2628.92	25484.0
2011-09-19 13:00:00	NQ	Futures	2628.64	2637.86	2624.02	2637.29	20752.0
2011-09-19 14:00:00	NQ	Futures	2637.0	2649.4	2630.08	2637.29	21521.0
2011-09-19 15:00:00	NQ	Futures	2637.86	2669.29	2632.67	2656.31	69863.0
2011-09-19 16:00:00	NQ	Futures	2656.31	2657.76	2650.26	2655.74	8388.0
2011-09-19 17:00:00	NQ	Futures	2654.58	2655.45	2651.41	2652.57	226.0
2011-09-19 18:00:00	NQ	Futures	2652.57	2654.87	2638.15	2638.44	1764.0
2011-09-19 19:00:00	NQ	Futures	2638.15	2643.92	2634.69	2642.19	1239.0
2011-09-19 20:00:00	NQ	Futures	2642.48	2647.95	2636.71	2644.49	1214.0
2011-09-19 21:00:00	NQ	Futures	2644.49	2652.57	2643.92	2645.07	1211.0
2011-09-19 22:00:00	NQ	Futures	2645.36	2645.65	2633.83	2638.15	857.0
2011-09-19 23:00:00	NQ	Futures	2637.57	2645.07	2634.11	2639.02	494.0
2011-09-19 00:00:00	YM	Futures	11122.6	11122.6	11108.8	11109.8	426.0
2011-09-19 01:00:00	YM	Futures	11110.8	11118.6	11096.0	11104.9	477.0

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

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