PREVIEW / futures_1hour / 2016-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-21.parquet
  size:    44 KB
  rows:    1,328

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-10-21 00:00:00	ES	Futures	2320.83	2321.92	2320.56	2321.65	2331.0
2016-10-21 01:00:00	ES	Futures	2321.65	2321.92	2318.66	2319.47	5673.0
2016-10-21 02:00:00	ES	Futures	2319.47	2322.74	2319.2	2321.92	6220.0
2016-10-21 03:00:00	ES	Futures	2321.65	2323.01	2319.2	2319.47	19247.0
2016-10-21 04:00:00	ES	Futures	2319.47	2321.11	2317.02	2317.3	14742.0
2016-10-21 05:00:00	ES	Futures	2317.3	2321.38	2316.75	2320.56	15331.0
2016-10-21 06:00:00	ES	Futures	2320.56	2320.83	2317.02	2317.02	12896.0
2016-10-21 07:00:00	ES	Futures	2317.3	2319.2	2316.75	2318.93	17961.0
2016-10-21 08:00:00	ES	Futures	2318.66	2320.29	2315.12	2315.39	45263.0
2016-10-21 09:00:00	ES	Futures	2315.12	2316.21	2310.77	2315.39	325721.0
2016-10-21 10:00:00	ES	Futures	2315.39	2319.75	2313.22	2317.57	222166.0
2016-10-21 11:00:00	ES	Futures	2317.57	2321.92	2316.48	2320.83	155000.0
2016-10-21 12:00:00	ES	Futures	2320.83	2321.92	2318.66	2320.02	73323.0
2016-10-21 13:00:00	ES	Futures	2320.29	2322.74	2317.3	2322.19	96962.0
2016-10-21 14:00:00	ES	Futures	2322.47	2324.64	2320.83	2324.64	106413.0
2016-10-21 15:00:00	ES	Futures	2324.37	2325.46	2322.19	2324.1	187022.0
2016-10-21 16:00:00	ES	Futures	2324.1	2324.92	2322.74	2324.64	69920.0
2016-10-21 00:00:00	NQ	Futures	5773.38	5775.76	5773.08	5775.17	336.0
2016-10-21 01:00:00	NQ	Futures	5775.17	5776.96	5770.69	5773.08	822.0
2016-10-21 02:00:00	NQ	Futures	5772.48	5780.24	5771.59	5777.55	743.0
2016-10-21 03:00:00	NQ	Futures	5777.26	5781.13	5773.08	5774.87	2997.0
2016-10-21 04:00:00	NQ	Futures	5774.87	5778.45	5766.52	5768.9	2466.0
2016-10-21 05:00:00	NQ	Futures	5768.6	5780.24	5768.31	5778.15	2268.0
2016-10-21 06:00:00	NQ	Futures	5777.55	5778.15	5769.5	5769.5	1540.0
2016-10-21 07:00:00	NQ	Futures	5769.8	5776.96	5769.2	5774.87	2655.0
2016-10-21 08:00:00	NQ	Futures	5774.87	5778.15	5768.01	5770.39	5798.0
2016-10-21 09:00:00	NQ	Futures	5770.39	5771.29	5745.63	5766.22	45671.0
2016-10-21 10:00:00	NQ	Futures	5765.62	5772.18	5757.57	5767.41	34224.0
2016-10-21 11:00:00	NQ	Futures	5767.11	5782.03	5764.73	5779.05	22191.0
2016-10-21 12:00:00	NQ	Futures	5779.34	5781.73	5770.39	5775.47	12438.0
2016-10-21 13:00:00	NQ	Futures	5775.17	5783.22	5768.9	5781.13	11691.0
2016-10-21 14:00:00	NQ	Futures	5781.13	5784.42	5776.36	5782.92	12417.0
2016-10-21 15:00:00	NQ	Futures	5782.92	5785.31	5777.55	5782.03	19711.0
2016-10-21 16:00:00	NQ	Futures	5782.03	5783.22	5778.75	5782.92	4911.0
2016-10-21 00:00:00	YM	Futures	19530.5	19540.2	19529.4	19535.9	473.0
2016-10-21 01:00:00	YM	Futures	19535.9	19540.2	19517.5	19525.1	1078.0
2016-10-21 02:00:00	YM	Futures	19524.0	19549.9	19518.6	19540.2	1543.0
2016-10-21 03:00:00	YM	Futures	19539.1	19552.1	19516.4	19521.8	3479.0
2016-10-21 04:00:00	YM	Futures	19520.7	19533.7	19495.9	19499.1	2632.0
2016-10-21 05:00:00	YM	Futures	19499.1	19530.5	19495.9	19525.1	2711.0
2016-10-21 06:00:00	YM	Futures	19524.0	19527.2	19497.0	19497.0	1788.0
2016-10-21 07:00:00	YM	Futures	19498.0	19521.8	19494.8	19519.7	3640.0
2016-10-21 08:00:00	YM	Futures	19519.7	19532.6	19465.6	19468.9	7364.0
2016-10-21 09:00:00	YM	Futures	19468.9	19473.2	19415.9	19441.8	33753.0
2016-10-21 10:00:00	YM	Futures	19441.8	19455.9	19417.0	19442.9	20238.0
2016-10-21 11:00:00	YM	Futures	19441.8	19505.6	19431.0	19495.9	17418.0
2016-10-21 12:00:00	YM	Futures	19497.0	19505.6	19474.3	19485.1	8207.0
2016-10-21 13:00:00	YM	Futures	19485.1	19529.4	19469.9	19522.9	10478.0
2016-10-21 14:00:00	YM	Futures	19522.9	19541.3	19511.0	19541.3	8260.0
2016-10-21 15:00:00	YM	Futures	19541.3	19551.0	19518.6	19527.2	12731.0

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

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