PREVIEW / futures_1hour / 2016-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-16.parquet
  size:    46 KB
  rows:    1,337

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-16 00:00:00	ES	Futures	2323.28	2323.55	2322.19	2323.28	2373.0
2016-09-16 01:00:00	ES	Futures	2323.28	2324.1	2323.01	2323.83	2326.0
2016-09-16 02:00:00	ES	Futures	2323.55	2324.37	2322.47	2322.47	8104.0
2016-09-16 03:00:00	ES	Futures	2322.19	2324.92	2320.83	2322.19	29641.0
2016-09-16 04:00:00	ES	Futures	2322.47	2322.47	2317.57	2319.75	25473.0
2016-09-16 05:00:00	ES	Futures	2320.02	2323.01	2319.47	2320.56	21040.0
2016-09-16 06:00:00	ES	Futures	2320.56	2320.83	2314.3	2317.02	41214.0
2016-09-16 07:00:00	ES	Futures	2316.75	2317.84	2314.85	2316.75	32127.0
2016-09-16 08:00:00	ES	Futures	2316.48	2323.83	2316.48	2322.47	86816.0
2016-09-16 09:00:00	ES	Futures	2322.47	2324.64	2314.58	2317.57	363926.0
2016-09-16 10:00:00	ES	Futures	2317.3	2320.83	2310.77	2315.66	328270.0
2016-09-16 11:00:00	ES	Futures	2315.66	2319.47	2313.22	2317.3	211863.0
2016-09-16 12:00:00	ES	Futures	2317.57	2320.29	2315.94	2316.21	134134.0
2016-09-16 13:00:00	ES	Futures	2316.21	2317.84	2310.49	2312.94	135603.0
2016-09-16 14:00:00	ES	Futures	2312.67	2319.2	2311.31	2315.66	171731.0
2016-09-16 15:00:00	ES	Futures	2315.39	2322.74	2315.12	2318.66	304087.0
2016-09-16 16:00:00	ES	Futures	2318.66	2321.65	2318.11	2320.83	94561.0
2016-09-16 00:00:00	NQ	Futures	5738.47	5739.07	5736.09	5738.47	564.0
2016-09-16 01:00:00	NQ	Futures	5738.47	5741.46	5738.17	5740.56	449.0
2016-09-16 02:00:00	NQ	Futures	5740.26	5741.75	5736.38	5736.68	1225.0
2016-09-16 03:00:00	NQ	Futures	5736.38	5741.75	5732.21	5736.09	4132.0
2016-09-16 04:00:00	NQ	Futures	5735.49	5736.98	5725.94	5731.61	3941.0
2016-09-16 05:00:00	NQ	Futures	5731.61	5739.67	5729.82	5733.1	3089.0
2016-09-16 06:00:00	NQ	Futures	5733.4	5733.7	5720.27	5727.14	6903.0
2016-09-16 07:00:00	NQ	Futures	5726.84	5729.82	5722.96	5724.45	4306.0
2016-09-16 08:00:00	NQ	Futures	5724.45	5739.96	5724.15	5736.98	11128.0
2016-09-16 09:00:00	NQ	Futures	5737.28	5751.3	5726.54	5731.61	61049.0
2016-09-16 10:00:00	NQ	Futures	5731.01	5743.84	5714.61	5728.93	44560.0
2016-09-16 11:00:00	NQ	Futures	5729.22	5738.47	5722.06	5732.51	25313.0
2016-09-16 12:00:00	NQ	Futures	5732.51	5743.54	5730.42	5732.21	26223.0
2016-09-16 13:00:00	NQ	Futures	5731.91	5736.38	5718.78	5724.15	21482.0
2016-09-16 14:00:00	NQ	Futures	5724.15	5740.56	5719.98	5732.21	20425.0
2016-09-16 15:00:00	NQ	Futures	5731.91	5750.11	5731.01	5742.95	35114.0
2016-09-16 16:00:00	NQ	Futures	5742.95	5747.12	5740.86	5747.12	6788.0
2016-09-16 00:00:00	YM	Futures	19555.3	19557.5	19548.8	19555.3	338.0
2016-09-16 01:00:00	YM	Futures	19556.4	19561.8	19554.2	19557.5	384.0
2016-09-16 02:00:00	YM	Futures	19557.5	19562.9	19546.7	19547.8	1023.0
2016-09-16 03:00:00	YM	Futures	19546.7	19567.2	19534.8	19542.4	3850.0
2016-09-16 04:00:00	YM	Futures	19543.4	19543.4	19511.0	19525.1	3043.0
2016-09-16 05:00:00	YM	Futures	19526.1	19552.1	19522.9	19529.4	2571.0
2016-09-16 06:00:00	YM	Futures	19532.6	19533.7	19481.8	19501.3	5378.0
2016-09-16 07:00:00	YM	Futures	19500.2	19513.2	19488.3	19499.1	3005.0
2016-09-16 08:00:00	YM	Futures	19499.1	19553.2	19498.0	19540.2	7196.0
2016-09-16 09:00:00	YM	Futures	19540.2	19559.6	19471.0	19508.8	29614.0
2016-09-16 10:00:00	YM	Futures	19508.8	19534.8	19455.9	19498.0	21559.0
2016-09-16 11:00:00	YM	Futures	19498.0	19522.9	19473.2	19506.7	14128.0
2016-09-16 12:00:00	YM	Futures	19505.6	19530.5	19480.7	19481.8	9780.0
2016-09-16 13:00:00	YM	Futures	19481.8	19493.7	19434.3	19455.9	10821.0
2016-09-16 14:00:00	YM	Futures	19455.9	19506.7	19442.9	19479.7	10846.0
2016-09-16 15:00:00	YM	Futures	19479.7	19522.9	19475.3	19489.4	16663.0

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

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