PREVIEW / futures_1hour / 2023-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-18.parquet
  size:    71 KB
  rows:    2,094

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-18 00:00:00	ES	Futures	4489.92	4490.48	4486.57	4489.08	3623.0
2023-01-18 01:00:00	ES	Futures	4488.8	4494.12	4488.24	4493.28	6000.0
2023-01-18 02:00:00	ES	Futures	4493.56	4495.79	4488.24	4492.16	10749.0
2023-01-18 03:00:00	ES	Futures	4492.16	4496.63	4482.37	4490.2	18024.0
2023-01-18 04:00:00	ES	Futures	4490.2	4491.32	4484.05	4487.69	12490.0
2023-01-18 05:00:00	ES	Futures	4487.69	4491.88	4483.77	4488.8	9949.0
2023-01-18 06:00:00	ES	Futures	4489.08	4492.72	4487.41	4491.32	10195.0
2023-01-18 07:00:00	ES	Futures	4491.32	4500.27	4491.04	4499.43	16045.0
2023-01-18 08:00:00	ES	Futures	4499.43	4510.33	4485.45	4500.27	85365.0
2023-01-18 09:00:00	ES	Futures	4500.55	4506.14	4491.32	4504.18	209221.0
2023-01-18 10:00:00	ES	Futures	4504.18	4511.17	4469.79	4478.18	298451.0
2023-01-18 11:00:00	ES	Futures	4478.18	4480.42	4444.07	4451.34	271120.0
2023-01-18 12:00:00	ES	Futures	4451.34	4453.85	4432.88	4434.56	175742.0
2023-01-18 13:00:00	ES	Futures	4434.56	4442.11	4425.05	4436.8	159593.0
2023-01-18 14:00:00	ES	Futures	4437.08	4440.43	4430.65	4431.76	99358.0
2023-01-18 15:00:00	ES	Futures	4431.76	4436.8	4410.79	4414.15	305523.0
2023-01-18 16:00:00	ES	Futures	4414.15	4414.71	4411.91	4413.03	60807.0
2023-01-18 18:00:00	ES	Futures	4412.47	4416.39	4410.23	4413.87	7375.0
2023-01-18 19:00:00	ES	Futures	4414.15	4414.43	4405.48	4406.32	12935.0
2023-01-18 20:00:00	ES	Futures	4406.32	4409.4	4405.48	4406.04	7649.0
2023-01-18 21:00:00	ES	Futures	4406.04	4409.4	4403.52	4409.4	9549.0
2023-01-18 22:00:00	ES	Futures	4409.4	4412.47	4406.6	4406.88	9385.0
2023-01-18 23:00:00	ES	Futures	4406.88	4411.63	4406.6	4408.0	6471.0
2023-01-18 00:00:00	NQ	Futures	13251.73	13254.01	13237.79	13246.61	2110.0
2023-01-18 01:00:00	NQ	Futures	13245.76	13267.95	13244.34	13262.83	2725.0
2023-01-18 02:00:00	NQ	Futures	13262.83	13271.65	13241.49	13255.43	4669.0
2023-01-18 03:00:00	NQ	Futures	13255.72	13271.08	13216.46	13240.07	8705.0
2023-01-18 04:00:00	NQ	Futures	13240.64	13248.04	13223.0	13235.23	5590.0
2023-01-18 05:00:00	NQ	Futures	13235.23	13252.59	13216.46	13243.77	5206.0
2023-01-18 06:00:00	NQ	Futures	13244.34	13257.42	13238.08	13252.02	4541.0
2023-01-18 07:00:00	NQ	Futures	13250.88	13284.73	13249.46	13281.61	7215.0
2023-01-18 08:00:00	NQ	Futures	13280.75	13339.07	13241.78	13303.8	36671.0
2023-01-18 09:00:00	NQ	Futures	13303.51	13344.76	13282.74	13336.23	88730.0
2023-01-18 10:00:00	NQ	Futures	13336.51	13382.03	13184.02	13219.87	110878.0
2023-01-18 11:00:00	NQ	Futures	13219.59	13228.97	13107.78	13144.19	87218.0
2023-01-18 12:00:00	NQ	Futures	13144.48	13155.01	13092.99	13102.09	48319.0
2023-01-18 13:00:00	NQ	Futures	13102.09	13129.4	13067.1	13114.89	48627.0
2023-01-18 14:00:00	NQ	Futures	13115.18	13138.22	13090.71	13114.32	34437.0
2023-01-18 15:00:00	NQ	Futures	13114.32	13133.1	13053.16	13063.4	65731.0
2023-01-18 16:00:00	NQ	Futures	13063.4	13070.23	13050.31	13066.24	13142.0
2023-01-18 18:00:00	NQ	Futures	13053.16	13071.93	13048.6	13063.4	3026.0
2023-01-18 19:00:00	NQ	Futures	13063.68	13064.25	13029.54	13032.67	5163.0
2023-01-18 20:00:00	NQ	Futures	13033.24	13048.6	13027.55	13036.09	3376.0
2023-01-18 21:00:00	NQ	Futures	13035.52	13044.91	13025.85	13042.06	2575.0
2023-01-18 22:00:00	NQ	Futures	13041.78	13058.85	13040.35	13042.91	4239.0
2023-01-18 23:00:00	NQ	Futures	13042.91	13059.7	13042.35	13050.88	2644.0
2023-01-18 00:00:00	YM	Futures	37918.9	37920.1	37896.7	37914.5	585.0
2023-01-18 01:00:00	YM	Futures	37913.4	37946.8	37910.0	37941.2	1185.0
2023-01-18 02:00:00	YM	Futures	37942.3	37959.1	37905.6	37931.2	1946.0
2023-01-18 03:00:00	YM	Futures	37933.4	37973.5	37884.4	37936.8	2672.0

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

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