PREVIEW / futures_1hour / 2020-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-19.parquet
  size:    51 KB
  rows:    1,492

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-19 00:00:00	ES	Futures	3468.76	3470.44	3462.9	3464.3	5759.0
2020-06-19 01:00:00	ES	Futures	3464.57	3470.16	3463.18	3469.88	5863.0
2020-06-19 02:00:00	ES	Futures	3469.88	3489.99	3469.88	3480.21	31929.0
2020-06-19 03:00:00	ES	Futures	3480.21	3486.91	3474.35	3485.24	22881.0
2020-06-19 04:00:00	ES	Futures	3484.96	3485.24	3475.46	3484.12	24257.0
2020-06-19 05:00:00	ES	Futures	3484.12	3496.13	3481.61	3490.82	30227.0
2020-06-19 06:00:00	ES	Futures	3490.82	3497.53	3484.68	3489.43	26066.0
2020-06-19 07:00:00	ES	Futures	3489.15	3497.25	3485.8	3496.97	22342.0
2020-06-19 08:00:00	ES	Futures	3496.69	3504.51	3494.45	3502.55	66494.0
2020-06-19 09:00:00	ES	Futures	3502.55	3512.6	3491.66	3495.01	218101.0
2020-06-19 10:00:00	ES	Futures	3494.73	3499.48	3485.24	3487.47	178492.0
2020-06-19 11:00:00	ES	Futures	3487.19	3495.01	3479.37	3480.49	137837.0
2020-06-19 12:00:00	ES	Futures	3480.77	3481.61	3438.6	3466.53	274320.0
2020-06-19 13:00:00	ES	Futures	3466.25	3467.09	3438.33	3438.33	156537.0
2020-06-19 14:00:00	ES	Futures	3438.33	3457.59	3430.23	3455.08	202153.0
2020-06-19 15:00:00	ES	Futures	3455.36	3467.93	3444.75	3445.31	281991.0
2020-06-19 16:00:00	ES	Futures	3445.03	3446.42	3414.31	3415.43	127777.0
2020-06-19 00:00:00	NQ	Futures	11577.26	11589.99	11570.9	11574.66	3155.0
2020-06-19 01:00:00	NQ	Futures	11574.95	11594.9	11571.48	11594.9	3304.0
2020-06-19 02:00:00	NQ	Futures	11594.61	11656.21	11592.01	11630.47	9485.0
2020-06-19 03:00:00	NQ	Futures	11630.76	11649.56	11614.57	11643.48	6414.0
2020-06-19 04:00:00	NQ	Futures	11643.2	11643.48	11614.86	11634.23	6173.0
2020-06-19 05:00:00	NQ	Futures	11635.39	11653.03	11627.58	11637.12	6733.0
2020-06-19 06:00:00	NQ	Futures	11636.83	11654.76	11629.03	11645.22	5315.0
2020-06-19 07:00:00	NQ	Futures	11644.64	11658.52	11633.65	11657.94	5758.0
2020-06-19 08:00:00	NQ	Futures	11657.65	11678.76	11653.32	11673.27	19526.0
2020-06-19 09:00:00	NQ	Futures	11672.98	11697.27	11654.18	11667.78	61370.0
2020-06-19 10:00:00	NQ	Futures	11668.06	11692.36	11642.91	11655.92	47568.0
2020-06-19 11:00:00	NQ	Futures	11655.92	11678.76	11624.98	11627.29	42151.0
2020-06-19 12:00:00	NQ	Futures	11627.0	11630.76	11493.69	11589.99	75244.0
2020-06-19 13:00:00	NQ	Futures	11589.7	11592.01	11511.62	11512.49	50317.0
2020-06-19 14:00:00	NQ	Futures	11512.78	11559.04	11476.34	11547.77	60325.0
2020-06-19 15:00:00	NQ	Futures	11548.34	11591.14	11525.79	11556.15	61374.0
2020-06-19 16:00:00	NQ	Futures	11556.44	11558.47	11469.98	11480.39	23154.0
2020-06-19 00:00:00	YM	Futures	28598.8	28612.0	28523.9	28534.9	2870.0
2020-06-19 01:00:00	YM	Futures	28536.0	28588.9	28526.1	28582.3	1935.0
2020-06-19 02:00:00	YM	Futures	28583.4	28778.3	28582.3	28688.0	8621.0
2020-06-19 03:00:00	YM	Futures	28688.0	28757.4	28634.0	28739.8	8792.0
2020-06-19 04:00:00	YM	Futures	28738.7	28739.8	28657.2	28728.7	5093.0
2020-06-19 05:00:00	YM	Futures	28727.6	28847.7	28705.6	28799.2	8253.0
2020-06-19 06:00:00	YM	Futures	28800.3	28845.5	28745.3	28783.8	5555.0
2020-06-19 07:00:00	YM	Futures	28782.7	28846.6	28753.0	28844.4	4400.0
2020-06-19 08:00:00	YM	Futures	28844.4	28938.0	28837.8	28911.5	10225.0
2020-06-19 09:00:00	YM	Futures	28911.5	28982.0	28764.0	28791.5	28716.0
2020-06-19 10:00:00	YM	Futures	28793.7	28842.2	28704.5	28727.6	20167.0
2020-06-19 11:00:00	YM	Futures	28727.6	28797.0	28650.6	28691.3	16534.0
2020-06-19 12:00:00	YM	Futures	28691.3	28696.8	28299.3	28538.2	33010.0
2020-06-19 13:00:00	YM	Futures	28539.3	28543.8	28271.8	28274.0	17371.0
2020-06-19 14:00:00	YM	Futures	28275.1	28457.9	28217.8	28442.4	25970.0
2020-06-19 15:00:00	YM	Futures	28443.5	28553.7	28332.3	28336.7	27621.0

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

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