PREVIEW / futures_1hour / 2016-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-09.parquet
  size:    60 KB
  rows:    1,704

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-09 00:00:00	ES	Futures	2207.65	2228.05	2207.65	2218.8	119077.0
2016-11-09 01:00:00	ES	Futures	2218.53	2232.41	2215.81	2232.14	99136.0
2016-11-09 02:00:00	ES	Futures	2232.14	2268.32	2231.59	2266.15	191123.0
2016-11-09 03:00:00	ES	Futures	2265.87	2284.92	2258.8	2284.38	198314.0
2016-11-09 04:00:00	ES	Futures	2284.1	2294.99	2274.85	2283.01	131208.0
2016-11-09 05:00:00	ES	Futures	2282.74	2287.64	2272.68	2280.02	77750.0
2016-11-09 06:00:00	ES	Futures	2280.02	2280.57	2261.79	2274.85	88950.0
2016-11-09 07:00:00	ES	Futures	2274.85	2297.98	2273.22	2296.35	131065.0
2016-11-09 08:00:00	ES	Futures	2296.35	2303.69	2284.92	2297.16	140834.0
2016-11-09 09:00:00	ES	Futures	2296.89	2330.9	2294.17	2328.45	682425.0
2016-11-09 10:00:00	ES	Futures	2328.18	2328.72	2313.22	2321.92	441455.0
2016-11-09 11:00:00	ES	Futures	2321.65	2350.76	2321.38	2345.87	463588.0
2016-11-09 12:00:00	ES	Futures	2345.87	2346.95	2335.53	2345.32	233009.0
2016-11-09 13:00:00	ES	Futures	2345.59	2348.59	2337.16	2343.96	224577.0
2016-11-09 14:00:00	ES	Futures	2344.23	2355.93	2342.87	2350.76	228480.0
2016-11-09 15:00:00	ES	Futures	2350.76	2358.11	2346.14	2350.49	428538.0
2016-11-09 16:00:00	ES	Futures	2350.22	2353.48	2348.86	2351.31	111346.0
2016-11-09 18:00:00	ES	Futures	2350.22	2350.22	2345.59	2347.5	13696.0
2016-11-09 19:00:00	ES	Futures	2347.5	2353.48	2345.87	2352.12	21973.0
2016-11-09 20:00:00	ES	Futures	2352.12	2354.03	2347.23	2348.04	16775.0
2016-11-09 21:00:00	ES	Futures	2347.77	2349.67	2346.68	2348.04	11406.0
2016-11-09 22:00:00	ES	Futures	2348.31	2349.95	2347.23	2349.4	7410.0
2016-11-09 23:00:00	ES	Futures	2349.4	2350.76	2349.13	2349.95	6164.0
2016-11-09 00:00:00	NQ	Futures	5439.84	5478.92	5439.84	5451.47	7779.0
2016-11-09 01:00:00	NQ	Futures	5451.47	5480.41	5445.81	5479.22	12233.0
2016-11-09 02:00:00	NQ	Futures	5480.11	5574.09	5472.95	5569.32	26170.0
2016-11-09 03:00:00	NQ	Futures	5568.72	5608.1	5541.27	5597.96	25926.0
2016-11-09 04:00:00	NQ	Futures	5597.96	5625.4	5566.93	5609.29	19612.0
2016-11-09 05:00:00	NQ	Futures	5609.29	5623.31	5584.83	5604.52	8192.0
2016-11-09 06:00:00	NQ	Futures	5605.12	5605.71	5550.22	5586.02	9238.0
2016-11-09 07:00:00	NQ	Futures	5585.13	5638.53	5583.64	5635.85	16415.0
2016-11-09 08:00:00	NQ	Futures	5635.85	5648.08	5604.22	5630.77	23387.0
2016-11-09 09:00:00	NQ	Futures	5630.18	5729.82	5627.49	5715.8	120672.0
2016-11-09 10:00:00	NQ	Futures	5716.1	5717.29	5663.59	5693.42	69056.0
2016-11-09 11:00:00	NQ	Futures	5692.83	5762.34	5692.53	5742.65	58828.0
2016-11-09 12:00:00	NQ	Futures	5742.95	5753.09	5716.4	5750.7	33957.0
2016-11-09 13:00:00	NQ	Futures	5750.7	5753.39	5703.57	5717.29	43771.0
2016-11-09 14:00:00	NQ	Futures	5716.99	5756.37	5711.92	5735.49	26941.0
2016-11-09 15:00:00	NQ	Futures	5735.79	5763.53	5735.49	5752.79	34408.0
2016-11-09 16:00:00	NQ	Futures	5753.09	5763.83	5749.51	5752.2	10452.0
2016-11-09 18:00:00	NQ	Futures	5748.91	5749.81	5739.07	5748.02	1967.0
2016-11-09 19:00:00	NQ	Futures	5747.72	5765.02	5743.84	5761.15	3325.0
2016-11-09 20:00:00	NQ	Futures	5761.44	5765.02	5752.79	5754.58	3783.0
2016-11-09 21:00:00	NQ	Futures	5754.58	5763.23	5753.39	5762.64	4006.0
2016-11-09 22:00:00	NQ	Futures	5762.64	5769.8	5762.34	5767.11	3194.0
2016-11-09 23:00:00	NQ	Futures	5767.11	5771.59	5767.11	5768.01	2255.0
2016-11-09 00:00:00	YM	Futures	18910.1	19061.4	18824.7	19012.8	17439.0
2016-11-09 01:00:00	YM	Futures	19010.6	19113.3	18996.6	19093.8	14688.0
2016-11-09 02:00:00	YM	Futures	19096.0	19352.1	19093.8	19340.2	22819.0
2016-11-09 03:00:00	YM	Futures	19339.2	19464.5	19281.9	19459.1	27765.0

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

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