PREVIEW / etf_30min / 2025-02-04
file: by_date/etf_30min/2025/2025-02-04.parquet size: 975 KB rows: 39,181
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-04 04:00:00 | SPY | ETF | 596.78 | 596.88 | 595.81 | 596.56 | 54165.0 |
| 2025-02-04 04:30:00 | SPY | ETF | 596.61 | 596.63 | 595.9 | 596.2 | 39055.0 |
| 2025-02-04 05:00:00 | SPY | ETF | 596.08 | 597.0 | 596.02 | 596.76 | 4530.0 |
| 2025-02-04 05:30:00 | SPY | ETF | 596.74 | 596.86 | 596.35 | 596.7 | 10013.0 |
| 2025-02-04 06:00:00 | SPY | ETF | 596.7 | 597.3 | 596.36 | 597.11 | 25143.0 |
| 2025-02-04 06:30:00 | SPY | ETF | 597.09 | 597.14 | 596.77 | 596.8 | 37340.0 |
| 2025-02-04 07:00:00 | SPY | ETF | 596.91 | 597.8 | 596.85 | 597.76 | 72842.0 |
| 2025-02-04 07:30:00 | SPY | ETF | 597.91 | 598.55 | 597.68 | 598.19 | 116499.0 |
| 2025-02-04 08:00:00 | SPY | ETF | 597.21 | 598.52 | 594.49 | 598.25 | 166397.0 |
| 2025-02-04 08:30:00 | SPY | ETF | 598.23 | 598.26 | 597.4 | 597.49 | 130660.0 |
| 2025-02-04 09:00:00 | SPY | ETF | 597.61 | 598.19 | 597.47 | 597.8 | 142010.0 |
| 2025-02-04 09:30:00 | SPY | ETF | 597.8 | 599.2 | 597.28 | 598.995 | 3151438.0 |
| 2025-02-04 10:00:00 | SPY | ETF | 598.9943 | 601.14 | 598.96 | 600.52 | 2124985.0 |
| 2025-02-04 10:30:00 | SPY | ETF | 600.55 | 601.26 | 600.11 | 600.33 | 1443181.0 |
| 2025-02-04 11:00:00 | SPY | ETF | 600.375 | 602.01 | 600.375 | 601.98 | 1081825.0 |
| 2025-02-04 11:30:00 | SPY | ETF | 601.96 | 602.09 | 600.79 | 601.37 | 1011993.0 |
| 2025-02-04 12:00:00 | SPY | ETF | 601.38 | 601.64 | 599.67 | 599.76 | 1351739.0 |
| 2025-02-04 12:30:00 | SPY | ETF | 599.82 | 601.03 | 599.4054 | 600.99 | 1048005.0 |
| 2025-02-04 13:00:00 | SPY | ETF | 600.98 | 601.25 | 600.11 | 601.13 | 642664.0 |
| 2025-02-04 13:30:00 | SPY | ETF | 601.12 | 601.259 | 600.71 | 600.725 | 469858.0 |
| 2025-02-04 14:00:00 | SPY | ETF | 600.7 | 602.14 | 600.57 | 601.86 | 938418.0 |
| 2025-02-04 14:30:00 | SPY | ETF | 601.88 | 602.3 | 600.84 | 601.48 | 1518581.0 |
| 2025-02-04 15:00:00 | SPY | ETF | 601.47 | 601.92 | 601.03 | 601.085 | 1483994.0 |
| 2025-02-04 15:30:00 | SPY | ETF | 601.085 | 602.27 | 600.97 | 601.76 | 4552254.0 |
| 2025-02-04 16:00:00 | SPY | ETF | 601.76 | 602.09 | 600.03 | 600.4 | 2979117.0 |
| 2025-02-04 16:30:00 | SPY | ETF | 600.27 | 600.5183 | 599.75 | 600.0783 | 135382.0 |
| 2025-02-04 17:00:00 | SPY | ETF | 600.01 | 600.08 | 599.88 | 600.04 | 194282.0 |
| 2025-02-04 17:30:00 | SPY | ETF | 600.11 | 600.18 | 599.57 | 599.6 | 36251.0 |
| 2025-02-04 18:00:00 | SPY | ETF | 599.8 | 600.2699 | 599.48 | 600.17 | 109853.0 |
| 2025-02-04 18:30:00 | SPY | ETF | 600.25 | 600.25 | 599.75 | 599.75 | 21203.0 |
| 2025-02-04 19:00:00 | SPY | ETF | 599.81 | 600.28 | 599.5119 | 600.23 | 14028.0 |
| 2025-02-04 19:30:00 | SPY | ETF | 600.26 | 600.72 | 600.26 | 600.4 | 47875.0 |
| 2025-02-04 04:00:00 | QQQ | ETF | 517.28 | 518.15 | 517.26 | 517.67 | 64889.0 |
| 2025-02-04 04:30:00 | QQQ | ETF | 517.68 | 517.81 | 517.0 | 517.32 | 36049.0 |
| 2025-02-04 05:00:00 | QQQ | ETF | 517.33 | 518.07 | 517.11 | 517.89 | 12713.0 |
| 2025-02-04 05:30:00 | QQQ | ETF | 517.85 | 517.95 | 517.4 | 517.8 | 19256.0 |
| 2025-02-04 06:00:00 | QQQ | ETF | 517.85 | 518.56 | 517.55 | 518.35 | 52018.0 |
| 2025-02-04 06:30:00 | QQQ | ETF | 518.3 | 518.6 | 518.05 | 518.09 | 37041.0 |
| 2025-02-04 07:00:00 | QQQ | ETF | 518.17 | 519.33 | 518.16 | 519.33 | 78607.0 |
| 2025-02-04 07:30:00 | QQQ | ETF | 519.33 | 520.43 | 518.98 | 519.48 | 122390.0 |
| 2025-02-04 08:00:00 | QQQ | ETF | 518.53 | 520.0 | 514.43 | 519.4999 | 252640.0 |
| 2025-02-04 08:30:00 | QQQ | ETF | 519.46 | 519.53 | 518.64 | 518.77 | 76102.0 |
| 2025-02-04 09:00:00 | QQQ | ETF | 518.91 | 519.26 | 518.43 | 518.64 | 172451.0 |
| 2025-02-04 09:30:00 | QQQ | ETF | 518.63 | 522.31 | 518.23 | 521.94 | 2731515.0 |
| 2025-02-04 10:00:00 | QQQ | ETF | 521.97 | 524.41 | 521.94 | 523.84 | 1882951.0 |
| 2025-02-04 10:30:00 | QQQ | ETF | 523.85 | 524.79 | 523.35 | 523.645 | 1165460.0 |
| 2025-02-04 11:00:00 | QQQ | ETF | 523.68 | 524.89 | 523.68 | 524.8704 | 684869.0 |
| 2025-02-04 11:30:00 | QQQ | ETF | 524.84 | 525.11 | 523.6704 | 524.2152 | 824487.0 |
| 2025-02-04 12:00:00 | QQQ | ETF | 524.2105 | 524.28 | 521.83 | 521.94 | 1333043.0 |
| 2025-02-04 12:30:00 | QQQ | ETF | 522.0 | 523.4408 | 521.68 | 523.4001 | 1014545.0 |
> showing 50 of 39,181 rows — these rows as CSV