PREVIEW / etf_30min / 2025-02-12
file: by_date/etf_30min/2025/2025-02-12.parquet size: 960 KB rows: 38,656
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-12 04:00:00 | SPY | ETF | 604.89 | 604.89 | 603.68 | 604.1 | 17661.0 |
| 2025-02-12 04:30:00 | SPY | ETF | 604.12 | 604.4 | 604.12 | 604.25 | 13829.0 |
| 2025-02-12 05:00:00 | SPY | ETF | 604.24 | 604.49 | 604.01 | 604.49 | 27531.0 |
| 2025-02-12 05:30:00 | SPY | ETF | 604.45 | 604.69 | 604.3 | 604.64 | 10192.0 |
| 2025-02-12 06:00:00 | SPY | ETF | 604.58 | 604.66 | 604.54 | 604.66 | 4083.0 |
| 2025-02-12 06:30:00 | SPY | ETF | 604.61 | 604.67 | 604.6 | 604.66 | 1600.0 |
| 2025-02-12 07:00:00 | SPY | ETF | 604.65 | 604.94 | 604.62 | 604.88 | 40853.0 |
| 2025-02-12 07:30:00 | SPY | ETF | 604.93 | 605.4 | 604.87 | 605.34 | 56981.0 |
| 2025-02-12 08:00:00 | SPY | ETF | 604.66 | 605.72 | 604.1858 | 605.21 | 243170.0 |
| 2025-02-12 08:30:00 | SPY | ETF | 605.5 | 605.51 | 598.54 | 599.31 | 2297411.0 |
| 2025-02-12 09:00:00 | SPY | ETF | 599.22 | 599.61 | 598.231 | 599.23 | 527559.0 |
| 2025-02-12 09:30:00 | SPY | ETF | 599.23 | 601.68 | 598.51 | 601.355 | 4005990.0 |
| 2025-02-12 10:00:00 | SPY | ETF | 601.36 | 602.36 | 599.58 | 601.444 | 2468300.0 |
| 2025-02-12 10:30:00 | SPY | ETF | 601.44 | 603.32 | 601.41 | 602.43 | 1443357.0 |
| 2025-02-12 11:00:00 | SPY | ETF | 602.45 | 602.48 | 600.17 | 600.6599 | 1392247.0 |
| 2025-02-12 11:30:00 | SPY | ETF | 600.63 | 603.54 | 600.6 | 603.39 | 1495770.0 |
| 2025-02-12 12:00:00 | SPY | ETF | 603.41 | 603.99 | 602.84 | 603.79 | 1891453.0 |
| 2025-02-12 12:30:00 | SPY | ETF | 603.78 | 604.53 | 603.09 | 604.39 | 916604.0 |
| 2025-02-12 13:00:00 | SPY | ETF | 604.4 | 604.55 | 603.12 | 603.57 | 759557.0 |
| 2025-02-12 13:30:00 | SPY | ETF | 603.5899 | 603.7599 | 602.92 | 603.21 | 861184.0 |
| 2025-02-12 14:00:00 | SPY | ETF | 603.22 | 603.31 | 602.53 | 603.08 | 1262510.0 |
| 2025-02-12 14:30:00 | SPY | ETF | 603.06 | 604.23 | 603.06 | 603.9 | 1554465.0 |
| 2025-02-12 15:00:00 | SPY | ETF | 603.9 | 604.05 | 603.31 | 603.32 | 1668962.0 |
| 2025-02-12 15:30:00 | SPY | ETF | 603.325 | 603.59 | 602.57 | 603.36 | 3272649.0 |
| 2025-02-12 16:00:00 | SPY | ETF | 603.36 | 604.0 | 602.99 | 603.51 | 2189638.0 |
| 2025-02-12 16:30:00 | SPY | ETF | 603.49 | 604.1 | 603.46 | 604.04 | 80984.0 |
| 2025-02-12 17:00:00 | SPY | ETF | 604.0 | 604.03 | 603.92 | 604.02 | 25849.0 |
| 2025-02-12 17:30:00 | SPY | ETF | 604.01 | 604.1 | 603.98 | 603.99 | 13222.0 |
| 2025-02-12 18:00:00 | SPY | ETF | 603.99 | 604.09 | 603.76 | 603.9 | 38595.0 |
| 2025-02-12 18:30:00 | SPY | ETF | 603.88 | 604.58 | 603.8004 | 604.4104 | 19260.0 |
| 2025-02-12 19:00:00 | SPY | ETF | 604.5 | 604.5 | 604.2 | 604.35 | 14524.0 |
| 2025-02-12 19:30:00 | SPY | ETF | 604.35 | 604.689 | 604.35 | 604.59 | 38302.0 |
| 2025-02-12 04:00:00 | QQQ | ETF | 528.24 | 528.24 | 526.76 | 527.15 | 39036.0 |
| 2025-02-12 04:30:00 | QQQ | ETF | 527.18 | 527.66 | 527.18 | 527.49 | 20500.0 |
| 2025-02-12 05:00:00 | QQQ | ETF | 527.47 | 527.71 | 527.25 | 527.71 | 32181.0 |
| 2025-02-12 05:30:00 | QQQ | ETF | 527.75 | 528.04 | 527.62 | 527.87 | 8028.0 |
| 2025-02-12 06:00:00 | QQQ | ETF | 528.0 | 528.25 | 527.57 | 527.95 | 5161.0 |
| 2025-02-12 06:30:00 | QQQ | ETF | 527.95 | 528.12 | 527.85 | 527.95 | 5509.0 |
| 2025-02-12 07:00:00 | QQQ | ETF | 528.0 | 528.5 | 527.98 | 528.37 | 67942.0 |
| 2025-02-12 07:30:00 | QQQ | ETF | 528.43 | 529.08 | 528.4 | 528.95 | 46056.0 |
| 2025-02-12 08:00:00 | QQQ | ETF | 527.3958 | 529.4 | 527.163 | 528.83 | 234886.0 |
| 2025-02-12 08:30:00 | QQQ | ETF | 529.2 | 529.2 | 521.42 | 522.1 | 1474703.0 |
| 2025-02-12 09:00:00 | QQQ | ETF | 522.12 | 522.57 | 521.32 | 522.33 | 489331.0 |
| 2025-02-12 09:30:00 | QQQ | ETF | 522.29 | 525.8742 | 521.95 | 525.3 | 2805038.0 |
| 2025-02-12 10:00:00 | QQQ | ETF | 525.32 | 526.76 | 523.0 | 525.75 | 1991293.0 |
| 2025-02-12 10:30:00 | QQQ | ETF | 525.79 | 527.61 | 525.53 | 526.5697 | 1162551.0 |
| 2025-02-12 11:00:00 | QQQ | ETF | 526.57 | 526.6546 | 524.6 | 525.0352 | 975807.0 |
| 2025-02-12 11:30:00 | QQQ | ETF | 525.0 | 527.88 | 524.9701 | 527.771 | 956666.0 |
| 2025-02-12 12:00:00 | QQQ | ETF | 527.77 | 528.36 | 527.47 | 527.97 | 1145983.0 |
| 2025-02-12 12:30:00 | QQQ | ETF | 527.96 | 528.89 | 527.22 | 528.71 | 752285.0 |
> showing 50 of 38,656 rows — these rows as CSV