PREVIEW / futures_1hour / 2019-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-23.parquet
  size:    17 KB
  rows:    355

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
2019-06-23 18:00:00	ES	Futures	3192.15	3201.36	3191.34	3200.55	10754.0
2019-06-23 19:00:00	ES	Futures	3200.82	3201.36	3198.11	3200.28	6326.0
2019-06-23 20:00:00	ES	Futures	3200.0	3202.44	3199.19	3200.55	9450.0
2019-06-23 21:00:00	ES	Futures	3200.55	3203.79	3199.19	3201.9	11052.0
2019-06-23 22:00:00	ES	Futures	3202.17	3205.69	3201.9	3204.34	9409.0
2019-06-23 23:00:00	ES	Futures	3204.61	3206.77	3203.52	3205.96	7496.0
2019-06-23 18:00:00	NQ	Futures	8988.03	9019.37	8973.24	9017.63	4474.0
2019-06-23 19:00:00	NQ	Futures	9017.63	9021.69	9008.05	9017.92	2235.0
2019-06-23 20:00:00	NQ	Futures	9017.92	9023.14	9012.98	9017.05	3700.0
2019-06-23 21:00:00	NQ	Futures	9017.63	9029.81	9009.79	9023.72	4920.0
2019-06-23 22:00:00	NQ	Futures	9024.01	9036.78	9021.98	9034.17	3515.0
2019-06-23 23:00:00	NQ	Futures	9034.17	9045.77	9027.78	9040.26	3112.0
2019-06-23 18:00:00	YM	Futures	29008.0	29071.1	28994.9	29064.5	2245.0
2019-06-23 19:00:00	YM	Futures	29064.5	29080.8	29041.7	29070.0	1511.0
2019-06-23 20:00:00	YM	Futures	29068.9	29095.0	29062.4	29075.4	1853.0
2019-06-23 21:00:00	YM	Futures	29076.5	29098.2	29060.2	29080.8	2246.0
2019-06-23 22:00:00	YM	Futures	29081.9	29115.6	29080.8	29104.8	1482.0
2019-06-23 23:00:00	YM	Futures	29106.9	29116.7	29090.6	29111.3	1148.0
2019-06-23 18:00:00	CL	Futures	51.22	51.42	51.13	51.23	5158.0
2019-06-23 19:00:00	CL	Futures	51.22	51.35	51.13	51.31	3394.0
2019-06-23 20:00:00	CL	Futures	51.31	51.42	51.22	51.34	6036.0
2019-06-23 21:00:00	CL	Futures	51.34	51.35	51.15	51.3	11381.0
2019-06-23 22:00:00	CL	Futures	51.31	51.34	51.22	51.28	4938.0
2019-06-23 23:00:00	CL	Futures	51.28	51.32	51.24	51.3	2854.0
2019-06-23 18:00:00	GC	Futures	1794.7	1807.7	1794.4	1801.3	17596.0
2019-06-23 19:00:00	GC	Futures	1801.1	1803.7	1796.4	1803.1	7298.0
2019-06-23 20:00:00	GC	Futures	1803.2	1806.0	1801.1	1801.7	10955.0
2019-06-23 21:00:00	GC	Futures	1801.8	1808.7	1798.5	1802.8	17770.0
2019-06-23 22:00:00	GC	Futures	1802.7	1802.8	1798.7	1802.4	9889.0
2019-06-23 23:00:00	GC	Futures	1802.4	1803.1	1797.8	1798.3	7021.0
2019-06-23 18:00:00	ZN	Futures	128.418559	128.465719	128.402839	128.418559	9206.0
2019-06-23 19:00:00	ZN	Futures	128.418559	128.418559	128.355678	128.371398	9854.0
2019-06-23 20:00:00	ZN	Futures	128.371398	128.434279	128.308517	128.355678	14884.0
2019-06-23 21:00:00	ZN	Futures	128.371398	128.402839	128.355678	128.387118	7053.0
2019-06-23 22:00:00	ZN	Futures	128.402839	128.418559	128.339958	128.418559	10322.0
2019-06-23 23:00:00	ZN	Futures	128.402839	128.434279	128.371398	128.402839	11444.0

> showing 36 of 355 rows — these rows as CSV

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