PREVIEW / futures_1hour / 2011-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-29.parquet
  size:    46 KB
  rows:    1,441

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-12-29 00:00:00	ES	Futures	1259.44	1260.7	1258.68	1259.44	2326.0
2011-12-29 01:00:00	ES	Futures	1259.18	1259.69	1258.43	1258.68	2720.0
2011-12-29 02:00:00	ES	Futures	1258.68	1260.7	1258.68	1259.18	4119.0
2011-12-29 03:00:00	ES	Futures	1259.44	1260.44	1255.4	1256.16	17121.0
2011-12-29 04:00:00	ES	Futures	1256.41	1257.42	1254.14	1257.42	10529.0
2011-12-29 05:00:00	ES	Futures	1257.42	1258.18	1255.4	1256.66	14063.0
2011-12-29 06:00:00	ES	Futures	1256.92	1259.18	1256.16	1256.66	10598.0
2011-12-29 07:00:00	ES	Futures	1256.92	1258.93	1255.91	1258.93	12090.0
2011-12-29 08:00:00	ES	Futures	1258.68	1259.69	1256.92	1258.18	22654.0
2011-12-29 09:00:00	ES	Futures	1258.43	1261.45	1256.92	1260.19	117924.0
2011-12-29 10:00:00	ES	Futures	1260.44	1264.98	1259.94	1263.97	138593.0
2011-12-29 11:00:00	ES	Futures	1263.97	1265.48	1260.7	1265.23	142933.0
2011-12-29 12:00:00	ES	Futures	1265.23	1265.48	1262.21	1264.48	53558.0
2011-12-29 13:00:00	ES	Futures	1264.22	1265.74	1262.96	1264.73	57981.0
2011-12-29 14:00:00	ES	Futures	1264.73	1265.48	1263.97	1264.48	34795.0
2011-12-29 15:00:00	ES	Futures	1264.48	1268.51	1264.22	1267.25	141222.0
2011-12-29 16:00:00	ES	Futures	1267.25	1267.75	1265.74	1266.49	63864.0
2011-12-29 17:00:00	ES	Futures	1266.74	1267.5	1266.24	1266.49	1280.0
2011-12-29 18:00:00	ES	Futures	1266.49	1267.5	1266.24	1267.0	1927.0
2011-12-29 19:00:00	ES	Futures	1266.74	1267.75	1265.99	1266.74	2816.0
2011-12-29 20:00:00	ES	Futures	1266.74	1266.74	1265.74	1266.74	2340.0
2011-12-29 21:00:00	ES	Futures	1266.49	1267.0	1265.74	1265.99	2143.0
2011-12-29 22:00:00	ES	Futures	1265.99	1265.99	1263.72	1263.97	3363.0
2011-12-29 23:00:00	ES	Futures	1263.97	1265.23	1263.97	1264.48	1554.0
2011-12-29 00:00:00	NQ	Futures	2619.98	2622.0	2619.11	2619.4	179.0
2011-12-29 01:00:00	NQ	Futures	2619.4	2620.85	2618.25	2618.53	124.0
2011-12-29 02:00:00	NQ	Futures	2618.25	2622.0	2618.25	2619.69	263.0
2011-12-29 03:00:00	NQ	Futures	2619.69	2620.85	2610.45	2613.63	1968.0
2011-12-29 04:00:00	NQ	Futures	2613.63	2615.36	2608.72	2614.78	1314.0
2011-12-29 05:00:00	NQ	Futures	2614.78	2615.36	2611.31	2614.2	878.0
2011-12-29 06:00:00	NQ	Futures	2613.63	2617.38	2612.47	2613.91	937.0
2011-12-29 07:00:00	NQ	Futures	2613.91	2617.38	2612.18	2617.09	888.0
2011-12-29 08:00:00	NQ	Futures	2617.38	2618.82	2613.91	2618.25	2824.0
2011-12-29 09:00:00	NQ	Futures	2618.25	2620.85	2609.87	2612.18	14640.0
2011-12-29 10:00:00	NQ	Futures	2612.47	2623.44	2609.58	2621.42	17692.0
2011-12-29 11:00:00	NQ	Futures	2621.42	2628.64	2617.38	2628.35	13521.0
2011-12-29 12:00:00	NQ	Futures	2628.06	2628.93	2624.02	2628.64	7401.0
2011-12-29 13:00:00	NQ	Futures	2628.64	2632.11	2626.62	2629.22	9736.0
2011-12-29 14:00:00	NQ	Futures	2629.22	2631.24	2626.91	2628.35	4962.0
2011-12-29 15:00:00	NQ	Futures	2628.35	2636.15	2628.35	2632.11	17402.0
2011-12-29 16:00:00	NQ	Futures	2632.11	2634.71	2628.93	2633.26	4478.0
2011-12-29 17:00:00	NQ	Futures	2632.69	2633.84	2631.82	2632.97	52.0
2011-12-29 18:00:00	NQ	Futures	2632.69	2633.84	2632.11	2633.26	100.0
2011-12-29 19:00:00	NQ	Futures	2632.97	2634.71	2631.82	2633.55	303.0
2011-12-29 20:00:00	NQ	Futures	2633.26	2634.13	2632.11	2633.26	126.0
2011-12-29 21:00:00	NQ	Futures	2633.26	2633.55	2631.24	2632.11	71.0
2011-12-29 22:00:00	NQ	Futures	2631.53	2632.11	2628.35	2628.93	129.0
2011-12-29 23:00:00	NQ	Futures	2628.35	2629.51	2627.49	2628.35	189.0
2011-12-29 00:00:00	YM	Futures	12017.5	12023.5	12010.6	12012.6	154.0
2011-12-29 01:00:00	YM	Futures	12012.6	12021.5	12009.6	12011.6	176.0

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

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