PREVIEW / futures_1hour / 2016-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-22.parquet
  size:    45 KB
  rows:    1,311

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-07-22 00:00:00	ES	Futures	2340.88	2341.15	2339.53	2340.34	2462.0
2016-07-22 01:00:00	ES	Futures	2340.07	2340.61	2338.71	2339.8	3912.0
2016-07-22 02:00:00	ES	Futures	2339.8	2342.78	2339.8	2342.24	7343.0
2016-07-22 03:00:00	ES	Futures	2342.51	2344.95	2340.07	2343.32	26550.0
2016-07-22 04:00:00	ES	Futures	2343.32	2347.12	2341.15	2346.03	27745.0
2016-07-22 05:00:00	ES	Futures	2345.76	2347.93	2343.32	2343.59	22972.0
2016-07-22 06:00:00	ES	Futures	2343.32	2346.3	2343.05	2345.22	12583.0
2016-07-22 07:00:00	ES	Futures	2345.22	2346.3	2342.78	2343.86	16574.0
2016-07-22 08:00:00	ES	Futures	2343.86	2344.95	2343.32	2344.41	21086.0
2016-07-22 09:00:00	ES	Futures	2344.14	2344.41	2339.8	2341.42	164992.0
2016-07-22 10:00:00	ES	Futures	2341.15	2347.39	2341.15	2346.85	186888.0
2016-07-22 11:00:00	ES	Futures	2347.12	2349.83	2344.68	2349.29	110808.0
2016-07-22 12:00:00	ES	Futures	2349.29	2350.92	2348.47	2349.56	80936.0
2016-07-22 13:00:00	ES	Futures	2349.83	2351.46	2349.29	2350.37	71835.0
2016-07-22 14:00:00	ES	Futures	2350.37	2351.73	2349.56	2351.46	72049.0
2016-07-22 15:00:00	ES	Futures	2351.19	2353.08	2350.1	2352.0	195475.0
2016-07-22 16:00:00	ES	Futures	2352.0	2352.54	2349.56	2351.19	75099.0
2016-07-22 00:00:00	NQ	Futures	5527.66	5528.86	5525.28	5527.07	434.0
2016-07-22 01:00:00	NQ	Futures	5526.77	5527.37	5523.19	5526.17	671.0
2016-07-22 02:00:00	NQ	Futures	5526.77	5533.33	5526.77	5532.73	951.0
2016-07-22 03:00:00	NQ	Futures	5532.73	5539.59	5526.47	5535.41	2466.0
2016-07-22 04:00:00	NQ	Futures	5535.41	5546.74	5530.35	5543.46	3379.0
2016-07-22 05:00:00	NQ	Futures	5544.06	5548.23	5536.9	5536.9	2101.0
2016-07-22 06:00:00	NQ	Futures	5536.61	5542.27	5536.61	5539.59	1710.0
2016-07-22 07:00:00	NQ	Futures	5539.88	5540.48	5533.63	5535.71	2405.0
2016-07-22 08:00:00	NQ	Futures	5535.71	5539.29	5534.82	5538.99	2362.0
2016-07-22 09:00:00	NQ	Futures	5538.69	5538.69	5518.13	5531.54	28987.0
2016-07-22 10:00:00	NQ	Futures	5531.54	5549.72	5530.64	5547.93	28212.0
2016-07-22 11:00:00	NQ	Futures	5547.93	5558.07	5540.18	5556.87	16405.0
2016-07-22 12:00:00	NQ	Futures	5556.87	5561.05	5554.19	5555.68	11154.0
2016-07-22 13:00:00	NQ	Futures	5555.68	5556.58	5550.32	5554.49	8614.0
2016-07-22 14:00:00	NQ	Futures	5554.49	5556.87	5551.51	5553.89	8495.0
2016-07-22 15:00:00	NQ	Futures	5553.89	5556.28	5549.72	5554.19	19912.0
2016-07-22 16:00:00	NQ	Futures	5554.19	5555.68	5549.72	5553.89	6037.0
2016-07-22 00:00:00	YM	Futures	19839.8	19839.8	19830.2	19835.5	336.0
2016-07-22 01:00:00	YM	Futures	19834.5	19836.6	19823.7	19835.5	1114.0
2016-07-22 02:00:00	YM	Futures	19837.7	19864.6	19836.6	19860.3	1768.0
2016-07-22 03:00:00	YM	Futures	19861.4	19876.4	19838.8	19861.4	4030.0
2016-07-22 04:00:00	YM	Futures	19860.3	19887.2	19838.8	19877.5	3509.0
2016-07-22 05:00:00	YM	Futures	19876.4	19895.8	19852.8	19853.8	3446.0
2016-07-22 06:00:00	YM	Futures	19853.8	19877.5	19852.8	19871.0	1866.0
2016-07-22 07:00:00	YM	Futures	19872.1	19880.7	19852.8	19859.2	2357.0
2016-07-22 08:00:00	YM	Futures	19859.2	19867.8	19856.0	19862.4	1757.0
2016-07-22 09:00:00	YM	Futures	19862.4	19864.6	19820.5	19829.1	15488.0
2016-07-22 10:00:00	YM	Futures	19828.0	19860.3	19822.6	19856.0	12675.0
2016-07-22 11:00:00	YM	Futures	19854.9	19875.4	19840.9	19872.1	9511.0
2016-07-22 12:00:00	YM	Futures	19872.1	19881.8	19866.7	19870.0	7037.0
2016-07-22 13:00:00	YM	Futures	19870.0	19879.7	19864.6	19875.4	4272.0
2016-07-22 14:00:00	YM	Futures	19875.4	19891.5	19868.9	19887.2	5200.0
2016-07-22 15:00:00	YM	Futures	19887.2	19904.4	19878.6	19900.1	11564.0

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

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