PREVIEW / futures_1hour / 2011-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-30.parquet
  size:    49 KB
  rows:    1,494

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-06-30 00:00:00	ES	Futures	1303.64	1304.14	1302.89	1303.89	2167.0
2011-06-30 01:00:00	ES	Futures	1304.14	1304.39	1303.14	1303.64	4234.0
2011-06-30 02:00:00	ES	Futures	1303.64	1304.14	1302.4	1303.14	9887.0
2011-06-30 03:00:00	ES	Futures	1303.39	1305.39	1302.65	1303.14	30536.0
2011-06-30 04:00:00	ES	Futures	1303.39	1304.64	1302.4	1304.14	16847.0
2011-06-30 05:00:00	ES	Futures	1303.89	1304.89	1302.65	1303.14	12629.0
2011-06-30 06:00:00	ES	Futures	1303.14	1303.64	1302.15	1302.4	11461.0
2011-06-30 07:00:00	ES	Futures	1302.15	1304.64	1301.4	1303.89	24514.0
2011-06-30 08:00:00	ES	Futures	1303.89	1304.89	1302.65	1304.64	40738.0
2011-06-30 09:00:00	ES	Futures	1304.89	1310.63	1302.4	1307.88	359012.0
2011-06-30 10:00:00	ES	Futures	1307.88	1312.37	1307.63	1309.88	297933.0
2011-06-30 11:00:00	ES	Futures	1310.13	1313.12	1309.88	1312.62	196888.0
2011-06-30 12:00:00	ES	Futures	1312.37	1313.62	1310.88	1311.37	125144.0
2011-06-30 13:00:00	ES	Futures	1311.37	1312.37	1309.38	1311.12	103982.0
2011-06-30 14:00:00	ES	Futures	1311.12	1312.12	1309.63	1310.63	87625.0
2011-06-30 15:00:00	ES	Futures	1310.38	1314.37	1309.13	1312.12	359425.0
2011-06-30 16:00:00	ES	Futures	1312.12	1312.87	1310.38	1310.63	147770.0
2011-06-30 17:00:00	ES	Futures	1310.63	1313.12	1310.38	1312.12	7904.0
2011-06-30 18:00:00	ES	Futures	1312.12	1312.87	1311.37	1312.62	3928.0
2011-06-30 19:00:00	ES	Futures	1312.37	1313.12	1310.63	1310.63	3761.0
2011-06-30 20:00:00	ES	Futures	1310.63	1312.12	1310.13	1310.38	6320.0
2011-06-30 21:00:00	ES	Futures	1310.38	1310.38	1309.38	1309.38	5732.0
2011-06-30 22:00:00	ES	Futures	1309.38	1310.38	1309.38	1310.38	3740.0
2011-06-30 23:00:00	ES	Futures	1310.38	1310.88	1310.13	1310.63	1713.0
2011-06-30 00:00:00	NQ	Futures	2643.7	2644.56	2641.4	2643.12	434.0
2011-06-30 01:00:00	NQ	Futures	2643.41	2644.28	2642.55	2643.12	233.0
2011-06-30 02:00:00	NQ	Futures	2643.7	2643.99	2640.53	2642.26	443.0
2011-06-30 03:00:00	NQ	Futures	2642.55	2646.29	2640.82	2642.26	2980.0
2011-06-30 04:00:00	NQ	Futures	2642.26	2647.73	2641.4	2646.87	2863.0
2011-06-30 05:00:00	NQ	Futures	2646.87	2649.45	2644.56	2645.43	3370.0
2011-06-30 06:00:00	NQ	Futures	2645.14	2646.58	2643.41	2643.7	1383.0
2011-06-30 07:00:00	NQ	Futures	2643.99	2648.88	2643.12	2647.44	2371.0
2011-06-30 08:00:00	NQ	Futures	2647.44	2650.32	2645.71	2648.88	4833.0
2011-06-30 09:00:00	NQ	Futures	2648.88	2660.97	2644.56	2657.51	39294.0
2011-06-30 10:00:00	NQ	Futures	2657.51	2668.74	2657.51	2662.98	36814.0
2011-06-30 11:00:00	NQ	Futures	2662.98	2673.92	2662.69	2670.75	24646.0
2011-06-30 12:00:00	NQ	Futures	2670.75	2672.76	2666.72	2669.89	14103.0
2011-06-30 13:00:00	NQ	Futures	2669.89	2671.04	2665.28	2668.74	11295.0
2011-06-30 14:00:00	NQ	Futures	2669.02	2670.75	2667.01	2669.02	12621.0
2011-06-30 15:00:00	NQ	Futures	2668.74	2674.49	2665.86	2671.61	32024.0
2011-06-30 16:00:00	NQ	Futures	2671.9	2673.34	2668.45	2669.02	8554.0
2011-06-30 17:00:00	NQ	Futures	2669.31	2670.46	2668.74	2668.74	366.0
2011-06-30 18:00:00	NQ	Futures	2670.46	2671.61	2668.74	2671.33	471.0
2011-06-30 19:00:00	NQ	Futures	2671.61	2672.76	2670.17	2670.17	545.0
2011-06-30 20:00:00	NQ	Futures	2670.17	2672.19	2668.45	2669.02	357.0
2011-06-30 21:00:00	NQ	Futures	2669.02	2669.02	2666.72	2666.72	564.0
2011-06-30 22:00:00	NQ	Futures	2667.3	2668.16	2667.01	2668.16	127.0
2011-06-30 23:00:00	NQ	Futures	2668.45	2669.02	2667.58	2668.16	171.0
2011-06-30 00:00:00	YM	Futures	11849.3	11853.2	11841.6	11851.3	161.0
2011-06-30 01:00:00	YM	Futures	11852.2	11856.1	11845.5	11852.2	461.0

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

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