PREVIEW / futures_1hour / 2016-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-12.parquet
  size:    53 KB
  rows:    1,631

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-12 00:00:00	ES	Futures	2325.19	2326.0	2324.92	2325.46	2417.0
2016-10-12 01:00:00	ES	Futures	2325.73	2326.55	2324.1	2324.37	5489.0
2016-10-12 02:00:00	ES	Futures	2324.1	2325.19	2323.01	2323.28	8157.0
2016-10-12 03:00:00	ES	Futures	2323.28	2324.1	2317.84	2320.29	39955.0
2016-10-12 04:00:00	ES	Futures	2320.29	2321.65	2318.39	2320.56	17773.0
2016-10-12 05:00:00	ES	Futures	2320.83	2322.47	2319.2	2319.75	10058.0
2016-10-12 06:00:00	ES	Futures	2319.47	2321.92	2318.93	2321.38	7985.0
2016-10-12 07:00:00	ES	Futures	2321.38	2322.74	2318.93	2319.75	15655.0
2016-10-12 08:00:00	ES	Futures	2320.02	2320.56	2315.12	2319.2	56261.0
2016-10-12 09:00:00	ES	Futures	2319.47	2321.92	2314.03	2321.11	259167.0
2016-10-12 10:00:00	ES	Futures	2320.83	2325.73	2317.3	2318.66	245317.0
2016-10-12 11:00:00	ES	Futures	2318.66	2323.01	2317.57	2321.11	112984.0
2016-10-12 12:00:00	ES	Futures	2321.11	2326.28	2320.83	2324.64	90828.0
2016-10-12 13:00:00	ES	Futures	2324.64	2325.46	2322.47	2324.92	71634.0
2016-10-12 14:00:00	ES	Futures	2325.19	2328.45	2321.38	2322.74	175469.0
2016-10-12 15:00:00	ES	Futures	2323.01	2324.92	2319.47	2321.92	211643.0
2016-10-12 16:00:00	ES	Futures	2321.92	2322.19	2315.66	2315.94	76747.0
2016-10-12 18:00:00	ES	Futures	2315.66	2317.3	2314.85	2317.02	8477.0
2016-10-12 19:00:00	ES	Futures	2317.02	2318.93	2316.75	2317.57	4667.0
2016-10-12 20:00:00	ES	Futures	2317.57	2319.2	2316.48	2317.02	5911.0
2016-10-12 21:00:00	ES	Futures	2317.02	2317.3	2311.04	2312.94	14529.0
2016-10-12 22:00:00	ES	Futures	2312.94	2313.22	2301.79	2303.96	37630.0
2016-10-12 23:00:00	ES	Futures	2303.96	2306.41	2303.42	2306.14	12107.0
2016-10-12 00:00:00	NQ	Futures	5764.13	5767.11	5763.83	5765.92	375.0
2016-10-12 01:00:00	NQ	Futures	5765.92	5768.31	5761.74	5762.94	728.0
2016-10-12 02:00:00	NQ	Futures	5762.64	5765.02	5759.65	5760.55	1123.0
2016-10-12 03:00:00	NQ	Futures	5760.85	5761.44	5743.84	5749.81	6042.0
2016-10-12 04:00:00	NQ	Futures	5750.11	5753.39	5744.14	5751.0	2758.0
2016-10-12 05:00:00	NQ	Futures	5751.3	5755.48	5747.12	5748.02	1135.0
2016-10-12 06:00:00	NQ	Futures	5748.02	5753.99	5746.23	5753.09	1402.0
2016-10-12 07:00:00	NQ	Futures	5753.09	5756.37	5747.72	5749.81	1908.0
2016-10-12 08:00:00	NQ	Futures	5749.81	5751.3	5738.17	5750.11	7317.0
2016-10-12 09:00:00	NQ	Futures	5750.11	5755.18	5728.33	5746.83	48333.0
2016-10-12 10:00:00	NQ	Futures	5746.83	5754.58	5735.19	5737.28	41394.0
2016-10-12 11:00:00	NQ	Futures	5737.58	5753.99	5736.38	5749.51	18084.0
2016-10-12 12:00:00	NQ	Futures	5749.51	5757.27	5746.83	5752.79	15167.0
2016-10-12 13:00:00	NQ	Futures	5753.09	5758.46	5748.32	5756.67	12128.0
2016-10-12 14:00:00	NQ	Futures	5757.57	5765.92	5748.02	5749.51	31858.0
2016-10-12 15:00:00	NQ	Futures	5750.11	5754.28	5737.28	5746.23	29349.0
2016-10-12 16:00:00	NQ	Futures	5746.23	5748.62	5735.19	5735.79	5504.0
2016-10-12 18:00:00	NQ	Futures	5733.7	5737.88	5732.21	5737.88	1693.0
2016-10-12 19:00:00	NQ	Futures	5737.58	5741.46	5736.98	5738.77	655.0
2016-10-12 20:00:00	NQ	Futures	5739.07	5743.54	5736.38	5739.37	902.0
2016-10-12 21:00:00	NQ	Futures	5739.37	5739.67	5722.66	5728.33	3439.0
2016-10-12 22:00:00	NQ	Futures	5728.63	5728.93	5699.99	5704.76	7156.0
2016-10-12 23:00:00	NQ	Futures	5705.06	5711.03	5703.27	5710.13	2387.0
2016-10-12 00:00:00	YM	Futures	19546.7	19555.3	19545.6	19552.1	436.0
2016-10-12 01:00:00	YM	Futures	19553.2	19561.8	19540.2	19542.4	982.0
2016-10-12 02:00:00	YM	Futures	19541.3	19549.9	19527.2	19532.6	1327.0
2016-10-12 03:00:00	YM	Futures	19531.5	19539.1	19486.2	19507.8	6205.0

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

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