PREVIEW / futures_1hour / 2019-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-15.parquet
  size:    18 KB
  rows:    365

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-09-15 18:00:00	ES	Futures	3256.04	3259.57	3245.45	3255.5	20691.0
2019-09-15 19:00:00	ES	Futures	3256.04	3259.03	3249.52	3250.61	10982.0
2019-09-15 20:00:00	ES	Futures	3250.61	3251.97	3241.64	3249.25	28675.0
2019-09-15 21:00:00	ES	Futures	3248.98	3250.88	3244.36	3249.25	17888.0
2019-09-15 22:00:00	ES	Futures	3248.98	3250.34	3245.45	3249.79	7516.0
2019-09-15 23:00:00	ES	Futures	3250.06	3252.24	3249.52	3251.97	5293.0
2019-09-15 18:00:00	NQ	Futures	9154.57	9154.57	9095.6	9129.59	5097.0
2019-09-15 19:00:00	NQ	Futures	9129.88	9139.76	9104.03	9109.55	3188.0
2019-09-15 20:00:00	NQ	Futures	9109.26	9113.62	9061.33	9086.02	12266.0
2019-09-15 21:00:00	NQ	Futures	9085.73	9094.15	9069.17	9090.67	7457.0
2019-09-15 22:00:00	NQ	Futures	9089.79	9098.51	9077.88	9096.77	3368.0
2019-09-15 23:00:00	NQ	Futures	9096.77	9107.22	9095.6	9105.19	2410.0
2019-09-15 18:00:00	YM	Futures	29516.1	29541.1	29418.2	29509.6	4349.0
2019-09-15 19:00:00	YM	Futures	29510.7	29533.5	29462.8	29471.5	1430.0
2019-09-15 20:00:00	YM	Futures	29469.3	29479.1	29395.3	29467.1	4608.0
2019-09-15 21:00:00	YM	Futures	29468.2	29478.0	29423.6	29459.5	2641.0
2019-09-15 22:00:00	YM	Futures	29457.3	29470.4	29434.5	29469.3	1154.0
2019-09-15 23:00:00	YM	Futures	29469.3	29488.9	29465.0	29482.4	716.0
2019-09-15 18:00:00	CL	Futures	53.45	56.76	53.23	54.21	20010.0
2019-09-15 19:00:00	CL	Futures	54.2	54.5	53.79	54.36	8303.0
2019-09-15 20:00:00	CL	Futures	54.37	54.5	53.47	53.84	25032.0
2019-09-15 21:00:00	CL	Futures	53.82	53.87	53.26	53.39	9366.0
2019-09-15 22:00:00	CL	Futures	53.38	53.43	52.61	52.87	6225.0
2019-09-15 23:00:00	CL	Futures	52.87	52.99	52.79	52.83	2307.0
2019-09-15 18:00:00	GC	Futures	1916.9	1918.9	1908.3	1915.2	23026.0
2019-09-15 19:00:00	GC	Futures	1915.2	1920.1	1912.7	1917.6	9516.0
2019-09-15 20:00:00	GC	Futures	1917.6	1925.3	1916.5	1916.9	21408.0
2019-09-15 21:00:00	GC	Futures	1917.0	1923.2	1916.9	1919.5	22510.0
2019-09-15 22:00:00	GC	Futures	1919.7	1920.3	1913.2	1913.6	10100.0
2019-09-15 23:00:00	GC	Futures	1913.5	1916.5	1913.3	1913.8	5239.0
2019-09-15 18:00:00	ZN	Futures	128.919482	129.028922	128.841311	128.935117	50228.0
2019-09-15 19:00:00	ZN	Futures	128.935117	129.06019	128.919482	129.044556	31621.0
2019-09-15 20:00:00	ZN	Futures	129.044556	129.138361	129.028922	129.044556	40569.0
2019-09-15 21:00:00	ZN	Futures	129.044556	129.138361	129.013287	129.06019	18592.0
2019-09-15 22:00:00	ZN	Futures	129.075824	129.122727	129.06019	129.091458	9102.0
2019-09-15 23:00:00	ZN	Futures	129.091458	129.107093	129.06019	129.075824	5655.0

> showing 36 of 365 rows — these rows as CSV

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