PREVIEW / futures_1hour / 2016-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-08.parquet
  size:    50 KB
  rows:    1,584

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-08-08 00:00:00	ES	Futures	2362.03	2362.85	2361.76	2362.03	1818.0
2016-08-08 01:00:00	ES	Futures	2362.3	2362.85	2361.76	2362.85	2946.0
2016-08-08 02:00:00	ES	Futures	2362.85	2363.66	2361.22	2362.58	7789.0
2016-08-08 03:00:00	ES	Futures	2362.58	2366.1	2360.95	2365.83	26106.0
2016-08-08 04:00:00	ES	Futures	2365.83	2368.0	2365.02	2366.92	21942.0
2016-08-08 05:00:00	ES	Futures	2366.92	2367.46	2365.56	2365.83	8108.0
2016-08-08 06:00:00	ES	Futures	2365.56	2366.37	2364.75	2365.56	8340.0
2016-08-08 07:00:00	ES	Futures	2365.29	2366.1	2364.47	2365.02	9206.0
2016-08-08 08:00:00	ES	Futures	2365.02	2365.02	2362.85	2363.12	18119.0
2016-08-08 09:00:00	ES	Futures	2363.12	2366.1	2361.49	2362.03	179525.0
2016-08-08 10:00:00	ES	Futures	2362.03	2363.39	2359.32	2360.95	159534.0
2016-08-08 11:00:00	ES	Futures	2360.95	2362.85	2360.41	2361.22	93908.0
2016-08-08 12:00:00	ES	Futures	2361.22	2361.49	2359.32	2360.68	50621.0
2016-08-08 13:00:00	ES	Futures	2360.68	2361.22	2359.59	2360.95	50014.0
2016-08-08 14:00:00	ES	Futures	2360.68	2361.22	2357.42	2358.24	95660.0
2016-08-08 15:00:00	ES	Futures	2358.24	2360.95	2357.42	2360.68	131297.0
2016-08-08 16:00:00	ES	Futures	2360.41	2361.22	2359.32	2360.95	51232.0
2016-08-08 18:00:00	ES	Futures	2360.41	2360.41	2359.05	2359.86	4503.0
2016-08-08 19:00:00	ES	Futures	2359.86	2359.86	2359.05	2359.32	1354.0
2016-08-08 20:00:00	ES	Futures	2359.32	2361.22	2359.32	2359.86	4312.0
2016-08-08 21:00:00	ES	Futures	2359.86	2360.68	2359.59	2360.68	2415.0
2016-08-08 22:00:00	ES	Futures	2360.68	2360.95	2359.86	2360.68	1753.0
2016-08-08 23:00:00	ES	Futures	2360.41	2361.22	2360.14	2360.68	2176.0
2016-08-08 00:00:00	NQ	Futures	5709.48	5710.67	5708.28	5709.48	269.0
2016-08-08 01:00:00	NQ	Futures	5710.07	5710.97	5709.18	5710.67	407.0
2016-08-08 02:00:00	NQ	Futures	5710.67	5713.65	5707.99	5711.26	1041.0
2016-08-08 03:00:00	NQ	Futures	5711.56	5719.31	5707.39	5719.01	3274.0
2016-08-08 04:00:00	NQ	Futures	5719.01	5723.48	5715.73	5721.4	2259.0
2016-08-08 05:00:00	NQ	Futures	5721.4	5722.29	5716.93	5717.82	819.0
2016-08-08 06:00:00	NQ	Futures	5717.52	5719.31	5715.73	5716.93	869.0
2016-08-08 07:00:00	NQ	Futures	5716.63	5717.52	5714.24	5715.14	758.0
2016-08-08 08:00:00	NQ	Futures	5715.14	5715.14	5707.69	5707.69	2891.0
2016-08-08 09:00:00	NQ	Futures	5707.99	5711.26	5696.36	5698.75	30951.0
2016-08-08 10:00:00	NQ	Futures	5698.75	5701.13	5682.35	5689.8	27511.0
2016-08-08 11:00:00	NQ	Futures	5689.51	5696.06	5686.53	5692.19	13375.0
2016-08-08 12:00:00	NQ	Futures	5692.49	5695.47	5689.51	5692.78	6386.0
2016-08-08 13:00:00	NQ	Futures	5692.78	5696.06	5688.91	5693.68	7520.0
2016-08-08 14:00:00	NQ	Futures	5693.38	5693.98	5684.74	5690.1	9923.0
2016-08-08 15:00:00	NQ	Futures	5689.8	5700.83	5689.21	5700.83	14968.0
2016-08-08 16:00:00	NQ	Futures	5700.53	5700.83	5694.57	5699.64	5193.0
2016-08-08 18:00:00	NQ	Futures	5699.34	5699.64	5695.77	5697.55	575.0
2016-08-08 19:00:00	NQ	Futures	5697.26	5697.26	5696.06	5696.96	169.0
2016-08-08 20:00:00	NQ	Futures	5696.66	5702.02	5696.36	5698.45	447.0
2016-08-08 21:00:00	NQ	Futures	5698.15	5700.83	5697.26	5700.53	282.0
2016-08-08 22:00:00	NQ	Futures	5700.83	5701.13	5698.75	5700.24	286.0
2016-08-08 23:00:00	NQ	Futures	5700.83	5701.73	5699.34	5700.83	253.0
2016-08-08 00:00:00	YM	Futures	19879.7	19882.9	19876.4	19880.7	256.0
2016-08-08 01:00:00	YM	Futures	19880.7	19882.9	19876.4	19881.8	550.0
2016-08-08 02:00:00	YM	Futures	19881.8	19888.3	19873.2	19885.0	1254.0
2016-08-08 03:00:00	YM	Futures	19884.0	19911.9	19870.0	19909.8	3300.0

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

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