PREVIEW / futures_1hour / 2019-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-03.parquet
  size:    17 KB
  rows:    374

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-03 18:00:00	ES	Futures	3329.92	3334.54	3329.92	3332.91	11233.0
2019-11-03 19:00:00	ES	Futures	3332.91	3334.0	3331.83	3332.37	4868.0
2019-11-03 20:00:00	ES	Futures	3332.37	3334.54	3332.1	3333.73	6465.0
2019-11-03 21:00:00	ES	Futures	3333.73	3337.53	3332.91	3336.71	8462.0
2019-11-03 22:00:00	ES	Futures	3336.71	3337.26	3335.63	3335.63	4155.0
2019-11-03 23:00:00	ES	Futures	3335.63	3335.9	3335.09	3335.63	1852.0
2019-11-03 18:00:00	NQ	Futures	9487.48	9506.07	9486.32	9501.13	3378.0
2019-11-03 19:00:00	NQ	Futures	9501.13	9504.33	9497.36	9498.52	1692.0
2019-11-03 20:00:00	NQ	Futures	9498.52	9508.98	9497.06	9505.49	2776.0
2019-11-03 21:00:00	NQ	Futures	9505.2	9521.47	9504.04	9518.27	2809.0
2019-11-03 22:00:00	NQ	Futures	9518.56	9519.72	9513.62	9515.66	1684.0
2019-11-03 23:00:00	NQ	Futures	9515.66	9516.24	9513.04	9515.95	864.0
2019-11-03 18:00:00	YM	Futures	29688.1	29731.6	29683.7	29715.3	2262.0
2019-11-03 19:00:00	YM	Futures	29714.2	29717.5	29701.1	29705.5	900.0
2019-11-03 20:00:00	YM	Futures	29704.4	29729.4	29702.2	29724.0	1330.0
2019-11-03 21:00:00	YM	Futures	29724.0	29755.6	29720.7	29754.5	1531.0
2019-11-03 22:00:00	YM	Futures	29754.5	29755.6	29740.3	29741.4	700.0
2019-11-03 23:00:00	YM	Futures	29741.4	29741.4	29732.7	29734.9	560.0
2019-11-03 18:00:00	CL	Futures	50.06	50.08	49.87	49.87	3721.0
2019-11-03 19:00:00	CL	Futures	49.87	49.88	49.7	49.7	4157.0
2019-11-03 20:00:00	CL	Futures	49.7	49.7	49.57	49.67	8116.0
2019-11-03 21:00:00	CL	Futures	49.66	49.71	49.62	49.66	4662.0
2019-11-03 22:00:00	CL	Futures	49.67	49.67	49.59	49.59	2952.0
2019-11-03 23:00:00	CL	Futures	49.59	49.63	49.55	49.59	2111.0
2019-11-03 18:00:00	GC	Futures	1921.1	1921.2	1918.7	1919.4	2957.0
2019-11-03 19:00:00	GC	Futures	1919.4	1920.2	1917.5	1917.9	2972.0
2019-11-03 20:00:00	GC	Futures	1917.9	1920.7	1917.1	1919.8	6383.0
2019-11-03 21:00:00	GC	Futures	1919.8	1920.4	1918.7	1919.9	3477.0
2019-11-03 22:00:00	GC	Futures	1919.9	1919.9	1918.3	1918.5	2239.0
2019-11-03 23:00:00	GC	Futures	1918.5	1918.8	1918.0	1918.2	1275.0
2019-11-03 18:00:00	ZN	Futures	130.10768	130.154583	130.029509	130.060778	12777.0
2019-11-03 19:00:00	ZN	Futures	130.060778	130.076412	129.998241	130.029509	6720.0
2019-11-03 20:00:00	ZN	Futures	130.029509	130.045144	130.013875	130.045144	7103.0
2019-11-03 21:00:00	ZN	Futures	130.045144	130.045144	129.982607	129.998241	7457.0
2019-11-03 22:00:00	ZN	Futures	129.998241	130.013875	129.951338	129.966973	7610.0
2019-11-03 23:00:00	ZN	Futures	129.966973	129.998241	129.951338	129.982607	5575.0

> showing 36 of 374 rows — these rows as CSV

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