PREVIEW / futures_1hour / 2016-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-15.parquet
  size:    52 KB
  rows:    1,584

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-15 00:00:00	ES	Futures	2298.8	2301.52	2298.52	2300.16	7608.0
2016-09-15 01:00:00	ES	Futures	2300.16	2302.6	2299.61	2301.24	3478.0
2016-09-15 02:00:00	ES	Futures	2301.52	2303.42	2299.07	2300.7	8433.0
2016-09-15 03:00:00	ES	Futures	2300.43	2304.78	2298.25	2301.79	31877.0
2016-09-15 04:00:00	ES	Futures	2301.79	2304.51	2301.24	2304.51	18420.0
2016-09-15 05:00:00	ES	Futures	2304.51	2308.32	2303.15	2307.5	17913.0
2016-09-15 06:00:00	ES	Futures	2307.23	2310.77	2305.6	2309.41	17241.0
2016-09-15 07:00:00	ES	Futures	2309.41	2309.68	2304.24	2308.05	31783.0
2016-09-15 08:00:00	ES	Futures	2308.05	2312.13	2302.6	2303.42	89740.0
2016-09-15 09:00:00	ES	Futures	2303.42	2310.77	2299.88	2308.32	352171.0
2016-09-15 10:00:00	ES	Futures	2308.32	2319.75	2305.33	2319.47	343544.0
2016-09-15 11:00:00	ES	Futures	2319.47	2326.82	2319.2	2322.74	268267.0
2016-09-15 12:00:00	ES	Futures	2322.74	2325.46	2318.39	2320.29	159452.0
2016-09-15 13:00:00	ES	Futures	2320.02	2329.81	2319.47	2329.81	184660.0
2016-09-15 14:00:00	ES	Futures	2329.54	2333.89	2329.0	2331.44	156844.0
2016-09-15 15:00:00	ES	Futures	2331.72	2333.62	2327.91	2329.0	248101.0
2016-09-15 16:00:00	ES	Futures	2329.0	2329.0	2325.19	2325.46	87424.0
2016-09-15 18:00:00	ES	Futures	2325.19	2325.73	2320.29	2322.47	9858.0
2016-09-15 19:00:00	ES	Futures	2322.74	2324.1	2321.92	2322.19	3999.0
2016-09-15 20:00:00	ES	Futures	2321.92	2323.55	2320.83	2321.92	6133.0
2016-09-15 21:00:00	ES	Futures	2321.92	2323.55	2321.65	2323.28	3932.0
2016-09-15 22:00:00	ES	Futures	2323.28	2324.1	2322.74	2323.28	1709.0
2016-09-15 23:00:00	ES	Futures	2323.28	2324.1	2323.01	2323.28	2043.0
2016-09-15 00:00:00	NQ	Futures	5638.83	5646.29	5637.93	5642.11	1269.0
2016-09-15 01:00:00	NQ	Futures	5642.11	5648.97	5640.62	5645.09	747.0
2016-09-15 02:00:00	NQ	Futures	5645.09	5650.17	5639.43	5643.6	1660.0
2016-09-15 03:00:00	NQ	Futures	5643.6	5654.34	5638.23	5645.99	5149.0
2016-09-15 04:00:00	NQ	Futures	5645.99	5656.43	5644.8	5655.24	2485.0
2016-09-15 05:00:00	NQ	Futures	5655.24	5664.49	5651.96	5662.4	2916.0
2016-09-15 06:00:00	NQ	Futures	5662.1	5667.77	5658.52	5663.89	3724.0
2016-09-15 07:00:00	NQ	Futures	5664.19	5664.78	5654.94	5662.99	4953.0
2016-09-15 08:00:00	NQ	Futures	5662.99	5674.03	5655.24	5659.12	13672.0
2016-09-15 09:00:00	NQ	Futures	5659.12	5684.18	5651.66	5680.0	55975.0
2016-09-15 10:00:00	NQ	Futures	5680.3	5720.57	5671.65	5719.98	58051.0
2016-09-15 11:00:00	NQ	Futures	5720.27	5733.4	5718.19	5724.15	40702.0
2016-09-15 12:00:00	NQ	Futures	5724.45	5735.79	5719.68	5723.26	25899.0
2016-09-15 13:00:00	NQ	Futures	5723.56	5745.04	5720.57	5744.44	30117.0
2016-09-15 14:00:00	NQ	Futures	5744.74	5754.58	5742.05	5751.6	24010.0
2016-09-15 15:00:00	NQ	Futures	5751.9	5756.07	5742.65	5748.02	31252.0
2016-09-15 16:00:00	NQ	Futures	5748.02	5748.32	5741.16	5742.95	9290.0
2016-09-15 18:00:00	NQ	Futures	5739.37	5742.35	5730.12	5736.09	2596.0
2016-09-15 19:00:00	NQ	Futures	5736.09	5739.37	5733.7	5734.0	667.0
2016-09-15 20:00:00	NQ	Futures	5733.4	5737.88	5731.61	5734.3	1169.0
2016-09-15 21:00:00	NQ	Futures	5734.3	5738.77	5733.7	5736.38	673.0
2016-09-15 22:00:00	NQ	Futures	5736.68	5739.96	5736.09	5738.47	434.0
2016-09-15 23:00:00	NQ	Futures	5738.47	5739.67	5736.98	5738.77	810.0
2016-09-15 00:00:00	YM	Futures	19361.9	19385.6	19360.8	19372.7	1449.0
2016-09-15 01:00:00	YM	Futures	19372.7	19388.9	19369.4	19380.2	747.0
2016-09-15 02:00:00	YM	Futures	19380.2	19400.8	19366.2	19374.8	1902.0
2016-09-15 03:00:00	YM	Futures	19373.8	19408.3	19356.5	19380.2	6236.0

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

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