PREVIEW / futures_1hour / 2020-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-19.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-07-19 18:00:00	ES	Futures	3590.51	3598.05	3588.0	3593.86	13241.0
2020-07-19 19:00:00	ES	Futures	3593.86	3599.17	3592.75	3598.05	5520.0
2020-07-19 20:00:00	ES	Futures	3598.05	3598.89	3591.63	3593.03	10230.0
2020-07-19 21:00:00	ES	Futures	3592.75	3593.86	3569.85	3574.32	32980.0
2020-07-19 22:00:00	ES	Futures	3574.04	3579.06	3572.64	3575.71	11379.0
2020-07-19 23:00:00	ES	Futures	3575.71	3582.14	3574.88	3579.9	9354.0
2020-07-19 18:00:00	NQ	Futures	12285.75	12327.1	12276.5	12307.44	4804.0
2020-07-19 19:00:00	NQ	Futures	12308.31	12321.03	12297.61	12316.11	3197.0
2020-07-19 20:00:00	NQ	Futures	12315.82	12319.01	12297.61	12302.81	3695.0
2020-07-19 21:00:00	NQ	Futures	12302.52	12305.13	12205.65	12219.53	13964.0
2020-07-19 22:00:00	NQ	Futures	12219.53	12236.3	12214.03	12225.02	6583.0
2020-07-19 23:00:00	NQ	Futures	12225.6	12255.39	12220.97	12248.16	4377.0
2020-07-19 18:00:00	YM	Futures	29225.4	29274.9	29189.0	29238.6	2626.0
2020-07-19 19:00:00	YM	Futures	29239.7	29294.7	29229.8	29282.6	1403.0
2020-07-19 20:00:00	YM	Futures	29284.8	29289.2	29233.1	29245.2	1944.0
2020-07-19 21:00:00	YM	Futures	29240.8	29251.8	29023.8	29066.8	6730.0
2020-07-19 22:00:00	YM	Futures	29065.7	29108.6	29050.3	29076.7	2707.0
2020-07-19 23:00:00	YM	Futures	29077.8	29138.4	29072.3	29118.5	2305.0
2020-07-19 18:00:00	CL	Futures	28.43	28.48	28.32	28.43	1728.0
2020-07-19 19:00:00	CL	Futures	28.44	28.47	28.42	28.44	991.0
2020-07-19 20:00:00	CL	Futures	28.43	28.45	28.3	28.32	2809.0
2020-07-19 21:00:00	CL	Futures	28.32	28.34	28.16	28.24	6635.0
2020-07-19 22:00:00	CL	Futures	28.23	28.29	28.22	28.23	2497.0
2020-07-19 23:00:00	CL	Futures	28.23	28.32	28.22	28.25	2373.0
2020-07-19 18:00:00	GC	Futures	2237.3	2237.6	2234.3	2235.9	2428.0
2020-07-19 19:00:00	GC	Futures	2236.0	2236.8	2234.6	2234.9	1059.0
2020-07-19 20:00:00	GC	Futures	2234.9	2235.4	2230.9	2232.4	3795.0
2020-07-19 21:00:00	GC	Futures	2232.4	2233.9	2230.3	2232.4	4534.0
2020-07-19 22:00:00	GC	Futures	2232.4	2234.1	2231.4	2233.0	2190.0
2020-07-19 23:00:00	GC	Futures	2233.1	2234.0	2232.3	2233.1	2417.0
2020-07-19 18:00:00	ZN	Futures	138.991931	139.023099	138.976348	139.007515	6641.0
2020-07-19 19:00:00	ZN	Futures	139.007515	139.007515	138.960764	138.991931	3569.0
2020-07-19 20:00:00	ZN	Futures	138.976348	139.007515	138.976348	138.976348	5553.0
2020-07-19 21:00:00	ZN	Futures	138.991931	139.06985	138.976348	139.06985	15235.0
2020-07-19 22:00:00	ZN	Futures	139.085434	139.085434	139.054267	139.06985	3387.0
2020-07-19 23:00:00	ZN	Futures	139.06985	139.101018	139.054267	139.085434	5038.0

> showing 36 of 351 rows — these rows as CSV

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