PREVIEW / futures_1hour / 2019-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-27.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-10-27 18:00:00	ES	Futures	3284.56	3287.82	3284.29	3285.65	7548.0
2019-10-27 19:00:00	ES	Futures	3285.92	3287.01	3285.38	3285.92	2993.0
2019-10-27 20:00:00	ES	Futures	3286.19	3288.09	3284.83	3286.46	5474.0
2019-10-27 21:00:00	ES	Futures	3286.46	3287.01	3284.29	3286.19	6962.0
2019-10-27 22:00:00	ES	Futures	3286.46	3287.82	3285.65	3286.46	5020.0
2019-10-27 23:00:00	ES	Futures	3286.46	3287.55	3286.19	3287.01	2710.0
2019-10-27 18:00:00	NQ	Futures	9351.53	9368.67	9351.53	9358.79	5075.0
2019-10-27 19:00:00	NQ	Futures	9358.79	9366.05	9358.21	9361.99	1513.0
2019-10-27 20:00:00	NQ	Futures	9362.28	9370.99	9357.63	9361.7	2968.0
2019-10-27 21:00:00	NQ	Futures	9361.7	9364.31	9355.6	9361.7	3592.0
2019-10-27 22:00:00	NQ	Futures	9361.99	9367.51	9359.66	9361.7	2205.0
2019-10-27 23:00:00	NQ	Futures	9361.99	9365.18	9360.24	9363.44	1345.0
2019-10-27 18:00:00	YM	Futures	29310.4	29335.4	29305.0	29326.7	1500.0
2019-10-27 19:00:00	YM	Futures	29324.6	29336.5	29318.0	29324.6	525.0
2019-10-27 20:00:00	YM	Futures	29325.7	29340.9	29313.7	29328.9	1007.0
2019-10-27 21:00:00	YM	Futures	29330.0	29335.4	29314.8	29331.1	1476.0
2019-10-27 22:00:00	YM	Futures	29330.0	29347.4	29328.9	29336.5	916.0
2019-10-27 23:00:00	YM	Futures	29337.6	29347.4	29331.1	29337.6	775.0
2019-10-27 18:00:00	CL	Futures	50.27	50.45	50.16	50.36	4384.0
2019-10-27 19:00:00	CL	Futures	50.36	50.37	50.31	50.32	1412.0
2019-10-27 20:00:00	CL	Futures	50.32	50.38	50.22	50.22	2640.0
2019-10-27 21:00:00	CL	Futures	50.22	50.23	50.18	50.2	4041.0
2019-10-27 22:00:00	CL	Futures	50.2	50.24	50.17	50.18	2369.0
2019-10-27 23:00:00	CL	Futures	50.18	50.2	50.13	50.15	1773.0
2019-10-27 18:00:00	GC	Futures	1909.7	1909.7	1906.2	1907.6	2048.0
2019-10-27 19:00:00	GC	Futures	1907.6	1908.8	1907.4	1908.7	1220.0
2019-10-27 20:00:00	GC	Futures	1908.5	1909.9	1908.1	1909.7	2664.0
2019-10-27 21:00:00	GC	Futures	1909.5	1911.4	1909.2	1910.9	6489.0
2019-10-27 22:00:00	GC	Futures	1911.1	1911.4	1908.8	1910.0	4325.0
2019-10-27 23:00:00	GC	Futures	1909.9	1910.3	1908.4	1908.7	3081.0
2019-10-27 18:00:00	ZN	Futures	129.654289	129.654289	129.576118	129.591752	6522.0
2019-10-27 19:00:00	ZN	Futures	129.591752	129.607386	129.560484	129.576118	5775.0
2019-10-27 20:00:00	ZN	Futures	129.576118	129.591752	129.560484	129.591752	6903.0
2019-10-27 21:00:00	ZN	Futures	129.591752	129.607386	129.576118	129.576118	7601.0
2019-10-27 22:00:00	ZN	Futures	129.576118	129.591752	129.466679	129.529216	20484.0
2019-10-27 23:00:00	ZN	Futures	129.513581	129.529216	129.482313	129.497947	5858.0

> showing 36 of 358 rows — these rows as CSV

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