PREVIEW / etf_1hour / 2024-09-10
file: by_date/etf_1hour/2024/2024-09-10.parquet size: 535 KB rows: 20,346
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-10 04:00:00 | SPY | ETF | 547.08 | 547.18 | 546.13 | 546.2 | 35020.0 |
| 2024-09-10 05:00:00 | SPY | ETF | 546.0 | 546.14 | 544.86 | 545.94 | 171917.0 |
| 2024-09-10 06:00:00 | SPY | ETF | 546.26 | 546.69 | 545.52 | 545.98 | 32982.0 |
| 2024-09-10 07:00:00 | SPY | ETF | 546.0 | 547.03 | 545.98 | 546.86 | 193020.0 |
| 2024-09-10 08:00:00 | SPY | ETF | 546.069 | 548.29 | 545.35 | 548.12 | 304567.0 |
| 2024-09-10 09:00:00 | SPY | ETF | 548.12 | 548.66 | 547.63 | 547.8698 | 3433508.0 |
| 2024-09-10 10:00:00 | SPY | ETF | 547.87 | 548.11 | 545.5493 | 546.52 | 4008028.0 |
| 2024-09-10 11:00:00 | SPY | ETF | 546.52 | 547.73 | 544.12 | 544.18 | 3134105.0 |
| 2024-09-10 12:00:00 | SPY | ETF | 544.15 | 545.82 | 543.38 | 545.14 | 3616602.0 |
| 2024-09-10 13:00:00 | SPY | ETF | 545.13 | 547.1899 | 545.03 | 546.99 | 2986372.0 |
| 2024-09-10 14:00:00 | SPY | ETF | 547.0 | 548.36 | 547.0 | 548.2199 | 3376820.0 |
| 2024-09-10 15:00:00 | SPY | ETF | 548.2 | 549.15 | 547.97 | 548.82 | 6172053.0 |
| 2024-09-10 16:00:00 | SPY | ETF | 548.77 | 548.94 | 548.13 | 548.47 | 2145864.0 |
| 2024-09-10 17:00:00 | SPY | ETF | 548.48 | 548.67 | 548.3863 | 548.6 | 21672.0 |
| 2024-09-10 18:00:00 | SPY | ETF | 548.55 | 548.55 | 548.22 | 548.46 | 54851.0 |
| 2024-09-10 19:00:00 | SPY | ETF | 548.49 | 548.69 | 548.04 | 548.3 | 50584.0 |
| 2024-09-10 04:00:00 | QQQ | ETF | 454.38 | 454.6 | 453.37 | 453.51 | 30127.0 |
| 2024-09-10 05:00:00 | QQQ | ETF | 453.35 | 453.55 | 452.06 | 453.33 | 32904.0 |
| 2024-09-10 06:00:00 | QQQ | ETF | 453.39 | 454.27 | 452.83 | 453.67 | 36025.0 |
| 2024-09-10 07:00:00 | QQQ | ETF | 453.68 | 454.99 | 453.66 | 454.81 | 186833.0 |
| 2024-09-10 08:00:00 | QQQ | ETF | 453.95 | 456.53 | 452.273 | 456.29 | 372092.0 |
| 2024-09-10 09:00:00 | QQQ | ETF | 456.25 | 457.82 | 455.4 | 456.41 | 3370452.0 |
| 2024-09-10 10:00:00 | QQQ | ETF | 456.44 | 457.66 | 454.24 | 455.55 | 3611557.0 |
| 2024-09-10 11:00:00 | QQQ | ETF | 455.52 | 457.03 | 453.0 | 453.04 | 2345674.0 |
| 2024-09-10 12:00:00 | QQQ | ETF | 453.04 | 455.3 | 452.23 | 454.575 | 2498484.0 |
| 2024-09-10 13:00:00 | QQQ | ETF | 454.56 | 457.165 | 454.5 | 456.97 | 2626986.0 |
| 2024-09-10 14:00:00 | QQQ | ETF | 456.97 | 458.41 | 456.97 | 457.85 | 2293077.0 |
| 2024-09-10 15:00:00 | QQQ | ETF | 457.845 | 459.17 | 457.74 | 458.67 | 3829592.0 |
| 2024-09-10 16:00:00 | QQQ | ETF | 458.66 | 458.85 | 457.81 | 458.15 | 1230122.0 |
| 2024-09-10 17:00:00 | QQQ | ETF | 458.18 | 458.43 | 458.1455 | 458.35 | 40568.0 |
| 2024-09-10 18:00:00 | QQQ | ETF | 458.3 | 458.4 | 457.99 | 458.4 | 28563.0 |
| 2024-09-10 19:00:00 | QQQ | ETF | 458.38 | 458.6499 | 457.88 | 458.2 | 36844.0 |
| 2024-09-10 04:00:00 | IWM | ETF | 208.57 | 208.77 | 208.17 | 208.22 | 5914.0 |
| 2024-09-10 05:00:00 | IWM | ETF | 208.0 | 208.4 | 207.56 | 208.14 | 6568.0 |
| 2024-09-10 06:00:00 | IWM | ETF | 208.2 | 208.25 | 207.91 | 207.91 | 3798.0 |
| 2024-09-10 07:00:00 | IWM | ETF | 207.98 | 208.66 | 207.91 | 208.66 | 22474.0 |
| 2024-09-10 08:00:00 | IWM | ETF | 208.2309 | 209.02 | 207.67 | 208.88 | 135429.0 |
| 2024-09-10 09:00:00 | IWM | ETF | 208.831 | 208.9 | 207.589 | 207.75 | 1940437.0 |
| 2024-09-10 10:00:00 | IWM | ETF | 207.75 | 207.83 | 206.58 | 207.37 | 3516564.0 |
| 2024-09-10 11:00:00 | IWM | ETF | 207.365 | 208.0 | 206.231 | 206.24 | 1758472.0 |
| 2024-09-10 12:00:00 | IWM | ETF | 206.265 | 206.57 | 205.791 | 206.23 | 1518527.0 |
| 2024-09-10 13:00:00 | IWM | ETF | 206.22 | 206.98 | 206.16 | 206.95 | 1280938.0 |
| 2024-09-10 14:00:00 | IWM | ETF | 206.97 | 208.24 | 206.94 | 208.055 | 1864779.0 |
| 2024-09-10 15:00:00 | IWM | ETF | 208.06 | 208.49 | 207.69 | 208.34 | 3800960.0 |
| 2024-09-10 16:00:00 | IWM | ETF | 208.31 | 208.505 | 207.5385 | 208.28 | 1297745.0 |
| 2024-09-10 17:00:00 | IWM | ETF | 208.18 | 208.31 | 208.13 | 208.25 | 23895.0 |
| 2024-09-10 18:00:00 | IWM | ETF | 208.25 | 208.31 | 208.11 | 208.17 | 14619.0 |
| 2024-09-10 19:00:00 | IWM | ETF | 208.2 | 208.31 | 207.95 | 208.17 | 25340.0 |
| 2024-09-10 04:00:00 | DIA | ETF | 409.5 | 409.5 | 409.15 | 409.15 | 350.0 |
| 2024-09-10 05:00:00 | DIA | ETF | 408.58 | 408.58 | 408.23 | 408.23 | 200.0 |
> showing 50 of 20,346 rows — these rows as CSV