PREVIEW / futures_1hour / 2012-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-12.parquet
  size:    48 KB
  rows:    1,473

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
2012-01-12 00:00:00	ES	Futures	1296.48	1297.49	1296.48	1296.98	1701.0
2012-01-12 01:00:00	ES	Futures	1296.98	1297.74	1296.73	1296.98	1845.0
2012-01-12 02:00:00	ES	Futures	1296.98	1297.74	1296.23	1296.98	4838.0
2012-01-12 03:00:00	ES	Futures	1297.23	1297.74	1295.72	1296.73	17856.0
2012-01-12 04:00:00	ES	Futures	1296.73	1302.02	1295.22	1301.52	30579.0
2012-01-12 05:00:00	ES	Futures	1301.77	1305.05	1301.01	1304.54	37742.0
2012-01-12 06:00:00	ES	Futures	1304.29	1305.3	1302.78	1304.79	27174.0
2012-01-12 07:00:00	ES	Futures	1304.79	1307.82	1304.29	1305.8	47937.0
2012-01-12 08:00:00	ES	Futures	1305.55	1305.8	1299.25	1300.51	108875.0
2012-01-12 09:00:00	ES	Futures	1300.51	1303.03	1296.73	1298.75	238381.0
2012-01-12 10:00:00	ES	Futures	1298.49	1300.01	1290.93	1292.95	398391.0
2012-01-12 11:00:00	ES	Futures	1292.95	1296.48	1292.7	1295.72	221372.0
2012-01-12 12:00:00	ES	Futures	1295.72	1299.0	1295.47	1298.49	107105.0
2012-01-12 13:00:00	ES	Futures	1298.49	1300.26	1296.73	1298.75	108150.0
2012-01-12 14:00:00	ES	Futures	1298.49	1301.27	1296.98	1300.76	111174.0
2012-01-12 15:00:00	ES	Futures	1300.51	1302.53	1299.25	1301.01	195095.0
2012-01-12 16:00:00	ES	Futures	1301.27	1302.53	1300.76	1301.77	70460.0
2012-01-12 17:00:00	ES	Futures	1301.77	1302.27	1301.52	1302.02	1041.0
2012-01-12 18:00:00	ES	Futures	1301.77	1302.53	1301.52	1302.27	3879.0
2012-01-12 19:00:00	ES	Futures	1302.27	1304.54	1302.27	1303.53	6203.0
2012-01-12 20:00:00	ES	Futures	1303.79	1303.79	1302.27	1303.03	3874.0
2012-01-12 21:00:00	ES	Futures	1302.78	1303.28	1301.52	1301.52	3277.0
2012-01-12 22:00:00	ES	Futures	1301.52	1302.27	1301.27	1301.52	2911.0
2012-01-12 23:00:00	ES	Futures	1301.27	1302.53	1301.27	1302.27	1776.0
2012-01-12 00:00:00	NQ	Futures	2731.17	2733.48	2731.17	2732.61	137.0
2012-01-12 01:00:00	NQ	Futures	2732.9	2734.34	2732.9	2733.77	162.0
2012-01-12 02:00:00	NQ	Futures	2733.48	2734.34	2732.61	2733.77	378.0
2012-01-12 03:00:00	NQ	Futures	2733.77	2736.08	2732.61	2734.92	1348.0
2012-01-12 04:00:00	NQ	Futures	2735.21	2745.32	2732.03	2744.45	1903.0
2012-01-12 05:00:00	NQ	Futures	2744.74	2751.09	2743.87	2749.36	1617.0
2012-01-12 06:00:00	NQ	Futures	2749.65	2750.52	2745.89	2747.05	1861.0
2012-01-12 07:00:00	NQ	Futures	2746.76	2752.83	2746.47	2748.21	2363.0
2012-01-12 08:00:00	NQ	Futures	2747.63	2748.21	2738.39	2740.41	7017.0
2012-01-12 09:00:00	NQ	Futures	2740.41	2746.18	2731.17	2736.08	23454.0
2012-01-12 10:00:00	NQ	Futures	2736.08	2738.39	2721.35	2727.41	36179.0
2012-01-12 11:00:00	NQ	Futures	2727.41	2739.54	2727.12	2738.1	17822.0
2012-01-12 12:00:00	NQ	Futures	2738.1	2741.56	2736.65	2740.41	18083.0
2012-01-12 13:00:00	NQ	Futures	2740.7	2744.16	2737.52	2742.43	10608.0
2012-01-12 14:00:00	NQ	Futures	2742.14	2747.63	2739.54	2747.34	11585.0
2012-01-12 15:00:00	NQ	Futures	2747.63	2749.94	2744.74	2747.92	19695.0
2012-01-12 16:00:00	NQ	Futures	2747.63	2748.78	2745.61	2748.78	5037.0
2012-01-12 17:00:00	NQ	Futures	2749.07	2750.23	2748.21	2749.94	179.0
2012-01-12 18:00:00	NQ	Futures	2749.65	2750.52	2749.36	2750.23	226.0
2012-01-12 19:00:00	NQ	Futures	2750.23	2753.98	2749.94	2752.54	426.0
2012-01-12 20:00:00	NQ	Futures	2752.25	2752.54	2750.52	2751.09	254.0
2012-01-12 21:00:00	NQ	Futures	2751.67	2751.67	2748.78	2749.07	209.0
2012-01-12 22:00:00	NQ	Futures	2749.36	2749.94	2748.49	2748.78	173.0
2012-01-12 23:00:00	NQ	Futures	2749.36	2750.8	2748.49	2750.23	139.0
2012-01-12 00:00:00	YM	Futures	12268.3	12274.2	12266.3	12269.3	158.0
2012-01-12 01:00:00	YM	Futures	12270.3	12274.2	12268.3	12270.3	158.0

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

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