PREVIEW / futures_1hour / 2023-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-05.parquet
  size:    58 KB
  rows:    1,670

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
2023-05-05 00:00:00	ES	Futures	4540.27	4540.27	4538.61	4540.0	2640.0
2023-05-05 01:00:00	ES	Futures	4539.72	4540.27	4536.11	4537.78	3253.0
2023-05-05 02:00:00	ES	Futures	4537.78	4541.94	4534.73	4541.66	7677.0
2023-05-05 03:00:00	ES	Futures	4541.38	4543.6	4533.9	4537.78	17392.0
2023-05-05 04:00:00	ES	Futures	4537.5	4544.71	4532.51	4543.05	16144.0
2023-05-05 05:00:00	ES	Futures	4543.33	4545.54	4539.72	4544.44	12569.0
2023-05-05 06:00:00	ES	Futures	4544.71	4552.48	4544.16	4549.43	15623.0
2023-05-05 07:00:00	ES	Futures	4549.43	4556.92	4547.76	4554.14	23500.0
2023-05-05 08:00:00	ES	Futures	4554.42	4563.02	4541.11	4553.87	93066.0
2023-05-05 09:00:00	ES	Futures	4553.59	4580.49	4553.31	4578.0	237616.0
2023-05-05 10:00:00	ES	Futures	4578.0	4594.91	4577.16	4588.81	219401.0
2023-05-05 11:00:00	ES	Futures	4588.53	4593.25	4584.1	4587.98	127402.0
2023-05-05 12:00:00	ES	Futures	4588.26	4589.37	4578.83	4589.09	105061.0
2023-05-05 13:00:00	ES	Futures	4589.09	4599.35	4588.81	4597.69	100740.0
2023-05-05 14:00:00	ES	Futures	4597.96	4618.77	4597.13	4613.77	159713.0
2023-05-05 15:00:00	ES	Futures	4613.77	4616.27	4601.29	4606.01	232088.0
2023-05-05 16:00:00	ES	Futures	4605.73	4607.39	4600.46	4602.96	71809.0
2023-05-05 00:00:00	NQ	Futures	14765.77	14766.33	14757.04	14762.67	1091.0
2023-05-05 01:00:00	NQ	Futures	14761.82	14764.92	14749.72	14753.38	1724.0
2023-05-05 02:00:00	NQ	Futures	14753.38	14762.95	14741.55	14762.67	3169.0
2023-05-05 03:00:00	NQ	Futures	14761.26	14767.17	14726.63	14750.56	6504.0
2023-05-05 04:00:00	NQ	Futures	14750.0	14768.02	14736.48	14761.54	5749.0
2023-05-05 05:00:00	NQ	Futures	14761.54	14781.81	14756.48	14779.28	5282.0
2023-05-05 06:00:00	NQ	Futures	14779.56	14793.64	14773.93	14779.84	5891.0
2023-05-05 07:00:00	NQ	Futures	14780.13	14799.27	14776.18	14791.95	7250.0
2023-05-05 08:00:00	NQ	Futures	14792.23	14818.14	14736.77	14769.15	29483.0
2023-05-05 09:00:00	NQ	Futures	14768.86	14858.12	14766.89	14855.58	89144.0
2023-05-05 10:00:00	NQ	Futures	14855.58	14953.56	14855.58	14932.16	102069.0
2023-05-05 11:00:00	NQ	Futures	14932.16	14949.06	14912.74	14930.76	50763.0
2023-05-05 12:00:00	NQ	Futures	14930.76	14946.8	14909.92	14945.12	38544.0
2023-05-05 13:00:00	NQ	Futures	14945.4	14985.1	14942.58	14984.53	46771.0
2023-05-05 14:00:00	NQ	Futures	14984.53	15045.07	14973.83	15032.4	61975.0
2023-05-05 15:00:00	NQ	Futures	15032.68	15038.59	14991.57	15005.65	71150.0
2023-05-05 16:00:00	NQ	Futures	15005.09	15011.56	14987.35	14990.45	16920.0
2023-05-05 00:00:00	YM	Futures	36780.2	36782.5	36769.2	36779.1	550.0
2023-05-05 01:00:00	YM	Futures	36778.0	36782.5	36752.6	36763.7	993.0
2023-05-05 02:00:00	YM	Futures	36763.7	36802.3	36750.4	36799.0	1962.0
2023-05-05 03:00:00	YM	Futures	36797.9	36835.5	36755.9	36781.3	4127.0
2023-05-05 04:00:00	YM	Futures	36782.5	36826.7	36732.7	36815.6	3334.0
2023-05-05 05:00:00	YM	Futures	36816.7	36825.6	36784.7	36813.4	2469.0
2023-05-05 06:00:00	YM	Futures	36814.5	36875.3	36811.2	36862.0	3260.0
2023-05-05 07:00:00	YM	Futures	36863.1	36912.9	36848.8	36886.4	3494.0
2023-05-05 08:00:00	YM	Futures	36886.4	36965.9	36826.7	36908.5	11585.0
2023-05-05 09:00:00	YM	Futures	36908.5	37216.8	36902.9	37153.8	30576.0
2023-05-05 10:00:00	YM	Futures	37154.9	37230.1	37135.0	37170.4	20079.0
2023-05-05 11:00:00	YM	Futures	37170.4	37219.0	37103.0	37138.4	13099.0
2023-05-05 12:00:00	YM	Futures	37139.5	37163.8	37064.3	37143.9	9699.0
2023-05-05 13:00:00	YM	Futures	37146.1	37208.0	37136.2	37195.8	7936.0
2023-05-05 14:00:00	YM	Futures	37196.9	37383.7	37196.9	37349.5	12942.0
2023-05-05 15:00:00	YM	Futures	37350.6	37369.4	37267.7	37299.7	15494.0

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

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