PREVIEW / futures_1hour / 2020-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-09.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-08-09 18:00:00	ES	Futures	3738.51	3738.51	3725.11	3728.18	17720.0
2020-08-09 19:00:00	ES	Futures	3728.46	3733.77	3727.62	3732.65	5364.0
2020-08-09 20:00:00	ES	Futures	3732.93	3737.12	3731.53	3733.77	9403.0
2020-08-09 21:00:00	ES	Futures	3733.49	3737.4	3730.69	3734.6	11629.0
2020-08-09 22:00:00	ES	Futures	3734.6	3741.3	3733.49	3740.75	9173.0
2020-08-09 23:00:00	ES	Futures	3740.75	3742.42	3739.35	3741.3	4867.0
2020-08-09 18:00:00	NQ	Futures	12886.08	12904.88	12808.3	12819.86	6506.0
2020-08-09 19:00:00	NQ	Futures	12820.44	12855.43	12820.44	12848.49	2821.0
2020-08-09 20:00:00	NQ	Futures	12847.62	12862.08	12840.11	12847.62	3444.0
2020-08-09 21:00:00	NQ	Futures	12846.76	12849.94	12827.09	12829.98	5184.0
2020-08-09 22:00:00	NQ	Futures	12830.56	12854.85	12822.75	12852.54	3309.0
2020-08-09 23:00:00	NQ	Futures	12852.25	12859.19	12846.18	12853.99	1837.0
2020-08-09 18:00:00	YM	Futures	30131.6	30134.9	30017.1	30038.0	3192.0
2020-08-09 19:00:00	YM	Futures	30039.1	30083.1	30033.6	30076.5	2607.0
2020-08-09 20:00:00	YM	Futures	30077.6	30109.6	30053.4	30071.0	2841.0
2020-08-09 21:00:00	YM	Futures	30069.9	30123.9	30054.5	30101.9	2091.0
2020-08-09 22:00:00	YM	Futures	30103.0	30167.9	30095.3	30161.3	2926.0
2020-08-09 23:00:00	YM	Futures	30162.4	30184.4	30152.5	30176.7	939.0
2020-08-09 18:00:00	CL	Futures	28.94	29.08	28.71	28.96	3307.0
2020-08-09 19:00:00	CL	Futures	28.97	29.03	28.97	29.02	849.0
2020-08-09 20:00:00	CL	Futures	29.03	29.2	29.0	29.09	4043.0
2020-08-09 21:00:00	CL	Futures	29.08	29.11	28.96	29.06	4369.0
2020-08-09 22:00:00	CL	Futures	29.06	29.12	29.05	29.08	2356.0
2020-08-09 23:00:00	CL	Futures	29.08	29.17	29.08	29.13	1258.0
2020-08-09 18:00:00	GC	Futures	2486.8	2490.1	2467.2	2475.9	7953.0
2020-08-09 19:00:00	GC	Futures	2476.2	2482.6	2476.0	2477.6	3805.0
2020-08-09 20:00:00	GC	Futures	2477.6	2485.2	2475.7	2483.9	4812.0
2020-08-09 21:00:00	GC	Futures	2483.8	2486.2	2478.3	2480.9	8023.0
2020-08-09 22:00:00	GC	Futures	2480.7	2483.0	2476.4	2477.6	5528.0
2020-08-09 23:00:00	GC	Futures	2477.4	2481.9	2476.8	2480.2	3192.0
2020-08-09 18:00:00	ZN	Futures	139.568532	139.615284	139.568532	139.615284	11143.0
2020-08-09 19:00:00	ZN	Futures	139.5997	139.630867	139.5997	139.630867	2401.0
2020-08-09 20:00:00	ZN	Futures	139.630867	139.630867	139.568532	139.5997	8093.0
2020-08-09 21:00:00	ZN	Futures	139.615284	139.615284	139.568532	139.5997	2247.0
2020-08-09 22:00:00	ZN	Futures	139.5997	139.5997	139.552948	139.568532	3412.0
2020-08-09 23:00:00	ZN	Futures	139.568532	139.568532	139.537364	139.552948	1410.0

> showing 36 of 351 rows — these rows as CSV

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