PREVIEW / futures_1hour / 2023-01-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-24.parquet
  size:    67 KB
  rows:    2,040

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-01-24 00:00:00	ES	Futures	4515.37	4520.12	4514.53	4515.09	4665.0
2023-01-24 01:00:00	ES	Futures	4514.81	4516.21	4511.45	4515.37	5034.0
2023-01-24 02:00:00	ES	Futures	4515.09	4516.21	4509.21	4511.73	7814.0
2023-01-24 03:00:00	ES	Futures	4511.73	4515.65	4507.54	4510.61	15000.0
2023-01-24 04:00:00	ES	Futures	4510.33	4512.85	4505.3	4506.98	15004.0
2023-01-24 05:00:00	ES	Futures	4506.98	4508.38	4501.67	4507.26	13274.0
2023-01-24 06:00:00	ES	Futures	4506.98	4506.98	4499.71	4503.62	16236.0
2023-01-24 07:00:00	ES	Futures	4503.34	4504.74	4499.15	4502.5	15906.0
2023-01-24 08:00:00	ES	Futures	4502.78	4504.18	4488.24	4492.16	40573.0
2023-01-24 09:00:00	ES	Futures	4491.88	4508.1	4483.77	4488.24	217733.0
2023-01-24 10:00:00	ES	Futures	4488.24	4515.09	4479.58	4512.29	293318.0
2023-01-24 11:00:00	ES	Futures	4512.29	4514.53	4503.06	4506.7	150161.0
2023-01-24 12:00:00	ES	Futures	4506.7	4512.57	4497.75	4506.7	111439.0
2023-01-24 13:00:00	ES	Futures	4506.98	4519.56	4499.99	4515.09	107441.0
2023-01-24 14:00:00	ES	Futures	4515.37	4517.88	4505.86	4516.21	101660.0
2023-01-24 15:00:00	ES	Futures	4516.21	4518.44	4498.31	4507.82	197418.0
2023-01-24 16:00:00	ES	Futures	4507.82	4526.83	4505.86	4517.04	97056.0
2023-01-24 18:00:00	ES	Futures	4517.32	4519.0	4489.92	4493.56	32476.0
2023-01-24 19:00:00	ES	Futures	4493.56	4496.35	4486.01	4490.48	12639.0
2023-01-24 20:00:00	ES	Futures	4490.2	4491.6	4485.17	4487.13	6932.0
2023-01-24 21:00:00	ES	Futures	4486.85	4493.56	4486.57	4490.48	6920.0
2023-01-24 22:00:00	ES	Futures	4490.76	4495.23	4488.52	4493.56	4971.0
2023-01-24 23:00:00	ES	Futures	4493.28	4494.95	4489.64	4490.48	3484.0
2023-01-24 00:00:00	NQ	Futures	13575.77	13592.84	13572.07	13577.19	2756.0
2023-01-24 01:00:00	NQ	Futures	13576.91	13582.03	13564.68	13576.91	2386.0
2023-01-24 02:00:00	NQ	Futures	13576.34	13583.45	13553.58	13565.81	4012.0
2023-01-24 03:00:00	NQ	Futures	13564.96	13579.19	13550.17	13567.81	6795.0
2023-01-24 04:00:00	NQ	Futures	13568.09	13569.8	13542.2	13546.47	7365.0
2023-01-24 05:00:00	NQ	Futures	13546.75	13551.31	13523.99	13542.2	6886.0
2023-01-24 06:00:00	NQ	Futures	13542.2	13542.77	13515.17	13521.72	6274.0
2023-01-24 07:00:00	NQ	Futures	13521.15	13532.81	13511.48	13520.01	5743.0
2023-01-24 08:00:00	NQ	Futures	13520.3	13527.98	13468.8	13483.31	20486.0
2023-01-24 09:00:00	NQ	Futures	13483.03	13600.52	13473.92	13523.99	90916.0
2023-01-24 10:00:00	NQ	Futures	13523.71	13590.57	13471.65	13578.05	94315.0
2023-01-24 11:00:00	NQ	Futures	13578.05	13586.3	13540.78	13562.12	46104.0
2023-01-24 12:00:00	NQ	Futures	13561.83	13583.74	13527.69	13541.92	39436.0
2023-01-24 13:00:00	NQ	Futures	13542.49	13585.16	13510.34	13567.24	35383.0
2023-01-24 14:00:00	NQ	Futures	13567.24	13568.66	13532.81	13562.4	30663.0
2023-01-24 15:00:00	NQ	Futures	13562.69	13568.94	13495.83	13548.75	54666.0
2023-01-24 16:00:00	NQ	Futures	13548.75	13667.66	13514.32	13621.86	37551.0
2023-01-24 18:00:00	NQ	Futures	13622.14	13628.97	13452.3	13473.35	21205.0
2023-01-24 19:00:00	NQ	Futures	13474.21	13483.03	13440.35	13454.01	7541.0
2023-01-24 20:00:00	NQ	Futures	13454.29	13458.28	13426.13	13434.38	5186.0
2023-01-24 21:00:00	NQ	Futures	13433.81	13459.41	13432.39	13448.89	3819.0
2023-01-24 22:00:00	NQ	Futures	13449.17	13461.12	13440.35	13457.71	2824.0
2023-01-24 23:00:00	NQ	Futures	13458.28	13466.53	13446.33	13450.03	2161.0
2023-01-24 00:00:00	YM	Futures	37589.2	37613.7	37582.5	37589.2	1051.0
2023-01-24 01:00:00	YM	Futures	37589.2	37593.6	37566.9	37582.5	879.0
2023-01-24 02:00:00	YM	Futures	37583.6	37584.7	37539.0	37556.8	1313.0
2023-01-24 03:00:00	YM	Futures	37556.8	37590.3	37523.4	37536.8	2555.0

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

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