PREVIEW / futures_1hour / 2019-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-14.parquet
  size:    17 KB
  rows:    354

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-07-14 18:00:00	ES	Futures	3264.97	3266.6	3263.89	3264.97	4028.0
2019-07-14 19:00:00	ES	Futures	3264.97	3265.79	3262.27	3262.81	3025.0
2019-07-14 20:00:00	ES	Futures	3262.81	3264.43	3262.27	3263.89	3231.0
2019-07-14 21:00:00	ES	Futures	3263.62	3264.16	3260.1	3262.54	8114.0
2019-07-14 22:00:00	ES	Futures	3262.81	3268.76	3262.81	3268.22	10369.0
2019-07-14 23:00:00	ES	Futures	3267.95	3269.31	3267.68	3267.95	4484.0
2019-07-14 18:00:00	NQ	Futures	9236.1	9245.97	9233.2	9236.68	1890.0
2019-07-14 19:00:00	NQ	Futures	9236.68	9239.59	9226.82	9228.56	1526.0
2019-07-14 20:00:00	NQ	Futures	9228.56	9232.91	9225.66	9229.14	1953.0
2019-07-14 21:00:00	NQ	Futures	9229.14	9231.17	9216.37	9225.08	4861.0
2019-07-14 22:00:00	NQ	Futures	9225.08	9243.94	9225.08	9241.91	4932.0
2019-07-14 23:00:00	NQ	Futures	9242.49	9248.0	9240.75	9242.78	2462.0
2019-07-14 18:00:00	YM	Futures	29692.0	29704.0	29688.8	29700.7	1631.0
2019-07-14 19:00:00	YM	Futures	29699.6	29705.1	29673.5	29680.1	1102.0
2019-07-14 20:00:00	YM	Futures	29679.0	29690.9	29670.3	29682.2	1293.0
2019-07-14 21:00:00	YM	Futures	29682.2	29683.3	29648.5	29671.4	2650.0
2019-07-14 22:00:00	YM	Futures	29671.4	29737.7	29671.4	29730.1	3391.0
2019-07-14 23:00:00	YM	Futures	29730.1	29742.0	29726.8	29730.1	1223.0
2019-07-14 18:00:00	CL	Futures	53.59	53.62	53.47	53.56	590.0
2019-07-14 19:00:00	CL	Futures	53.56	53.6	53.44	53.46	651.0
2019-07-14 20:00:00	CL	Futures	53.48	53.52	53.46	53.52	336.0
2019-07-14 21:00:00	CL	Futures	53.51	53.52	53.23	53.3	1887.0
2019-07-14 22:00:00	CL	Futures	53.31	53.35	53.21	53.33	821.0
2019-07-14 23:00:00	CL	Futures	53.34	53.42	53.3	53.41	476.0
2019-07-14 18:00:00	GC	Futures	1812.4	1817.4	1810.9	1814.6	5651.0
2019-07-14 19:00:00	GC	Futures	1814.3	1814.4	1808.4	1812.9	5848.0
2019-07-14 20:00:00	GC	Futures	1812.9	1814.3	1810.1	1812.0	5051.0
2019-07-14 21:00:00	GC	Futures	1811.9	1812.1	1806.3	1808.0	14764.0
2019-07-14 22:00:00	GC	Futures	1808.2	1808.7	1804.1	1805.5	7968.0
2019-07-14 23:00:00	GC	Futures	1805.4	1807.8	1805.2	1807.4	3175.0
2019-07-14 18:00:00	ZN	Futures	127.774029	127.852631	127.758309	127.82119	6048.0
2019-07-14 19:00:00	ZN	Futures	127.82119	127.82119	127.758309	127.80547	3937.0
2019-07-14 20:00:00	ZN	Futures	127.80547	127.80547	127.78975	127.80547	474.0
2019-07-14 21:00:00	ZN	Futures	127.78975	127.80547	127.742589	127.758309	6721.0
2019-07-14 22:00:00	ZN	Futures	127.758309	127.758309	127.648268	127.679708	17313.0
2019-07-14 23:00:00	ZN	Futures	127.663988	127.679708	127.648268	127.679708	2824.0

> showing 36 of 354 rows — these rows as CSV

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