PREVIEW / futures_1hour / 2022-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-03-27.parquet
  size:    20 KB
  rows:    425

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
2022-03-27 18:00:00	ES	Futures	5141.89	5147.27	5133.1	5134.52	9427.0
2022-03-27 19:00:00	ES	Futures	5134.8	5139.05	5131.97	5131.97	5629.0
2022-03-27 20:00:00	ES	Futures	5131.97	5133.1	5126.58	5127.15	7241.0
2022-03-27 21:00:00	ES	Futures	5127.15	5127.72	5123.18	5125.45	7137.0
2022-03-27 22:00:00	ES	Futures	5125.45	5132.54	5123.18	5130.27	8306.0
2022-03-27 23:00:00	ES	Futures	5130.55	5132.82	5125.17	5126.87	4198.0
2022-03-27 18:00:00	NQ	Futures	17115.49	17142.74	17083.88	17089.39	5541.0
2022-03-27 19:00:00	NQ	Futures	17090.55	17103.6	17073.73	17075.76	2682.0
2022-03-27 20:00:00	NQ	Futures	17073.73	17083.3	17056.33	17063.87	3749.0
2022-03-27 21:00:00	NQ	Futures	17063.0	17066.48	17029.07	17037.48	4514.0
2022-03-27 22:00:00	NQ	Futures	17036.61	17068.51	17030.81	17058.36	4206.0
2022-03-27 23:00:00	NQ	Futures	17058.94	17072.57	17034.29	17042.99	2563.0
2022-03-27 18:00:00	YM	Futures	39188.3	39205.2	39108.2	39119.5	1694.0
2022-03-27 19:00:00	YM	Futures	39121.8	39152.2	39106.0	39106.0	986.0
2022-03-27 20:00:00	YM	Futures	39104.8	39107.1	39059.8	39063.1	1233.0
2022-03-27 21:00:00	YM	Futures	39060.9	39071.0	39037.2	39067.6	1049.0
2022-03-27 22:00:00	YM	Futures	39066.5	39101.5	39038.3	39086.8	1475.0
2022-03-27 23:00:00	YM	Futures	39095.8	39101.5	39062.0	39069.9	576.0
2022-03-27 18:00:00	CL	Futures	84.24	84.24	81.98	82.77	9206.0
2022-03-27 19:00:00	CL	Futures	82.76	82.87	82.39	82.59	2507.0
2022-03-27 20:00:00	CL	Futures	82.62	82.62	81.57	82.08	6410.0
2022-03-27 21:00:00	CL	Futures	82.09	82.49	81.54	82.43	6344.0
2022-03-27 22:00:00	CL	Futures	82.44	82.73	82.17	82.73	3732.0
2022-03-27 23:00:00	CL	Futures	82.71	82.84	82.15	82.32	3368.0
2022-03-27 18:00:00	GC	Futures	2349.9	2353.2	2347.2	2348.5	708.0
2022-03-27 19:00:00	GC	Futures	2348.5	2350.9	2347.7	2350.5	222.0
2022-03-27 20:00:00	GC	Futures	2350.2	2351.9	2347.6	2350.9	608.0
2022-03-27 21:00:00	GC	Futures	2350.8	2350.8	2336.9	2336.9	1537.0
2022-03-27 22:00:00	GC	Futures	2337.0	2341.4	2334.7	2339.8	1220.0
2022-03-27 23:00:00	GC	Futures	2339.9	2339.9	2332.2	2334.9	806.0
2022-03-27 18:00:00	ZN	Futures	124.914903	124.930945	124.690323	124.88282	16280.0
2022-03-27 19:00:00	ZN	Futures	124.88282	125.011152	124.834696	124.979069	9879.0
2022-03-27 20:00:00	ZN	Futures	124.995111	125.171567	124.979069	125.139484	24152.0
2022-03-27 21:00:00	ZN	Futures	125.123442	125.155525	124.754489	124.754489	26436.0
2022-03-27 22:00:00	ZN	Futures	124.754489	124.802613	124.594074	124.642198	32630.0
2022-03-27 23:00:00	ZN	Futures	124.642198	124.722406	124.385535	124.433659	29801.0

> showing 36 of 425 rows — these rows as CSV

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