PREVIEW / futures_1hour / 2023-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-06.parquet
  size:    58 KB
  rows:    1,643

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-06 00:00:00	ES	Futures	4303.14	4303.14	4294.76	4296.15	8097.0
2023-01-06 01:00:00	ES	Futures	4296.15	4298.67	4293.92	4295.6	5878.0
2023-01-06 02:00:00	ES	Futures	4295.6	4300.35	4285.25	4285.81	11315.0
2023-01-06 03:00:00	ES	Futures	4286.09	4291.4	4283.01	4289.16	17500.0
2023-01-06 04:00:00	ES	Futures	4289.16	4289.44	4276.86	4283.29	16611.0
2023-01-06 05:00:00	ES	Futures	4283.29	4288.05	4279.1	4281.62	11850.0
2023-01-06 06:00:00	ES	Futures	4281.34	4289.16	4280.22	4283.85	10447.0
2023-01-06 07:00:00	ES	Futures	4283.85	4285.25	4278.82	4280.78	17482.0
2023-01-06 08:00:00	ES	Futures	4281.06	4335.3	4271.27	4331.66	158258.0
2023-01-06 09:00:00	ES	Futures	4331.39	4333.9	4282.45	4297.55	308317.0
2023-01-06 10:00:00	ES	Futures	4297.55	4352.36	4297.55	4348.72	384824.0
2023-01-06 11:00:00	ES	Futures	4348.72	4365.5	4345.65	4359.9	200940.0
2023-01-06 12:00:00	ES	Futures	4360.18	4362.98	4346.48	4350.68	105651.0
2023-01-06 13:00:00	ES	Futures	4350.68	4366.9	4348.16	4365.22	106924.0
2023-01-06 14:00:00	ES	Futures	4365.5	4388.7	4365.5	4385.63	172589.0
2023-01-06 15:00:00	ES	Futures	4385.63	4394.02	4376.4	4380.04	290350.0
2023-01-06 16:00:00	ES	Futures	4379.76	4381.43	4374.44	4377.24	65167.0
2023-01-06 00:00:00	NQ	Futures	12374.64	12374.92	12339.36	12345.9	2992.0
2023-01-06 01:00:00	NQ	Futures	12346.19	12354.15	12339.65	12346.19	2034.0
2023-01-06 02:00:00	NQ	Futures	12346.47	12363.26	12310.34	12312.62	5394.0
2023-01-06 03:00:00	NQ	Futures	12312.62	12330.26	12302.66	12322.29	8623.0
2023-01-06 04:00:00	NQ	Futures	12322.01	12323.43	12265.11	12294.41	10140.0
2023-01-06 05:00:00	NQ	Futures	12294.13	12319.73	12278.48	12279.9	7862.0
2023-01-06 06:00:00	NQ	Futures	12279.33	12304.94	12270.51	12281.61	7287.0
2023-01-06 07:00:00	NQ	Futures	12281.89	12298.39	12265.68	12284.74	8986.0
2023-01-06 08:00:00	NQ	Futures	12285.31	12483.03	12234.38	12453.44	67457.0
2023-01-06 09:00:00	NQ	Futures	12452.59	12461.69	12251.74	12306.64	131500.0
2023-01-06 10:00:00	NQ	Futures	12307.21	12517.17	12307.21	12502.09	134272.0
2023-01-06 11:00:00	NQ	Futures	12502.38	12567.24	12483.31	12544.77	83621.0
2023-01-06 12:00:00	NQ	Futures	12545.05	12562.4	12514.89	12532.53	44109.0
2023-01-06 13:00:00	NQ	Futures	12532.53	12604.51	12527.13	12600.24	44362.0
2023-01-06 14:00:00	NQ	Futures	12600.53	12687.58	12597.4	12675.35	56262.0
2023-01-06 15:00:00	NQ	Futures	12675.63	12706.36	12638.93	12648.04	79091.0
2023-01-06 16:00:00	NQ	Futures	12647.47	12654.3	12624.42	12641.49	16970.0
2023-01-06 00:00:00	YM	Futures	36988.6	36989.7	36938.5	36950.7	927.0
2023-01-06 01:00:00	YM	Futures	36950.7	36968.6	36940.7	36949.6	874.0
2023-01-06 02:00:00	YM	Futures	36951.8	36984.2	36872.7	36872.7	1518.0
2023-01-06 03:00:00	YM	Futures	36875.0	36912.8	36852.7	36903.9	2093.0
2023-01-06 04:00:00	YM	Futures	36905.0	36906.2	36827.1	36867.2	2360.0
2023-01-06 05:00:00	YM	Futures	36866.0	36898.4	36840.4	36864.9	1524.0
2023-01-06 06:00:00	YM	Futures	36863.8	36925.1	36859.4	36892.8	1707.0
2023-01-06 07:00:00	YM	Futures	36892.8	36912.8	36851.6	36858.2	2133.0
2023-01-06 08:00:00	YM	Futures	36861.6	37273.8	36803.7	37253.8	27512.0
2023-01-06 09:00:00	YM	Futures	37252.7	37327.3	36915.1	37018.7	47933.0
2023-01-06 10:00:00	YM	Futures	37024.3	37447.7	37024.3	37424.3	48008.0
2023-01-06 11:00:00	YM	Futures	37426.5	37575.8	37412.0	37522.3	26429.0
2023-01-06 12:00:00	YM	Futures	37522.3	37541.2	37403.1	37435.4	12663.0
2023-01-06 13:00:00	YM	Futures	37435.4	37524.5	37410.9	37503.4	10367.0
2023-01-06 14:00:00	YM	Futures	37503.4	37674.9	37503.4	37661.6	16777.0
2023-01-06 15:00:00	YM	Futures	37661.6	37729.5	37604.8	37627.0	23058.0

> showing 50 of 1,643 rows — these rows as CSV

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