PREVIEW / futures_1hour / 2020-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-24.parquet
  size:    15 KB
  rows:    302

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-05-24 18:00:00	ES	Futures	3236.44	3258.4	3235.34	3255.38	13255.0
2020-05-24 19:00:00	ES	Futures	3255.38	3259.49	3251.54	3256.75	5702.0
2020-05-24 20:00:00	ES	Futures	3256.75	3258.4	3250.16	3251.26	7137.0
2020-05-24 21:00:00	ES	Futures	3250.99	3252.91	3242.75	3252.91	12748.0
2020-05-24 22:00:00	ES	Futures	3252.91	3254.83	3247.97	3250.16	6884.0
2020-05-24 23:00:00	ES	Futures	3249.89	3253.73	3249.61	3251.81	3403.0
2020-05-24 18:00:00	NQ	Futures	10735.8	10807.21	10730.38	10794.65	4511.0
2020-05-24 19:00:00	NQ	Futures	10794.65	10814.35	10784.36	10803.5	2327.0
2020-05-24 20:00:00	NQ	Futures	10804.36	10811.5	10786.08	10789.22	3778.0
2020-05-24 21:00:00	NQ	Futures	10789.79	10793.5	10758.94	10791.79	6023.0
2020-05-24 22:00:00	NQ	Futures	10792.36	10798.07	10770.94	10778.08	4313.0
2020-05-24 23:00:00	NQ	Futures	10778.36	10797.79	10777.51	10790.65	2667.0
2020-05-24 18:00:00	YM	Futures	26737.8	26895.5	26699.5	26869.2	2985.0
2020-05-24 19:00:00	YM	Futures	26870.3	26904.3	26847.3	26881.3	1834.0
2020-05-24 20:00:00	YM	Futures	26884.6	26899.9	26821.0	26830.9	2089.0
2020-05-24 21:00:00	YM	Futures	26830.9	26847.3	26759.7	26847.3	3282.0
2020-05-24 22:00:00	YM	Futures	26846.2	26863.8	26806.8	26826.5	2143.0
2020-05-24 23:00:00	YM	Futures	26827.6	26858.3	26825.4	26845.1	1184.0
2020-05-24 18:00:00	CL	Futures	23.17	23.29	22.6	22.9	7360.0
2020-05-24 19:00:00	CL	Futures	22.9	23.04	22.81	22.88	3025.0
2020-05-24 20:00:00	CL	Futures	22.88	23.14	22.88	23.01	4030.0
2020-05-24 21:00:00	CL	Futures	23.02	23.18	22.76	23.05	8845.0
2020-05-24 22:00:00	CL	Futures	23.05	23.18	22.99	23.18	4734.0
2020-05-24 23:00:00	CL	Futures	23.18	23.45	23.18	23.38	6036.0
2020-05-24 18:00:00	GC	Futures	2164.6	2167.2	2160.6	2160.7	1321.0
2020-05-24 19:00:00	GC	Futures	2161.0	2161.9	2158.1	2159.4	1034.0
2020-05-24 20:00:00	GC	Futures	2159.4	2160.4	2155.2	2157.6	1855.0
2020-05-24 21:00:00	GC	Futures	2157.6	2158.0	2154.5	2155.6	2571.0
2020-05-24 22:00:00	GC	Futures	2155.5	2157.9	2154.4	2157.9	1555.0
2020-05-24 23:00:00	GC	Futures	2157.7	2158.0	2155.0	2156.2	1073.0
2020-05-24 18:00:00	ZN	Futures	138.379005	138.410073	138.363471	138.379005	2862.0
2020-05-24 19:00:00	ZN	Futures	138.363471	138.379005	138.301334	138.332402	3208.0
2020-05-24 20:00:00	ZN	Futures	138.316868	138.347936	138.316868	138.332402	3561.0
2020-05-24 21:00:00	ZN	Futures	138.347936	138.379005	138.347936	138.363471	2135.0
2020-05-24 22:00:00	ZN	Futures	138.363471	138.410073	138.347936	138.394539	1823.0
2020-05-24 23:00:00	ZN	Futures	138.379005	138.394539	138.363471	138.379005	1346.0

> showing 36 of 302 rows — these rows as CSV

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