PREVIEW / futures_1hour / 2016-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-24.parquet
  size:    51 KB
  rows:    1,615

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-24 00:00:00	ES	Futures	2326.28	2326.82	2326.0	2326.55	1559.0
2016-10-24 01:00:00	ES	Futures	2326.55	2327.36	2326.28	2327.09	2869.0
2016-10-24 02:00:00	ES	Futures	2327.09	2329.0	2326.55	2328.72	5586.0
2016-10-24 03:00:00	ES	Futures	2328.72	2336.34	2328.18	2336.07	30804.0
2016-10-24 04:00:00	ES	Futures	2335.8	2337.16	2333.89	2333.89	15214.0
2016-10-24 05:00:00	ES	Futures	2333.89	2334.98	2333.08	2334.71	8775.0
2016-10-24 06:00:00	ES	Futures	2334.71	2334.98	2333.08	2333.35	6536.0
2016-10-24 07:00:00	ES	Futures	2333.08	2333.89	2332.53	2333.35	9975.0
2016-10-24 08:00:00	ES	Futures	2333.35	2334.98	2331.99	2334.44	19685.0
2016-10-24 09:00:00	ES	Futures	2334.71	2338.79	2333.62	2337.43	168498.0
2016-10-24 10:00:00	ES	Futures	2337.43	2337.97	2331.99	2335.25	164155.0
2016-10-24 11:00:00	ES	Futures	2335.25	2336.89	2332.81	2333.08	109547.0
2016-10-24 12:00:00	ES	Futures	2333.08	2334.17	2329.54	2331.99	90840.0
2016-10-24 13:00:00	ES	Futures	2331.99	2334.17	2331.44	2333.08	55999.0
2016-10-24 14:00:00	ES	Futures	2333.08	2334.71	2332.53	2334.17	64239.0
2016-10-24 15:00:00	ES	Futures	2334.44	2335.8	2332.53	2333.89	142510.0
2016-10-24 16:00:00	ES	Futures	2333.62	2335.53	2332.53	2334.98	72050.0
2016-10-24 18:00:00	ES	Futures	2334.17	2334.71	2333.35	2333.62	2054.0
2016-10-24 19:00:00	ES	Futures	2333.89	2334.98	2333.62	2333.89	1701.0
2016-10-24 20:00:00	ES	Futures	2334.17	2335.53	2333.89	2335.25	2585.0
2016-10-24 21:00:00	ES	Futures	2335.25	2335.8	2334.44	2335.8	3031.0
2016-10-24 22:00:00	ES	Futures	2335.53	2337.16	2335.53	2336.34	3808.0
2016-10-24 23:00:00	ES	Futures	2336.34	2337.16	2336.34	2337.16	1490.0
2016-10-24 00:00:00	NQ	Futures	5787.1	5788.0	5786.5	5787.4	148.0
2016-10-24 01:00:00	NQ	Futures	5787.1	5789.79	5786.8	5788.89	362.0
2016-10-24 02:00:00	NQ	Futures	5788.59	5795.45	5788.0	5794.56	1017.0
2016-10-24 03:00:00	NQ	Futures	5794.26	5815.74	5793.37	5815.14	6371.0
2016-10-24 04:00:00	NQ	Futures	5814.85	5817.53	5812.16	5813.06	2726.0
2016-10-24 05:00:00	NQ	Futures	5813.06	5816.93	5811.86	5816.64	1594.0
2016-10-24 06:00:00	NQ	Futures	5816.34	5816.64	5813.65	5813.65	950.0
2016-10-24 07:00:00	NQ	Futures	5813.95	5816.04	5812.46	5813.65	1906.0
2016-10-24 08:00:00	NQ	Futures	5813.65	5819.62	5811.86	5819.32	3990.0
2016-10-24 09:00:00	NQ	Futures	5819.32	5836.03	5817.23	5836.03	35330.0
2016-10-24 10:00:00	NQ	Futures	5835.73	5843.49	5828.27	5840.2	33060.0
2016-10-24 11:00:00	NQ	Futures	5839.91	5845.87	5838.12	5838.71	19502.0
2016-10-24 12:00:00	NQ	Futures	5838.71	5840.5	5835.13	5838.12	12361.0
2016-10-24 13:00:00	NQ	Futures	5838.12	5848.56	5837.22	5845.87	13385.0
2016-10-24 14:00:00	NQ	Futures	5846.17	5847.36	5843.49	5845.28	11499.0
2016-10-24 15:00:00	NQ	Futures	5844.98	5856.31	5841.99	5851.84	23895.0
2016-10-24 16:00:00	NQ	Futures	5852.14	5857.81	5848.26	5856.31	7249.0
2016-10-24 18:00:00	NQ	Futures	5854.82	5855.42	5851.84	5853.03	620.0
2016-10-24 19:00:00	NQ	Futures	5853.03	5855.42	5852.73	5853.03	443.0
2016-10-24 20:00:00	NQ	Futures	5853.03	5857.51	5852.44	5857.21	642.0
2016-10-24 21:00:00	NQ	Futures	5856.91	5858.4	5855.42	5857.51	799.0
2016-10-24 22:00:00	NQ	Futures	5857.81	5863.77	5857.51	5862.28	1413.0
2016-10-24 23:00:00	NQ	Futures	5862.28	5864.67	5862.28	5864.37	651.0
2016-10-24 00:00:00	YM	Futures	19548.8	19551.0	19545.6	19549.9	259.0
2016-10-24 01:00:00	YM	Futures	19548.8	19560.7	19548.8	19557.5	609.0
2016-10-24 02:00:00	YM	Futures	19557.5	19576.9	19552.1	19574.8	1622.0
2016-10-24 03:00:00	YM	Futures	19573.7	19625.6	19570.5	19624.5	5752.0

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

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