PREVIEW / etf_1hour / 2024-08-09
file: by_date/etf_1hour/2024/2024-08-09.parquet size: 546 KB rows: 20,048
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-08-09 04:00:00 | SPY | ETF | 531.69 | 533.14 | 531.36 | 532.94 | 51181.0 |
| 2024-08-09 05:00:00 | SPY | ETF | 533.0 | 533.07 | 532.0 | 532.54 | 15958.0 |
| 2024-08-09 06:00:00 | SPY | ETF | 532.22 | 532.22 | 531.36 | 531.49 | 65837.0 |
| 2024-08-09 07:00:00 | SPY | ETF | 531.57 | 532.39 | 530.15 | 530.84 | 335331.0 |
| 2024-08-09 08:00:00 | SPY | ETF | 531.69 | 532.9396 | 528.09 | 529.07 | 864334.0 |
| 2024-08-09 09:00:00 | SPY | ETF | 529.01 | 531.1101 | 528.56 | 529.27 | 4556582.0 |
| 2024-08-09 10:00:00 | SPY | ETF | 529.24 | 532.1599 | 528.8 | 531.5 | 5360733.0 |
| 2024-08-09 11:00:00 | SPY | ETF | 531.51 | 532.6499 | 530.12 | 530.302 | 3225941.0 |
| 2024-08-09 12:00:00 | SPY | ETF | 530.32 | 531.46 | 529.8 | 531.44 | 2175299.0 |
| 2024-08-09 13:00:00 | SPY | ETF | 531.44 | 534.51 | 531.31 | 532.5999 | 4010494.0 |
| 2024-08-09 14:00:00 | SPY | ETF | 532.62 | 532.96 | 531.47 | 532.4192 | 3268933.0 |
| 2024-08-09 15:00:00 | SPY | ETF | 532.38 | 533.41 | 531.88 | 532.91 | 7501790.0 |
| 2024-08-09 16:00:00 | SPY | ETF | 532.91 | 533.07 | 532.25 | 532.48 | 3840382.0 |
| 2024-08-09 17:00:00 | SPY | ETF | 532.32 | 532.74 | 532.32 | 532.55 | 115881.0 |
| 2024-08-09 18:00:00 | SPY | ETF | 532.65 | 532.97 | 532.5013 | 532.86 | 44828.0 |
| 2024-08-09 19:00:00 | SPY | ETF | 532.9016 | 533.08 | 532.86 | 532.99 | 35830.0 |
| 2024-08-09 04:00:00 | QQQ | ETF | 449.1 | 451.55 | 449.09 | 451.07 | 73270.0 |
| 2024-08-09 05:00:00 | QQQ | ETF | 451.37 | 451.37 | 449.98 | 450.71 | 72791.0 |
| 2024-08-09 06:00:00 | QQQ | ETF | 450.48 | 450.48 | 449.15 | 449.59 | 65514.0 |
| 2024-08-09 07:00:00 | QQQ | ETF | 449.68 | 450.25 | 447.69 | 448.55 | 317282.0 |
| 2024-08-09 08:00:00 | QQQ | ETF | 449.959 | 451.1496 | 445.09 | 446.14 | 793887.0 |
| 2024-08-09 09:00:00 | QQQ | ETF | 446.0 | 448.62 | 445.63 | 446.29 | 4241084.0 |
| 2024-08-09 10:00:00 | QQQ | ETF | 446.26 | 449.52 | 445.61 | 448.53 | 4289730.0 |
| 2024-08-09 11:00:00 | QQQ | ETF | 448.54 | 449.81 | 447.19 | 447.3901 | 2500665.0 |
| 2024-08-09 12:00:00 | QQQ | ETF | 447.41 | 448.62 | 446.84 | 448.6 | 2069721.0 |
| 2024-08-09 13:00:00 | QQQ | ETF | 448.6 | 452.06 | 448.41 | 450.49 | 3846756.0 |
| 2024-08-09 14:00:00 | QQQ | ETF | 450.52 | 450.97 | 449.42 | 450.15 | 2048234.0 |
| 2024-08-09 15:00:00 | QQQ | ETF | 450.15 | 451.09 | 449.5 | 450.53 | 4308243.0 |
| 2024-08-09 16:00:00 | QQQ | ETF | 450.54 | 450.81 | 450.11 | 450.29 | 1128014.0 |
| 2024-08-09 17:00:00 | QQQ | ETF | 450.21 | 450.9 | 450.21 | 450.52 | 38124.0 |
| 2024-08-09 18:00:00 | QQQ | ETF | 450.41 | 450.77 | 450.41 | 450.55 | 11685.0 |
| 2024-08-09 19:00:00 | QQQ | ETF | 450.5855 | 450.74 | 450.47 | 450.6 | 13327.0 |
| 2024-08-09 04:00:00 | IWM | ETF | 207.55 | 208.54 | 207.55 | 208.51 | 32704.0 |
| 2024-08-09 05:00:00 | IWM | ETF | 208.54 | 208.54 | 207.85 | 207.93 | 7358.0 |
| 2024-08-09 06:00:00 | IWM | ETF | 207.8 | 207.8 | 207.37 | 207.37 | 9209.0 |
| 2024-08-09 07:00:00 | IWM | ETF | 207.43 | 207.83 | 207.11 | 207.71 | 85880.0 |
| 2024-08-09 08:00:00 | IWM | ETF | 207.3909 | 208.4496 | 206.27 | 206.94 | 253242.0 |
| 2024-08-09 09:00:00 | IWM | ETF | 206.9 | 207.28 | 205.47 | 206.1174 | 2183689.0 |
| 2024-08-09 10:00:00 | IWM | ETF | 206.07 | 206.91 | 205.56 | 206.17 | 3003114.0 |
| 2024-08-09 11:00:00 | IWM | ETF | 206.17 | 206.88 | 205.27 | 205.394 | 1511145.0 |
| 2024-08-09 12:00:00 | IWM | ETF | 205.43 | 206.12 | 204.94 | 206.06 | 1402336.0 |
| 2024-08-09 13:00:00 | IWM | ETF | 206.0641 | 207.12 | 205.99 | 206.11 | 1553217.0 |
| 2024-08-09 14:00:00 | IWM | ETF | 206.13 | 206.66 | 205.82 | 206.32 | 1036202.0 |
| 2024-08-09 15:00:00 | IWM | ETF | 206.32 | 206.56 | 205.9294 | 206.41 | 2789316.0 |
| 2024-08-09 16:00:00 | IWM | ETF | 206.46 | 206.64 | 206.15 | 206.23 | 1338451.0 |
| 2024-08-09 17:00:00 | IWM | ETF | 206.18 | 206.46 | 206.15 | 206.26 | 54949.0 |
| 2024-08-09 18:00:00 | IWM | ETF | 206.2599 | 206.4 | 206.2599 | 206.39 | 1183.0 |
| 2024-08-09 19:00:00 | IWM | ETF | 206.38 | 206.45 | 206.31 | 206.45 | 1619.0 |
| 2024-08-09 04:00:00 | DIA | ETF | 395.0 | 395.56 | 395.0 | 395.56 | 1558.0 |
| 2024-08-09 05:00:00 | DIA | ETF | 395.69 | 395.69 | 395.44 | 395.44 | 866.0 |
> showing 50 of 20,048 rows — these rows as CSV