PREVIEW / etf_30min / 2024-05-24
file: by_date/etf_30min/2024/2024-05-24.parquet size: 774 KB rows: 30,541
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-05-24 04:00:00 | SPY | ETF | 526.64 | 526.93 | 526.64 | 526.85 | 6477.0 |
| 2024-05-24 04:30:00 | SPY | ETF | 526.91 | 527.36 | 526.91 | 527.29 | 3634.0 |
| 2024-05-24 05:00:00 | SPY | ETF | 527.14 | 527.29 | 527.03 | 527.11 | 5993.0 |
| 2024-05-24 05:30:00 | SPY | ETF | 527.15 | 527.16 | 526.95 | 526.95 | 1587.0 |
| 2024-05-24 06:00:00 | SPY | ETF | 527.14 | 527.32 | 527.14 | 527.24 | 2369.0 |
| 2024-05-24 06:30:00 | SPY | ETF | 527.31 | 527.48 | 527.28 | 527.42 | 3233.0 |
| 2024-05-24 07:00:00 | SPY | ETF | 527.35 | 527.5 | 526.55 | 527.26 | 180985.0 |
| 2024-05-24 07:30:00 | SPY | ETF | 527.33 | 527.6 | 527.15 | 527.57 | 42704.0 |
| 2024-05-24 08:00:00 | SPY | ETF | 527.37 | 527.64 | 526.16 | 527.1 | 177486.0 |
| 2024-05-24 08:30:00 | SPY | ETF | 526.98 | 527.91 | 526.96 | 527.44 | 160880.0 |
| 2024-05-24 09:00:00 | SPY | ETF | 527.49 | 527.96 | 527.23 | 527.85 | 154867.0 |
| 2024-05-24 09:30:00 | SPY | ETF | 527.85 | 528.095 | 526.881 | 527.202 | 3931244.0 |
| 2024-05-24 10:00:00 | SPY | ETF | 527.25 | 528.74 | 527.23 | 528.61 | 2073474.0 |
| 2024-05-24 10:30:00 | SPY | ETF | 528.6 | 529.12 | 527.84 | 529.03 | 1669059.0 |
| 2024-05-24 11:00:00 | SPY | ETF | 529.02 | 530.27 | 528.89 | 529.7 | 2794329.0 |
| 2024-05-24 11:30:00 | SPY | ETF | 529.71 | 530.054 | 529.0 | 529.45 | 1714370.0 |
| 2024-05-24 12:00:00 | SPY | ETF | 529.44 | 530.01 | 529.355 | 529.79 | 1134813.0 |
| 2024-05-24 12:30:00 | SPY | ETF | 529.78 | 529.8626 | 529.24 | 529.255 | 1265886.0 |
| 2024-05-24 13:00:00 | SPY | ETF | 529.26 | 529.87 | 529.06 | 529.6287 | 779689.0 |
| 2024-05-24 13:30:00 | SPY | ETF | 529.61 | 529.755 | 529.24 | 529.565 | 1345948.0 |
| 2024-05-24 14:00:00 | SPY | ETF | 529.53 | 530.1 | 529.36 | 529.4298 | 1383252.0 |
| 2024-05-24 14:30:00 | SPY | ETF | 529.43 | 529.61 | 529.06 | 529.0899 | 1146137.0 |
| 2024-05-24 15:00:00 | SPY | ETF | 529.08 | 529.13 | 528.28 | 528.93 | 1781135.0 |
| 2024-05-24 15:30:00 | SPY | ETF | 528.93 | 529.58 | 528.77 | 529.5 | 4260755.0 |
| 2024-05-24 16:00:00 | SPY | ETF | 529.51 | 529.69 | 529.36 | 529.5 | 2260896.0 |
| 2024-05-24 16:30:00 | SPY | ETF | 529.46 | 529.58 | 529.2141 | 529.44 | 223828.0 |
| 2024-05-24 17:00:00 | SPY | ETF | 529.4 | 529.55 | 529.37 | 529.55 | 26551.0 |
| 2024-05-24 17:30:00 | SPY | ETF | 529.55 | 529.6 | 529.44 | 529.5 | 668201.0 |
| 2024-05-24 18:00:00 | SPY | ETF | 529.6187 | 529.6332 | 529.5 | 529.59 | 2747.0 |
| 2024-05-24 18:30:00 | SPY | ETF | 529.48 | 529.55 | 529.48 | 529.5 | 5028.0 |
| 2024-05-24 19:00:00 | SPY | ETF | 529.53 | 529.56 | 529.44 | 529.44 | 8147.0 |
| 2024-05-24 19:30:00 | SPY | ETF | 529.44 | 529.6 | 529.36 | 529.38 | 10486.0 |
| 2024-05-24 04:00:00 | QQQ | ETF | 453.92 | 454.43 | 453.9 | 454.23 | 50645.0 |
| 2024-05-24 04:30:00 | QQQ | ETF | 454.28 | 454.9 | 454.28 | 454.73 | 20075.0 |
| 2024-05-24 05:00:00 | QQQ | ETF | 454.72 | 454.88 | 454.45 | 454.5 | 10186.0 |
| 2024-05-24 05:30:00 | QQQ | ETF | 454.7 | 454.7 | 454.41 | 454.57 | 4877.0 |
| 2024-05-24 06:00:00 | QQQ | ETF | 454.58 | 454.88 | 454.58 | 454.74 | 12062.0 |
| 2024-05-24 06:30:00 | QQQ | ETF | 454.77 | 455.08 | 454.7 | 455.04 | 6457.0 |
| 2024-05-24 07:00:00 | QQQ | ETF | 454.88 | 455.26 | 454.81 | 454.97 | 53725.0 |
| 2024-05-24 07:30:00 | QQQ | ETF | 454.95 | 455.28 | 454.74 | 455.26 | 23144.0 |
| 2024-05-24 08:00:00 | QQQ | ETF | 455.02 | 455.28 | 453.34 | 454.62 | 92316.0 |
| 2024-05-24 08:30:00 | QQQ | ETF | 454.55 | 455.54 | 454.45 | 455.03 | 95814.0 |
| 2024-05-24 09:00:00 | QQQ | ETF | 455.09 | 455.47 | 454.74 | 455.29 | 128473.0 |
| 2024-05-24 09:30:00 | QQQ | ETF | 455.28 | 455.89 | 454.58 | 455.01 | 2150973.0 |
| 2024-05-24 10:00:00 | QQQ | ETF | 455.05 | 457.11 | 455.05 | 457.0 | 1675428.0 |
| 2024-05-24 10:30:00 | QQQ | ETF | 457.0379 | 457.78 | 456.52 | 457.6704 | 1446726.0 |
| 2024-05-24 11:00:00 | QQQ | ETF | 457.68 | 459.06 | 457.61 | 458.605 | 1868723.0 |
| 2024-05-24 11:30:00 | QQQ | ETF | 458.61 | 458.96 | 458.0999 | 458.52 | 1433555.0 |
| 2024-05-24 12:00:00 | QQQ | ETF | 458.52 | 458.96 | 458.33 | 458.74 | 741479.0 |
| 2024-05-24 12:30:00 | QQQ | ETF | 458.755 | 458.85 | 458.2 | 458.22 | 906396.0 |
> showing 50 of 30,541 rows — these rows as CSV