PREVIEW / etf_1hour / 2024-09-20
file: by_date/etf_1hour/2024/2024-09-20.parquet size: 548 KB rows: 20,464
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-20 04:00:00 | SPY | ETF | 568.99 | 569.0 | 568.09 | 568.25 | 40666.0 |
| 2024-09-20 05:00:00 | SPY | ETF | 568.34 | 568.7 | 568.09 | 568.27 | 10192.0 |
| 2024-09-20 06:00:00 | SPY | ETF | 568.23 | 568.53 | 567.83 | 567.96 | 21525.0 |
| 2024-09-20 07:00:00 | SPY | ETF | 567.97 | 568.17 | 567.69 | 568.14 | 168752.0 |
| 2024-09-20 08:00:00 | SPY | ETF | 568.09 | 569.1 | 567.7497 | 568.97 | 269577.0 |
| 2024-09-20 09:00:00 | SPY | ETF | 568.93 | 568.94 | 566.93 | 567.149 | 4658306.0 |
| 2024-09-20 10:00:00 | SPY | ETF | 567.07 | 567.76 | 566.26 | 566.395 | 4725320.0 |
| 2024-09-20 11:00:00 | SPY | ETF | 566.4 | 567.36 | 565.17 | 566.93 | 4883884.0 |
| 2024-09-20 12:00:00 | SPY | ETF | 566.95 | 568.5 | 566.73 | 568.1485 | 2942149.0 |
| 2024-09-20 13:00:00 | SPY | ETF | 568.14 | 568.6455 | 567.87 | 568.07 | 2514079.0 |
| 2024-09-20 14:00:00 | SPY | ETF | 568.065 | 568.14 | 566.09 | 567.4801 | 4956776.0 |
| 2024-09-20 15:00:00 | SPY | ETF | 567.48 | 569.31 | 567.1275 | 568.1 | 10129822.0 |
| 2024-09-20 16:00:00 | SPY | ETF | 568.1 | 568.25 | 567.2 | 567.79 | 4997338.0 |
| 2024-09-20 17:00:00 | SPY | ETF | 567.83 | 568.0 | 567.41 | 567.5 | 119935.0 |
| 2024-09-20 18:00:00 | SPY | ETF | 567.5 | 568.25 | 567.48 | 568.25 | 91842.0 |
| 2024-09-20 19:00:00 | SPY | ETF | 568.25 | 568.29 | 568.01 | 568.15 | 19998.0 |
| 2024-09-20 04:00:00 | QQQ | ETF | 483.01 | 483.13 | 481.84 | 482.22 | 94565.0 |
| 2024-09-20 05:00:00 | QQQ | ETF | 482.18 | 482.6 | 481.83 | 481.85 | 35740.0 |
| 2024-09-20 06:00:00 | QQQ | ETF | 481.92 | 482.1 | 481.21 | 481.45 | 63680.0 |
| 2024-09-20 07:00:00 | QQQ | ETF | 481.47 | 482.09 | 481.22 | 482.09 | 155480.0 |
| 2024-09-20 08:00:00 | QQQ | ETF | 481.62 | 483.43 | 481.2401 | 483.16 | 363822.0 |
| 2024-09-20 09:00:00 | QQQ | ETF | 483.17 | 483.63 | 481.43 | 481.6602 | 2625779.0 |
| 2024-09-20 10:00:00 | QQQ | ETF | 481.68 | 482.269 | 480.05 | 480.25 | 3165582.0 |
| 2024-09-20 11:00:00 | QQQ | ETF | 480.24 | 481.35 | 478.3 | 481.04 | 3278805.0 |
| 2024-09-20 12:00:00 | QQQ | ETF | 481.05 | 482.54 | 480.9 | 482.14 | 1659723.0 |
| 2024-09-20 13:00:00 | QQQ | ETF | 482.13 | 482.41 | 481.41 | 481.56 | 1370998.0 |
| 2024-09-20 14:00:00 | QQQ | ETF | 481.56 | 481.77 | 480.13 | 481.63 | 1927632.0 |
| 2024-09-20 15:00:00 | QQQ | ETF | 481.63 | 483.69 | 481.26 | 482.42 | 4734382.0 |
| 2024-09-20 16:00:00 | QQQ | ETF | 482.43 | 482.55 | 481.61 | 482.02 | 2454534.0 |
| 2024-09-20 17:00:00 | QQQ | ETF | 482.01 | 482.44 | 481.66 | 481.75 | 120027.0 |
| 2024-09-20 18:00:00 | QQQ | ETF | 481.72 | 482.2 | 481.72 | 482.16 | 12482.0 |
| 2024-09-20 19:00:00 | QQQ | ETF | 482.2 | 482.25 | 482.04 | 482.19 | 10695.0 |
| 2024-09-20 04:00:00 | IWM | ETF | 223.35 | 223.52 | 222.96 | 223.31 | 26934.0 |
| 2024-09-20 05:00:00 | IWM | ETF | 223.37 | 223.7 | 223.26 | 223.26 | 4079.0 |
| 2024-09-20 06:00:00 | IWM | ETF | 223.16 | 223.72 | 223.03 | 223.49 | 17111.0 |
| 2024-09-20 07:00:00 | IWM | ETF | 223.48 | 223.55 | 223.26 | 223.36 | 38615.0 |
| 2024-09-20 08:00:00 | IWM | ETF | 223.4 | 223.93 | 223.01 | 223.67 | 92641.0 |
| 2024-09-20 09:00:00 | IWM | ETF | 223.65 | 223.85 | 221.84 | 222.2313 | 3302129.0 |
| 2024-09-20 10:00:00 | IWM | ETF | 222.22 | 223.27 | 221.8599 | 222.72 | 3387887.0 |
| 2024-09-20 11:00:00 | IWM | ETF | 222.71 | 222.77 | 221.29 | 222.39 | 2033372.0 |
| 2024-09-20 12:00:00 | IWM | ETF | 222.39 | 222.88 | 222.2132 | 222.55 | 1147195.0 |
| 2024-09-20 13:00:00 | IWM | ETF | 222.55 | 222.99 | 222.22 | 222.43 | 1206305.0 |
| 2024-09-20 14:00:00 | IWM | ETF | 222.44 | 222.44 | 221.68 | 222.29 | 1702918.0 |
| 2024-09-20 15:00:00 | IWM | ETF | 222.27 | 222.65 | 221.42 | 221.635 | 5956944.0 |
| 2024-09-20 16:00:00 | IWM | ETF | 221.57 | 222.05 | 221.49 | 221.57 | 2074964.0 |
| 2024-09-20 17:00:00 | IWM | ETF | 221.99 | 222.05 | 221.6996 | 221.7 | 39994.0 |
| 2024-09-20 18:00:00 | IWM | ETF | 221.699 | 222.0 | 221.699 | 222.0 | 12913.0 |
| 2024-09-20 19:00:00 | IWM | ETF | 221.9955 | 222.03 | 221.91 | 221.91 | 4252.0 |
| 2024-09-20 04:00:00 | DIA | ETF | 420.16 | 420.22 | 420.16 | 420.19 | 1300.0 |
| 2024-09-20 06:00:00 | DIA | ETF | 420.42 | 420.79 | 420.42 | 420.67 | 2494.0 |
> showing 50 of 20,464 rows — these rows as CSV