PREVIEW / futures_1hour / 2011-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-24.parquet
  size:    48 KB
  rows:    1,459

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-05-24 00:00:00	ES	Futures	1308.98	1309.73	1308.24	1309.73	2796.0
2011-05-24 01:00:00	ES	Futures	1309.48	1310.22	1308.48	1308.48	6081.0
2011-05-24 02:00:00	ES	Futures	1308.73	1311.22	1307.24	1310.22	20314.0
2011-05-24 03:00:00	ES	Futures	1310.22	1311.96	1309.73	1309.73	25684.0
2011-05-24 04:00:00	ES	Futures	1309.73	1311.96	1309.73	1310.47	20530.0
2011-05-24 05:00:00	ES	Futures	1310.47	1312.96	1309.97	1312.46	20354.0
2011-05-24 06:00:00	ES	Futures	1312.21	1312.21	1308.98	1310.97	28793.0
2011-05-24 07:00:00	ES	Futures	1310.97	1310.97	1308.24	1310.47	22033.0
2011-05-24 08:00:00	ES	Futures	1310.47	1312.71	1310.47	1311.96	37467.0
2011-05-24 09:00:00	ES	Futures	1311.96	1312.71	1309.73	1311.96	201650.0
2011-05-24 10:00:00	ES	Futures	1312.21	1314.2	1307.24	1307.99	359033.0
2011-05-24 11:00:00	ES	Futures	1307.74	1310.72	1306.0	1306.74	284580.0
2011-05-24 12:00:00	ES	Futures	1306.99	1307.24	1304.76	1305.75	191413.0
2011-05-24 13:00:00	ES	Futures	1305.75	1307.49	1303.52	1306.74	142488.0
2011-05-24 14:00:00	ES	Futures	1306.5	1309.23	1305.75	1308.48	141338.0
2011-05-24 15:00:00	ES	Futures	1308.48	1310.47	1305.75	1306.25	215174.0
2011-05-24 16:00:00	ES	Futures	1306.5	1306.5	1303.02	1304.26	95733.0
2011-05-24 17:00:00	ES	Futures	1304.26	1305.25	1304.01	1304.26	3146.0
2011-05-24 18:00:00	ES	Futures	1304.01	1305.01	1303.76	1305.01	3403.0
2011-05-24 19:00:00	ES	Futures	1304.76	1305.25	1303.76	1303.76	3409.0
2011-05-24 20:00:00	ES	Futures	1304.01	1304.26	1298.3	1300.53	21556.0
2011-05-24 21:00:00	ES	Futures	1300.53	1300.78	1294.07	1296.56	32509.0
2011-05-24 22:00:00	ES	Futures	1296.56	1297.8	1296.31	1297.3	6566.0
2011-05-24 23:00:00	ES	Futures	1297.3	1298.3	1296.31	1297.3	5002.0
2011-05-24 00:00:00	NQ	Futures	2665.71	2665.99	2663.12	2665.99	215.0
2011-05-24 01:00:00	NQ	Futures	2665.99	2667.43	2661.97	2662.26	735.0
2011-05-24 02:00:00	NQ	Futures	2661.97	2665.71	2659.39	2664.84	1937.0
2011-05-24 03:00:00	NQ	Futures	2663.98	2667.72	2663.7	2663.7	1589.0
2011-05-24 04:00:00	NQ	Futures	2663.41	2668.58	2663.41	2665.71	2167.0
2011-05-24 05:00:00	NQ	Futures	2665.42	2669.73	2663.98	2669.15	1488.0
2011-05-24 06:00:00	NQ	Futures	2668.87	2669.15	2662.83	2666.28	2189.0
2011-05-24 07:00:00	NQ	Futures	2666.28	2666.57	2661.4	2666.28	1962.0
2011-05-24 08:00:00	NQ	Futures	2666.28	2670.59	2666.28	2668.87	4296.0
2011-05-24 09:00:00	NQ	Futures	2669.15	2671.17	2657.66	2661.11	40912.0
2011-05-24 10:00:00	NQ	Futures	2661.4	2664.56	2652.49	2654.5	50463.0
2011-05-24 11:00:00	NQ	Futures	2654.79	2659.1	2649.9	2651.34	26268.0
2011-05-24 12:00:00	NQ	Futures	2651.34	2652.78	2648.47	2649.04	22557.0
2011-05-24 13:00:00	NQ	Futures	2649.04	2653.06	2644.73	2651.05	23399.0
2011-05-24 14:00:00	NQ	Futures	2651.05	2654.79	2649.62	2652.49	17708.0
2011-05-24 15:00:00	NQ	Futures	2652.2	2655.65	2644.45	2644.73	33168.0
2011-05-24 16:00:00	NQ	Futures	2645.02	2647.89	2638.99	2642.72	11151.0
2011-05-24 17:00:00	NQ	Futures	2642.43	2643.58	2641.28	2642.15	95.0
2011-05-24 18:00:00	NQ	Futures	2641.86	2643.01	2639.56	2643.01	311.0
2011-05-24 19:00:00	NQ	Futures	2642.72	2643.87	2641.28	2642.15	254.0
2011-05-24 20:00:00	NQ	Futures	2641.57	2641.86	2628.93	2634.39	2050.0
2011-05-24 21:00:00	NQ	Futures	2634.68	2634.68	2621.46	2625.77	2258.0
2011-05-24 22:00:00	NQ	Futures	2626.06	2628.36	2625.48	2626.34	469.0
2011-05-24 23:00:00	NQ	Futures	2626.34	2628.07	2625.2	2626.63	419.0
2011-05-24 00:00:00	YM	Futures	11926.2	11931.0	11920.4	11930.0	122.0
2011-05-24 01:00:00	YM	Futures	11931.0	11933.9	11921.4	11921.4	220.0

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

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