PREVIEW / futures_1hour / 2017-01-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-22.parquet
  size:    15 KB
  rows:    306

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
2017-01-22 18:00:00	ES	Futures	2472.38	2472.92	2465.29	2465.83	16679.0
2017-01-22 19:00:00	ES	Futures	2465.56	2466.65	2464.47	2464.74	7519.0
2017-01-22 20:00:00	ES	Futures	2464.74	2467.74	2464.74	2465.29	6827.0
2017-01-22 21:00:00	ES	Futures	2465.29	2466.92	2464.74	2466.38	3486.0
2017-01-22 22:00:00	ES	Futures	2466.38	2466.65	2465.56	2466.1	3666.0
2017-01-22 23:00:00	ES	Futures	2466.1	2466.38	2465.29	2466.38	1669.0
2017-01-22 18:00:00	NQ	Futures	6036.8	6037.69	6018.9	6019.8	2329.0
2017-01-22 19:00:00	NQ	Futures	6019.8	6021.59	6013.53	6015.32	1982.0
2017-01-22 20:00:00	NQ	Futures	6015.02	6022.48	6014.72	6018.01	1821.0
2017-01-22 21:00:00	NQ	Futures	6018.01	6021.88	6015.02	6020.39	960.0
2017-01-22 22:00:00	NQ	Futures	6020.39	6020.69	6017.41	6019.5	859.0
2017-01-22 23:00:00	NQ	Futures	6019.5	6020.69	6017.71	6020.69	479.0
2017-01-22 18:00:00	YM	Futures	21419.8	21436.1	21376.4	21377.5	2403.0
2017-01-22 19:00:00	YM	Futures	21378.6	21384.0	21368.8	21373.1	1423.0
2017-01-22 20:00:00	YM	Futures	21372.1	21399.2	21372.1	21379.7	1693.0
2017-01-22 21:00:00	YM	Futures	21380.7	21392.7	21376.4	21390.5	727.0
2017-01-22 22:00:00	YM	Futures	21390.5	21390.5	21378.6	21386.2	743.0
2017-01-22 23:00:00	YM	Futures	21386.2	21391.6	21381.8	21391.6	615.0
2017-01-22 18:00:00	CL	Futures	50.55	50.68	50.39	50.53	4830.0
2017-01-22 19:00:00	CL	Futures	50.53	50.55	50.48	50.51	1182.0
2017-01-22 20:00:00	CL	Futures	50.51	50.53	50.43	50.5	2022.0
2017-01-22 21:00:00	CL	Futures	50.51	50.56	50.49	50.52	1940.0
2017-01-22 22:00:00	CL	Futures	50.51	50.55	50.49	50.5	1066.0
2017-01-22 23:00:00	CL	Futures	50.5	50.5	50.29	50.37	4030.0
2017-01-22 18:00:00	GC	Futures	1632.2	1640.7	1632.2	1640.5	5983.0
2017-01-22 19:00:00	GC	Futures	1640.5	1641.6	1639.0	1640.1	6417.0
2017-01-22 20:00:00	GC	Futures	1640.1	1643.6	1639.3	1643.4	9799.0
2017-01-22 21:00:00	GC	Futures	1643.6	1645.9	1643.0	1644.0	9912.0
2017-01-22 22:00:00	GC	Futures	1644.1	1644.7	1642.0	1642.1	5210.0
2017-01-22 23:00:00	GC	Futures	1642.2	1642.2	1638.9	1639.0	4667.0
2017-01-22 18:00:00	ZN	Futures	122.554915	122.832503	122.554915	122.817081	23861.0
2017-01-22 19:00:00	ZN	Futures	122.80166	122.863346	122.770817	122.863346	19914.0
2017-01-22 20:00:00	ZN	Futures	122.847924	122.878767	122.817081	122.878767	20872.0
2017-01-22 21:00:00	ZN	Futures	122.878767	122.925032	122.863346	122.878767	16353.0
2017-01-22 22:00:00	ZN	Futures	122.878767	122.909611	122.832503	122.847924	9777.0
2017-01-22 23:00:00	ZN	Futures	122.832503	122.863346	122.786238	122.80166	10869.0

> showing 36 of 306 rows — these rows as CSV

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