PREVIEW / futures_1hour / 2020-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-21.parquet
  size:    60 KB
  rows:    1,891

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-01-21 00:00:00	ES	Futures	3589.5	3590.6	3587.9	3589.0	6785.0
2020-01-21 01:00:00	ES	Futures	3589.3	3590.9	3586.8	3588.2	9833.0
2020-01-21 02:00:00	ES	Futures	3587.9	3594.7	3587.1	3593.3	21858.0
2020-01-21 03:00:00	ES	Futures	3593.3	3593.6	3584.9	3590.6	42832.0
2020-01-21 04:00:00	ES	Futures	3590.9	3591.7	3586.8	3589.5	16722.0
2020-01-21 05:00:00	ES	Futures	3589.5	3590.6	3588.2	3590.3	14202.0
2020-01-21 06:00:00	ES	Futures	3590.6	3593.6	3589.5	3593.3	14662.0
2020-01-21 07:00:00	ES	Futures	3593.3	3595.2	3592.5	3593.3	14131.0
2020-01-21 08:00:00	ES	Futures	3593.3	3595.2	3592.0	3592.2	23920.0
2020-01-21 09:00:00	ES	Futures	3592.0	3602.5	3592.0	3598.8	194164.0
2020-01-21 10:00:00	ES	Futures	3598.8	3602.0	3595.8	3598.2	191737.0
2020-01-21 11:00:00	ES	Futures	3598.2	3608.2	3597.9	3607.2	132270.0
2020-01-21 12:00:00	ES	Futures	3607.4	3609.3	3606.1	3607.7	59845.0
2020-01-21 13:00:00	ES	Futures	3607.7	3608.5	3596.0	3596.9	161225.0
2020-01-21 14:00:00	ES	Futures	3596.6	3602.0	3594.7	3600.9	132561.0
2020-01-21 15:00:00	ES	Futures	3600.9	3605.0	3596.9	3600.1	189816.0
2020-01-21 16:00:00	ES	Futures	3600.4	3602.0	3597.7	3599.0	63881.0
2020-01-21 18:00:00	ES	Futures	3600.1	3601.2	3597.9	3599.3	8984.0
2020-01-21 19:00:00	ES	Futures	3599.3	3603.9	3599.0	3602.5	14901.0
2020-01-21 20:00:00	ES	Futures	3602.5	3606.1	3602.3	3603.4	19649.0
2020-01-21 21:00:00	ES	Futures	3603.1	3616.6	3603.1	3614.5	35332.0
2020-01-21 22:00:00	ES	Futures	3614.7	3616.1	3612.3	3614.2	15039.0
2020-01-21 23:00:00	ES	Futures	3614.2	3615.0	3613.7	3614.5	3982.0
2020-01-21 00:00:00	NQ	Futures	10558.87	10563.79	10554.82	10557.72	3804.0
2020-01-21 01:00:00	NQ	Futures	10558.01	10562.92	10546.15	10551.64	5169.0
2020-01-21 02:00:00	NQ	Futures	10551.35	10575.93	10547.6	10569.57	9564.0
2020-01-21 03:00:00	NQ	Futures	10569.86	10570.15	10542.97	10562.92	15807.0
2020-01-21 04:00:00	NQ	Futures	10563.21	10565.52	10549.62	10557.72	7735.0
2020-01-21 05:00:00	NQ	Futures	10558.29	10562.05	10553.67	10561.76	6160.0
2020-01-21 06:00:00	NQ	Futures	10562.34	10571.02	10557.14	10570.73	6734.0
2020-01-21 07:00:00	NQ	Futures	10570.44	10575.93	10568.7	10573.33	6502.0
2020-01-21 08:00:00	NQ	Futures	10573.04	10580.85	10569.86	10574.2	10336.0
2020-01-21 09:00:00	NQ	Futures	10574.2	10614.39	10573.91	10607.16	68839.0
2020-01-21 10:00:00	NQ	Futures	10606.59	10621.62	10596.75	10604.85	61881.0
2020-01-21 11:00:00	NQ	Futures	10604.85	10641.29	10602.54	10632.61	46501.0
2020-01-21 12:00:00	NQ	Futures	10632.9	10636.66	10627.7	10631.46	19937.0
2020-01-21 13:00:00	NQ	Futures	10631.17	10636.08	10587.21	10592.42	50090.0
2020-01-21 14:00:00	NQ	Futures	10592.13	10611.5	10586.06	10608.9	42423.0
2020-01-21 15:00:00	NQ	Futures	10609.19	10632.32	10607.45	10618.15	47820.0
2020-01-21 16:00:00	NQ	Futures	10617.86	10631.74	10601.67	10612.37	15397.0
2020-01-21 18:00:00	NQ	Futures	10617.86	10623.65	10611.79	10616.13	5004.0
2020-01-21 19:00:00	NQ	Futures	10616.42	10630.59	10615.55	10627.12	8315.0
2020-01-21 20:00:00	NQ	Futures	10626.83	10636.95	10623.65	10627.41	8554.0
2020-01-21 21:00:00	NQ	Futures	10627.41	10680.33	10627.12	10672.23	16891.0
2020-01-21 22:00:00	NQ	Futures	10672.81	10682.64	10667.02	10671.65	8653.0
2020-01-21 23:00:00	NQ	Futures	10671.65	10677.14	10670.78	10674.54	3539.0
2020-01-21 00:00:00	YM	Futures	31769.5	31780.4	31761.9	31771.7	2074.0
2020-01-21 01:00:00	YM	Futures	31772.8	31793.5	31759.7	31766.2	2143.0
2020-01-21 02:00:00	YM	Futures	31765.1	31820.7	31756.4	31813.1	5762.0
2020-01-21 03:00:00	YM	Futures	31814.1	31815.2	31733.6	31783.7	10161.0

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

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