PREVIEW / etf_1hour / 2024-09-24
file: by_date/etf_1hour/2024/2024-09-24.parquet size: 569 KB rows: 21,412
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-24 04:00:00 | SPY | ETF | 570.22 | 571.41 | 570.22 | 571.34 | 10424.0 |
| 2024-09-24 05:00:00 | SPY | ETF | 571.19 | 571.26 | 570.59 | 570.74 | 17745.0 |
| 2024-09-24 06:00:00 | SPY | ETF | 570.67 | 571.09 | 570.2 | 570.21 | 24888.0 |
| 2024-09-24 07:00:00 | SPY | ETF | 570.17 | 570.541 | 569.1 | 570.08 | 201192.0 |
| 2024-09-24 08:00:00 | SPY | ETF | 570.1 | 571.38 | 568.91 | 570.21 | 302938.0 |
| 2024-09-24 09:00:00 | SPY | ETF | 570.3 | 570.8 | 569.23 | 569.332 | 3271270.0 |
| 2024-09-24 10:00:00 | SPY | ETF | 569.34 | 569.7015 | 567.6 | 569.4988 | 5268259.0 |
| 2024-09-24 11:00:00 | SPY | ETF | 569.49 | 571.07 | 569.32 | 570.6 | 3154439.0 |
| 2024-09-24 12:00:00 | SPY | ETF | 570.61 | 571.2 | 570.26 | 570.4475 | 2499960.0 |
| 2024-09-24 13:00:00 | SPY | ETF | 570.445 | 571.01 | 570.27 | 570.465 | 1379922.0 |
| 2024-09-24 14:00:00 | SPY | ETF | 570.5 | 570.6991 | 569.43 | 570.45 | 2260049.0 |
| 2024-09-24 15:00:00 | SPY | ETF | 570.43 | 571.36 | 570.36 | 571.24 | 8220810.0 |
| 2024-09-24 16:00:00 | SPY | ETF | 571.24 | 571.4 | 570.85 | 571.21 | 5933925.0 |
| 2024-09-24 17:00:00 | SPY | ETF | 571.2 | 571.3 | 571.2 | 571.24 | 43470.0 |
| 2024-09-24 18:00:00 | SPY | ETF | 571.31 | 571.34 | 571.1 | 571.26 | 28204.0 |
| 2024-09-24 19:00:00 | SPY | ETF | 571.29 | 571.39 | 571.19 | 571.22 | 29145.0 |
| 2024-09-24 04:00:00 | QQQ | ETF | 483.72 | 485.5 | 483.72 | 485.19 | 55468.0 |
| 2024-09-24 05:00:00 | QQQ | ETF | 485.15 | 485.19 | 484.2 | 484.37 | 18192.0 |
| 2024-09-24 06:00:00 | QQQ | ETF | 484.27 | 484.91 | 484.0 | 484.02 | 19281.0 |
| 2024-09-24 07:00:00 | QQQ | ETF | 484.03 | 484.23 | 482.5 | 483.76 | 134015.0 |
| 2024-09-24 08:00:00 | QQQ | ETF | 483.9901 | 485.4504 | 482.34 | 483.96 | 141253.0 |
| 2024-09-24 09:00:00 | QQQ | ETF | 484.0 | 484.89 | 483.21 | 483.35 | 1924675.0 |
| 2024-09-24 10:00:00 | QQQ | ETF | 483.35 | 483.3971 | 480.17 | 483.0315 | 4494703.0 |
| 2024-09-24 11:00:00 | QQQ | ETF | 483.03 | 486.33 | 482.91 | 485.67 | 3913464.0 |
| 2024-09-24 12:00:00 | QQQ | ETF | 485.67 | 486.3 | 485.05 | 485.1 | 2460999.0 |
| 2024-09-24 13:00:00 | QQQ | ETF | 485.08 | 485.84 | 484.84 | 485.17 | 1308411.0 |
| 2024-09-24 14:00:00 | QQQ | ETF | 485.19 | 485.42 | 483.85 | 484.77 | 1534415.0 |
| 2024-09-24 15:00:00 | QQQ | ETF | 484.75 | 485.48 | 484.62 | 485.35 | 3010785.0 |
| 2024-09-24 16:00:00 | QQQ | ETF | 485.37 | 485.82 | 485.17 | 485.73 | 965137.0 |
| 2024-09-24 17:00:00 | QQQ | ETF | 485.75 | 485.78 | 485.56 | 485.7785 | 42686.0 |
| 2024-09-24 18:00:00 | QQQ | ETF | 485.64 | 485.74 | 485.48 | 485.6902 | 29252.0 |
| 2024-09-24 19:00:00 | QQQ | ETF | 485.73 | 485.85 | 485.5775 | 485.63 | 47505.0 |
| 2024-09-24 04:00:00 | IWM | ETF | 221.25 | 221.94 | 221.25 | 221.74 | 27076.0 |
| 2024-09-24 05:00:00 | IWM | ETF | 221.8 | 221.8 | 220.8 | 221.36 | 13202.0 |
| 2024-09-24 06:00:00 | IWM | ETF | 221.41 | 222.0 | 221.38 | 221.54 | 25391.0 |
| 2024-09-24 07:00:00 | IWM | ETF | 221.35 | 221.67 | 220.98 | 221.14 | 42353.0 |
| 2024-09-24 08:00:00 | IWM | ETF | 221.3513 | 221.78 | 220.68 | 221.46 | 58794.0 |
| 2024-09-24 09:00:00 | IWM | ETF | 221.47 | 221.93 | 221.13 | 221.37 | 1840306.0 |
| 2024-09-24 10:00:00 | IWM | ETF | 221.34 | 221.45 | 219.5 | 220.53 | 3525759.0 |
| 2024-09-24 11:00:00 | IWM | ETF | 220.53 | 221.17 | 220.3001 | 220.55 | 1428174.0 |
| 2024-09-24 12:00:00 | IWM | ETF | 220.565 | 221.225 | 220.54 | 220.98 | 1151227.0 |
| 2024-09-24 13:00:00 | IWM | ETF | 220.93 | 221.46 | 220.91 | 221.26 | 1117159.0 |
| 2024-09-24 14:00:00 | IWM | ETF | 221.27 | 221.56 | 220.93 | 221.15 | 880007.0 |
| 2024-09-24 15:00:00 | IWM | ETF | 221.13 | 221.4394 | 221.04 | 221.12 | 2656617.0 |
| 2024-09-24 16:00:00 | IWM | ETF | 221.13 | 221.23 | 220.98 | 221.14 | 947824.0 |
| 2024-09-24 17:00:00 | IWM | ETF | 221.13 | 221.13 | 221.08 | 221.13 | 9662.0 |
| 2024-09-24 18:00:00 | IWM | ETF | 221.19 | 221.2 | 221.03 | 221.16 | 19509.0 |
| 2024-09-24 19:00:00 | IWM | ETF | 221.14 | 221.2 | 221.03 | 221.03 | 11233.0 |
| 2024-09-24 05:00:00 | DIA | ETF | 421.83 | 421.83 | 421.81 | 421.81 | 595.0 |
| 2024-09-24 06:00:00 | DIA | ETF | 421.54 | 421.54 | 421.52 | 421.52 | 200.0 |
> showing 50 of 21,412 rows — these rows as CSV