PREVIEW / etf_1hour / 2024-02-29
file: by_date/etf_1hour/2024/2024-02-29.parquet size: 536 KB rows: 19,942
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-02-29 04:00:00 | SPY | ETF | 505.2 | 505.25 | 504.64 | 505.12 | 25734.0 |
| 2024-02-29 05:00:00 | SPY | ETF | 505.15 | 505.29 | 504.8 | 504.98 | 91309.0 |
| 2024-02-29 06:00:00 | SPY | ETF | 504.91 | 505.46 | 504.91 | 505.43 | 16656.0 |
| 2024-02-29 07:00:00 | SPY | ETF | 505.4 | 505.4 | 504.85 | 505.08 | 61779.0 |
| 2024-02-29 08:00:00 | SPY | ETF | 505.49 | 508.11 | 504.5 | 507.83 | 992035.0 |
| 2024-02-29 09:00:00 | SPY | ETF | 507.87 | 508.8455 | 507.86 | 508.49 | 4657403.0 |
| 2024-02-29 10:00:00 | SPY | ETF | 508.51 | 508.75 | 506.81 | 507.454 | 9465023.0 |
| 2024-02-29 11:00:00 | SPY | ETF | 507.445 | 507.7299 | 505.35 | 506.65 | 5849501.0 |
| 2024-02-29 12:00:00 | SPY | ETF | 506.65 | 507.43 | 506.505 | 507.375 | 3804963.0 |
| 2024-02-29 13:00:00 | SPY | ETF | 507.36 | 507.9 | 507.3588 | 507.8 | 3535432.0 |
| 2024-02-29 14:00:00 | SPY | ETF | 507.81 | 508.29 | 507.164 | 507.75 | 4556076.0 |
| 2024-02-29 15:00:00 | SPY | ETF | 507.75 | 509.74 | 507.65 | 508.0 | 21051775.0 |
| 2024-02-29 16:00:00 | SPY | ETF | 508.0 | 508.8013 | 507.67 | 508.4 | 7326207.0 |
| 2024-02-29 17:00:00 | SPY | ETF | 508.53 | 508.56 | 508.27 | 508.55 | 85776.0 |
| 2024-02-29 18:00:00 | SPY | ETF | 508.55 | 508.75 | 507.7801 | 508.05 | 115668.0 |
| 2024-02-29 19:00:00 | SPY | ETF | 508.09 | 508.58 | 508.09 | 508.58 | 35380.0 |
| 2024-02-29 04:00:00 | QQQ | ETF | 434.6 | 434.6 | 433.84 | 434.35 | 39375.0 |
| 2024-02-29 05:00:00 | QQQ | ETF | 434.38 | 434.54 | 434.21 | 434.37 | 19326.0 |
| 2024-02-29 06:00:00 | QQQ | ETF | 434.44 | 434.84 | 434.44 | 434.8 | 13521.0 |
| 2024-02-29 07:00:00 | QQQ | ETF | 434.8 | 434.85 | 434.11 | 434.36 | 68335.0 |
| 2024-02-29 08:00:00 | QQQ | ETF | 434.5 | 438.12 | 433.36 | 437.63 | 1227665.0 |
| 2024-02-29 09:00:00 | QQQ | ETF | 437.68 | 439.27 | 437.67 | 438.78 | 4905228.0 |
| 2024-02-29 10:00:00 | QQQ | ETF | 438.78 | 439.16 | 437.02 | 437.585 | 4956732.0 |
| 2024-02-29 11:00:00 | QQQ | ETF | 437.59 | 437.83 | 435.02 | 437.09 | 4703331.0 |
| 2024-02-29 12:00:00 | QQQ | ETF | 437.08 | 438.04 | 436.72 | 437.96 | 3478170.0 |
| 2024-02-29 13:00:00 | QQQ | ETF | 437.96 | 438.67 | 437.92 | 438.375 | 2555326.0 |
| 2024-02-29 14:00:00 | QQQ | ETF | 438.36 | 438.875 | 437.64 | 438.37 | 2697100.0 |
| 2024-02-29 15:00:00 | QQQ | ETF | 438.36 | 440.09 | 437.95 | 439.09 | 6831458.0 |
| 2024-02-29 16:00:00 | QQQ | ETF | 439.09 | 439.42 | 438.37 | 439.17 | 1972421.0 |
| 2024-02-29 17:00:00 | QQQ | ETF | 439.17 | 439.28 | 439.0 | 439.2 | 87401.0 |
| 2024-02-29 18:00:00 | QQQ | ETF | 439.2 | 439.44 | 438.59 | 438.88 | 131173.0 |
| 2024-02-29 19:00:00 | QQQ | ETF | 438.97 | 439.49 | 438.97 | 439.48 | 65167.0 |
| 2024-02-29 04:00:00 | IWM | ETF | 203.09 | 203.09 | 202.06 | 202.83 | 26653.0 |
| 2024-02-29 05:00:00 | IWM | ETF | 202.9 | 202.9 | 202.63 | 202.66 | 12834.0 |
| 2024-02-29 06:00:00 | IWM | ETF | 202.9 | 203.16 | 202.8 | 203.04 | 34673.0 |
| 2024-02-29 07:00:00 | IWM | ETF | 203.0 | 203.13 | 202.67 | 202.69 | 48627.0 |
| 2024-02-29 08:00:00 | IWM | ETF | 203.0112 | 205.72 | 201.9 | 205.44 | 1432106.0 |
| 2024-02-29 09:00:00 | IWM | ETF | 205.46 | 206.39 | 204.89 | 205.435 | 4530107.0 |
| 2024-02-29 10:00:00 | IWM | ETF | 205.42 | 206.04 | 204.03 | 204.14 | 5695503.0 |
| 2024-02-29 11:00:00 | IWM | ETF | 204.14 | 204.4 | 202.52 | 203.445 | 5628590.0 |
| 2024-02-29 12:00:00 | IWM | ETF | 203.44 | 203.74 | 202.92 | 203.61 | 3157523.0 |
| 2024-02-29 13:00:00 | IWM | ETF | 203.61 | 203.84 | 203.47 | 203.83 | 2212519.0 |
| 2024-02-29 14:00:00 | IWM | ETF | 203.83 | 203.95 | 203.1 | 203.37 | 2622069.0 |
| 2024-02-29 15:00:00 | IWM | ETF | 203.38 | 204.34 | 203.365 | 203.63 | 6200710.0 |
| 2024-02-29 16:00:00 | IWM | ETF | 203.73 | 203.83 | 203.26 | 203.46 | 1735887.0 |
| 2024-02-29 17:00:00 | IWM | ETF | 203.49 | 203.65 | 203.34 | 203.64 | 36084.0 |
| 2024-02-29 18:00:00 | IWM | ETF | 203.59 | 203.69 | 203.13 | 203.29 | 45585.0 |
| 2024-02-29 19:00:00 | IWM | ETF | 203.48 | 203.65 | 203.4 | 203.65 | 16744.0 |
| 2024-02-29 04:00:00 | DIA | ETF | 388.62 | 388.62 | 388.54 | 388.6 | 1886.0 |
| 2024-02-29 05:00:00 | DIA | ETF | 388.59 | 388.59 | 388.59 | 388.59 | 379.0 |
> showing 50 of 19,942 rows — these rows as CSV