PREVIEW / etf_30min / 2025-10-01
file: by_date/etf_30min/2025/2025-10-01.parquet size: 1.1 MB rows: 44,890
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-10-01 04:00:00 | SPY | ETF | 661.23 | 661.32 | 660.93 | 661.22 | 43117.0 |
| 2025-10-01 04:30:00 | SPY | ETF | 661.29 | 662.34 | 661.29 | 662.1 | 35852.0 |
| 2025-10-01 05:00:00 | SPY | ETF | 662.16 | 663.03 | 662.04 | 662.93 | 49115.0 |
| 2025-10-01 05:30:00 | SPY | ETF | 662.99 | 663.0 | 662.61 | 662.72 | 37575.0 |
| 2025-10-01 06:00:00 | SPY | ETF | 662.76 | 663.07 | 662.6 | 662.6 | 12935.0 |
| 2025-10-01 06:30:00 | SPY | ETF | 662.51 | 662.78 | 662.31 | 662.5 | 14730.0 |
| 2025-10-01 07:00:00 | SPY | ETF | 662.47 | 663.3 | 662.47 | 663.27 | 48536.0 |
| 2025-10-01 07:30:00 | SPY | ETF | 663.37 | 663.95 | 663.3 | 663.91 | 84925.0 |
| 2025-10-01 08:00:00 | SPY | ETF | 662.74 | 666.18 | 660.51 | 663.47 | 531305.0 |
| 2025-10-01 08:30:00 | SPY | ETF | 663.52 | 663.93 | 663.27 | 663.5494 | 144667.0 |
| 2025-10-01 09:00:00 | SPY | ETF | 663.55 | 663.84 | 663.03 | 663.17 | 175674.0 |
| 2025-10-01 09:30:00 | SPY | ETF | 663.16 | 665.39 | 663.06 | 663.735 | 9017005.0 |
| 2025-10-01 10:00:00 | SPY | ETF | 663.74 | 665.71 | 663.41 | 665.53 | 4183159.0 |
| 2025-10-01 10:30:00 | SPY | ETF | 665.53 | 666.06 | 665.26 | 665.805 | 3536998.0 |
| 2025-10-01 11:00:00 | SPY | ETF | 665.805 | 666.44 | 665.75 | 666.31 | 2911782.0 |
| 2025-10-01 11:30:00 | SPY | ETF | 666.31 | 667.18 | 666.31 | 666.975 | 3019148.0 |
| 2025-10-01 12:00:00 | SPY | ETF | 666.99 | 667.16 | 666.61 | 666.9 | 1896356.0 |
| 2025-10-01 12:30:00 | SPY | ETF | 666.9 | 667.035 | 666.43 | 666.91 | 1766633.0 |
| 2025-10-01 13:00:00 | SPY | ETF | 666.92 | 668.09 | 666.82 | 667.97 | 2852030.0 |
| 2025-10-01 13:30:00 | SPY | ETF | 667.98 | 668.035 | 667.605 | 667.955 | 1640595.0 |
| 2025-10-01 14:00:00 | SPY | ETF | 667.95 | 668.935 | 667.89 | 668.77 | 2848436.0 |
| 2025-10-01 14:30:00 | SPY | ETF | 668.775 | 669.35 | 668.73 | 669.13 | 2344190.0 |
| 2025-10-01 15:00:00 | SPY | ETF | 669.13 | 669.37 | 668.725 | 669.125 | 3038914.0 |
| 2025-10-01 15:30:00 | SPY | ETF | 669.12 | 669.26 | 668.48 | 668.51 | 8247949.0 |
| 2025-10-01 16:00:00 | SPY | ETF | 668.5 | 668.56 | 666.8186 | 668.06 | 4439040.0 |
| 2025-10-01 16:30:00 | SPY | ETF | 668.0 | 668.29 | 668.0 | 668.14 | 71121.0 |
| 2025-10-01 17:00:00 | SPY | ETF | 668.17 | 668.24 | 668.0 | 668.15 | 34536.0 |
| 2025-10-01 17:30:00 | SPY | ETF | 668.1 | 668.1 | 667.96 | 668.0 | 56343.0 |
| 2025-10-01 18:00:00 | SPY | ETF | 668.07 | 668.47 | 668.07 | 668.41 | 82502.0 |
| 2025-10-01 18:30:00 | SPY | ETF | 668.48 | 668.48 | 668.24 | 668.25 | 15084.0 |
| 2025-10-01 19:00:00 | SPY | ETF | 668.25 | 668.55 | 668.18 | 668.48 | 30678.0 |
| 2025-10-01 19:30:00 | SPY | ETF | 668.47 | 668.4999 | 668.01 | 668.2915 | 17736.0 |
| 2025-10-01 04:00:00 | QQQ | ETF | 596.88 | 596.88 | 594.62 | 595.17 | 122137.0 |
| 2025-10-01 04:30:00 | QQQ | ETF | 595.21 | 596.44 | 595.2 | 596.13 | 79947.0 |
| 2025-10-01 05:00:00 | QQQ | ETF | 596.08 | 597.26 | 596.02 | 597.09 | 50814.0 |
| 2025-10-01 05:30:00 | QQQ | ETF | 597.14 | 597.14 | 596.64 | 596.8 | 39089.0 |
| 2025-10-01 06:00:00 | QQQ | ETF | 596.86 | 597.2 | 596.67 | 596.67 | 46001.0 |
| 2025-10-01 06:30:00 | QQQ | ETF | 596.64 | 596.9 | 596.2 | 596.43 | 29077.0 |
| 2025-10-01 07:00:00 | QQQ | ETF | 596.48 | 597.62 | 596.43 | 597.61 | 187216.0 |
| 2025-10-01 07:30:00 | QQQ | ETF | 597.63 | 598.12 | 597.49 | 598.04 | 71374.0 |
| 2025-10-01 08:00:00 | QQQ | ETF | 596.45 | 599.92 | 594.31 | 597.54 | 488295.0 |
| 2025-10-01 08:30:00 | QQQ | ETF | 597.57 | 597.91 | 597.24 | 597.52 | 305977.0 |
| 2025-10-01 09:00:00 | QQQ | ETF | 597.54 | 597.93 | 597.11 | 597.2 | 282571.0 |
| 2025-10-01 09:30:00 | QQQ | ETF | 597.18 | 599.07 | 596.34 | 597.6 | 6275716.0 |
| 2025-10-01 10:00:00 | QQQ | ETF | 597.59 | 600.35 | 597.14 | 600.12 | 2718817.0 |
| 2025-10-01 10:30:00 | QQQ | ETF | 600.13 | 600.79 | 599.91 | 600.47 | 2414790.0 |
| 2025-10-01 11:00:00 | QQQ | ETF | 600.45 | 601.02 | 599.94 | 600.31 | 2322536.0 |
| 2025-10-01 11:30:00 | QQQ | ETF | 600.33 | 601.45 | 600.32 | 601.285 | 1555400.0 |
| 2025-10-01 12:00:00 | QQQ | ETF | 601.29 | 601.69 | 601.21 | 601.575 | 1581635.0 |
| 2025-10-01 12:30:00 | QQQ | ETF | 601.58 | 601.9051 | 601.24 | 601.8399 | 1114599.0 |
> showing 50 of 44,890 rows — these rows as CSV