PREVIEW / etf_30min / 2025-02-20
file: by_date/etf_30min/2025/2025-02-20.parquet size: 939 KB rows: 38,442
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 |
|---|---|---|---|---|---|---|---|
| 2025-02-20 04:00:00 | SPY | ETF | 611.45 | 611.73 | 611.42 | 611.62 | 5485.0 |
| 2025-02-20 04:30:00 | SPY | ETF | 611.76 | 612.0 | 611.74 | 611.98 | 3820.0 |
| 2025-02-20 05:00:00 | SPY | ETF | 611.95 | 612.15 | 611.92 | 612.04 | 2475.0 |
| 2025-02-20 05:30:00 | SPY | ETF | 612.06 | 612.12 | 611.88 | 611.89 | 2023.0 |
| 2025-02-20 06:00:00 | SPY | ETF | 611.82 | 611.88 | 611.57 | 611.57 | 2417.0 |
| 2025-02-20 06:30:00 | SPY | ETF | 611.52 | 611.71 | 611.04 | 611.09 | 71465.0 |
| 2025-02-20 07:00:00 | SPY | ETF | 611.15 | 611.51 | 610.89 | 611.06 | 64842.0 |
| 2025-02-20 07:30:00 | SPY | ETF | 611.15 | 611.559 | 611.11 | 611.53 | 36939.0 |
| 2025-02-20 08:00:00 | SPY | ETF | 611.39 | 611.56 | 610.92 | 611.16 | 77099.0 |
| 2025-02-20 08:30:00 | SPY | ETF | 611.2 | 611.52 | 611.08 | 611.12 | 82098.0 |
| 2025-02-20 09:00:00 | SPY | ETF | 611.41 | 611.75 | 611.34 | 611.59 | 159746.0 |
| 2025-02-20 09:30:00 | SPY | ETF | 611.55 | 611.684 | 608.31 | 608.3825 | 2838833.0 |
| 2025-02-20 10:00:00 | SPY | ETF | 608.4 | 609.36 | 607.02 | 609.11 | 2944575.0 |
| 2025-02-20 10:30:00 | SPY | ETF | 609.1 | 609.52 | 607.08 | 607.35 | 1483281.0 |
| 2025-02-20 11:00:00 | SPY | ETF | 607.35 | 608.45 | 607.23 | 608.26 | 1360515.0 |
| 2025-02-20 11:30:00 | SPY | ETF | 608.255 | 608.42 | 607.1 | 607.46 | 1040070.0 |
| 2025-02-20 12:00:00 | SPY | ETF | 607.45 | 608.9399 | 607.28 | 608.79 | 1146223.0 |
| 2025-02-20 12:30:00 | SPY | ETF | 608.78 | 609.0999 | 608.025 | 608.03 | 718953.0 |
| 2025-02-20 13:00:00 | SPY | ETF | 608.03 | 608.49 | 607.64 | 607.96 | 1064399.0 |
| 2025-02-20 13:30:00 | SPY | ETF | 607.94 | 608.76 | 607.82 | 608.6 | 686715.0 |
| 2025-02-20 14:00:00 | SPY | ETF | 608.6 | 609.49 | 608.5 | 609.17 | 1179367.0 |
| 2025-02-20 14:30:00 | SPY | ETF | 609.16 | 610.1 | 608.72 | 609.86 | 1281716.0 |
| 2025-02-20 15:00:00 | SPY | ETF | 609.865 | 610.0987 | 609.26 | 609.84 | 1232708.0 |
| 2025-02-20 15:30:00 | SPY | ETF | 609.84 | 610.7 | 609.4625 | 610.39 | 4272784.0 |
| 2025-02-20 16:00:00 | SPY | ETF | 610.39 | 610.5 | 609.77 | 610.0194 | 2020837.0 |
| 2025-02-20 16:30:00 | SPY | ETF | 610.0 | 610.08 | 609.85 | 610.0 | 65280.0 |
| 2025-02-20 17:00:00 | SPY | ETF | 610.07 | 610.07 | 609.97 | 609.97 | 12570.0 |
| 2025-02-20 17:30:00 | SPY | ETF | 609.97 | 610.0 | 609.83 | 609.9 | 5965.0 |
| 2025-02-20 18:00:00 | SPY | ETF | 609.9 | 610.38 | 609.9 | 610.2 | 19374.0 |
| 2025-02-20 18:30:00 | SPY | ETF | 610.379 | 610.6 | 610.36 | 610.43 | 17108.0 |
| 2025-02-20 19:00:00 | SPY | ETF | 610.35 | 610.53 | 610.32 | 610.36 | 8210.0 |
| 2025-02-20 19:30:00 | SPY | ETF | 610.4 | 610.41 | 610.23 | 610.37 | 6286.0 |
| 2025-02-20 20:00:00 | SPY | ETF | 610.39 | 610.39 | 610.39 | 610.39 | 300.0 |
| 2025-02-20 04:00:00 | QQQ | ETF | 538.05 | 538.3 | 537.93 | 538.26 | 15045.0 |
| 2025-02-20 04:30:00 | QQQ | ETF | 538.28 | 538.56 | 538.05 | 538.54 | 7634.0 |
| 2025-02-20 05:00:00 | QQQ | ETF | 538.65 | 538.9 | 538.63 | 538.8 | 9518.0 |
| 2025-02-20 05:30:00 | QQQ | ETF | 538.79 | 538.86 | 538.59 | 538.65 | 6176.0 |
| 2025-02-20 06:00:00 | QQQ | ETF | 538.62 | 538.68 | 538.27 | 538.29 | 13838.0 |
| 2025-02-20 06:30:00 | QQQ | ETF | 538.31 | 538.7 | 537.93 | 538.17 | 20729.0 |
| 2025-02-20 07:00:00 | QQQ | ETF | 538.19 | 538.51 | 537.9 | 538.19 | 46840.0 |
| 2025-02-20 07:30:00 | QQQ | ETF | 538.23 | 538.74 | 538.2 | 538.74 | 26518.0 |
| 2025-02-20 08:00:00 | QQQ | ETF | 538.0 | 538.83 | 537.15 | 538.3091 | 71708.0 |
| 2025-02-20 08:30:00 | QQQ | ETF | 538.32 | 538.68 | 538.23 | 538.56 | 95212.0 |
| 2025-02-20 09:00:00 | QQQ | ETF | 538.62 | 539.03 | 538.56 | 538.85 | 163983.0 |
| 2025-02-20 09:30:00 | QQQ | ETF | 538.73 | 539.1 | 533.65 | 533.895 | 2711302.0 |
| 2025-02-20 10:00:00 | QQQ | ETF | 533.85 | 536.1 | 532.46 | 535.76 | 2759059.0 |
| 2025-02-20 10:30:00 | QQQ | ETF | 535.75 | 536.22 | 533.08 | 533.41 | 1375244.0 |
| 2025-02-20 11:00:00 | QQQ | ETF | 533.4599 | 535.4802 | 533.27 | 535.05 | 1074786.0 |
| 2025-02-20 11:30:00 | QQQ | ETF | 535.14 | 535.36 | 534.07 | 534.38 | 839865.0 |
| 2025-02-20 12:00:00 | QQQ | ETF | 534.36 | 535.78 | 534.25 | 535.56 | 668949.0 |
> showing 50 of 38,442 rows — these rows as CSV