PREVIEW / etf_30min / 2025-02-13
file: by_date/etf_30min/2025/2025-02-13.parquet size: 957 KB rows: 38,357
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-13 04:00:00 | SPY | ETF | 602.44 | 603.08 | 601.65 | 603.05 | 13764.0 |
| 2025-02-13 04:30:00 | SPY | ETF | 603.08 | 603.42 | 603.02 | 603.32 | 19342.0 |
| 2025-02-13 05:00:00 | SPY | ETF | 603.42 | 603.48 | 603.0 | 603.23 | 4507.0 |
| 2025-02-13 05:30:00 | SPY | ETF | 603.18 | 603.6 | 603.18 | 603.44 | 4682.0 |
| 2025-02-13 06:00:00 | SPY | ETF | 603.53 | 603.91 | 603.48 | 603.91 | 3602.0 |
| 2025-02-13 06:30:00 | SPY | ETF | 603.88 | 603.9 | 602.79 | 603.4 | 57494.0 |
| 2025-02-13 07:00:00 | SPY | ETF | 603.32 | 603.49 | 602.75 | 603.15 | 61464.0 |
| 2025-02-13 07:30:00 | SPY | ETF | 603.24 | 603.34 | 602.72 | 603.17 | 44450.0 |
| 2025-02-13 08:00:00 | SPY | ETF | 603.28 | 604.99 | 602.0 | 603.21 | 111326.0 |
| 2025-02-13 08:30:00 | SPY | ETF | 603.37 | 604.84 | 602.52 | 604.62 | 586149.0 |
| 2025-02-13 09:00:00 | SPY | ETF | 604.5904 | 604.73 | 604.18 | 604.55 | 152636.0 |
| 2025-02-13 09:30:00 | SPY | ETF | 604.48 | 605.06 | 603.2 | 604.83 | 2602130.0 |
| 2025-02-13 10:00:00 | SPY | ETF | 604.82 | 606.4199 | 604.21 | 606.08 | 2557311.0 |
| 2025-02-13 10:30:00 | SPY | ETF | 606.0849 | 607.49 | 606.0 | 607.09 | 1741039.0 |
| 2025-02-13 11:00:00 | SPY | ETF | 607.09 | 607.48 | 606.61 | 606.69 | 933724.0 |
| 2025-02-13 11:30:00 | SPY | ETF | 606.7 | 606.96 | 605.75 | 606.1 | 1067311.0 |
| 2025-02-13 12:00:00 | SPY | ETF | 606.1 | 606.695 | 605.72 | 606.54 | 718644.0 |
| 2025-02-13 12:30:00 | SPY | ETF | 606.54 | 606.97 | 605.795 | 606.1829 | 709644.0 |
| 2025-02-13 13:00:00 | SPY | ETF | 606.17 | 606.44 | 604.99 | 606.2 | 949735.0 |
| 2025-02-13 13:30:00 | SPY | ETF | 606.2 | 607.25 | 605.31 | 607.19 | 1905432.0 |
| 2025-02-13 14:00:00 | SPY | ETF | 607.19 | 608.41 | 607.03 | 608.28 | 2471705.0 |
| 2025-02-13 14:30:00 | SPY | ETF | 608.28 | 609.29 | 608.1422 | 608.9 | 2401837.0 |
| 2025-02-13 15:00:00 | SPY | ETF | 608.895 | 609.71 | 608.82 | 609.5799 | 2562953.0 |
| 2025-02-13 15:30:00 | SPY | ETF | 609.57 | 609.94 | 609.09 | 609.69 | 6251354.0 |
| 2025-02-13 16:00:00 | SPY | ETF | 609.67 | 609.92 | 609.24 | 609.39 | 2904774.0 |
| 2025-02-13 16:30:00 | SPY | ETF | 609.38 | 609.72 | 609.36 | 609.4 | 86127.0 |
| 2025-02-13 17:00:00 | SPY | ETF | 609.4 | 609.43 | 609.26 | 609.42 | 22526.0 |
| 2025-02-13 17:30:00 | SPY | ETF | 609.42 | 609.486 | 609.2 | 609.34 | 23019.0 |
| 2025-02-13 18:00:00 | SPY | ETF | 609.36 | 609.81 | 609.36 | 609.73 | 34333.0 |
| 2025-02-13 18:30:00 | SPY | ETF | 609.64 | 609.64 | 609.37 | 609.5 | 16508.0 |
| 2025-02-13 19:00:00 | SPY | ETF | 609.58 | 609.77 | 609.38 | 609.77 | 15331.0 |
| 2025-02-13 19:30:00 | SPY | ETF | 609.74 | 609.74 | 609.59 | 609.65 | 13284.0 |
| 2025-02-13 04:00:00 | QQQ | ETF | 529.88 | 529.88 | 527.22 | 529.06 | 52874.0 |
| 2025-02-13 04:30:00 | QQQ | ETF | 529.03 | 529.29 | 528.9 | 529.11 | 26808.0 |
| 2025-02-13 05:00:00 | QQQ | ETF | 529.16 | 529.19 | 528.61 | 528.92 | 13200.0 |
| 2025-02-13 05:30:00 | QQQ | ETF | 528.9 | 529.43 | 528.77 | 529.29 | 13050.0 |
| 2025-02-13 06:00:00 | QQQ | ETF | 529.21 | 529.75 | 529.16 | 529.7 | 5041.0 |
| 2025-02-13 06:30:00 | QQQ | ETF | 529.66 | 529.73 | 528.35 | 529.0 | 42362.0 |
| 2025-02-13 07:00:00 | QQQ | ETF | 528.92 | 529.1 | 528.15 | 528.71 | 80240.0 |
| 2025-02-13 07:30:00 | QQQ | ETF | 528.75 | 528.98 | 528.36 | 528.86 | 25031.0 |
| 2025-02-13 08:00:00 | QQQ | ETF | 528.34 | 531.17 | 527.349 | 529.0 | 171090.0 |
| 2025-02-13 08:30:00 | QQQ | ETF | 529.35 | 530.69 | 528.08 | 530.24 | 322977.0 |
| 2025-02-13 09:00:00 | QQQ | ETF | 530.21 | 530.27 | 529.75 | 530.0 | 112411.0 |
| 2025-02-13 09:30:00 | QQQ | ETF | 529.98 | 531.9897 | 529.19 | 531.2347 | 2310272.0 |
| 2025-02-13 10:00:00 | QQQ | ETF | 531.22 | 533.06 | 530.22 | 532.538 | 1838885.0 |
| 2025-02-13 10:30:00 | QQQ | ETF | 532.53 | 534.57 | 532.45 | 534.09 | 1729202.0 |
| 2025-02-13 11:00:00 | QQQ | ETF | 534.0775 | 534.275 | 533.115 | 533.23 | 781045.0 |
| 2025-02-13 11:30:00 | QQQ | ETF | 533.25 | 533.48 | 531.78 | 532.26 | 962546.0 |
| 2025-02-13 12:00:00 | QQQ | ETF | 532.26 | 533.1175 | 531.8106 | 532.4 | 619233.0 |
| 2025-02-13 12:30:00 | QQQ | ETF | 532.4 | 533.16 | 531.92 | 532.3799 | 646883.0 |
> showing 50 of 38,357 rows — these rows as CSV