PREVIEW / etf_1hour / 2024-11-21
file: by_date/etf_1hour/2024/2024-11-21.parquet size: 604 KB rows: 22,606
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-11-21 04:00:00 | SPY | ETF | 588.85 | 588.86 | 587.23 | 588.37 | 31531.0 |
| 2024-11-21 05:00:00 | SPY | ETF | 588.04 | 589.17 | 588.04 | 588.87 | 14224.0 |
| 2024-11-21 06:00:00 | SPY | ETF | 589.06 | 590.9 | 589.06 | 590.86 | 113575.0 |
| 2024-11-21 07:00:00 | SPY | ETF | 590.74 | 592.65 | 590.67 | 591.6 | 278967.0 |
| 2024-11-21 08:00:00 | SPY | ETF | 591.18 | 593.86 | 588.0 | 592.91 | 403325.0 |
| 2024-11-21 09:00:00 | SPY | ETF | 592.92 | 593.8 | 588.56 | 589.78 | 5048212.0 |
| 2024-11-21 10:00:00 | SPY | ETF | 589.74 | 591.85 | 587.45 | 591.68 | 5119787.0 |
| 2024-11-21 11:00:00 | SPY | ETF | 591.72 | 593.15 | 591.04 | 591.89 | 3269706.0 |
| 2024-11-21 12:00:00 | SPY | ETF | 591.89 | 594.17 | 591.08 | 593.71 | 3221768.0 |
| 2024-11-21 13:00:00 | SPY | ETF | 593.72 | 594.8 | 593.6368 | 594.43 | 2434993.0 |
| 2024-11-21 14:00:00 | SPY | ETF | 594.41 | 594.68 | 593.52 | 594.59 | 3533221.0 |
| 2024-11-21 15:00:00 | SPY | ETF | 594.58 | 595.12 | 593.56 | 593.61 | 6366493.0 |
| 2024-11-21 16:00:00 | SPY | ETF | 593.61 | 593.81 | 593.19 | 593.24 | 2301717.0 |
| 2024-11-21 17:00:00 | SPY | ETF | 593.25 | 593.6215 | 593.06 | 593.1 | 118416.0 |
| 2024-11-21 18:00:00 | SPY | ETF | 593.1 | 593.41 | 592.71 | 593.05 | 87930.0 |
| 2024-11-21 19:00:00 | SPY | ETF | 592.97 | 593.45 | 592.83 | 592.97 | 37746.0 |
| 2024-11-21 04:00:00 | QQQ | ETF | 501.4 | 501.46 | 499.55 | 500.79 | 100274.0 |
| 2024-11-21 05:00:00 | QQQ | ETF | 500.67 | 501.65 | 500.4 | 501.56 | 65243.0 |
| 2024-11-21 06:00:00 | QQQ | ETF | 501.54 | 503.0 | 501.54 | 502.81 | 252773.0 |
| 2024-11-21 07:00:00 | QQQ | ETF | 502.75 | 504.6 | 502.6 | 503.5 | 337385.0 |
| 2024-11-21 08:00:00 | QQQ | ETF | 502.61 | 506.18 | 500.0 | 505.48 | 494125.0 |
| 2024-11-21 09:00:00 | QQQ | ETF | 505.54 | 506.96 | 500.31 | 501.31 | 4819191.0 |
| 2024-11-21 10:00:00 | QQQ | ETF | 501.31 | 502.4199 | 497.56 | 502.2 | 6036823.0 |
| 2024-11-21 11:00:00 | QQQ | ETF | 502.22 | 504.2 | 501.76 | 502.77 | 2926286.0 |
| 2024-11-21 12:00:00 | QQQ | ETF | 502.8 | 505.77 | 501.95 | 504.8301 | 2709553.0 |
| 2024-11-21 13:00:00 | QQQ | ETF | 504.86 | 505.99 | 504.6901 | 505.79 | 1793741.0 |
| 2024-11-21 14:00:00 | QQQ | ETF | 505.78 | 506.06 | 504.2019 | 505.5601 | 2139055.0 |
| 2024-11-21 15:00:00 | QQQ | ETF | 505.54 | 506.34 | 504.86 | 504.98 | 3491420.0 |
| 2024-11-21 16:00:00 | QQQ | ETF | 504.97 | 505.13 | 504.2 | 504.26 | 981866.0 |
| 2024-11-21 17:00:00 | QQQ | ETF | 504.3001 | 505.04 | 504.21 | 504.2511 | 40328.0 |
| 2024-11-21 18:00:00 | QQQ | ETF | 504.25 | 504.53 | 503.46 | 503.84 | 76042.0 |
| 2024-11-21 19:00:00 | QQQ | ETF | 503.68 | 504.2 | 503.57 | 503.72 | 51040.0 |
| 2024-11-21 04:00:00 | IWM | ETF | 230.39 | 230.4 | 229.64 | 230.26 | 17495.0 |
| 2024-11-21 05:00:00 | IWM | ETF | 230.14 | 230.56 | 229.99 | 230.21 | 6342.0 |
| 2024-11-21 06:00:00 | IWM | ETF | 230.34 | 231.67 | 230.34 | 231.58 | 46937.0 |
| 2024-11-21 07:00:00 | IWM | ETF | 231.5 | 232.579 | 231.49 | 232.34 | 101266.0 |
| 2024-11-21 08:00:00 | IWM | ETF | 232.44 | 232.9095 | 230.0 | 232.43 | 196100.0 |
| 2024-11-21 09:00:00 | IWM | ETF | 232.44 | 232.76 | 231.11 | 232.22 | 2985996.0 |
| 2024-11-21 10:00:00 | IWM | ETF | 232.2 | 234.16 | 231.4501 | 233.88 | 3498952.0 |
| 2024-11-21 11:00:00 | IWM | ETF | 233.89 | 234.67 | 233.55 | 234.45 | 2563448.0 |
| 2024-11-21 12:00:00 | IWM | ETF | 234.455 | 235.305 | 234.04 | 234.93 | 1808278.0 |
| 2024-11-21 13:00:00 | IWM | ETF | 234.93 | 235.57 | 234.81 | 235.2432 | 1691907.0 |
| 2024-11-21 14:00:00 | IWM | ETF | 235.24 | 235.48 | 234.79 | 235.08 | 1778038.0 |
| 2024-11-21 15:00:00 | IWM | ETF | 235.07 | 235.5 | 234.5 | 234.51 | 4061500.0 |
| 2024-11-21 16:00:00 | IWM | ETF | 234.44 | 235.3591 | 234.22 | 234.34 | 2136769.0 |
| 2024-11-21 17:00:00 | IWM | ETF | 234.38 | 234.5 | 234.3 | 234.44 | 16665.0 |
| 2024-11-21 18:00:00 | IWM | ETF | 234.35 | 234.44 | 234.21 | 234.43 | 43048.0 |
| 2024-11-21 19:00:00 | IWM | ETF | 234.31 | 234.6 | 234.31 | 234.53 | 51238.0 |
| 2024-11-21 04:00:00 | DIA | ETF | 433.64 | 433.64 | 433.0 | 433.0 | 425.0 |
| 2024-11-21 05:00:00 | DIA | ETF | 434.0 | 434.0 | 433.86 | 433.86 | 400.0 |
> showing 50 of 22,606 rows — these rows as CSV