PREVIEW / futures_1hour / 2020-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-23.parquet
  size:    18 KB
  rows:    377

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
2020-02-23 18:00:00	ES	Futures	3586.8	3590.1	3565.7	3575.2	92492.0
2020-02-23 19:00:00	ES	Futures	3575.4	3581.1	3570.3	3573.3	49915.0
2020-02-23 20:00:00	ES	Futures	3573.3	3577.6	3572.5	3574.9	35980.0
2020-02-23 21:00:00	ES	Futures	3574.9	3576.8	3561.4	3565.4	42374.0
2020-02-23 22:00:00	ES	Futures	3565.1	3571.1	3561.6	3568.9	26120.0
2020-02-23 23:00:00	ES	Futures	3569.2	3573.0	3569.2	3570.3	15510.0
2020-02-23 18:00:00	NQ	Futures	10821.15	10832.43	10744.52	10768.23	34298.0
2020-02-23 19:00:00	NQ	Futures	10768.81	10784.72	10737.58	10754.06	26441.0
2020-02-23 20:00:00	NQ	Futures	10754.64	10772.57	10750.02	10758.69	11890.0
2020-02-23 21:00:00	NQ	Futures	10758.11	10764.76	10702.88	10721.68	20944.0
2020-02-23 22:00:00	NQ	Futures	10721.39	10741.05	10703.75	10737.58	14932.0
2020-02-23 23:00:00	NQ	Futures	10738.74	10760.43	10738.74	10749.44	9378.0
2020-02-23 18:00:00	YM	Futures	31295.9	31305.7	31114.1	31184.8	14886.0
2020-02-23 19:00:00	YM	Futures	31185.9	31217.5	31145.7	31157.6	10882.0
2020-02-23 20:00:00	YM	Futures	31155.5	31192.5	31147.8	31169.6	5382.0
2020-02-23 21:00:00	YM	Futures	31167.4	31181.6	31062.9	31092.3	7591.0
2020-02-23 22:00:00	YM	Futures	31091.2	31131.5	31058.6	31114.1	4817.0
2020-02-23 23:00:00	YM	Futures	31115.2	31148.9	31115.2	31123.9	2960.0
2020-02-23 18:00:00	CL	Futures	46.38	46.41	45.55	45.91	25452.0
2020-02-23 19:00:00	CL	Futures	45.91	45.97	45.66	45.74	13663.0
2020-02-23 20:00:00	CL	Futures	45.74	45.92	45.62	45.82	18757.0
2020-02-23 21:00:00	CL	Futures	45.83	45.94	45.8	45.82	7305.0
2020-02-23 22:00:00	CL	Futures	45.82	45.96	45.75	45.94	6965.0
2020-02-23 23:00:00	CL	Futures	45.94	46.06	45.94	45.97	4933.0
2020-02-23 18:00:00	GC	Futures	2068.4	2103.5	2066.7	2083.7	38986.0
2020-02-23 19:00:00	GC	Futures	2083.7	2085.8	2074.7	2080.4	23221.0
2020-02-23 20:00:00	GC	Futures	2080.4	2086.4	2076.4	2078.8	20082.0
2020-02-23 21:00:00	GC	Futures	2078.7	2081.1	2077.1	2079.8	9166.0
2020-02-23 22:00:00	GC	Futures	2079.7	2080.1	2075.2	2077.6	8238.0
2020-02-23 23:00:00	GC	Futures	2077.7	2079.6	2076.2	2079.6	4291.0
2020-02-23 18:00:00	ZN	Futures	132.361016	132.501809	132.298442	132.361016	73000.0
2020-02-23 19:00:00	ZN	Futures	132.37666	132.392304	132.251511	132.361016	37072.0
2020-02-23 20:00:00	ZN	Futures	132.345373	132.392304	132.298442	132.345373	26306.0
2020-02-23 21:00:00	ZN	Futures	132.345373	132.454878	132.329729	132.439235	25957.0
2020-02-23 22:00:00	ZN	Futures	132.454878	132.470522	132.37666	132.392304	19826.0
2020-02-23 23:00:00	ZN	Futures	132.392304	132.407947	132.345373	132.361016	9108.0

> showing 36 of 377 rows — these rows as CSV

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