PREVIEW / futures_1hour / 2023-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-25.parquet
  size:    54 KB
  rows:    1,608

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-08-25 00:00:00	ES	Futures	4817.4	4819.6	4817.13	4817.13	3264.0
2023-08-25 01:00:00	ES	Futures	4817.4	4821.52	4814.38	4820.15	8479.0
2023-08-25 02:00:00	ES	Futures	4820.15	4821.24	4808.89	4811.91	13719.0
2023-08-25 03:00:00	ES	Futures	4812.18	4824.54	4812.18	4820.15	20910.0
2023-08-25 04:00:00	ES	Futures	4820.42	4829.2	4820.42	4826.46	17211.0
2023-08-25 05:00:00	ES	Futures	4826.18	4828.38	4819.87	4821.24	11018.0
2023-08-25 06:00:00	ES	Futures	4821.24	4830.3	4820.97	4828.38	10489.0
2023-08-25 07:00:00	ES	Futures	4828.11	4830.3	4824.26	4828.11	12509.0
2023-08-25 08:00:00	ES	Futures	4827.83	4837.99	4827.01	4835.24	30683.0
2023-08-25 09:00:00	ES	Futures	4835.24	4842.93	4827.01	4838.54	155095.0
2023-08-25 10:00:00	ES	Futures	4837.99	4861.87	4794.34	4795.71	451441.0
2023-08-25 11:00:00	ES	Futures	4795.99	4834.97	4793.24	4815.2	293942.0
2023-08-25 12:00:00	ES	Futures	4815.2	4838.26	4814.66	4833.6	149058.0
2023-08-25 13:00:00	ES	Futures	4833.6	4838.54	4819.32	4832.5	118010.0
2023-08-25 14:00:00	ES	Futures	4832.77	4858.3	4831.13	4856.93	160925.0
2023-08-25 15:00:00	ES	Futures	4857.2	4863.24	4843.2	4847.87	253742.0
2023-08-25 16:00:00	ES	Futures	4847.87	4851.44	4845.13	4845.95	48051.0
2023-08-25 00:00:00	NQ	Futures	16504.86	16520.71	16504.02	16513.76	2250.0
2023-08-25 01:00:00	NQ	Futures	16513.76	16533.51	16499.02	16524.61	4674.0
2023-08-25 02:00:00	NQ	Futures	16525.16	16529.06	16448.95	16464.53	9916.0
2023-08-25 03:00:00	NQ	Futures	16464.81	16531.28	16464.81	16511.26	11530.0
2023-08-25 04:00:00	NQ	Futures	16510.7	16563.54	16510.7	16551.58	12319.0
2023-08-25 05:00:00	NQ	Futures	16551.03	16558.82	16519.6	16528.22	6788.0
2023-08-25 06:00:00	NQ	Futures	16527.11	16564.93	16524.05	16553.25	8050.0
2023-08-25 07:00:00	NQ	Futures	16552.42	16561.04	16528.22	16551.03	8392.0
2023-08-25 08:00:00	NQ	Futures	16550.75	16596.92	16547.13	16575.23	16038.0
2023-08-25 09:00:00	NQ	Futures	16575.5	16637.8	16551.86	16630.85	81891.0
2023-08-25 10:00:00	NQ	Futures	16628.35	16742.1	16415.02	16420.58	198802.0
2023-08-25 11:00:00	NQ	Futures	16421.14	16566.88	16411.68	16471.48	125423.0
2023-08-25 12:00:00	NQ	Futures	16471.48	16574.39	16467.87	16556.59	68699.0
2023-08-25 13:00:00	NQ	Futures	16557.15	16581.9	16506.81	16555.48	57037.0
2023-08-25 14:00:00	NQ	Futures	16555.48	16685.37	16549.08	16682.31	72652.0
2023-08-25 15:00:00	NQ	Futures	16682.58	16717.91	16650.32	16662.84	84921.0
2023-08-25 16:00:00	NQ	Futures	16662.84	16680.08	16651.99	16657.0	12979.0
2023-08-25 00:00:00	YM	Futures	37450.1	37458.9	37440.3	37440.3	470.0
2023-08-25 01:00:00	YM	Futures	37442.4	37472.0	37428.2	37463.3	812.0
2023-08-25 02:00:00	YM	Futures	37464.4	37477.5	37424.9	37440.3	2271.0
2023-08-25 03:00:00	YM	Futures	37440.3	37506.0	37438.1	37473.1	5565.0
2023-08-25 04:00:00	YM	Futures	37473.1	37500.5	37451.2	37480.8	2833.0
2023-08-25 05:00:00	YM	Futures	37480.8	37498.3	37445.7	37458.9	1528.0
2023-08-25 06:00:00	YM	Futures	37458.9	37527.9	37455.6	37515.9	2085.0
2023-08-25 07:00:00	YM	Futures	37514.8	37533.4	37503.8	37521.3	1992.0
2023-08-25 08:00:00	YM	Futures	37521.3	37592.5	37514.8	37576.1	4534.0
2023-08-25 09:00:00	YM	Futures	37576.1	37656.1	37500.5	37557.5	19245.0
2023-08-25 10:00:00	YM	Futures	37556.4	37685.7	37324.1	37339.5	49501.0
2023-08-25 11:00:00	YM	Futures	37341.7	37613.4	37316.5	37480.8	31514.0
2023-08-25 12:00:00	YM	Futures	37480.8	37633.1	37476.4	37583.8	18561.0
2023-08-25 13:00:00	YM	Futures	37582.7	37630.9	37507.1	37610.1	13463.0
2023-08-25 14:00:00	YM	Futures	37606.8	37764.5	37595.8	37738.2	17209.0
2023-08-25 15:00:00	YM	Futures	37740.4	37777.7	37634.2	37664.8	16469.0

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

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