PREVIEW / futures_1hour / 2011-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-15.parquet
  size:    40 KB
  rows:    1,177

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-04-15 00:00:00	ES	Futures	1300.53	1301.53	1300.53	1301.03	1944.0
2011-04-15 01:00:00	ES	Futures	1300.78	1301.03	1299.79	1300.53	4351.0
2011-04-15 02:00:00	ES	Futures	1300.53	1301.78	1300.04	1301.53	5728.0
2011-04-15 03:00:00	ES	Futures	1301.53	1302.02	1297.8	1298.05	22986.0
2011-04-15 04:00:00	ES	Futures	1297.8	1299.79	1297.8	1299.04	12599.0
2011-04-15 05:00:00	ES	Futures	1299.04	1300.53	1297.55	1299.79	12541.0
2011-04-15 06:00:00	ES	Futures	1299.79	1301.03	1299.29	1300.53	11663.0
2011-04-15 07:00:00	ES	Futures	1300.29	1301.03	1298.79	1299.54	32998.0
2011-04-15 08:00:00	ES	Futures	1299.54	1302.52	1297.8	1301.53	84072.0
2011-04-15 09:00:00	ES	Futures	1301.78	1306.0	1301.28	1305.01	304043.0
2011-04-15 10:00:00	ES	Futures	1305.01	1308.24	1302.27	1305.5	315845.0
2011-04-15 11:00:00	ES	Futures	1305.75	1307.99	1303.76	1306.99	143665.0
2011-04-15 12:00:00	ES	Futures	1307.24	1310.72	1306.99	1310.72	144245.0
2011-04-15 13:00:00	ES	Futures	1310.47	1310.97	1308.24	1308.48	64908.0
2011-04-15 14:00:00	ES	Futures	1308.48	1309.97	1308.24	1309.23	57104.0
2011-04-15 15:00:00	ES	Futures	1309.23	1309.73	1306.0	1307.99	250521.0
2011-04-15 16:00:00	ES	Futures	1307.99	1310.72	1307.74	1310.72	119231.0
2011-04-15 00:00:00	NQ	Futures	2641.0	2641.57	2640.71	2641.0	204.0
2011-04-15 01:00:00	NQ	Futures	2641.0	2641.0	2638.99	2640.42	408.0
2011-04-15 02:00:00	NQ	Futures	2640.71	2643.01	2639.85	2643.01	587.0
2011-04-15 03:00:00	NQ	Futures	2643.01	2644.45	2637.55	2637.84	1738.0
2011-04-15 04:00:00	NQ	Futures	2637.84	2640.71	2637.55	2638.99	791.0
2011-04-15 05:00:00	NQ	Futures	2639.56	2642.43	2637.26	2641.28	845.0
2011-04-15 06:00:00	NQ	Futures	2641.28	2643.3	2640.42	2642.43	875.0
2011-04-15 07:00:00	NQ	Futures	2642.43	2644.16	2639.56	2640.71	1459.0
2011-04-15 08:00:00	NQ	Futures	2640.71	2643.01	2636.4	2642.15	4855.0
2011-04-15 09:00:00	NQ	Futures	2642.15	2649.04	2630.94	2638.7	46340.0
2011-04-15 10:00:00	NQ	Futures	2638.41	2647.89	2638.12	2645.88	54692.0
2011-04-15 11:00:00	NQ	Futures	2645.88	2653.06	2644.16	2648.76	23352.0
2011-04-15 12:00:00	NQ	Futures	2648.47	2658.52	2648.47	2657.37	23666.0
2011-04-15 13:00:00	NQ	Futures	2657.66	2659.1	2650.19	2650.77	13664.0
2011-04-15 14:00:00	NQ	Futures	2650.48	2653.64	2649.9	2651.92	11091.0
2011-04-15 15:00:00	NQ	Futures	2651.92	2652.2	2643.3	2648.18	39547.0
2011-04-15 16:00:00	NQ	Futures	2648.47	2655.94	2647.61	2654.79	8633.0
2011-04-15 00:00:00	YM	Futures	11760.5	11767.3	11760.5	11762.4	164.0
2011-04-15 01:00:00	YM	Futures	11763.4	11764.4	11753.8	11761.5	349.0
2011-04-15 02:00:00	YM	Futures	11761.5	11773.0	11757.6	11772.1	372.0
2011-04-15 03:00:00	YM	Futures	11772.1	11774.0	11740.3	11741.3	1396.0
2011-04-15 04:00:00	YM	Futures	11740.3	11762.4	11740.3	11756.7	765.0
2011-04-15 05:00:00	YM	Futures	11757.6	11758.6	11737.4	11752.8	1069.0
2011-04-15 06:00:00	YM	Futures	11751.9	11762.4	11750.9	11761.5	820.0
2011-04-15 07:00:00	YM	Futures	11758.6	11768.2	11750.9	11756.7	2136.0
2011-04-15 08:00:00	YM	Futures	11757.6	11777.9	11744.1	11771.1	2362.0
2011-04-15 09:00:00	YM	Futures	11770.2	11811.6	11765.3	11796.2	15766.0
2011-04-15 10:00:00	YM	Futures	11796.2	11827.0	11784.6	11810.6	15347.0
2011-04-15 11:00:00	YM	Futures	11810.6	11827.0	11796.2	11820.2	7362.0
2011-04-15 12:00:00	YM	Futures	11821.2	11858.8	11819.3	11855.9	11479.0
2011-04-15 13:00:00	YM	Futures	11856.8	11860.7	11838.5	11845.3	5193.0
2011-04-15 14:00:00	YM	Futures	11845.3	11856.8	11842.4	11849.1	3894.0
2011-04-15 15:00:00	YM	Futures	11849.1	11851.1	11824.1	11837.6	14954.0

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

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