PREVIEW / futures_1hour / 2023-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-03.parquet
  size:    68 KB
  rows:    2,018

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-03 00:00:00	ES	Futures	4321.6	4332.5	4321.6	4329.99	8797.0
2023-01-03 01:00:00	ES	Futures	4329.99	4333.06	4324.12	4328.87	7627.0
2023-01-03 02:00:00	ES	Futures	4328.59	4341.73	4323.56	4341.45	16333.0
2023-01-03 03:00:00	ES	Futures	4341.17	4358.51	4336.7	4356.55	38627.0
2023-01-03 04:00:00	ES	Futures	4356.55	4368.85	4355.71	4368.57	36167.0
2023-01-03 05:00:00	ES	Futures	4368.57	4369.41	4354.31	4358.79	20919.0
2023-01-03 06:00:00	ES	Futures	4358.79	4360.18	4330.83	4336.14	34711.0
2023-01-03 07:00:00	ES	Futures	4335.86	4341.45	4328.59	4339.49	37686.0
2023-01-03 08:00:00	ES	Futures	4339.21	4346.76	4329.15	4343.97	78303.0
2023-01-03 09:00:00	ES	Futures	4344.25	4363.54	4309.58	4310.41	255025.0
2023-01-03 10:00:00	ES	Futures	4310.41	4319.92	4291.68	4314.05	219438.0
2023-01-03 11:00:00	ES	Futures	4314.05	4317.13	4275.74	4280.5	197657.0
2023-01-03 12:00:00	ES	Futures	4280.78	4291.12	4266.24	4275.18	133635.0
2023-01-03 13:00:00	ES	Futures	4275.46	4290.84	4272.39	4289.16	108007.0
2023-01-03 14:00:00	ES	Futures	4289.16	4299.51	4269.31	4291.4	157891.0
2023-01-03 15:00:00	ES	Futures	4291.68	4305.1	4288.88	4300.07	220722.0
2023-01-03 16:00:00	ES	Futures	4300.07	4300.91	4292.52	4298.39	44342.0
2023-01-03 18:00:00	ES	Futures	4297.83	4300.63	4293.92	4300.35	5534.0
2023-01-03 19:00:00	ES	Futures	4300.35	4304.26	4298.11	4299.79	9418.0
2023-01-03 20:00:00	ES	Futures	4300.07	4310.14	4299.23	4308.46	9775.0
2023-01-03 21:00:00	ES	Futures	4308.18	4310.14	4300.63	4300.91	8217.0
2023-01-03 22:00:00	ES	Futures	4300.91	4306.78	4300.35	4304.26	7903.0
2023-01-03 23:00:00	ES	Futures	4304.54	4309.58	4303.7	4309.3	5759.0
2023-01-03 00:00:00	NQ	Futures	12543.06	12583.74	12542.49	12575.21	4233.0
2023-01-03 01:00:00	NQ	Futures	12574.35	12591.71	12556.71	12575.78	5055.0
2023-01-03 02:00:00	NQ	Futures	12575.78	12617.88	12556.43	12616.17	7253.0
2023-01-03 03:00:00	NQ	Futures	12615.89	12669.09	12590.85	12661.98	16764.0
2023-01-03 04:00:00	NQ	Futures	12662.55	12708.07	12658.28	12708.07	15563.0
2023-01-03 05:00:00	NQ	Futures	12708.07	12712.33	12656.86	12680.47	9572.0
2023-01-03 06:00:00	NQ	Futures	12681.04	12687.3	12580.33	12606.79	12021.0
2023-01-03 07:00:00	NQ	Futures	12606.22	12640.64	12577.48	12628.41	12193.0
2023-01-03 08:00:00	NQ	Futures	12628.12	12662.55	12588.01	12650.31	24455.0
2023-01-03 09:00:00	NQ	Futures	12650.88	12724.85	12507.78	12510.63	102704.0
2023-01-03 10:00:00	NQ	Futures	12511.2	12537.08	12419.02	12488.72	82774.0
2023-01-03 11:00:00	NQ	Futures	12489.29	12501.81	12356.72	12372.93	73305.0
2023-01-03 12:00:00	NQ	Futures	12374.07	12412.76	12341.07	12370.94	50883.0
2023-01-03 13:00:00	NQ	Futures	12371.51	12426.42	12349.32	12420.73	48709.0
2023-01-03 14:00:00	NQ	Futures	12421.01	12475.92	12370.66	12447.18	63737.0
2023-01-03 15:00:00	NQ	Futures	12447.18	12487.01	12435.24	12452.59	71170.0
2023-01-03 16:00:00	NQ	Futures	12452.31	12457.71	12428.69	12450.6	11778.0
2023-01-03 18:00:00	NQ	Futures	12450.88	12461.12	12426.99	12460.27	3004.0
2023-01-03 19:00:00	NQ	Futures	12460.27	12475.92	12456.0	12461.41	3556.0
2023-01-03 20:00:00	NQ	Futures	12461.12	12500.95	12459.13	12492.13	4489.0
2023-01-03 21:00:00	NQ	Futures	12493.27	12499.25	12469.09	12469.66	2980.0
2023-01-03 22:00:00	NQ	Futures	12470.51	12489.29	12464.25	12478.19	3474.0
2023-01-03 23:00:00	NQ	Futures	12479.05	12500.1	12475.92	12498.96	2623.0
2023-01-03 00:00:00	YM	Futures	37124.5	37205.9	37124.5	37181.4	1256.0
2023-01-03 01:00:00	YM	Futures	37180.2	37192.5	37127.9	37159.1	1038.0
2023-01-03 02:00:00	YM	Futures	37159.1	37249.3	37123.4	37244.9	2217.0
2023-01-03 03:00:00	YM	Futures	37246.0	37402.0	37230.4	37379.7	6103.0

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

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