PREVIEW / futures_1hour / 2020-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-12.parquet
  size:    17 KB
  rows:    352

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-12 18:00:00	ES	Futures	3555.89	3573.2	3555.89	3568.45	25208.0
2020-07-12 19:00:00	ES	Futures	3568.45	3569.29	3559.24	3559.24	12903.0
2020-07-12 20:00:00	ES	Futures	3559.24	3563.99	3553.93	3563.71	16954.0
2020-07-12 21:00:00	ES	Futures	3563.71	3569.57	3560.63	3567.89	17187.0
2020-07-12 22:00:00	ES	Futures	3567.89	3570.13	3565.1	3566.5	11511.0
2020-07-12 23:00:00	ES	Futures	3566.5	3568.45	3563.99	3565.66	6977.0
2020-07-12 18:00:00	NQ	Futures	12548.32	12619.17	12547.75	12604.14	8475.0
2020-07-12 19:00:00	NQ	Futures	12605.0	12610.21	12580.13	12581.0	3996.0
2020-07-12 20:00:00	NQ	Futures	12581.58	12599.8	12559.89	12598.35	6844.0
2020-07-12 21:00:00	NQ	Futures	12598.64	12607.9	12584.18	12599.8	6575.0
2020-07-12 22:00:00	NQ	Futures	12599.22	12604.14	12583.6	12585.92	4404.0
2020-07-12 23:00:00	NQ	Futures	12585.92	12589.39	12574.64	12583.03	3398.0
2020-07-12 18:00:00	YM	Futures	28657.2	28824.5	28657.2	28767.3	4493.0
2020-07-12 19:00:00	YM	Futures	28768.4	28782.7	28682.5	28691.3	3350.0
2020-07-12 20:00:00	YM	Futures	28693.5	28737.6	28648.4	28732.0	3853.0
2020-07-12 21:00:00	YM	Futures	28733.1	28778.3	28689.1	28762.9	3585.0
2020-07-12 22:00:00	YM	Futures	28759.6	28797.0	28728.7	28759.6	3457.0
2020-07-12 23:00:00	YM	Futures	28760.7	28790.4	28743.1	28764.0	1804.0
2020-07-12 18:00:00	CL	Futures	28.31	28.43	28.01	28.32	6048.0
2020-07-12 19:00:00	CL	Futures	28.32	28.37	28.12	28.16	2439.0
2020-07-12 20:00:00	CL	Futures	28.15	28.23	28.07	28.2	3025.0
2020-07-12 21:00:00	CL	Futures	28.19	28.3	28.19	28.24	3098.0
2020-07-12 22:00:00	CL	Futures	28.25	28.26	28.14	28.16	2269.0
2020-07-12 23:00:00	CL	Futures	28.16	28.24	28.14	28.21	1374.0
2020-07-12 18:00:00	GC	Futures	2226.4	2229.6	2224.7	2228.6	2944.0
2020-07-12 19:00:00	GC	Futures	2228.6	2229.4	2226.7	2227.0	1528.0
2020-07-12 20:00:00	GC	Futures	2227.0	2229.8	2226.8	2228.9	2264.0
2020-07-12 21:00:00	GC	Futures	2228.9	2232.7	2227.3	2230.7	6540.0
2020-07-12 22:00:00	GC	Futures	2230.8	2234.1	2230.8	2233.3	3272.0
2020-07-12 23:00:00	GC	Futures	2233.3	2233.9	2231.3	2231.3	2935.0
2020-07-12 18:00:00	ZN	Futures	138.789342	138.882845	138.758174	138.882845	8476.0
2020-07-12 19:00:00	ZN	Futures	138.882845	138.929596	138.851677	138.929596	9588.0
2020-07-12 20:00:00	ZN	Futures	138.914012	138.94518	138.882845	138.898429	8967.0
2020-07-12 21:00:00	ZN	Futures	138.898429	138.914012	138.82051	138.851677	10127.0
2020-07-12 22:00:00	ZN	Futures	138.836093	138.882845	138.836093	138.882845	7237.0
2020-07-12 23:00:00	ZN	Futures	138.882845	138.898429	138.867261	138.898429	4616.0

> showing 36 of 352 rows — these rows as CSV

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