PREVIEW / futures_1hour / 2022-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-10.parquet
  size:    68 KB
  rows:    2,039

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-08-10 00:00:00	ES	Futures	4670.3	4673.41	4670.3	4672.28	1699.0
2022-08-10 01:00:00	ES	Futures	4672.28	4672.56	4666.61	4666.9	3226.0
2022-08-10 02:00:00	ES	Futures	4666.61	4669.45	4662.93	4668.31	8342.0
2022-08-10 03:00:00	ES	Futures	4668.03	4679.08	4661.23	4675.4	14826.0
2022-08-10 04:00:00	ES	Futures	4675.4	4691.26	4674.26	4688.14	14652.0
2022-08-10 05:00:00	ES	Futures	4688.43	4690.41	4682.48	4685.31	8131.0
2022-08-10 06:00:00	ES	Futures	4685.59	4686.73	4680.49	4683.61	8885.0
2022-08-10 07:00:00	ES	Futures	4683.33	4688.71	4681.91	4688.43	13213.0
2022-08-10 08:00:00	ES	Futures	4688.43	4760.66	4686.73	4749.9	162814.0
2022-08-10 09:00:00	ES	Futures	4749.9	4758.96	4739.98	4751.6	249576.0
2022-08-10 10:00:00	ES	Futures	4751.6	4758.96	4734.6	4758.11	224030.0
2022-08-10 11:00:00	ES	Futures	4758.39	4772.56	4758.11	4767.46	184810.0
2022-08-10 12:00:00	ES	Futures	4767.74	4770.01	4753.01	4761.51	115809.0
2022-08-10 13:00:00	ES	Futures	4761.51	4770.01	4756.98	4765.48	113090.0
2022-08-10 14:00:00	ES	Futures	4765.76	4768.03	4754.43	4755.0	95811.0
2022-08-10 15:00:00	ES	Futures	4755.0	4773.69	4753.3	4770.86	234109.0
2022-08-10 16:00:00	ES	Futures	4770.86	4774.26	4767.46	4771.42	63320.0
2022-08-10 18:00:00	ES	Futures	4771.14	4771.42	4766.61	4768.03	3899.0
2022-08-10 19:00:00	ES	Futures	4767.74	4775.11	4767.46	4773.12	5737.0
2022-08-10 20:00:00	ES	Futures	4773.12	4785.31	4772.84	4783.61	11255.0
2022-08-10 21:00:00	ES	Futures	4783.61	4787.0	4780.49	4781.91	7040.0
2022-08-10 22:00:00	ES	Futures	4781.91	4784.74	4779.36	4780.77	3770.0
2022-08-10 23:00:00	ES	Futures	4780.77	4785.87	4780.77	4784.17	5018.0
2022-08-10 00:00:00	NQ	Futures	15055.18	15070.8	15054.89	15065.88	1422.0
2022-08-10 01:00:00	NQ	Futures	15066.75	15068.78	15040.43	15040.72	2575.0
2022-08-10 02:00:00	NQ	Futures	15040.43	15048.24	15021.92	15042.74	5175.0
2022-08-10 03:00:00	NQ	Futures	15043.03	15089.6	15019.61	15072.83	8086.0
2022-08-10 04:00:00	NQ	Futures	15073.4	15149.76	15067.91	15142.24	9722.0
2022-08-10 05:00:00	NQ	Futures	15143.4	15159.89	15115.05	15124.89	5685.0
2022-08-10 06:00:00	NQ	Futures	15124.89	15126.05	15095.1	15107.24	5126.0
2022-08-10 07:00:00	NQ	Futures	15107.24	15141.95	15100.3	15141.37	6834.0
2022-08-10 08:00:00	NQ	Futures	15141.66	15474.29	15134.72	15419.33	65376.0
2022-08-10 09:00:00	NQ	Futures	15419.62	15451.15	15351.07	15408.63	101436.0
2022-08-10 10:00:00	NQ	Futures	15409.21	15435.24	15315.5	15422.52	86821.0
2022-08-10 11:00:00	NQ	Futures	15423.09	15483.26	15422.8	15478.34	71989.0
2022-08-10 12:00:00	NQ	Futures	15478.05	15490.2	15406.61	15435.53	48949.0
2022-08-10 13:00:00	NQ	Futures	15435.82	15494.83	15410.37	15469.66	45198.0
2022-08-10 14:00:00	NQ	Futures	15469.95	15481.23	15430.61	15432.93	33656.0
2022-08-10 15:00:00	NQ	Futures	15432.93	15512.47	15425.12	15495.69	67171.0
2022-08-10 16:00:00	NQ	Futures	15495.98	15499.16	15475.74	15481.23	13874.0
2022-08-10 18:00:00	NQ	Futures	15480.65	15482.1	15468.5	15476.02	1825.0
2022-08-10 19:00:00	NQ	Futures	15476.02	15506.97	15475.45	15502.35	3732.0
2022-08-10 20:00:00	NQ	Futures	15502.06	15565.11	15501.19	15559.9	7752.0
2022-08-10 21:00:00	NQ	Futures	15559.9	15570.03	15547.47	15552.96	3887.0
2022-08-10 22:00:00	NQ	Futures	15553.25	15562.51	15535.9	15540.52	2813.0
2022-08-10 23:00:00	NQ	Futures	15541.39	15565.69	15540.52	15553.83	2790.0
2022-08-10 00:00:00	YM	Futures	36928.4	36942.0	36928.4	36935.2	293.0
2022-08-10 01:00:00	YM	Futures	36935.2	36938.6	36905.9	36907.0	702.0
2022-08-10 02:00:00	YM	Futures	36907.0	36928.4	36886.7	36918.3	1731.0
2022-08-10 03:00:00	YM	Futures	36918.3	36991.6	36872.0	36967.9	3681.0

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

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