PREVIEW / futures_1hour / 2019-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-24.parquet
  size:    16 KB
  rows:    359

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-11-24 18:00:00	ES	Futures	3388.87	3391.04	3386.15	3388.87	11434.0
2019-11-24 19:00:00	ES	Futures	3389.14	3389.68	3388.05	3389.41	7682.0
2019-11-24 20:00:00	ES	Futures	3389.14	3391.31	3388.87	3390.23	11198.0
2019-11-24 21:00:00	ES	Futures	3390.23	3390.77	3389.14	3389.68	5690.0
2019-11-24 22:00:00	ES	Futures	3389.41	3389.95	3389.14	3389.14	3347.0
2019-11-24 23:00:00	ES	Futures	3389.14	3390.23	3387.78	3388.05	3152.0
2019-11-24 18:00:00	NQ	Futures	9648.12	9658.0	9640.28	9652.19	5344.0
2019-11-24 19:00:00	NQ	Futures	9651.9	9654.22	9648.12	9653.93	2626.0
2019-11-24 20:00:00	NQ	Futures	9653.93	9663.23	9652.77	9659.74	4823.0
2019-11-24 21:00:00	NQ	Futures	9660.03	9661.48	9654.8	9656.25	1994.0
2019-11-24 22:00:00	NQ	Futures	9656.25	9657.71	9653.64	9654.22	1299.0
2019-11-24 23:00:00	NQ	Futures	9654.22	9657.42	9650.15	9651.03	1147.0
2019-11-24 18:00:00	YM	Futures	30394.4	30408.6	30369.4	30394.4	2263.0
2019-11-24 19:00:00	YM	Futures	30393.3	30406.4	30392.2	30402.0	1221.0
2019-11-24 20:00:00	YM	Futures	30402.0	30424.9	30397.7	30419.4	2497.0
2019-11-24 21:00:00	YM	Futures	30419.4	30422.7	30405.3	30412.9	972.0
2019-11-24 22:00:00	YM	Futures	30410.7	30414.0	30404.2	30407.5	632.0
2019-11-24 23:00:00	YM	Futures	30406.4	30414.0	30393.3	30396.6	711.0
2019-11-24 18:00:00	CL	Futures	51.36	51.48	51.28	51.44	3760.0
2019-11-24 19:00:00	CL	Futures	51.44	51.44	51.33	51.35	2301.0
2019-11-24 20:00:00	CL	Futures	51.35	51.36	51.22	51.35	4157.0
2019-11-24 21:00:00	CL	Futures	51.35	51.36	51.28	51.34	2042.0
2019-11-24 22:00:00	CL	Futures	51.34	51.4	51.31	51.34	2051.0
2019-11-24 23:00:00	CL	Futures	51.34	51.36	51.3	51.3	907.0
2019-11-24 18:00:00	GC	Futures	1850.9	1851.1	1848.9	1850.0	3748.0
2019-11-24 19:00:00	GC	Futures	1850.1	1851.0	1850.0	1850.6	2289.0
2019-11-24 20:00:00	GC	Futures	1850.6	1851.9	1848.9	1850.9	6864.0
2019-11-24 21:00:00	GC	Futures	1851.0	1852.2	1850.1	1851.1	3840.0
2019-11-24 22:00:00	GC	Futures	1851.1	1851.4	1850.4	1851.3	2101.0
2019-11-24 23:00:00	GC	Futures	1851.4	1851.6	1850.6	1851.5	1232.0
2019-11-24 18:00:00	ZN	Futures	129.513581	129.54485	129.451045	129.482313	15599.0
2019-11-24 19:00:00	ZN	Futures	129.482313	129.497947	129.451045	129.466679	13628.0
2019-11-24 20:00:00	ZN	Futures	129.466679	129.482313	129.43541	129.482313	9036.0
2019-11-24 21:00:00	ZN	Futures	129.497947	129.513581	129.466679	129.497947	6083.0
2019-11-24 22:00:00	ZN	Futures	129.497947	129.529216	129.482313	129.529216	3389.0
2019-11-24 23:00:00	ZN	Futures	129.513581	129.54485	129.513581	129.54485	4434.0

> showing 36 of 359 rows — these rows as CSV

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