PREVIEW / futures_1hour / 2023-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-19.parquet
  size:    65 KB
  rows:    2,015

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-04-19 00:00:00	ES	Futures	4631.52	4631.8	4630.41	4630.69	1688.0
2023-04-19 01:00:00	ES	Futures	4630.69	4631.25	4629.03	4629.31	4847.0
2023-04-19 02:00:00	ES	Futures	4629.31	4629.86	4619.6	4623.2	14045.0
2023-04-19 03:00:00	ES	Futures	4623.2	4624.87	4618.21	4622.65	17292.0
2023-04-19 04:00:00	ES	Futures	4622.37	4623.76	4613.22	4617.66	15465.0
2023-04-19 05:00:00	ES	Futures	4617.38	4617.38	4607.12	4609.06	19980.0
2023-04-19 06:00:00	ES	Futures	4609.06	4614.61	4607.67	4614.33	13395.0
2023-04-19 07:00:00	ES	Futures	4614.33	4617.1	4610.45	4611.83	23991.0
2023-04-19 08:00:00	ES	Futures	4611.83	4612.11	4604.62	4607.67	33772.0
2023-04-19 09:00:00	ES	Futures	4607.67	4618.77	4607.67	4614.05	179990.0
2023-04-19 10:00:00	ES	Futures	4614.33	4628.75	4613.22	4625.42	199555.0
2023-04-19 11:00:00	ES	Futures	4625.7	4630.97	4621.54	4630.14	145572.0
2023-04-19 12:00:00	ES	Futures	4630.14	4635.68	4627.92	4633.74	94227.0
2023-04-19 13:00:00	ES	Futures	4634.02	4640.12	4631.25	4639.29	114036.0
2023-04-19 14:00:00	ES	Futures	4639.57	4645.67	4635.13	4639.57	121167.0
2023-04-19 15:00:00	ES	Futures	4639.57	4642.34	4629.03	4635.68	168337.0
2023-04-19 16:00:00	ES	Futures	4635.41	4635.96	4629.03	4630.14	57970.0
2023-04-19 18:00:00	ES	Futures	4628.75	4629.58	4623.48	4625.15	6778.0
2023-04-19 19:00:00	ES	Futures	4624.87	4625.7	4620.98	4621.82	5497.0
2023-04-19 20:00:00	ES	Futures	4622.09	4626.25	4621.54	4625.42	6630.0
2023-04-19 21:00:00	ES	Futures	4625.42	4628.47	4623.76	4627.64	7293.0
2023-04-19 22:00:00	ES	Futures	4627.36	4630.14	4623.76	4624.87	6113.0
2023-04-19 23:00:00	ES	Futures	4624.59	4627.36	4622.93	4627.09	4279.0
2023-04-19 00:00:00	NQ	Futures	14833.34	14833.9	14824.33	14826.02	1483.0
2023-04-19 01:00:00	NQ	Futures	14826.02	14829.12	14816.16	14817.01	2792.0
2023-04-19 02:00:00	NQ	Futures	14816.73	14818.7	14764.64	14780.41	8424.0
2023-04-19 03:00:00	NQ	Futures	14780.41	14798.43	14765.48	14786.32	7754.0
2023-04-19 04:00:00	NQ	Futures	14786.32	14798.43	14751.69	14769.43	9734.0
2023-04-19 05:00:00	NQ	Futures	14769.43	14771.4	14713.96	14726.35	13321.0
2023-04-19 06:00:00	NQ	Futures	14726.91	14751.13	14722.97	14747.18	7607.0
2023-04-19 07:00:00	NQ	Futures	14747.75	14759.29	14732.82	14742.96	9233.0
2023-04-19 08:00:00	NQ	Futures	14742.12	14746.9	14717.34	14729.73	12781.0
2023-04-19 09:00:00	NQ	Futures	14729.73	14790.26	14725.79	14747.47	84705.0
2023-04-19 10:00:00	NQ	Futures	14747.47	14808.56	14742.96	14796.74	85953.0
2023-04-19 11:00:00	NQ	Futures	14797.3	14841.22	14795.61	14835.87	64046.0
2023-04-19 12:00:00	NQ	Futures	14836.15	14873.88	14823.77	14856.43	49567.0
2023-04-19 13:00:00	NQ	Futures	14856.43	14879.23	14849.95	14874.73	40055.0
2023-04-19 14:00:00	NQ	Futures	14874.73	14896.13	14850.8	14874.16	41418.0
2023-04-19 15:00:00	NQ	Futures	14873.88	14885.43	14831.37	14846.85	51926.0
2023-04-19 16:00:00	NQ	Futures	14846.57	14857.83	14815.6	14830.24	21950.0
2023-04-19 18:00:00	NQ	Futures	14823.2	14827.43	14800.4	14806.31	4085.0
2023-04-19 19:00:00	NQ	Futures	14806.31	14809.13	14779.0	14784.63	5043.0
2023-04-19 20:00:00	NQ	Futures	14784.63	14801.24	14781.81	14799.83	3395.0
2023-04-19 21:00:00	NQ	Futures	14800.4	14810.53	14791.11	14803.78	3261.0
2023-04-19 22:00:00	NQ	Futures	14803.49	14813.35	14785.48	14791.67	3370.0
2023-04-19 23:00:00	NQ	Futures	14791.67	14799.27	14778.72	14798.99	2809.0
2023-04-19 00:00:00	YM	Futures	37656.8	37661.2	37649.0	37654.5	412.0
2023-04-19 01:00:00	YM	Futures	37655.6	37660.1	37646.8	37646.8	921.0
2023-04-19 02:00:00	YM	Futures	37647.9	37665.6	37597.1	37623.6	2498.0
2023-04-19 03:00:00	YM	Futures	37623.6	37641.3	37600.4	37621.4	3126.0

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

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