PREVIEW / futures_1hour / 2016-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-01.parquet
  size:    52 KB
  rows:    1,604

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-01 00:00:00	ES	Futures	2357.97	2358.78	2357.97	2358.78	3540.0
2016-09-01 01:00:00	ES	Futures	2358.78	2359.05	2357.42	2357.97	3476.0
2016-09-01 02:00:00	ES	Futures	2357.97	2358.78	2357.42	2358.51	7188.0
2016-09-01 03:00:00	ES	Futures	2358.51	2361.76	2358.24	2360.41	32652.0
2016-09-01 04:00:00	ES	Futures	2360.41	2361.22	2359.05	2360.14	21084.0
2016-09-01 05:00:00	ES	Futures	2360.14	2360.14	2355.53	2355.8	25545.0
2016-09-01 06:00:00	ES	Futures	2356.07	2358.51	2355.8	2357.69	13297.0
2016-09-01 07:00:00	ES	Futures	2357.42	2358.24	2356.61	2357.15	14741.0
2016-09-01 08:00:00	ES	Futures	2357.15	2357.97	2353.08	2354.17	38879.0
2016-09-01 09:00:00	ES	Futures	2353.9	2356.34	2348.75	2350.92	207829.0
2016-09-01 10:00:00	ES	Futures	2350.64	2353.36	2338.98	2340.88	442027.0
2016-09-01 11:00:00	ES	Futures	2341.15	2343.59	2337.36	2342.24	217163.0
2016-09-01 12:00:00	ES	Futures	2341.97	2352.27	2341.15	2348.75	226938.0
2016-09-01 13:00:00	ES	Futures	2349.02	2351.73	2348.2	2349.56	107064.0
2016-09-01 14:00:00	ES	Futures	2349.56	2351.46	2345.49	2349.29	177952.0
2016-09-01 15:00:00	ES	Futures	2349.56	2352.81	2345.22	2352.54	279632.0
2016-09-01 16:00:00	ES	Futures	2352.81	2352.81	2349.83	2349.83	73820.0
2016-09-01 18:00:00	ES	Futures	2349.83	2351.73	2349.83	2350.64	2962.0
2016-09-01 19:00:00	ES	Futures	2350.92	2351.46	2350.64	2350.92	1225.0
2016-09-01 20:00:00	ES	Futures	2350.92	2351.19	2349.29	2350.1	3980.0
2016-09-01 21:00:00	ES	Futures	2350.1	2350.64	2349.02	2349.56	2939.0
2016-09-01 22:00:00	ES	Futures	2349.56	2350.1	2349.02	2349.56	1905.0
2016-09-01 23:00:00	ES	Futures	2349.83	2350.1	2348.75	2349.29	2680.0
2016-09-01 00:00:00	NQ	Futures	5706.79	5708.88	5705.6	5707.99	1107.0
2016-09-01 01:00:00	NQ	Futures	5707.99	5708.28	5704.41	5705.3	1053.0
2016-09-01 02:00:00	NQ	Futures	5705.6	5708.88	5705.0	5707.99	1501.0
2016-09-01 03:00:00	NQ	Futures	5708.28	5716.93	5707.09	5712.16	5734.0
2016-09-01 04:00:00	NQ	Futures	5711.86	5714.84	5708.88	5711.56	2381.0
2016-09-01 05:00:00	NQ	Futures	5711.86	5711.86	5702.32	5703.81	3819.0
2016-09-01 06:00:00	NQ	Futures	5703.81	5710.07	5703.51	5707.69	1599.0
2016-09-01 07:00:00	NQ	Futures	5707.99	5709.48	5705.9	5707.39	1492.0
2016-09-01 08:00:00	NQ	Futures	5707.39	5708.88	5696.36	5698.45	4929.0
2016-09-01 09:00:00	NQ	Futures	5698.15	5706.79	5690.4	5693.98	30823.0
2016-09-01 10:00:00	NQ	Futures	5693.68	5699.64	5663.58	5671.62	54223.0
2016-09-01 11:00:00	NQ	Futures	5671.62	5680.56	5662.38	5678.18	24159.0
2016-09-01 12:00:00	NQ	Futures	5677.88	5706.5	5674.9	5699.94	33149.0
2016-09-01 13:00:00	NQ	Futures	5699.94	5709.77	5699.34	5702.92	15474.0
2016-09-01 14:00:00	NQ	Futures	5702.92	5705.9	5696.06	5702.02	20970.0
2016-09-01 15:00:00	NQ	Futures	5702.02	5705.0	5686.82	5702.92	31900.0
2016-09-01 16:00:00	NQ	Futures	5702.92	5703.51	5693.08	5693.98	6668.0
2016-09-01 18:00:00	NQ	Futures	5695.77	5699.04	5694.87	5696.96	645.0
2016-09-01 19:00:00	NQ	Futures	5697.26	5698.15	5696.36	5697.26	182.0
2016-09-01 20:00:00	NQ	Futures	5696.96	5697.26	5692.78	5695.17	414.0
2016-09-01 21:00:00	NQ	Futures	5695.17	5696.96	5692.49	5693.98	468.0
2016-09-01 22:00:00	NQ	Futures	5693.98	5695.17	5692.49	5693.98	295.0
2016-09-01 23:00:00	NQ	Futures	5693.98	5694.87	5692.49	5693.38	296.0
2016-09-01 00:00:00	YM	Futures	19844.1	19847.4	19839.8	19846.3	1031.0
2016-09-01 01:00:00	YM	Futures	19847.4	19847.4	19834.5	19837.7	1205.0
2016-09-01 02:00:00	YM	Futures	19837.7	19845.2	19835.5	19840.9	1426.0
2016-09-01 03:00:00	YM	Futures	19840.9	19868.9	19838.8	19858.1	5559.0

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

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