PREVIEW / futures_1hour / 2021-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-04.parquet
  size:    63 KB
  rows:    1,966

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
2021-02-04 00:00:00	ES	Futures	4284.09	4287.18	4278.76	4286.06	12268.0
2021-02-04 01:00:00	ES	Futures	4286.34	4293.63	4281.85	4292.79	9158.0
2021-02-04 02:00:00	ES	Futures	4292.79	4295.88	4286.62	4289.42	8910.0
2021-02-04 03:00:00	ES	Futures	4289.42	4302.62	4288.58	4300.09	17239.0
2021-02-04 04:00:00	ES	Futures	4300.09	4300.65	4295.32	4295.88	7124.0
2021-02-04 05:00:00	ES	Futures	4295.88	4300.65	4293.63	4299.53	5659.0
2021-02-04 06:00:00	ES	Futures	4299.53	4300.65	4289.99	4289.99	10638.0
2021-02-04 07:00:00	ES	Futures	4290.27	4300.65	4289.99	4300.65	16635.0
2021-02-04 08:00:00	ES	Futures	4300.65	4304.86	4297.84	4301.77	28557.0
2021-02-04 09:00:00	ES	Futures	4301.77	4313.56	4299.25	4313.56	169662.0
2021-02-04 10:00:00	ES	Futures	4313.28	4319.18	4309.35	4317.21	191531.0
2021-02-04 11:00:00	ES	Futures	4317.21	4323.1	4316.09	4320.86	113950.0
2021-02-04 12:00:00	ES	Futures	4321.14	4326.19	4320.58	4323.1	74086.0
2021-02-04 13:00:00	ES	Futures	4323.1	4329.84	4322.26	4328.16	65564.0
2021-02-04 14:00:00	ES	Futures	4327.88	4330.96	4326.75	4329.56	60647.0
2021-02-04 15:00:00	ES	Futures	4329.56	4339.94	4325.35	4339.38	197215.0
2021-02-04 16:00:00	ES	Futures	4339.38	4344.43	4337.14	4340.79	59656.0
2021-02-04 18:00:00	ES	Futures	4338.26	4341.91	4336.3	4339.94	8660.0
2021-02-04 19:00:00	ES	Futures	4340.22	4341.91	4334.61	4336.58	8879.0
2021-02-04 20:00:00	ES	Futures	4336.3	4343.31	4333.49	4342.19	11757.0
2021-02-04 21:00:00	ES	Futures	4342.47	4348.93	4342.19	4345.56	12457.0
2021-02-04 22:00:00	ES	Futures	4345.56	4346.68	4340.51	4343.87	6352.0
2021-02-04 23:00:00	ES	Futures	4343.59	4347.24	4343.31	4345.56	5990.0
2021-02-04 00:00:00	NQ	Futures	15470.81	15496.28	15450.26	15492.23	5473.0
2021-02-04 01:00:00	NQ	Futures	15493.1	15543.75	15476.02	15542.01	5292.0
2021-02-04 02:00:00	NQ	Futures	15542.3	15573.85	15523.78	15533.33	6631.0
2021-02-04 03:00:00	NQ	Futures	15533.62	15579.93	15529.86	15565.46	9073.0
2021-02-04 04:00:00	NQ	Futures	15565.17	15568.93	15554.46	15560.54	3162.0
2021-02-04 05:00:00	NQ	Futures	15559.96	15575.3	15549.83	15569.51	3014.0
2021-02-04 06:00:00	NQ	Futures	15569.8	15573.27	15535.36	15542.01	4719.0
2021-02-04 07:00:00	NQ	Futures	15542.59	15576.17	15541.43	15569.8	7411.0
2021-02-04 08:00:00	NQ	Futures	15569.22	15587.16	15562.56	15572.98	8991.0
2021-02-04 09:00:00	NQ	Futures	15572.98	15606.56	15527.83	15557.06	78154.0
2021-02-04 10:00:00	NQ	Futures	15556.2	15574.72	15504.1	15553.59	75763.0
2021-02-04 11:00:00	NQ	Futures	15553.3	15588.03	15539.12	15578.77	43386.0
2021-02-04 12:00:00	NQ	Futures	15578.77	15612.06	15577.61	15605.69	28114.0
2021-02-04 13:00:00	NQ	Futures	15605.4	15634.63	15601.06	15623.92	24100.0
2021-02-04 14:00:00	NQ	Futures	15623.63	15641.87	15615.24	15636.66	20095.0
2021-02-04 15:00:00	NQ	Futures	15636.66	15690.2	15629.42	15687.89	38995.0
2021-02-04 16:00:00	NQ	Futures	15687.89	15709.02	15673.99	15702.65	16320.0
2021-02-04 18:00:00	NQ	Futures	15698.89	15705.25	15676.31	15690.78	4281.0
2021-02-04 19:00:00	NQ	Futures	15691.36	15693.1	15670.52	15676.89	2690.0
2021-02-04 20:00:00	NQ	Futures	15676.6	15707.57	15662.13	15704.67	4958.0
2021-02-04 21:00:00	NQ	Futures	15706.12	15737.67	15704.67	15717.7	6082.0
2021-02-04 22:00:00	NQ	Futures	15717.99	15725.51	15701.2	15710.75	3257.0
2021-02-04 23:00:00	NQ	Futures	15710.46	15732.46	15710.17	15723.49	3176.0
2021-02-04 00:00:00	YM	Futures	33912.5	33925.8	33878.1	33917.0	1877.0
2021-02-04 01:00:00	YM	Futures	33919.2	33960.2	33888.1	33954.7	1990.0
2021-02-04 02:00:00	YM	Futures	33955.8	33962.4	33901.4	33917.0	2084.0
2021-02-04 03:00:00	YM	Futures	33920.3	34023.5	33914.8	34005.7	4199.0

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

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