PREVIEW / futures_1hour / 2023-01-11

all futures 1-hour files

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

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-11 00:00:00	ES	Futures	4409.4	4413.59	4407.72	4409.67	3715.0
2023-01-11 01:00:00	ES	Futures	4409.67	4411.63	4406.32	4406.6	4095.0
2023-01-11 02:00:00	ES	Futures	4406.32	4406.32	4400.45	4401.57	9758.0
2023-01-11 03:00:00	ES	Futures	4401.57	4408.84	4401.29	4406.04	15428.0
2023-01-11 04:00:00	ES	Futures	4406.04	4419.18	4403.8	4415.55	20622.0
2023-01-11 05:00:00	ES	Futures	4415.55	4423.1	4412.47	4414.99	16679.0
2023-01-11 06:00:00	ES	Futures	4414.99	4421.14	4412.19	4417.22	12813.0
2023-01-11 07:00:00	ES	Futures	4416.94	4418.62	4409.12	4416.94	20750.0
2023-01-11 08:00:00	ES	Futures	4416.67	4426.45	4416.39	4425.61	31789.0
2023-01-11 09:00:00	ES	Futures	4425.33	4436.52	4420.58	4426.73	183796.0
2023-01-11 10:00:00	ES	Futures	4427.01	4435.4	4416.39	4418.34	213866.0
2023-01-11 11:00:00	ES	Futures	4418.62	4435.12	4417.5	4432.04	128031.0
2023-01-11 12:00:00	ES	Futures	4432.04	4441.83	4431.76	4436.8	113398.0
2023-01-11 13:00:00	ES	Futures	4436.8	4449.1	4433.72	4442.11	142731.0
2023-01-11 14:00:00	ES	Futures	4442.11	4452.18	4436.52	4449.1	102627.0
2023-01-11 15:00:00	ES	Futures	4449.38	4463.36	4446.3	4462.24	224890.0
2023-01-11 16:00:00	ES	Futures	4461.96	4465.32	4460.84	4465.04	59057.0
2023-01-11 18:00:00	ES	Futures	4464.48	4465.04	4459.72	4460.56	6928.0
2023-01-11 19:00:00	ES	Futures	4460.56	4461.68	4457.21	4460.56	7489.0
2023-01-11 20:00:00	ES	Futures	4460.84	4463.64	4460.28	4462.24	6884.0
2023-01-11 21:00:00	ES	Futures	4462.24	4463.08	4460.28	4461.12	4424.0
2023-01-11 22:00:00	ES	Futures	4461.12	4462.24	4460.28	4461.68	4016.0
2023-01-11 23:00:00	ES	Futures	4461.68	4467.55	4461.68	4466.99	4157.0
2023-01-11 00:00:00	NQ	Futures	12832.39	12849.46	12827.55	12834.38	1735.0
2023-01-11 01:00:00	NQ	Futures	12834.95	12841.21	12820.72	12821.58	2240.0
2023-01-11 02:00:00	NQ	Futures	12821.01	12821.58	12790.57	12802.52	7476.0
2023-01-11 03:00:00	NQ	Futures	12802.52	12824.71	12795.4	12820.72	8014.0
2023-01-11 04:00:00	NQ	Futures	12821.29	12877.62	12814.75	12863.68	9913.0
2023-01-11 05:00:00	NQ	Futures	12863.68	12886.73	12845.48	12850.6	6545.0
2023-01-11 06:00:00	NQ	Futures	12850.6	12880.47	12841.49	12858.56	6723.0
2023-01-11 07:00:00	NQ	Futures	12858.28	12866.81	12831.25	12856.57	8613.0
2023-01-11 08:00:00	NQ	Futures	12857.14	12891.85	12854.86	12886.16	15285.0
2023-01-11 09:00:00	NQ	Futures	12886.44	12931.11	12848.89	12900.95	80663.0
2023-01-11 10:00:00	NQ	Futures	12901.52	12960.13	12874.21	12883.6	76393.0
2023-01-11 11:00:00	NQ	Futures	12883.88	12955.29	12879.9	12946.47	47756.0
2023-01-11 12:00:00	NQ	Futures	12946.76	12994.27	12945.33	12974.64	50164.0
2023-01-11 13:00:00	NQ	Futures	12974.92	13020.72	12957.28	12983.74	45043.0
2023-01-11 14:00:00	NQ	Futures	12983.74	13010.48	12966.95	12997.11	29515.0
2023-01-11 15:00:00	NQ	Futures	12997.4	13063.4	12995.12	13059.98	68217.0
2023-01-11 16:00:00	NQ	Futures	13058.85	13061.41	13044.91	13058.28	14291.0
2023-01-11 18:00:00	NQ	Futures	13057.71	13062.83	13048.04	13057.71	4298.0
2023-01-11 19:00:00	NQ	Futures	13058.28	13061.12	13044.62	13053.16	3850.0
2023-01-11 20:00:00	NQ	Futures	13053.16	13059.98	13043.2	13052.87	2983.0
2023-01-11 21:00:00	NQ	Futures	13052.59	13057.14	13043.48	13046.61	2223.0
2023-01-11 22:00:00	NQ	Futures	13046.61	13055.15	13045.48	13052.02	1993.0
2023-01-11 23:00:00	NQ	Futures	13052.59	13078.48	13051.73	13072.22	2982.0
2023-01-11 00:00:00	YM	Futures	37748.5	37776.3	37735.1	37749.6	940.0
2023-01-11 01:00:00	YM	Futures	37749.6	37763.0	37726.2	37727.3	780.0
2023-01-11 02:00:00	YM	Futures	37726.2	37726.2	37688.3	37698.3	1627.0
2023-01-11 03:00:00	YM	Futures	37697.2	37742.9	37695.0	37724.0	1940.0

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

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