PREVIEW / etf_1hour / 2024-10-01
file: by_date/etf_1hour/2024/2024-10-01.parquet size: 586 KB rows: 22,004
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-10-01 04:00:00 | SPY | ETF | 573.5 | 573.81 | 573.12 | 573.16 | 14659.0 |
| 2024-10-01 05:00:00 | SPY | ETF | 573.17 | 573.41 | 573.0 | 573.41 | 11461.0 |
| 2024-10-01 06:00:00 | SPY | ETF | 573.33 | 574.27 | 573.33 | 574.16 | 94024.0 |
| 2024-10-01 07:00:00 | SPY | ETF | 574.15 | 574.38 | 573.34 | 573.62 | 97446.0 |
| 2024-10-01 08:00:00 | SPY | ETF | 574.25 | 574.352 | 572.88 | 573.53 | 81699.0 |
| 2024-10-01 09:00:00 | SPY | ETF | 573.51 | 573.69 | 568.53 | 569.56 | 7637850.0 |
| 2024-10-01 10:00:00 | SPY | ETF | 569.5 | 570.32 | 566.61 | 568.03 | 9932675.0 |
| 2024-10-01 11:00:00 | SPY | ETF | 568.05 | 569.47 | 566.0 | 568.37 | 6958537.0 |
| 2024-10-01 12:00:00 | SPY | ETF | 568.3202 | 569.6 | 566.57 | 568.37 | 5780899.0 |
| 2024-10-01 13:00:00 | SPY | ETF | 568.3486 | 569.37 | 566.27 | 569.34 | 7030891.0 |
| 2024-10-01 14:00:00 | SPY | ETF | 569.32 | 570.93 | 569.28 | 570.4 | 5354634.0 |
| 2024-10-01 15:00:00 | SPY | ETF | 570.38 | 570.49 | 568.38 | 568.69 | 7203606.0 |
| 2024-10-01 16:00:00 | SPY | ETF | 568.69 | 569.33 | 568.4 | 568.45 | 2614201.0 |
| 2024-10-01 17:00:00 | SPY | ETF | 568.42 | 568.69 | 568.4 | 568.69 | 49115.0 |
| 2024-10-01 18:00:00 | SPY | ETF | 568.73 | 568.98 | 567.19 | 567.64 | 197865.0 |
| 2024-10-01 19:00:00 | SPY | ETF | 567.47 | 568.07 | 566.98 | 567.76 | 234081.0 |
| 2024-10-01 04:00:00 | QQQ | ETF | 487.75 | 488.78 | 487.75 | 488.1 | 14450.0 |
| 2024-10-01 05:00:00 | QQQ | ETF | 488.04 | 488.33 | 487.78 | 488.33 | 13550.0 |
| 2024-10-01 06:00:00 | QQQ | ETF | 488.3 | 489.24 | 488.23 | 489.17 | 33548.0 |
| 2024-10-01 07:00:00 | QQQ | ETF | 489.15 | 489.36 | 487.8 | 488.1 | 94431.0 |
| 2024-10-01 08:00:00 | QQQ | ETF | 489.12 | 489.35 | 487.0 | 488.1613 | 108531.0 |
| 2024-10-01 09:00:00 | QQQ | ETF | 488.199 | 488.32 | 481.25 | 482.74 | 5523389.0 |
| 2024-10-01 10:00:00 | QQQ | ETF | 482.74 | 483.59 | 478.57 | 479.94 | 6455893.0 |
| 2024-10-01 11:00:00 | QQQ | ETF | 479.98 | 481.12 | 477.4 | 479.87 | 3863753.0 |
| 2024-10-01 12:00:00 | QQQ | ETF | 479.83 | 481.62 | 478.22 | 480.1499 | 3456859.0 |
| 2024-10-01 13:00:00 | QQQ | ETF | 480.11 | 481.7 | 478.01 | 481.69 | 3958243.0 |
| 2024-10-01 14:00:00 | QQQ | ETF | 481.63 | 483.57 | 481.62 | 482.93 | 3486727.0 |
| 2024-10-01 15:00:00 | QQQ | ETF | 482.8825 | 483.19 | 480.59 | 481.17 | 3995502.0 |
| 2024-10-01 16:00:00 | QQQ | ETF | 481.17 | 482.08 | 480.59 | 480.8099 | 1338278.0 |
| 2024-10-01 17:00:00 | QQQ | ETF | 480.8 | 481.0 | 480.65 | 480.79 | 104615.0 |
| 2024-10-01 18:00:00 | QQQ | ETF | 480.92 | 481.27 | 479.42 | 479.73 | 169499.0 |
| 2024-10-01 19:00:00 | QQQ | ETF | 479.84 | 480.4 | 479.2 | 480.01 | 67537.0 |
| 2024-10-01 04:00:00 | IWM | ETF | 220.65 | 220.65 | 220.0 | 220.28 | 17901.0 |
| 2024-10-01 05:00:00 | IWM | ETF | 220.41 | 220.52 | 220.25 | 220.52 | 6348.0 |
| 2024-10-01 06:00:00 | IWM | ETF | 220.35 | 220.75 | 220.32 | 220.62 | 61808.0 |
| 2024-10-01 07:00:00 | IWM | ETF | 220.67 | 220.95 | 220.64 | 220.73 | 49871.0 |
| 2024-10-01 08:00:00 | IWM | ETF | 220.8899 | 220.94 | 220.0 | 220.67 | 35424.0 |
| 2024-10-01 09:00:00 | IWM | ETF | 220.65 | 220.65 | 217.42 | 218.13 | 3630912.0 |
| 2024-10-01 10:00:00 | IWM | ETF | 218.17 | 218.84 | 216.3 | 217.69 | 4562551.0 |
| 2024-10-01 11:00:00 | IWM | ETF | 217.7 | 218.21 | 216.47 | 217.5 | 2331895.0 |
| 2024-10-01 12:00:00 | IWM | ETF | 217.49 | 218.06 | 216.88 | 217.86 | 2158911.0 |
| 2024-10-01 13:00:00 | IWM | ETF | 217.87 | 218.0 | 216.51 | 217.99 | 2467835.0 |
| 2024-10-01 14:00:00 | IWM | ETF | 217.98 | 218.78 | 217.94 | 218.37 | 1921516.0 |
| 2024-10-01 15:00:00 | IWM | ETF | 218.36 | 218.46 | 217.44 | 217.87 | 3225513.0 |
| 2024-10-01 16:00:00 | IWM | ETF | 217.89 | 218.05 | 217.58 | 217.64 | 1954386.0 |
| 2024-10-01 17:00:00 | IWM | ETF | 217.62 | 217.89 | 217.52 | 217.82 | 452863.0 |
| 2024-10-01 18:00:00 | IWM | ETF | 217.78 | 217.89 | 217.11 | 217.21 | 23030.0 |
| 2024-10-01 19:00:00 | IWM | ETF | 217.26 | 217.39 | 216.95 | 217.224 | 18791.0 |
| 2024-10-01 04:00:00 | DIA | ETF | 422.16 | 422.16 | 422.0 | 422.0 | 200.0 |
| 2024-10-01 05:00:00 | DIA | ETF | 421.93 | 421.96 | 421.9 | 421.94 | 580.0 |
> showing 50 of 22,004 rows — these rows as CSV