PREVIEW / futures_1hour / 2019-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-28.parquet
  size:    17 KB
  rows:    358

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-28 18:00:00	ES	Futures	3272.28	3276.61	3272.28	3274.99	5380.0
2019-07-28 19:00:00	ES	Futures	3274.99	3274.99	3273.37	3273.91	2370.0
2019-07-28 20:00:00	ES	Futures	3274.18	3274.45	3271.2	3271.74	7301.0
2019-07-28 21:00:00	ES	Futures	3271.74	3273.91	3271.2	3272.82	7911.0
2019-07-28 22:00:00	ES	Futures	3272.82	3272.82	3270.12	3271.47	5806.0
2019-07-28 23:00:00	ES	Futures	3271.2	3272.01	3270.66	3271.2	2279.0
2019-07-28 18:00:00	NQ	Futures	9304.87	9315.6	9304.87	9309.51	2428.0
2019-07-28 19:00:00	NQ	Futures	9309.51	9310.09	9303.42	9305.45	1221.0
2019-07-28 20:00:00	NQ	Futures	9305.45	9305.74	9293.84	9295.0	3308.0
2019-07-28 21:00:00	NQ	Futures	9294.71	9303.13	9293.84	9297.32	3518.0
2019-07-28 22:00:00	NQ	Futures	9297.32	9297.32	9286.88	9291.52	2929.0
2019-07-28 23:00:00	NQ	Futures	9290.94	9295.87	9288.62	9294.13	1510.0
2019-07-28 18:00:00	YM	Futures	29518.0	29539.8	29514.8	29525.6	991.0
2019-07-28 19:00:00	YM	Futures	29526.7	29531.1	29519.1	29523.5	391.0
2019-07-28 20:00:00	YM	Futures	29524.5	29524.5	29494.1	29496.3	1390.0
2019-07-28 21:00:00	YM	Futures	29496.3	29518.0	29495.2	29508.2	1059.0
2019-07-28 22:00:00	YM	Futures	29508.2	29508.2	29484.3	29497.4	1342.0
2019-07-28 23:00:00	YM	Futures	29495.2	29503.9	29490.8	29498.4	474.0
2019-07-28 18:00:00	CL	Futures	49.89	50.0	49.74	49.77	3273.0
2019-07-28 19:00:00	CL	Futures	49.78	49.78	49.69	49.71	2238.0
2019-07-28 20:00:00	CL	Futures	49.72	49.83	49.71	49.78	4643.0
2019-07-28 21:00:00	CL	Futures	49.77	49.88	49.77	49.82	5161.0
2019-07-28 22:00:00	CL	Futures	49.82	49.82	49.75	49.78	3018.0
2019-07-28 23:00:00	CL	Futures	49.78	49.83	49.77	49.82	1810.0
2019-07-28 18:00:00	GC	Futures	1814.0	1816.3	1812.9	1814.5	1342.0
2019-07-28 19:00:00	GC	Futures	1814.7	1815.8	1814.1	1815.3	630.0
2019-07-28 20:00:00	GC	Futures	1815.3	1817.1	1813.8	1816.8	1510.0
2019-07-28 21:00:00	GC	Futures	1816.8	1820.5	1816.6	1818.6	5139.0
2019-07-28 22:00:00	GC	Futures	1818.7	1818.8	1817.3	1817.4	1723.0
2019-07-28 23:00:00	GC	Futures	1817.4	1817.8	1815.4	1815.9	1873.0
2019-07-28 18:00:00	ZN	Futures	128.088434	128.104154	128.056993	128.088434	3131.0
2019-07-28 19:00:00	ZN	Futures	128.104154	128.135595	128.088434	128.119874	6721.0
2019-07-28 20:00:00	ZN	Futures	128.119874	128.182755	128.104154	128.167035	14162.0
2019-07-28 21:00:00	ZN	Futures	128.167035	128.182755	128.135595	128.167035	4585.0
2019-07-28 22:00:00	ZN	Futures	128.167035	128.167035	128.151315	128.151315	405.0
2019-07-28 23:00:00	ZN	Futures	128.151315	128.182755	128.119874	128.151315	9403.0

> showing 36 of 358 rows — these rows as CSV

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