PREVIEW / futures_1hour / 2020-12-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-15.parquet
  size:    60 KB
  rows:    1,886

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-12-15 00:00:00	ES	Futures	4086.78	4094.36	4082.29	4092.12	7594.0
2020-12-15 01:00:00	ES	Futures	4092.4	4095.2	4090.43	4092.96	3806.0
2020-12-15 02:00:00	ES	Futures	4092.96	4098.57	4092.4	4094.92	6792.0
2020-12-15 03:00:00	ES	Futures	4094.92	4110.64	4092.68	4109.8	17857.0
2020-12-15 04:00:00	ES	Futures	4110.08	4114.57	4109.8	4111.48	11845.0
2020-12-15 05:00:00	ES	Futures	4111.76	4112.32	4109.24	4109.8	9778.0
2020-12-15 06:00:00	ES	Futures	4109.8	4112.32	4107.55	4108.68	5967.0
2020-12-15 07:00:00	ES	Futures	4108.96	4118.5	4108.68	4113.17	16746.0
2020-12-15 08:00:00	ES	Futures	4113.45	4117.66	4112.04	4115.97	20072.0
2020-12-15 09:00:00	ES	Futures	4115.97	4121.31	4109.52	4110.92	155413.0
2020-12-15 10:00:00	ES	Futures	4111.2	4114.85	4102.22	4109.8	176194.0
2020-12-15 11:00:00	ES	Futures	4109.8	4114.57	4100.26	4113.45	184546.0
2020-12-15 12:00:00	ES	Futures	4113.45	4129.16	4112.6	4128.6	104240.0
2020-12-15 13:00:00	ES	Futures	4128.6	4137.58	4127.2	4136.18	115520.0
2020-12-15 14:00:00	ES	Futures	4136.18	4140.67	4134.22	4136.46	98105.0
2020-12-15 15:00:00	ES	Futures	4136.46	4140.67	4129.44	4140.11	190055.0
2020-12-15 16:00:00	ES	Futures	4140.11	4140.95	4135.62	4138.99	47338.0
2020-12-15 18:00:00	ES	Futures	4142.36	4142.36	4136.18	4138.71	6030.0
2020-12-15 19:00:00	ES	Futures	4138.43	4139.55	4131.41	4134.5	7106.0
2020-12-15 20:00:00	ES	Futures	4134.5	4135.9	4132.53	4134.5	4875.0
2020-12-15 21:00:00	ES	Futures	4134.5	4140.39	4134.22	4139.83	4905.0
2020-12-15 22:00:00	ES	Futures	4139.83	4142.07	4137.02	4137.3	4589.0
2020-12-15 23:00:00	ES	Futures	4137.02	4138.15	4134.22	4137.58	2793.0
2020-12-15 00:00:00	NQ	Futures	14405.12	14439.85	14397.88	14433.48	2160.0
2020-12-15 01:00:00	NQ	Futures	14434.06	14443.32	14420.17	14437.82	1811.0
2020-12-15 02:00:00	NQ	Futures	14436.95	14463.58	14431.74	14453.74	3154.0
2020-12-15 03:00:00	NQ	Futures	14453.16	14490.21	14447.95	14487.61	4127.0
2020-12-15 04:00:00	NQ	Futures	14488.18	14505.84	14486.45	14496.29	3255.0
2020-12-15 05:00:00	NQ	Futures	14496.87	14498.31	14484.71	14489.92	1806.0
2020-12-15 06:00:00	NQ	Futures	14489.63	14494.84	14478.05	14484.13	2087.0
2020-12-15 07:00:00	NQ	Futures	14484.42	14523.78	14484.42	14521.18	4156.0
2020-12-15 08:00:00	NQ	Futures	14521.47	14543.18	14517.42	14541.15	5890.0
2020-12-15 09:00:00	NQ	Futures	14541.15	14570.09	14520.31	14548.1	59486.0
2020-12-15 10:00:00	NQ	Futures	14548.1	14562.86	14499.18	14505.26	56435.0
2020-12-15 11:00:00	NQ	Futures	14505.26	14505.26	14439.27	14476.03	56468.0
2020-12-15 12:00:00	NQ	Futures	14475.45	14516.84	14473.13	14513.08	25790.0
2020-12-15 13:00:00	NQ	Futures	14512.79	14540.57	14508.44	14536.81	22135.0
2020-12-15 14:00:00	NQ	Futures	14536.52	14562.28	14521.76	14561.41	23552.0
2020-12-15 15:00:00	NQ	Futures	14561.41	14586.3	14554.18	14584.57	40147.0
2020-12-15 16:00:00	NQ	Futures	14584.86	14597.59	14577.91	14585.14	9189.0
2020-12-15 18:00:00	NQ	Futures	14592.09	14598.46	14576.46	14582.54	2310.0
2020-12-15 19:00:00	NQ	Futures	14582.25	14585.72	14564.6	14580.22	3400.0
2020-12-15 20:00:00	NQ	Futures	14579.65	14581.09	14570.96	14577.04	1589.0
2020-12-15 21:00:00	NQ	Futures	14576.75	14612.64	14575.59	14610.33	3063.0
2020-12-15 22:00:00	NQ	Futures	14611.19	14617.85	14598.75	14600.2	2489.0
2020-12-15 23:00:00	NQ	Futures	14599.04	14602.8	14595.28	14600.48	1282.0
2020-12-15 00:00:00	YM	Futures	33039.6	33097.3	32999.7	33079.5	1559.0
2020-12-15 01:00:00	YM	Futures	33080.6	33101.7	33064.0	33080.6	971.0
2020-12-15 02:00:00	YM	Futures	33079.5	33115.0	33076.2	33090.6	1677.0
2020-12-15 03:00:00	YM	Futures	33091.7	33229.3	33070.7	33218.2	3792.0

> showing 50 of 1,886 rows — these rows as CSV

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