PREVIEW / futures_1hour / 2016-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-08.parquet
  size:    57 KB
  rows:    1,675

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-08 00:00:00	ES	Futures	2314.03	2316.75	2313.76	2314.85	8677.0
2016-11-08 01:00:00	ES	Futures	2314.85	2316.21	2314.58	2315.39	2835.0
2016-11-08 02:00:00	ES	Futures	2315.39	2315.66	2313.49	2315.39	8987.0
2016-11-08 03:00:00	ES	Futures	2315.39	2318.39	2314.03	2317.02	23250.0
2016-11-08 04:00:00	ES	Futures	2317.02	2317.3	2314.85	2315.94	15583.0
2016-11-08 05:00:00	ES	Futures	2315.94	2316.48	2311.31	2314.03	19006.0
2016-11-08 06:00:00	ES	Futures	2314.03	2314.3	2311.31	2312.4	15476.0
2016-11-08 07:00:00	ES	Futures	2312.4	2314.85	2311.86	2314.03	14958.0
2016-11-08 08:00:00	ES	Futures	2313.76	2314.03	2311.31	2311.58	33833.0
2016-11-08 09:00:00	ES	Futures	2311.58	2312.13	2306.14	2308.32	235399.0
2016-11-08 10:00:00	ES	Futures	2308.32	2313.49	2307.23	2312.94	179243.0
2016-11-08 11:00:00	ES	Futures	2312.94	2326.28	2312.4	2326.0	260281.0
2016-11-08 12:00:00	ES	Futures	2326.0	2332.26	2325.46	2331.72	164822.0
2016-11-08 13:00:00	ES	Futures	2331.72	2332.53	2326.28	2327.64	161195.0
2016-11-08 14:00:00	ES	Futures	2327.64	2327.91	2319.47	2322.47	145658.0
2016-11-08 15:00:00	ES	Futures	2322.74	2330.08	2321.92	2325.19	287220.0
2016-11-08 16:00:00	ES	Futures	2324.92	2326.82	2322.74	2324.37	110183.0
2016-11-08 18:00:00	ES	Futures	2326.82	2333.62	2326.55	2331.44	27295.0
2016-11-08 19:00:00	ES	Futures	2331.44	2341.24	2315.66	2340.15	171880.0
2016-11-08 20:00:00	ES	Futures	2340.15	2342.6	2309.68	2310.49	197940.0
2016-11-08 21:00:00	ES	Futures	2310.22	2310.49	2238.94	2258.8	387538.0
2016-11-08 22:00:00	ES	Futures	2258.26	2258.8	2209.55	2219.89	265492.0
2016-11-08 23:00:00	ES	Futures	2220.16	2235.67	2207.65	2207.65	203353.0
2016-11-08 00:00:00	NQ	Futures	5690.14	5696.11	5688.65	5690.74	1064.0
2016-11-08 01:00:00	NQ	Futures	5690.14	5694.62	5690.14	5692.53	412.0
2016-11-08 02:00:00	NQ	Futures	5691.34	5693.42	5687.46	5692.53	1319.0
2016-11-08 03:00:00	NQ	Futures	5692.53	5698.79	5688.95	5696.11	2936.0
2016-11-08 04:00:00	NQ	Futures	5695.51	5698.5	5691.63	5696.11	2196.0
2016-11-08 05:00:00	NQ	Futures	5695.81	5697.0	5685.37	5691.04	2733.0
2016-11-08 06:00:00	NQ	Futures	5691.34	5691.63	5686.26	5689.25	2452.0
2016-11-08 07:00:00	NQ	Futures	5689.55	5694.62	5688.35	5692.53	2045.0
2016-11-08 08:00:00	NQ	Futures	5692.83	5693.13	5686.26	5687.16	6033.0
2016-11-08 09:00:00	NQ	Futures	5687.16	5689.84	5671.65	5676.12	34342.0
2016-11-08 10:00:00	NQ	Futures	5676.12	5691.93	5675.23	5691.93	22362.0
2016-11-08 11:00:00	NQ	Futures	5691.63	5728.93	5689.55	5728.93	32183.0
2016-11-08 12:00:00	NQ	Futures	5728.93	5754.88	5728.93	5752.79	23929.0
2016-11-08 13:00:00	NQ	Futures	5753.09	5754.58	5735.49	5736.98	23988.0
2016-11-08 14:00:00	NQ	Futures	5736.68	5738.17	5715.5	5726.84	19362.0
2016-11-08 15:00:00	NQ	Futures	5726.84	5746.23	5723.85	5729.82	26590.0
2016-11-08 16:00:00	NQ	Futures	5729.82	5734.89	5725.64	5731.61	7209.0
2016-11-08 18:00:00	NQ	Futures	5736.68	5753.69	5736.68	5746.53	3735.0
2016-11-08 19:00:00	NQ	Futures	5746.53	5769.5	5706.85	5767.11	17340.0
2016-11-08 20:00:00	NQ	Futures	5766.52	5772.78	5697.3	5699.09	24769.0
2016-11-08 21:00:00	NQ	Futures	5698.5	5699.09	5546.34	5573.19	57602.0
2016-11-08 22:00:00	NQ	Futures	5572.9	5574.69	5453.56	5473.55	35631.0
2016-11-08 23:00:00	NQ	Futures	5474.74	5505.47	5439.84	5439.84	20023.0
2016-11-08 00:00:00	YM	Futures	19640.7	19658.0	19638.5	19643.9	1845.0
2016-11-08 01:00:00	YM	Futures	19643.9	19654.8	19643.9	19649.3	556.0
2016-11-08 02:00:00	YM	Futures	19650.4	19658.0	19637.5	19655.8	2197.0
2016-11-08 03:00:00	YM	Futures	19655.8	19672.0	19645.0	19663.4	3509.0

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

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