PREVIEW / futures_1hour / 2022-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-17.parquet
  size:    69 KB
  rows:    2,064

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
2022-05-17 00:00:00	ES	Futures	4554.03	4559.99	4554.03	4557.72	5293.0
2022-05-17 01:00:00	ES	Futures	4557.72	4567.64	4556.02	4563.67	6659.0
2022-05-17 02:00:00	ES	Futures	4563.95	4567.64	4559.99	4567.64	9340.0
2022-05-17 03:00:00	ES	Futures	4567.92	4582.66	4561.97	4578.41	23736.0
2022-05-17 04:00:00	ES	Futures	4578.41	4615.26	4578.13	4606.19	38885.0
2022-05-17 05:00:00	ES	Futures	4605.9	4624.04	4604.49	4622.06	23937.0
2022-05-17 06:00:00	ES	Futures	4621.78	4630.0	4614.69	4614.69	22338.0
2022-05-17 07:00:00	ES	Futures	4614.97	4621.21	4607.04	4607.89	31427.0
2022-05-17 08:00:00	ES	Futures	4607.89	4612.71	4597.68	4610.44	50712.0
2022-05-17 09:00:00	ES	Futures	4610.15	4616.96	4589.18	4598.53	190214.0
2022-05-17 10:00:00	ES	Futures	4598.25	4609.3	4568.77	4582.38	214747.0
2022-05-17 11:00:00	ES	Futures	4582.38	4608.17	4580.68	4601.37	145546.0
2022-05-17 12:00:00	ES	Futures	4601.37	4618.09	4591.73	4610.44	119489.0
2022-05-17 13:00:00	ES	Futures	4610.44	4620.64	4601.37	4611.01	101122.0
2022-05-17 14:00:00	ES	Futures	4611.01	4627.44	4579.26	4619.51	282558.0
2022-05-17 15:00:00	ES	Futures	4619.51	4636.8	4615.26	4632.83	287621.0
2022-05-17 16:00:00	ES	Futures	4632.83	4638.78	4628.3	4637.65	63442.0
2022-05-17 18:00:00	ES	Futures	4638.5	4642.75	4637.08	4637.37	7027.0
2022-05-17 19:00:00	ES	Futures	4637.65	4638.22	4630.85	4631.98	5791.0
2022-05-17 20:00:00	ES	Futures	4631.98	4635.95	4628.86	4630.28	8390.0
2022-05-17 21:00:00	ES	Futures	4630.28	4631.7	4618.37	4623.76	8924.0
2022-05-17 22:00:00	ES	Futures	4623.76	4629.15	4620.93	4625.74	6048.0
2022-05-17 23:00:00	ES	Futures	4626.03	4628.3	4610.44	4617.52	8692.0
2022-05-17 00:00:00	NQ	Futures	14279.53	14300.99	14276.92	14294.32	2842.0
2022-05-17 01:00:00	NQ	Futures	14294.03	14323.32	14284.46	14316.65	4049.0
2022-05-17 02:00:00	NQ	Futures	14316.94	14328.83	14299.83	14328.83	4342.0
2022-05-17 03:00:00	NQ	Futures	14329.12	14384.5	14296.93	14367.39	11260.0
2022-05-17 04:00:00	NQ	Futures	14368.26	14531.52	14366.81	14494.98	23732.0
2022-05-17 05:00:00	NQ	Futures	14494.4	14543.99	14483.67	14535.87	10676.0
2022-05-17 06:00:00	NQ	Futures	14536.74	14549.79	14480.77	14482.8	12789.0
2022-05-17 07:00:00	NQ	Futures	14482.8	14509.77	14461.64	14472.07	13547.0
2022-05-17 08:00:00	NQ	Futures	14472.07	14492.66	14425.68	14470.62	19822.0
2022-05-17 09:00:00	NQ	Futures	14471.2	14540.22	14419.88	14435.83	82778.0
2022-05-17 10:00:00	NQ	Futures	14434.67	14493.24	14299.83	14341.3	90992.0
2022-05-17 11:00:00	NQ	Futures	14341.3	14487.44	14329.41	14457.58	64231.0
2022-05-17 12:00:00	NQ	Futures	14457.0	14499.62	14416.4	14458.74	44465.0
2022-05-17 13:00:00	NQ	Futures	14459.61	14509.77	14423.65	14480.48	39210.0
2022-05-17 14:00:00	NQ	Futures	14480.19	14551.82	14350.58	14517.31	104138.0
2022-05-17 15:00:00	NQ	Futures	14517.89	14589.22	14511.22	14572.12	79177.0
2022-05-17 16:00:00	NQ	Futures	14572.12	14588.06	14553.56	14584.29	13302.0
2022-05-17 18:00:00	NQ	Futures	14582.27	14607.78	14577.63	14580.53	3447.0
2022-05-17 19:00:00	NQ	Futures	14580.82	14587.77	14559.65	14571.83	3734.0
2022-05-17 20:00:00	NQ	Futures	14570.96	14583.71	14546.31	14555.01	4023.0
2022-05-17 21:00:00	NQ	Futures	14553.85	14559.07	14506.29	14526.01	5323.0
2022-05-17 22:00:00	NQ	Futures	14526.59	14552.11	14512.67	14538.77	4200.0
2022-05-17 23:00:00	NQ	Futures	14537.61	14545.15	14467.43	14500.2	5107.0
2022-05-17 00:00:00	YM	Futures	36331.6	36358.7	36328.2	36346.3	703.0
2022-05-17 01:00:00	YM	Futures	36347.4	36399.3	36333.9	36384.6	1309.0
2022-05-17 02:00:00	YM	Futures	36385.7	36412.8	36362.1	36412.8	1478.0
2022-05-17 03:00:00	YM	Futures	36413.9	36517.6	36376.7	36489.4	3152.0

> showing 50 of 2,064 rows — these rows as CSV

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