PREVIEW / futures_1hour / 2016-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-02.parquet
  size:    45 KB
  rows:    1,318

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
2016-09-02 00:00:00	ES	Futures	2349.29	2349.56	2349.02	2349.56	1411.0
2016-09-02 01:00:00	ES	Futures	2349.56	2350.64	2349.29	2350.37	2898.0
2016-09-02 02:00:00	ES	Futures	2350.37	2351.73	2350.37	2351.46	6310.0
2016-09-02 03:00:00	ES	Futures	2351.73	2353.08	2348.2	2350.92	34815.0
2016-09-02 04:00:00	ES	Futures	2351.19	2352.27	2349.83	2350.92	22459.0
2016-09-02 05:00:00	ES	Futures	2350.92	2353.36	2350.64	2352.0	16626.0
2016-09-02 06:00:00	ES	Futures	2352.0	2353.36	2350.92	2352.27	14134.0
2016-09-02 07:00:00	ES	Futures	2352.27	2352.81	2349.83	2350.37	20044.0
2016-09-02 08:00:00	ES	Futures	2350.37	2359.32	2347.66	2358.78	123802.0
2016-09-02 09:00:00	ES	Futures	2358.51	2368.81	2357.97	2367.46	336137.0
2016-09-02 10:00:00	ES	Futures	2367.46	2368.81	2362.3	2363.39	262469.0
2016-09-02 11:00:00	ES	Futures	2363.39	2366.1	2360.95	2362.85	163173.0
2016-09-02 12:00:00	ES	Futures	2363.12	2363.39	2356.61	2359.59	151759.0
2016-09-02 13:00:00	ES	Futures	2359.86	2360.95	2355.8	2357.15	111235.0
2016-09-02 14:00:00	ES	Futures	2357.15	2362.3	2356.88	2361.76	120741.0
2016-09-02 15:00:00	ES	Futures	2361.76	2363.93	2360.95	2363.12	200457.0
2016-09-02 16:00:00	ES	Futures	2363.12	2364.2	2362.3	2363.93	68850.0
2016-09-02 00:00:00	NQ	Futures	5692.78	5693.08	5691.89	5693.08	158.0
2016-09-02 01:00:00	NQ	Futures	5693.38	5697.55	5693.38	5697.26	729.0
2016-09-02 02:00:00	NQ	Futures	5697.26	5701.73	5696.66	5701.43	1320.0
2016-09-02 03:00:00	NQ	Futures	5701.43	5708.28	5694.28	5702.32	5194.0
2016-09-02 04:00:00	NQ	Futures	5702.62	5705.3	5698.75	5701.43	2154.0
2016-09-02 05:00:00	NQ	Futures	5701.73	5707.69	5701.73	5705.0	1398.0
2016-09-02 06:00:00	NQ	Futures	5705.0	5707.99	5702.32	5704.71	1246.0
2016-09-02 07:00:00	NQ	Futures	5705.0	5707.09	5700.83	5701.43	1715.0
2016-09-02 08:00:00	NQ	Futures	5702.02	5723.19	5696.06	5721.1	20862.0
2016-09-02 09:00:00	NQ	Futures	5721.4	5740.77	5719.31	5738.68	50015.0
2016-09-02 10:00:00	NQ	Futures	5738.98	5743.75	5729.74	5730.94	35655.0
2016-09-02 11:00:00	NQ	Futures	5730.94	5736.6	5719.31	5723.78	23446.0
2016-09-02 12:00:00	NQ	Futures	5723.78	5724.97	5705.9	5712.16	23384.0
2016-09-02 13:00:00	NQ	Futures	5711.86	5713.35	5699.34	5703.51	18082.0
2016-09-02 14:00:00	NQ	Futures	5703.81	5715.73	5702.32	5715.44	13196.0
2016-09-02 15:00:00	NQ	Futures	5715.44	5721.99	5713.95	5720.21	21694.0
2016-09-02 16:00:00	NQ	Futures	5720.5	5721.7	5715.44	5721.1	4719.0
2016-09-02 00:00:00	YM	Futures	19788.2	19791.4	19786.0	19788.2	195.0
2016-09-02 01:00:00	YM	Futures	19788.2	19798.9	19788.2	19797.9	361.0
2016-09-02 02:00:00	YM	Futures	19797.9	19809.7	19795.7	19808.6	633.0
2016-09-02 03:00:00	YM	Futures	19808.6	19821.5	19778.5	19804.3	3743.0
2016-09-02 04:00:00	YM	Futures	19804.3	19817.2	19795.7	19804.3	2018.0
2016-09-02 05:00:00	YM	Futures	19805.4	19822.6	19804.3	19817.2	2019.0
2016-09-02 06:00:00	YM	Futures	19816.2	19825.8	19807.6	19815.1	1732.0
2016-09-02 07:00:00	YM	Futures	19816.2	19823.7	19803.2	19804.3	2145.0
2016-09-02 08:00:00	YM	Futures	19803.2	19873.2	19780.6	19862.4	17723.0
2016-09-02 09:00:00	YM	Futures	19862.4	19951.8	19858.1	19928.1	35820.0
2016-09-02 10:00:00	YM	Futures	19930.2	19941.0	19891.5	19901.2	26574.0
2016-09-02 11:00:00	YM	Futures	19902.3	19924.9	19889.3	19903.3	13109.0
2016-09-02 12:00:00	YM	Futures	19904.4	19908.7	19839.8	19865.7	15900.0
2016-09-02 13:00:00	YM	Futures	19865.7	19873.2	19830.2	19840.9	9688.0
2016-09-02 14:00:00	YM	Futures	19840.9	19879.7	19839.8	19876.4	9278.0
2016-09-02 15:00:00	YM	Futures	19877.5	19895.8	19868.9	19890.4	12071.0

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

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