PREVIEW / futures_1hour / 2020-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-23.parquet
  size:    60 KB
  rows:    1,827

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-07-23 00:00:00	ES	Futures	3648.32	3651.11	3645.8	3649.43	3568.0
2020-07-23 01:00:00	ES	Futures	3649.15	3651.11	3647.2	3649.15	3621.0
2020-07-23 02:00:00	ES	Futures	3649.43	3668.7	3649.15	3663.95	23677.0
2020-07-23 03:00:00	ES	Futures	3663.95	3666.47	3656.97	3665.35	24650.0
2020-07-23 04:00:00	ES	Futures	3665.35	3668.7	3658.37	3658.37	23551.0
2020-07-23 05:00:00	ES	Futures	3658.37	3663.4	3657.81	3661.16	14410.0
2020-07-23 06:00:00	ES	Futures	3661.44	3665.91	3658.37	3659.77	16315.0
2020-07-23 07:00:00	ES	Futures	3659.77	3662.56	3653.9	3658.93	16191.0
2020-07-23 08:00:00	ES	Futures	3658.93	3659.21	3643.85	3643.85	38887.0
2020-07-23 09:00:00	ES	Futures	3644.13	3654.46	3642.17	3651.95	136173.0
2020-07-23 10:00:00	ES	Futures	3651.67	3653.06	3635.19	3643.85	183065.0
2020-07-23 11:00:00	ES	Futures	3643.85	3653.62	3638.82	3648.04	146306.0
2020-07-23 12:00:00	ES	Futures	3648.04	3648.32	3629.33	3632.68	160662.0
2020-07-23 13:00:00	ES	Futures	3632.4	3639.66	3607.27	3613.41	193993.0
2020-07-23 14:00:00	ES	Futures	3613.41	3613.97	3590.23	3606.43	306643.0
2020-07-23 15:00:00	ES	Futures	3606.43	3609.78	3592.47	3606.43	280394.0
2020-07-23 16:00:00	ES	Futures	3606.71	3607.83	3596.38	3607.27	59585.0
2020-07-23 18:00:00	ES	Futures	3607.83	3615.37	3607.27	3614.53	8748.0
2020-07-23 19:00:00	ES	Futures	3614.81	3614.81	3608.38	3612.01	9341.0
2020-07-23 20:00:00	ES	Futures	3611.74	3617.88	3610.06	3617.32	13486.0
2020-07-23 21:00:00	ES	Futures	3617.32	3617.6	3607.83	3612.29	10012.0
2020-07-23 22:00:00	ES	Futures	3612.01	3612.29	3605.87	3609.22	7059.0
2020-07-23 23:00:00	ES	Futures	3609.22	3609.22	3588.84	3593.03	16944.0
2020-07-23 00:00:00	NQ	Futures	12532.13	12542.83	12522.88	12535.89	2149.0
2020-07-23 01:00:00	NQ	Futures	12535.6	12544.28	12525.77	12536.47	2293.0
2020-07-23 02:00:00	NQ	Futures	12538.2	12652.72	12535.02	12623.8	12289.0
2020-07-23 03:00:00	NQ	Futures	12624.38	12631.03	12598.64	12626.98	6161.0
2020-07-23 04:00:00	NQ	Futures	12626.69	12633.05	12593.15	12596.62	6840.0
2020-07-23 05:00:00	NQ	Futures	12596.33	12619.17	12588.52	12602.69	5229.0
2020-07-23 06:00:00	NQ	Futures	12602.98	12618.59	12593.15	12600.95	4115.0
2020-07-23 07:00:00	NQ	Futures	12600.95	12609.92	12569.43	12583.31	6409.0
2020-07-23 08:00:00	NQ	Futures	12583.6	12585.92	12540.52	12544.28	12629.0
2020-07-23 09:00:00	NQ	Futures	12543.7	12575.51	12491.36	12543.41	59246.0
2020-07-23 10:00:00	NQ	Futures	12542.83	12556.71	12458.1	12506.39	77157.0
2020-07-23 11:00:00	NQ	Futures	12506.1	12526.06	12476.03	12484.13	47983.0
2020-07-23 12:00:00	NQ	Futures	12484.13	12484.7	12319.29	12363.83	82574.0
2020-07-23 13:00:00	NQ	Futures	12363.83	12397.95	12229.36	12266.38	78899.0
2020-07-23 14:00:00	NQ	Futures	12266.09	12269.27	12162.27	12242.08	107991.0
2020-07-23 15:00:00	NQ	Futures	12242.95	12254.23	12182.51	12228.78	83331.0
2020-07-23 16:00:00	NQ	Futures	12228.49	12242.66	12175.57	12220.68	15754.0
2020-07-23 18:00:00	NQ	Futures	12221.26	12252.78	12220.68	12249.02	4140.0
2020-07-23 19:00:00	NQ	Futures	12249.6	12252.49	12230.23	12240.06	3796.0
2020-07-23 20:00:00	NQ	Futures	12240.06	12256.83	12231.1	12255.96	3886.0
2020-07-23 21:00:00	NQ	Futures	12255.68	12257.7	12200.44	12225.89	5472.0
2020-07-23 22:00:00	NQ	Futures	12225.31	12225.6	12194.08	12206.52	3814.0
2020-07-23 23:00:00	NQ	Futures	12206.23	12212.3	12087.95	12112.24	13442.0
2020-07-23 00:00:00	YM	Futures	29597.5	29618.5	29574.4	29603.0	1153.0
2020-07-23 01:00:00	YM	Futures	29604.1	29621.8	29583.2	29596.4	1096.0
2020-07-23 02:00:00	YM	Futures	29601.9	29745.1	29597.5	29713.2	5408.0
2020-07-23 03:00:00	YM	Futures	29714.3	29749.5	29663.6	29742.9	5231.0

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

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