PREVIEW / futures_1hour / 2020-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-14.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-06-14 18:00:00	ES	Futures	3332.21	3348.41	3316.85	3345.62	34086.0
2020-06-14 19:00:00	ES	Futures	3345.9	3347.29	3324.95	3334.45	22525.0
2020-06-14 20:00:00	ES	Futures	3334.17	3340.59	3327.19	3327.47	26848.0
2020-06-14 21:00:00	ES	Futures	3327.19	3340.31	3325.51	3338.91	17962.0
2020-06-14 22:00:00	ES	Futures	3338.91	3342.27	3328.86	3329.42	13578.0
2020-06-14 23:00:00	ES	Futures	3329.14	3338.08	3329.14	3335.01	6891.0
2020-06-14 18:00:00	NQ	Futures	11020.02	11073.22	10979.53	11064.26	6527.0
2020-06-14 19:00:00	NQ	Futures	11064.55	11068.89	11000.06	11034.76	4325.0
2020-06-14 20:00:00	NQ	Futures	11034.19	11066.28	11020.88	11022.62	3259.0
2020-06-14 21:00:00	NQ	Futures	11021.46	11084.5	11021.17	11075.54	2774.0
2020-06-14 22:00:00	NQ	Futures	11074.38	11087.68	11037.37	11039.39	1837.0
2020-06-14 23:00:00	NQ	Futures	11037.08	11070.62	11034.76	11060.5	1013.0
2020-06-14 18:00:00	YM	Futures	27574.7	27714.6	27463.5	27693.7	5607.0
2020-06-14 19:00:00	YM	Futures	27694.8	27713.5	27526.3	27603.4	4068.0
2020-06-14 20:00:00	YM	Futures	27605.6	27651.8	27531.8	27536.2	3388.0
2020-06-14 21:00:00	YM	Futures	27537.3	27634.2	27514.2	27619.9	3980.0
2020-06-14 22:00:00	YM	Futures	27617.7	27636.4	27535.1	27537.3	2708.0
2020-06-14 23:00:00	YM	Futures	27537.3	27605.6	27536.2	27570.3	1515.0
2020-06-14 18:00:00	CL	Futures	25.44	25.52	24.99	25.23	3630.0
2020-06-14 19:00:00	CL	Futures	25.24	25.29	25.07	25.15	1370.0
2020-06-14 20:00:00	CL	Futures	25.15	25.15	24.84	24.88	2852.0
2020-06-14 21:00:00	CL	Futures	24.88	24.9	24.69	24.74	3140.0
2020-06-14 22:00:00	CL	Futures	24.76	24.9	24.6	24.79	2115.0
2020-06-14 23:00:00	CL	Futures	24.79	25.04	24.78	24.9	1568.0
2020-06-14 18:00:00	GC	Futures	2148.9	2152.8	2142.9	2145.9	2988.0
2020-06-14 19:00:00	GC	Futures	2145.9	2149.7	2145.0	2149.2	1513.0
2020-06-14 20:00:00	GC	Futures	2149.1	2150.8	2147.3	2148.3	3005.0
2020-06-14 21:00:00	GC	Futures	2148.5	2150.1	2145.1	2148.0	4375.0
2020-06-14 22:00:00	GC	Futures	2148.1	2149.2	2138.6	2141.5	5764.0
2020-06-14 23:00:00	GC	Futures	2141.4	2142.5	2139.6	2141.9	2213.0
2020-06-14 18:00:00	ZN	Futures	138.462082	138.477666	138.368579	138.415331	11616.0
2020-06-14 19:00:00	ZN	Futures	138.415331	138.571169	138.415331	138.540001	15782.0
2020-06-14 20:00:00	ZN	Futures	138.540001	138.664672	138.540001	138.633504	27573.0
2020-06-14 21:00:00	ZN	Futures	138.633504	138.664672	138.571169	138.586753	15258.0
2020-06-14 22:00:00	ZN	Futures	138.586753	138.602336	138.555585	138.602336	15642.0
2020-06-14 23:00:00	ZN	Futures	138.602336	138.633504	138.571169	138.602336	7476.0

> showing 36 of 352 rows — these rows as CSV

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