PREVIEW / futures_1hour / 2019-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-01.parquet
  size:    17 KB
  rows:    369

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-12-01 18:00:00	ES	Futures	3418.48	3420.38	3416.3	3419.83	14925.0
2019-12-01 19:00:00	ES	Futures	3420.11	3426.62	3419.56	3425.27	26573.0
2019-12-01 20:00:00	ES	Futures	3425.54	3425.81	3423.91	3425.27	8826.0
2019-12-01 21:00:00	ES	Futures	3425.27	3427.17	3424.99	3425.81	7779.0
2019-12-01 22:00:00	ES	Futures	3425.81	3427.71	3425.81	3427.44	5675.0
2019-12-01 23:00:00	ES	Futures	3427.44	3427.44	3425.81	3425.81	3845.0
2019-12-01 18:00:00	NQ	Futures	9789.01	9801.5	9786.69	9796.56	3961.0
2019-12-01 19:00:00	NQ	Futures	9796.27	9818.64	9795.69	9814.28	6444.0
2019-12-01 20:00:00	NQ	Futures	9814.57	9815.74	9809.34	9814.28	3673.0
2019-12-01 21:00:00	NQ	Futures	9814.28	9821.84	9812.54	9816.9	3299.0
2019-12-01 22:00:00	NQ	Futures	9816.9	9819.22	9815.15	9818.35	1813.0
2019-12-01 23:00:00	NQ	Futures	9818.64	9821.54	9816.9	9817.19	3256.0
2019-12-01 18:00:00	YM	Futures	30563.1	30594.7	30559.8	30591.4	2185.0
2019-12-01 19:00:00	YM	Futures	30592.5	30651.3	30590.3	30640.4	4118.0
2019-12-01 20:00:00	YM	Futures	30641.5	30650.2	30627.3	30636.0	1851.0
2019-12-01 21:00:00	YM	Futures	30637.1	30654.5	30633.9	30641.5	1304.0
2019-12-01 22:00:00	YM	Futures	30640.4	30657.8	30640.4	30656.7	977.0
2019-12-01 23:00:00	YM	Futures	30655.6	30657.8	30642.6	30644.7	854.0
2019-12-01 18:00:00	CL	Futures	49.19	49.52	49.15	49.49	9590.0
2019-12-01 19:00:00	CL	Futures	49.5	49.81	49.5	49.81	10439.0
2019-12-01 20:00:00	CL	Futures	49.81	49.87	49.62	49.68	15110.0
2019-12-01 21:00:00	CL	Futures	49.69	49.81	49.68	49.72	4429.0
2019-12-01 22:00:00	CL	Futures	49.72	49.76	49.71	49.74	2372.0
2019-12-01 23:00:00	CL	Futures	49.74	49.76	49.7	49.72	2046.0
2019-12-01 18:00:00	GC	Futures	1853.8	1854.2	1850.6	1850.9	3003.0
2019-12-01 19:00:00	GC	Futures	1850.8	1850.9	1848.5	1850.0	5272.0
2019-12-01 20:00:00	GC	Futures	1850.0	1850.8	1848.6	1849.2	4526.0
2019-12-01 21:00:00	GC	Futures	1849.2	1849.6	1847.6	1848.0	3844.0
2019-12-01 22:00:00	GC	Futures	1847.9	1848.6	1846.9	1847.2	3163.0
2019-12-01 23:00:00	GC	Futures	1847.1	1848.1	1847.0	1848.0	1222.0
2019-12-01 18:00:00	ZN	Futures	129.2478	129.279069	129.200898	129.232166	2194.0
2019-12-01 19:00:00	ZN	Futures	129.216532	129.216532	129.107093	129.122727	1310.0
2019-12-01 20:00:00	ZN	Futures	129.122727	129.138361	129.107093	129.107093	514.0
2019-12-01 21:00:00	ZN	Futures	129.122727	129.122727	129.122727	129.122727	186.0
2019-12-01 22:00:00	ZN	Futures	129.107093	129.107093	129.075824	129.075824	290.0
2019-12-01 23:00:00	ZN	Futures	129.075824	129.107093	129.075824	129.107093	321.0

> showing 36 of 369 rows — these rows as CSV

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