PREVIEW / etf_30min / 2025-03-10
file: by_date/etf_30min/2025/2025-03-10.parquet size: 1021 KB rows: 42,789
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-03-10 04:00:00 | SPY | ETF | 572.7 | 573.24 | 570.99 | 571.7 | 26980.0 |
| 2025-03-10 04:30:00 | SPY | ETF | 571.19 | 571.23 | 568.8 | 569.21 | 55963.0 |
| 2025-03-10 05:00:00 | SPY | ETF | 568.92 | 570.9 | 568.75 | 570.48 | 26937.0 |
| 2025-03-10 05:30:00 | SPY | ETF | 570.57 | 571.45 | 569.95 | 570.33 | 21490.0 |
| 2025-03-10 06:00:00 | SPY | ETF | 570.5 | 570.85 | 569.64 | 569.99 | 40038.0 |
| 2025-03-10 06:30:00 | SPY | ETF | 570.06 | 570.24 | 569.12 | 569.3 | 47057.0 |
| 2025-03-10 07:00:00 | SPY | ETF | 569.36 | 570.74 | 568.82 | 570.4 | 90954.0 |
| 2025-03-10 07:30:00 | SPY | ETF | 570.38 | 570.49 | 568.65 | 569.06 | 129662.0 |
| 2025-03-10 08:00:00 | SPY | ETF | 569.13 | 574.12 | 567.63 | 567.83 | 249239.0 |
| 2025-03-10 08:30:00 | SPY | ETF | 567.86 | 568.62 | 567.21 | 568.54 | 256001.0 |
| 2025-03-10 09:00:00 | SPY | ETF | 568.51 | 569.1 | 567.5 | 567.55 | 395519.0 |
| 2025-03-10 09:30:00 | SPY | ETF | 567.59 | 569.54 | 566.36 | 567.36 | 5449846.0 |
| 2025-03-10 10:00:00 | SPY | ETF | 567.32 | 567.32 | 565.1731 | 565.515 | 4214336.0 |
| 2025-03-10 10:30:00 | SPY | ETF | 565.53 | 566.05 | 563.06 | 563.94 | 4388032.0 |
| 2025-03-10 11:00:00 | SPY | ETF | 563.95 | 565.4 | 563.93 | 565.125 | 3650568.0 |
| 2025-03-10 11:30:00 | SPY | ETF | 565.14 | 566.62 | 563.64 | 563.84 | 2952945.0 |
| 2025-03-10 12:00:00 | SPY | ETF | 563.8 | 564.55 | 562.45 | 563.77 | 2239394.0 |
| 2025-03-10 12:30:00 | SPY | ETF | 563.78 | 565.11 | 562.71 | 563.0 | 2517141.0 |
| 2025-03-10 13:00:00 | SPY | ETF | 562.99 | 563.17 | 561.1 | 561.84 | 2459897.0 |
| 2025-03-10 13:30:00 | SPY | ETF | 561.88 | 561.97 | 560.1 | 560.42 | 2986999.0 |
| 2025-03-10 14:00:00 | SPY | ETF | 560.41 | 561.53 | 559.42 | 559.82 | 3826392.0 |
| 2025-03-10 14:30:00 | SPY | ETF | 559.82 | 560.48 | 557.07 | 557.3 | 3666361.0 |
| 2025-03-10 15:00:00 | SPY | ETF | 557.3 | 561.29 | 555.59 | 559.67 | 7479091.0 |
| 2025-03-10 15:30:00 | SPY | ETF | 559.72 | 562.4698 | 559.06 | 560.75 | 11216644.0 |
| 2025-03-10 16:00:00 | SPY | ETF | 560.75 | 561.4 | 559.74 | 561.36 | 5436732.0 |
| 2025-03-10 16:30:00 | SPY | ETF | 561.33 | 561.39 | 560.98 | 561.25 | 438438.0 |
| 2025-03-10 17:00:00 | SPY | ETF | 561.28 | 561.47 | 560.82 | 561.0 | 134510.0 |
| 2025-03-10 17:30:00 | SPY | ETF | 561.0 | 561.0 | 560.25 | 560.25 | 104743.0 |
| 2025-03-10 18:00:00 | SPY | ETF | 560.3 | 560.88 | 558.97 | 560.24 | 297776.0 |
| 2025-03-10 18:30:00 | SPY | ETF | 560.2 | 560.75 | 559.5 | 559.52 | 60703.0 |
| 2025-03-10 19:00:00 | SPY | ETF | 559.6606 | 559.85 | 557.64 | 558.43 | 138754.0 |
| 2025-03-10 19:30:00 | SPY | ETF | 558.36 | 558.87 | 556.9 | 558.58 | 123568.0 |
| 2025-03-10 04:00:00 | QQQ | ETF | 488.69 | 489.13 | 486.9 | 487.42 | 21801.0 |
| 2025-03-10 04:30:00 | QQQ | ETF | 487.24 | 487.28 | 485.12 | 485.52 | 59062.0 |
| 2025-03-10 05:00:00 | QQQ | ETF | 485.32 | 486.99 | 485.26 | 486.59 | 89111.0 |
| 2025-03-10 05:30:00 | QQQ | ETF | 486.74 | 487.7 | 485.97 | 486.37 | 62716.0 |
| 2025-03-10 06:00:00 | QQQ | ETF | 486.55 | 486.9 | 485.72 | 485.9 | 41601.0 |
| 2025-03-10 06:30:00 | QQQ | ETF | 486.01 | 486.3 | 484.93 | 485.59 | 61142.0 |
| 2025-03-10 07:00:00 | QQQ | ETF | 485.7 | 486.89 | 485.04 | 486.64 | 75960.0 |
| 2025-03-10 07:30:00 | QQQ | ETF | 486.65 | 486.76 | 484.51 | 485.19 | 93911.0 |
| 2025-03-10 08:00:00 | QQQ | ETF | 485.26 | 491.422 | 483.6504 | 483.6504 | 243594.0 |
| 2025-03-10 08:30:00 | QQQ | ETF | 483.8 | 484.3688 | 483.03 | 484.25 | 274818.0 |
| 2025-03-10 09:00:00 | QQQ | ETF | 484.34 | 484.9 | 483.29 | 483.58 | 207515.0 |
| 2025-03-10 09:30:00 | QQQ | ETF | 483.47 | 483.97 | 480.2 | 481.25 | 4999805.0 |
| 2025-03-10 10:00:00 | QQQ | ETF | 481.25 | 481.25 | 477.97 | 478.3 | 3692772.0 |
| 2025-03-10 10:30:00 | QQQ | ETF | 478.31 | 478.985 | 474.715 | 475.53 | 4407179.0 |
| 2025-03-10 11:00:00 | QQQ | ETF | 475.54 | 477.5 | 475.4 | 477.45 | 3124924.0 |
| 2025-03-10 11:30:00 | QQQ | ETF | 477.45 | 479.1372 | 476.03 | 476.3462 | 2438860.0 |
| 2025-03-10 12:00:00 | QQQ | ETF | 476.32 | 477.11 | 474.77 | 476.15 | 1575051.0 |
| 2025-03-10 12:30:00 | QQQ | ETF | 476.15 | 477.6 | 475.0 | 475.245 | 1840912.0 |
> showing 50 of 42,789 rows — these rows as CSV