PREVIEW / futures_1hour / 2022-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-17.parquet
  size:    68 KB
  rows:    2,029

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
2022-08-17 00:00:00	ES	Futures	4880.48	4885.02	4880.48	4884.17	2108.0
2022-08-17 01:00:00	ES	Futures	4884.17	4889.27	4883.03	4888.42	4748.0
2022-08-17 02:00:00	ES	Futures	4888.42	4888.42	4876.8	4877.37	8794.0
2022-08-17 03:00:00	ES	Futures	4877.65	4878.5	4868.87	4869.44	16281.0
2022-08-17 04:00:00	ES	Futures	4869.44	4870.85	4860.94	4861.79	16846.0
2022-08-17 05:00:00	ES	Futures	4862.07	4865.19	4853.57	4855.56	17632.0
2022-08-17 06:00:00	ES	Futures	4855.56	4856.12	4843.38	4849.04	22939.0
2022-08-17 07:00:00	ES	Futures	4849.32	4850.74	4837.43	4841.68	27082.0
2022-08-17 08:00:00	ES	Futures	4841.96	4846.49	4833.74	4837.71	50989.0
2022-08-17 09:00:00	ES	Futures	4837.43	4854.14	4834.31	4849.32	185972.0
2022-08-17 10:00:00	ES	Futures	4849.04	4855.56	4830.35	4832.61	226043.0
2022-08-17 11:00:00	ES	Futures	4832.61	4843.66	4821.28	4825.53	175619.0
2022-08-17 12:00:00	ES	Futures	4825.53	4847.91	4824.96	4843.94	118002.0
2022-08-17 13:00:00	ES	Futures	4843.94	4851.02	4838.56	4845.93	99244.0
2022-08-17 14:00:00	ES	Futures	4845.64	4878.22	4841.96	4857.82	284385.0
2022-08-17 15:00:00	ES	Futures	4858.11	4867.17	4839.98	4845.64	257691.0
2022-08-17 16:00:00	ES	Futures	4845.93	4851.31	4845.08	4850.46	37144.0
2022-08-17 18:00:00	ES	Futures	4849.04	4849.04	4839.69	4840.83	4546.0
2022-08-17 19:00:00	ES	Futures	4840.83	4841.11	4835.16	4837.71	8417.0
2022-08-17 20:00:00	ES	Futures	4837.71	4837.99	4832.33	4836.86	7458.0
2022-08-17 21:00:00	ES	Futures	4836.86	4844.23	4836.29	4838.84	6939.0
2022-08-17 22:00:00	ES	Futures	4838.56	4844.51	4838.28	4841.68	3688.0
2022-08-17 23:00:00	ES	Futures	4841.96	4844.51	4839.13	4841.39	2659.0
2022-08-17 00:00:00	NQ	Futures	15788.11	15802.29	15787.25	15798.53	1208.0
2022-08-17 01:00:00	NQ	Futures	15798.82	15817.91	15794.48	15814.14	2389.0
2022-08-17 02:00:00	NQ	Futures	15815.01	15815.01	15768.73	15777.41	4338.0
2022-08-17 03:00:00	NQ	Futures	15777.12	15782.04	15732.29	15736.05	8436.0
2022-08-17 04:00:00	NQ	Futures	15735.47	15745.88	15707.42	15714.36	7877.0
2022-08-17 05:00:00	NQ	Futures	15715.23	15735.18	15684.57	15695.27	6682.0
2022-08-17 06:00:00	NQ	Futures	15694.4	15699.03	15660.27	15680.23	9869.0
2022-08-17 07:00:00	NQ	Futures	15681.09	15688.62	15633.37	15649.86	13228.0
2022-08-17 08:00:00	NQ	Futures	15650.44	15681.96	15625.56	15642.92	21326.0
2022-08-17 09:00:00	NQ	Futures	15642.34	15694.98	15600.98	15658.25	77025.0
2022-08-17 10:00:00	NQ	Futures	15658.53	15686.59	15530.69	15537.63	98269.0
2022-08-17 11:00:00	NQ	Futures	15537.92	15595.77	15510.44	15531.27	70035.0
2022-08-17 12:00:00	NQ	Futures	15531.56	15612.26	15530.98	15593.46	51337.0
2022-08-17 13:00:00	NQ	Futures	15593.74	15630.19	15568.58	15601.84	39857.0
2022-08-17 14:00:00	NQ	Futures	15601.26	15753.12	15588.25	15671.84	95185.0
2022-08-17 15:00:00	NQ	Futures	15672.42	15712.62	15591.43	15614.86	72768.0
2022-08-17 16:00:00	NQ	Futures	15614.28	15633.37	15606.18	15631.64	11245.0
2022-08-17 18:00:00	NQ	Futures	15622.38	15622.38	15581.89	15585.94	2787.0
2022-08-17 19:00:00	NQ	Futures	15586.22	15587.67	15560.48	15567.13	3621.0
2022-08-17 20:00:00	NQ	Futures	15566.85	15572.05	15548.04	15567.13	4262.0
2022-08-17 21:00:00	NQ	Futures	15567.13	15593.46	15565.98	15576.68	3752.0
2022-08-17 22:00:00	NQ	Futures	15576.97	15599.53	15574.94	15589.12	2629.0
2022-08-17 23:00:00	NQ	Futures	15590.56	15597.5	15579.86	15587.67	1477.0
2022-08-17 00:00:00	YM	Futures	38508.1	38537.4	38508.1	38534.1	289.0
2022-08-17 01:00:00	YM	Futures	38532.9	38563.4	38521.6	38558.9	962.0
2022-08-17 02:00:00	YM	Futures	38557.8	38560.0	38483.3	38485.5	1567.0
2022-08-17 03:00:00	YM	Futures	38485.5	38494.6	38429.1	38440.4	4210.0

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

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