PREVIEW / futures_1hour / 2023-01-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	4331.39	4333.34	4328.87	4330.83	5795.0
2023-01-05 01:00:00	ES	Futures	4330.83	4332.78	4321.04	4321.04	6737.0
2023-01-05 02:00:00	ES	Futures	4321.04	4325.51	4317.13	4319.64	9747.0
2023-01-05 03:00:00	ES	Futures	4319.64	4325.23	4312.93	4322.16	18402.0
2023-01-05 04:00:00	ES	Futures	4322.44	4330.55	4317.4	4330.27	13816.0
2023-01-05 05:00:00	ES	Futures	4330.27	4338.65	4328.31	4335.02	14252.0
2023-01-05 06:00:00	ES	Futures	4335.3	4342.85	4335.3	4338.1	13535.0
2023-01-05 07:00:00	ES	Futures	4338.1	4345.65	4332.22	4333.06	20897.0
2023-01-05 08:00:00	ES	Futures	4333.34	4339.21	4305.1	4309.3	73774.0
2023-01-05 09:00:00	ES	Futures	4309.02	4309.58	4276.3	4290.56	250772.0
2023-01-05 10:00:00	ES	Futures	4290.56	4309.86	4280.78	4281.89	273361.0
2023-01-05 11:00:00	ES	Futures	4282.17	4293.08	4275.18	4281.06	158477.0
2023-01-05 12:00:00	ES	Futures	4281.06	4294.76	4278.54	4282.17	112591.0
2023-01-05 13:00:00	ES	Futures	4282.45	4305.94	4277.98	4295.6	178562.0
2023-01-05 14:00:00	ES	Futures	4295.88	4308.74	4289.72	4298.39	115432.0
2023-01-05 15:00:00	ES	Futures	4298.39	4298.67	4276.58	4282.45	260220.0
2023-01-05 16:00:00	ES	Futures	4282.17	4287.77	4280.78	4286.65	49040.0
2023-01-05 18:00:00	ES	Futures	4286.93	4291.96	4285.25	4289.16	6098.0
2023-01-05 19:00:00	ES	Futures	4289.16	4294.48	4288.88	4293.64	7691.0
2023-01-05 20:00:00	ES	Futures	4293.92	4300.07	4292.8	4299.23	8778.0
2023-01-05 21:00:00	ES	Futures	4299.23	4300.91	4298.11	4299.79	7355.0
2023-01-05 22:00:00	ES	Futures	4299.79	4304.82	4299.23	4301.47	9528.0
2023-01-05 23:00:00	ES	Futures	4301.75	4304.82	4300.07	4303.14	5698.0
2023-01-05 00:00:00	NQ	Futures	12498.39	12506.36	12489.0	12497.82	2176.0
2023-01-05 01:00:00	NQ	Futures	12498.11	12509.77	12462.83	12462.83	3278.0
2023-01-05 02:00:00	NQ	Futures	12465.39	12483.03	12451.74	12463.12	5010.0
2023-01-05 03:00:00	NQ	Futures	12463.4	12490.43	12439.5	12474.78	9556.0
2023-01-05 04:00:00	NQ	Futures	12474.5	12500.1	12455.15	12499.53	8536.0
2023-01-05 05:00:00	NQ	Futures	12500.1	12536.52	12491.28	12521.15	8076.0
2023-01-05 06:00:00	NQ	Futures	12522.01	12563.54	12522.01	12545.62	7701.0
2023-01-05 07:00:00	NQ	Futures	12545.62	12570.94	12521.44	12526.56	10671.0
2023-01-05 08:00:00	NQ	Futures	12526.56	12545.05	12418.73	12436.94	32935.0
2023-01-05 09:00:00	NQ	Futures	12437.23	12438.08	12306.93	12367.24	106244.0
2023-01-05 10:00:00	NQ	Futures	12368.09	12434.95	12329.4	12337.65	116742.0
2023-01-05 11:00:00	NQ	Futures	12337.94	12386.87	12325.14	12351.03	68343.0
2023-01-05 12:00:00	NQ	Futures	12351.59	12386.87	12328.27	12330.54	54958.0
2023-01-05 13:00:00	NQ	Futures	12330.83	12419.3	12313.76	12373.22	80156.0
2023-01-05 14:00:00	NQ	Futures	12374.07	12418.17	12356.15	12379.19	54776.0
2023-01-05 15:00:00	NQ	Futures	12379.47	12379.76	12295.83	12312.9	84582.0
2023-01-05 16:00:00	NQ	Futures	12313.19	12335.66	12308.35	12332.53	12819.0
2023-01-05 18:00:00	NQ	Futures	12334.24	12344.77	12323.71	12334.81	2909.0
2023-01-05 19:00:00	NQ	Futures	12335.09	12350.46	12333.96	12348.46	2506.0
2023-01-05 20:00:00	NQ	Futures	12349.32	12367.53	12342.77	12362.97	3405.0
2023-01-05 21:00:00	NQ	Futures	12362.97	12368.09	12360.7	12364.68	1771.0
2023-01-05 22:00:00	NQ	Futures	12364.97	12387.72	12362.97	12369.23	3481.0
2023-01-05 23:00:00	NQ	Futures	12369.8	12379.47	12362.97	12374.92	1818.0
2023-01-05 00:00:00	YM	Futures	37201.4	37215.9	37184.7	37199.2	596.0
2023-01-05 01:00:00	YM	Futures	37198.1	37210.3	37135.7	37136.8	794.0
2023-01-05 02:00:00	YM	Futures	37137.9	37166.9	37108.9	37122.3	1451.0
2023-01-05 03:00:00	YM	Futures	37125.7	37154.6	37073.3	37142.4	2880.0

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

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