PREVIEW / futures_1hour / 2020-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-17.parquet
  size:    17 KB
  rows:    353

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-17 18:00:00	ES	Futures	3139.03	3153.02	3128.32	3147.53	24432.0
2020-05-17 19:00:00	ES	Futures	3147.53	3154.39	3146.43	3148.36	13140.0
2020-05-17 20:00:00	ES	Futures	3148.36	3152.75	3145.06	3148.9	12616.0
2020-05-17 21:00:00	ES	Futures	3149.18	3155.22	3147.53	3151.92	13174.0
2020-05-17 22:00:00	ES	Futures	3151.65	3164.27	3151.1	3161.8	15821.0
2020-05-17 23:00:00	ES	Futures	3161.53	3166.74	3159.88	3160.43	7387.0
2020-05-17 18:00:00	NQ	Futures	10437.31	10475.01	10409.03	10464.16	5732.0
2020-05-17 19:00:00	NQ	Futures	10464.16	10487.58	10460.16	10471.59	4535.0
2020-05-17 20:00:00	NQ	Futures	10473.01	10485.58	10460.73	10472.16	4341.0
2020-05-17 21:00:00	NQ	Futures	10473.01	10499.01	10468.16	10481.58	5199.0
2020-05-17 22:00:00	NQ	Futures	10481.87	10518.43	10479.87	10509.86	4952.0
2020-05-17 23:00:00	NQ	Futures	10510.43	10527.57	10505.01	10507.29	3138.0
2020-05-17 18:00:00	YM	Futures	25849.5	25998.5	25781.6	25957.9	4864.0
2020-05-17 19:00:00	YM	Futures	25960.1	26010.5	25947.0	25970.0	3006.0
2020-05-17 20:00:00	YM	Futures	25968.9	25998.5	25937.1	25971.1	2756.0
2020-05-17 21:00:00	YM	Futures	25972.2	26028.0	25961.2	25991.9	2683.0
2020-05-17 22:00:00	YM	Futures	25993.0	26088.3	25987.5	26066.4	2768.0
2020-05-17 23:00:00	YM	Futures	26067.5	26110.2	26055.4	26058.7	1709.0
2020-05-17 18:00:00	CL	Futures	20.74	21.23	20.56	21.14	8322.0
2020-05-17 19:00:00	CL	Futures	21.14	21.26	21.07	21.21	4220.0
2020-05-17 20:00:00	CL	Futures	21.21	21.51	21.16	21.4	8441.0
2020-05-17 21:00:00	CL	Futures	21.41	21.48	21.29	21.37	6508.0
2020-05-17 22:00:00	CL	Futures	21.37	21.45	21.3	21.38	4093.0
2020-05-17 23:00:00	CL	Futures	21.38	21.43	21.13	21.18	4222.0
2020-05-17 18:00:00	GC	Futures	2192.9	2200.9	2190.1	2192.9	6429.0
2020-05-17 19:00:00	GC	Futures	2192.9	2206.4	2192.7	2204.2	6171.0
2020-05-17 20:00:00	GC	Futures	2204.0	2205.4	2200.4	2202.2	3868.0
2020-05-17 21:00:00	GC	Futures	2202.3	2208.9	2200.5	2208.4	9070.0
2020-05-17 22:00:00	GC	Futures	2208.5	2214.8	2206.9	2211.3	8106.0
2020-05-17 23:00:00	GC	Futures	2211.3	2211.9	2208.9	2209.9	2847.0
2020-05-17 18:00:00	ZN	Futures	138.549881	138.58095	138.47221	138.487745	7008.0
2020-05-17 19:00:00	ZN	Futures	138.487745	138.518813	138.456676	138.518813	4685.0
2020-05-17 20:00:00	ZN	Futures	138.518813	138.534347	138.47221	138.47221	6517.0
2020-05-17 21:00:00	ZN	Futures	138.47221	138.518813	138.456676	138.487745	7375.0
2020-05-17 22:00:00	ZN	Futures	138.487745	138.503279	138.441142	138.47221	3624.0
2020-05-17 23:00:00	ZN	Futures	138.487745	138.518813	138.487745	138.518813	3214.0

> showing 36 of 353 rows — these rows as CSV

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