PREVIEW / futures_1hour / 2016-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-07.parquet
  size:    52 KB
  rows:    1,646

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-11-07 00:00:00	ES	Futures	2291.99	2292.81	2290.63	2291.72	4358.0
2016-11-07 01:00:00	ES	Futures	2291.72	2293.63	2291.45	2293.08	6621.0
2016-11-07 02:00:00	ES	Futures	2293.35	2294.71	2292.27	2294.44	13864.0
2016-11-07 03:00:00	ES	Futures	2294.17	2294.99	2291.72	2294.99	22798.0
2016-11-07 04:00:00	ES	Futures	2294.71	2298.52	2294.17	2297.44	27426.0
2016-11-07 05:00:00	ES	Futures	2297.16	2297.44	2294.17	2296.07	19411.0
2016-11-07 06:00:00	ES	Futures	2295.8	2296.89	2294.17	2294.71	14033.0
2016-11-07 07:00:00	ES	Futures	2294.71	2295.26	2292.27	2294.17	21816.0
2016-11-07 08:00:00	ES	Futures	2294.17	2296.35	2293.9	2296.07	27701.0
2016-11-07 09:00:00	ES	Futures	2295.8	2300.43	2294.17	2299.34	209286.0
2016-11-07 10:00:00	ES	Futures	2299.34	2306.14	2298.8	2305.6	229907.0
2016-11-07 11:00:00	ES	Futures	2305.6	2310.77	2305.6	2310.49	193134.0
2016-11-07 12:00:00	ES	Futures	2310.77	2312.13	2309.13	2310.77	141923.0
2016-11-07 13:00:00	ES	Futures	2310.77	2312.4	2309.41	2312.13	86458.0
2016-11-07 14:00:00	ES	Futures	2311.86	2312.4	2307.23	2308.59	148331.0
2016-11-07 15:00:00	ES	Futures	2308.59	2315.39	2306.41	2314.3	323779.0
2016-11-07 16:00:00	ES	Futures	2314.3	2318.93	2313.49	2318.39	147494.0
2016-11-07 18:00:00	ES	Futures	2317.02	2318.11	2315.39	2315.66	8903.0
2016-11-07 19:00:00	ES	Futures	2315.94	2315.94	2313.76	2315.12	7531.0
2016-11-07 20:00:00	ES	Futures	2315.12	2315.12	2308.86	2310.77	17592.0
2016-11-07 21:00:00	ES	Futures	2310.49	2312.4	2308.59	2311.58	11512.0
2016-11-07 22:00:00	ES	Futures	2311.58	2313.76	2310.77	2313.76	8149.0
2016-11-07 23:00:00	ES	Futures	2313.49	2314.3	2312.4	2314.3	4044.0
2016-11-07 00:00:00	NQ	Futures	5638.83	5641.22	5636.44	5638.83	525.0
2016-11-07 01:00:00	NQ	Futures	5639.13	5644.5	5638.83	5643.9	623.0
2016-11-07 02:00:00	NQ	Futures	5643.9	5647.18	5641.81	5645.99	2046.0
2016-11-07 03:00:00	NQ	Futures	5645.69	5648.38	5639.43	5647.78	2976.0
2016-11-07 04:00:00	NQ	Futures	5647.48	5656.13	5645.99	5651.66	3288.0
2016-11-07 05:00:00	NQ	Futures	5651.66	5651.96	5645.99	5648.67	2150.0
2016-11-07 06:00:00	NQ	Futures	5648.67	5650.76	5643.6	5643.9	1751.0
2016-11-07 07:00:00	NQ	Futures	5643.9	5644.5	5637.93	5643.6	2610.0
2016-11-07 08:00:00	NQ	Futures	5643.6	5649.27	5643.3	5646.29	4218.0
2016-11-07 09:00:00	NQ	Futures	5645.99	5655.24	5640.02	5653.45	34791.0
2016-11-07 10:00:00	NQ	Futures	5653.45	5678.51	5652.85	5678.21	34813.0
2016-11-07 11:00:00	NQ	Futures	5678.51	5694.02	5678.21	5692.53	28358.0
2016-11-07 12:00:00	NQ	Futures	5692.53	5697.0	5685.97	5690.14	18887.0
2016-11-07 13:00:00	NQ	Futures	5690.14	5696.11	5688.05	5693.42	11948.0
2016-11-07 14:00:00	NQ	Futures	5693.13	5694.92	5676.12	5680.89	14727.0
2016-11-07 15:00:00	NQ	Futures	5680.6	5697.0	5675.52	5692.53	33123.0
2016-11-07 16:00:00	NQ	Futures	5692.23	5706.25	5690.14	5705.66	10611.0
2016-11-07 18:00:00	NQ	Futures	5701.18	5704.16	5695.81	5697.0	1765.0
2016-11-07 19:00:00	NQ	Futures	5697.3	5697.6	5692.53	5694.02	1045.0
2016-11-07 20:00:00	NQ	Futures	5693.72	5694.02	5677.91	5682.39	2116.0
2016-11-07 21:00:00	NQ	Futures	5682.09	5686.26	5678.51	5683.58	1446.0
2016-11-07 22:00:00	NQ	Futures	5683.88	5689.84	5681.79	5688.95	673.0
2016-11-07 23:00:00	NQ	Futures	5688.95	5690.44	5685.67	5690.14	540.0
2016-11-07 00:00:00	YM	Futures	19478.6	19486.2	19473.2	19479.7	1451.0
2016-11-07 01:00:00	YM	Futures	19479.7	19492.6	19479.7	19492.6	1415.0
2016-11-07 02:00:00	YM	Futures	19492.6	19499.1	19481.8	19495.9	2057.0
2016-11-07 03:00:00	YM	Futures	19494.8	19500.2	19478.6	19495.9	4370.0

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

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