PREVIEW / futures_1hour / 2019-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-01.parquet
  size:    16 KB
  rows:    314

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-01 18:00:00	ES	Futures	3141.26	3148.84	3133.41	3148.03	20941.0
2019-09-01 19:00:00	ES	Futures	3148.3	3151.01	3145.05	3149.92	8846.0
2019-09-01 20:00:00	ES	Futures	3149.92	3152.63	3148.57	3149.65	11029.0
2019-09-01 21:00:00	ES	Futures	3149.65	3156.69	3149.11	3154.8	14883.0
2019-09-01 22:00:00	ES	Futures	3154.8	3157.23	3148.03	3149.11	8329.0
2019-09-01 23:00:00	ES	Futures	3149.11	3153.98	3146.95	3153.17	6204.0
2019-09-01 18:00:00	NQ	Futures	8853.12	8853.41	8812.21	8846.15	6962.0
2019-09-01 19:00:00	NQ	Futures	8846.15	8858.05	8839.19	8855.44	3413.0
2019-09-01 20:00:00	NQ	Futures	8855.44	8861.53	8849.63	8855.73	4029.0
2019-09-01 21:00:00	NQ	Futures	8855.73	8876.62	8854.28	8869.94	6194.0
2019-09-01 22:00:00	NQ	Futures	8870.23	8879.81	8849.92	8853.41	5587.0
2019-09-01 23:00:00	NQ	Futures	8853.99	8868.2	8845.86	8867.04	3403.0
2019-09-01 18:00:00	YM	Futures	28539.3	28576.2	28352.2	28565.4	4220.0
2019-09-01 19:00:00	YM	Futures	28564.3	28594.7	28546.9	28575.2	1615.0
2019-09-01 20:00:00	YM	Futures	28576.2	28604.5	28568.6	28577.3	2002.0
2019-09-01 21:00:00	YM	Futures	28578.4	28653.5	28574.1	28633.9	2401.0
2019-09-01 22:00:00	YM	Futures	28635.0	28649.1	28571.9	28582.8	1548.0
2019-09-01 23:00:00	YM	Futures	28581.7	28615.4	28559.9	28612.1	1063.0
2019-09-01 18:00:00	CL	Futures	48.83	48.89	48.4	48.69	4503.0
2019-09-01 19:00:00	CL	Futures	48.69	48.73	48.62	48.66	2151.0
2019-09-01 20:00:00	CL	Futures	48.66	48.7	48.63	48.7	2514.0
2019-09-01 21:00:00	CL	Futures	48.7	48.91	48.69	48.8	6803.0
2019-09-01 22:00:00	CL	Futures	48.8	48.87	48.79	48.83	3499.0
2019-09-01 23:00:00	CL	Futures	48.83	48.93	48.81	48.93	3174.0
2019-09-01 18:00:00	GC	Futures	1944.9	1956.7	1944.9	1949.2	10064.0
2019-09-01 19:00:00	GC	Futures	1949.1	1949.2	1947.3	1948.4	2785.0
2019-09-01 20:00:00	GC	Futures	1948.4	1949.6	1946.7	1948.4	4679.0
2019-09-01 21:00:00	GC	Futures	1948.4	1949.1	1940.3	1942.6	16691.0
2019-09-01 22:00:00	GC	Futures	1942.6	1944.9	1940.8	1943.7	6372.0
2019-09-01 23:00:00	GC	Futures	1943.7	1945.1	1943.6	1944.1	2782.0
2019-09-01 18:00:00	ZN	Futures	132.049932	132.049932	132.002771	132.034212	1004.0
2019-09-01 19:00:00	ZN	Futures	132.018491	132.034212	131.955611	132.002771	89.0
2019-09-01 20:00:00	ZN	Futures	131.987051	132.018491	131.93989	132.018491	671.0
2019-09-01 21:00:00	ZN	Futures	131.987051	132.002771	131.877009	131.90845	623.0
2019-09-01 22:00:00	ZN	Futures	131.877009	131.877009	131.877009	131.877009	4.0
2019-09-01 23:00:00	ZN	Futures	131.90845	131.90845	131.89273	131.89273	53.0

> showing 36 of 314 rows — these rows as CSV

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