PREVIEW / futures_1hour / 2022-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-16.parquet
  size:    57 KB
  rows:    1,644

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-09-16 00:00:00	ES	Futures	4387.39	4389.37	4385.42	4389.08	5095.0
2022-09-16 01:00:00	ES	Futures	4389.08	4391.34	4385.42	4385.42	6840.0
2022-09-16 02:00:00	ES	Futures	4385.7	4391.34	4379.5	4381.75	19824.0
2022-09-16 03:00:00	ES	Futures	4381.75	4388.24	4377.53	4382.88	26584.0
2022-09-16 04:00:00	ES	Futures	4382.88	4383.73	4372.73	4376.4	26351.0
2022-09-16 05:00:00	ES	Futures	4376.68	4381.75	4373.86	4376.4	23019.0
2022-09-16 06:00:00	ES	Futures	4376.4	4390.77	4373.58	4389.65	18833.0
2022-09-16 07:00:00	ES	Futures	4389.37	4389.37	4379.5	4383.16	23864.0
2022-09-16 08:00:00	ES	Futures	4383.45	4384.01	4357.23	4358.07	69250.0
2022-09-16 09:00:00	ES	Futures	4358.07	4374.14	4345.11	4349.9	381281.0
2022-09-16 10:00:00	ES	Futures	4350.18	4388.24	4349.34	4361.46	439929.0
2022-09-16 11:00:00	ES	Futures	4361.46	4374.14	4353.28	4369.63	268468.0
2022-09-16 12:00:00	ES	Futures	4369.35	4370.76	4344.54	4360.61	213494.0
2022-09-16 13:00:00	ES	Futures	4360.33	4364.56	4348.49	4352.16	170672.0
2022-09-16 14:00:00	ES	Futures	4352.44	4380.34	4351.03	4375.83	251207.0
2022-09-16 15:00:00	ES	Futures	4376.12	4391.9	4367.94	4384.85	489815.0
2022-09-16 16:00:00	ES	Futures	4384.57	4401.49	4382.6	4400.36	90907.0
2022-09-16 00:00:00	NQ	Futures	13679.87	13685.04	13670.1	13681.88	2892.0
2022-09-16 01:00:00	NQ	Futures	13681.88	13689.93	13668.09	13669.53	3596.0
2022-09-16 02:00:00	NQ	Futures	13669.24	13687.92	13648.84	13657.17	8121.0
2022-09-16 03:00:00	NQ	Futures	13657.46	13679.59	13650.28	13668.95	10653.0
2022-09-16 04:00:00	NQ	Futures	13669.53	13675.85	13619.82	13637.92	10792.0
2022-09-16 05:00:00	NQ	Futures	13637.92	13656.89	13629.3	13635.91	8267.0
2022-09-16 06:00:00	NQ	Futures	13636.77	13697.69	13625.86	13693.09	9344.0
2022-09-16 07:00:00	NQ	Futures	13692.23	13692.52	13649.7	13669.53	10952.0
2022-09-16 08:00:00	NQ	Futures	13670.1	13672.4	13600.57	13604.88	23447.0
2022-09-16 09:00:00	NQ	Futures	13605.17	13643.67	13541.09	13555.17	112390.0
2022-09-16 10:00:00	NQ	Futures	13554.6	13695.68	13547.99	13580.75	132498.0
2022-09-16 11:00:00	NQ	Futures	13581.03	13638.79	13554.89	13631.03	78019.0
2022-09-16 12:00:00	NQ	Futures	13631.03	13636.2	13537.07	13610.91	63164.0
2022-09-16 13:00:00	NQ	Futures	13610.05	13621.83	13564.94	13579.31	50508.0
2022-09-16 14:00:00	NQ	Futures	13579.31	13681.88	13573.85	13664.36	64437.0
2022-09-16 15:00:00	NQ	Futures	13664.93	13732.45	13642.23	13708.03	100165.0
2022-09-16 16:00:00	NQ	Futures	13708.03	13747.11	13704.01	13746.53	20437.0
2022-09-16 00:00:00	YM	Futures	34661.3	34669.2	34645.6	34666.9	626.0
2022-09-16 01:00:00	YM	Futures	34669.2	34682.6	34645.6	34647.8	926.0
2022-09-16 02:00:00	YM	Futures	34645.6	34692.7	34609.7	34628.8	2078.0
2022-09-16 03:00:00	YM	Futures	34626.5	34672.5	34581.6	34615.3	3494.0
2022-09-16 04:00:00	YM	Futures	34616.4	34619.8	34545.7	34571.5	2834.0
2022-09-16 05:00:00	YM	Futures	34573.8	34608.6	34552.5	34576.0	2506.0
2022-09-16 06:00:00	YM	Futures	34574.9	34664.7	34553.6	34654.6	2311.0
2022-09-16 07:00:00	YM	Futures	34653.5	34655.7	34590.6	34615.3	2528.0
2022-09-16 08:00:00	YM	Futures	34619.8	34620.9	34389.7	34409.9	6924.0
2022-09-16 09:00:00	YM	Futures	34407.7	34533.4	34380.8	34439.1	34319.0
2022-09-16 10:00:00	YM	Futures	34429.0	34690.5	34429.0	34498.6	34452.0
2022-09-16 11:00:00	YM	Futures	34502.0	34590.6	34441.4	34559.2	15129.0
2022-09-16 12:00:00	YM	Futures	34559.2	34567.0	34395.3	34507.6	11087.0
2022-09-16 13:00:00	YM	Futures	34505.3	34549.1	34431.3	34466.0	9660.0
2022-09-16 14:00:00	YM	Futures	34466.0	34665.8	34457.1	34635.5	12937.0
2022-09-16 15:00:00	YM	Futures	34634.4	34755.6	34573.8	34689.4	25482.0

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

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