PREVIEW / futures_1hour / 2023-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-27.parquet
  size:    55 KB
  rows:    1,645

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-27 00:00:00	ES	Futures	4545.28	4547.8	4545.28	4546.4	3599.0
2023-01-27 01:00:00	ES	Futures	4546.4	4546.96	4539.13	4543.89	7414.0
2023-01-27 02:00:00	ES	Futures	4543.89	4546.4	4539.69	4543.89	9941.0
2023-01-27 03:00:00	ES	Futures	4543.61	4545.28	4537.73	4541.65	15592.0
2023-01-27 04:00:00	ES	Futures	4541.37	4545.56	4539.97	4544.45	9902.0
2023-01-27 05:00:00	ES	Futures	4544.45	4547.24	4542.77	4546.68	8907.0
2023-01-27 06:00:00	ES	Futures	4546.68	4550.32	4545.0	4547.52	11847.0
2023-01-27 07:00:00	ES	Futures	4547.24	4552.27	4539.97	4540.53	23152.0
2023-01-27 08:00:00	ES	Futures	4540.53	4550.32	4539.13	4541.09	43995.0
2023-01-27 09:00:00	ES	Futures	4541.09	4565.98	4539.13	4560.38	162013.0
2023-01-27 10:00:00	ES	Futures	4560.38	4578.56	4544.17	4550.32	285894.0
2023-01-27 11:00:00	ES	Futures	4550.32	4572.97	4545.84	4569.61	170565.0
2023-01-27 12:00:00	ES	Futures	4569.89	4579.96	4565.98	4576.32	144859.0
2023-01-27 13:00:00	ES	Futures	4576.32	4578.56	4567.37	4576.32	128607.0
2023-01-27 14:00:00	ES	Futures	4576.32	4589.18	4574.08	4588.06	137156.0
2023-01-27 15:00:00	ES	Futures	4588.06	4595.89	4565.98	4567.65	286225.0
2023-01-27 16:00:00	ES	Futures	4567.65	4569.89	4564.58	4567.65	47562.0
2023-01-27 00:00:00	NQ	Futures	13693.84	13706.35	13693.27	13703.79	1502.0
2023-01-27 01:00:00	NQ	Futures	13703.79	13704.36	13673.92	13689.85	3387.0
2023-01-27 02:00:00	NQ	Futures	13690.14	13708.06	13677.62	13698.67	3985.0
2023-01-27 03:00:00	NQ	Futures	13698.39	13704.93	13677.34	13687.58	6619.0
2023-01-27 04:00:00	NQ	Futures	13687.58	13707.21	13677.91	13701.8	6840.0
2023-01-27 05:00:00	NQ	Futures	13702.09	13715.74	13695.26	13710.62	5065.0
2023-01-27 06:00:00	NQ	Futures	13710.91	13722.86	13697.54	13716.6	4654.0
2023-01-27 07:00:00	NQ	Futures	13716.31	13737.65	13690.71	13691.28	12137.0
2023-01-27 08:00:00	NQ	Futures	13691.56	13745.33	13681.6	13704.36	23161.0
2023-01-27 09:00:00	NQ	Futures	13704.65	13823.0	13692.41	13795.69	75927.0
2023-01-27 10:00:00	NQ	Futures	13800.24	13875.63	13760.69	13787.44	106511.0
2023-01-27 11:00:00	NQ	Futures	13787.44	13893.55	13770.65	13878.47	63613.0
2023-01-27 12:00:00	NQ	Futures	13879.04	13930.54	13867.38	13910.62	55926.0
2023-01-27 13:00:00	NQ	Futures	13910.91	13957.28	13883.88	13946.75	46503.0
2023-01-27 14:00:00	NQ	Futures	13946.75	13977.48	13931.96	13968.37	44905.0
2023-01-27 15:00:00	NQ	Futures	13968.94	14006.78	13904.08	13909.77	90264.0
2023-01-27 16:00:00	NQ	Futures	13909.48	13918.87	13897.25	13907.21	14774.0
2023-01-27 00:00:00	YM	Futures	37886.6	37903.4	37885.5	37893.3	491.0
2023-01-27 01:00:00	YM	Futures	37891.1	37900.0	37846.5	37876.6	1111.0
2023-01-27 02:00:00	YM	Futures	37875.5	37883.3	37848.8	37859.9	1974.0
2023-01-27 03:00:00	YM	Futures	37858.8	37872.2	37820.9	37853.2	3439.0
2023-01-27 04:00:00	YM	Futures	37852.1	37878.8	37843.2	37872.2	1558.0
2023-01-27 05:00:00	YM	Futures	37872.2	37893.3	37861.0	37891.1	951.0
2023-01-27 06:00:00	YM	Futures	37892.2	37921.2	37868.8	37880.0	1674.0
2023-01-27 07:00:00	YM	Futures	37880.0	37942.3	37872.2	37878.8	4094.0
2023-01-27 08:00:00	YM	Futures	37878.8	37934.5	37864.4	37882.2	4361.0
2023-01-27 09:00:00	YM	Futures	37881.1	38018.1	37851.0	37980.2	17191.0
2023-01-27 10:00:00	YM	Futures	37986.9	38096.1	37769.6	37822.0	27912.0
2023-01-27 11:00:00	YM	Futures	37822.0	37989.1	37797.5	37964.6	16211.0
2023-01-27 12:00:00	YM	Futures	37963.5	38058.2	37935.7	38033.7	12056.0
2023-01-27 13:00:00	YM	Futures	38034.8	38048.2	37960.2	37995.8	9016.0
2023-01-27 14:00:00	YM	Futures	37992.5	38118.4	37968.0	38091.6	10232.0
2023-01-27 15:00:00	YM	Futures	38093.9	38150.7	37913.4	37933.4	19924.0

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

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