PREVIEW / futures_1hour / 2020-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-23.parquet
  size:    17 KB
  rows:    351

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-08-23 18:00:00	ES	Futures	3796.32	3799.39	3792.13	3796.32	15323.0
2020-08-23 19:00:00	ES	Futures	3796.59	3798.27	3792.96	3794.92	9350.0
2020-08-23 20:00:00	ES	Futures	3794.92	3797.71	3790.45	3796.87	12932.0
2020-08-23 21:00:00	ES	Futures	3796.87	3802.74	3794.64	3798.83	14446.0
2020-08-23 22:00:00	ES	Futures	3798.83	3801.06	3798.83	3798.83	7286.0
2020-08-23 23:00:00	ES	Futures	3798.83	3800.5	3798.83	3799.11	4821.0
2020-08-23 18:00:00	NQ	Futures	13395.91	13405.16	13385.21	13399.38	4243.0
2020-08-23 19:00:00	NQ	Futures	13399.96	13409.5	13392.73	13399.09	3498.0
2020-08-23 20:00:00	NQ	Futures	13398.51	13408.63	13379.71	13404.87	4716.0
2020-08-23 21:00:00	NQ	Futures	13404.87	13425.98	13395.33	13414.12	4987.0
2020-08-23 22:00:00	NQ	Futures	13414.7	13427.72	13414.12	13419.04	3578.0
2020-08-23 23:00:00	NQ	Futures	13418.75	13435.23	13418.17	13423.09	3782.0
2020-08-23 18:00:00	YM	Futures	30721.8	30792.3	30717.4	30757.0	2172.0
2020-08-23 19:00:00	YM	Futures	30759.2	30772.5	30709.7	30726.2	1413.0
2020-08-23 20:00:00	YM	Futures	30726.2	30746.0	30696.5	30738.3	1817.0
2020-08-23 21:00:00	YM	Futures	30743.8	30786.8	30722.9	30761.4	2117.0
2020-08-23 22:00:00	YM	Futures	30762.5	30784.6	30760.3	30761.4	910.0
2020-08-23 23:00:00	YM	Futures	30762.5	30773.6	30755.9	30755.9	640.0
2020-08-23 18:00:00	CL	Futures	29.45	29.6	29.33	29.45	5982.0
2020-08-23 19:00:00	CL	Futures	29.45	29.47	29.38	29.41	1323.0
2020-08-23 20:00:00	CL	Futures	29.41	29.43	29.3	29.42	4496.0
2020-08-23 21:00:00	CL	Futures	29.42	29.46	29.36	29.42	2954.0
2020-08-23 22:00:00	CL	Futures	29.41	29.44	29.35	29.35	2035.0
2020-08-23 23:00:00	CL	Futures	29.36	29.36	29.31	29.33	2683.0
2020-08-23 18:00:00	GC	Futures	2369.0	2370.3	2357.0	2365.3	5466.0
2020-08-23 19:00:00	GC	Futures	2365.6	2365.9	2361.4	2362.4	2262.0
2020-08-23 20:00:00	GC	Futures	2362.4	2364.6	2357.4	2362.6	4247.0
2020-08-23 21:00:00	GC	Futures	2362.8	2364.2	2356.4	2362.6	6830.0
2020-08-23 22:00:00	GC	Futures	2362.6	2365.0	2358.5	2362.8	5621.0
2020-08-23 23:00:00	GC	Futures	2362.8	2363.9	2357.7	2358.1	3315.0
2020-08-23 18:00:00	ZN	Futures	139.241272	139.256856	139.194521	139.241272	7104.0
2020-08-23 19:00:00	ZN	Futures	139.241272	139.288024	139.241272	139.27244	6000.0
2020-08-23 20:00:00	ZN	Futures	139.27244	139.303607	139.256856	139.288024	11347.0
2020-08-23 21:00:00	ZN	Futures	139.288024	139.319191	139.241272	139.27244	9133.0
2020-08-23 22:00:00	ZN	Futures	139.27244	139.288024	139.256856	139.288024	7627.0
2020-08-23 23:00:00	ZN	Futures	139.27244	139.288024	139.27244	139.27244	986.0

> showing 36 of 351 rows — these rows as CSV

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