PREVIEW / etf_30min / 2024-05-23
file: by_date/etf_30min/2024/2024-05-23.parquet size: 819 KB rows: 32,529
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-23 04:00:00 | SPY | ETF | 532.0 | 532.73 | 532.0 | 532.69 | 8061.0 |
| 2024-05-23 04:30:00 | SPY | ETF | 532.68 | 532.68 | 532.31 | 532.31 | 1086.0 |
| 2024-05-23 05:00:00 | SPY | ETF | 532.4 | 532.69 | 532.32 | 532.64 | 8738.0 |
| 2024-05-23 05:30:00 | SPY | ETF | 532.73 | 532.8 | 532.68 | 532.74 | 3579.0 |
| 2024-05-23 06:00:00 | SPY | ETF | 532.7 | 532.82 | 532.66 | 532.82 | 2982.0 |
| 2024-05-23 06:30:00 | SPY | ETF | 532.84 | 533.11 | 532.83 | 533.11 | 3700.0 |
| 2024-05-23 07:00:00 | SPY | ETF | 533.11 | 533.31 | 532.2 | 533.3 | 150871.0 |
| 2024-05-23 07:30:00 | SPY | ETF | 533.3 | 533.58 | 533.28 | 533.53 | 120999.0 |
| 2024-05-23 08:00:00 | SPY | ETF | 533.18 | 533.9893 | 531.57 | 533.89 | 250892.0 |
| 2024-05-23 08:30:00 | SPY | ETF | 533.85 | 534.0 | 533.67 | 533.7 | 186360.0 |
| 2024-05-23 09:00:00 | SPY | ETF | 533.7 | 533.72 | 532.78 | 532.97 | 323444.0 |
| 2024-05-23 09:30:00 | SPY | ETF | 532.96 | 533.07 | 529.545 | 529.96 | 5597651.0 |
| 2024-05-23 10:00:00 | SPY | ETF | 529.93 | 530.99 | 529.56 | 530.4499 | 2288340.0 |
| 2024-05-23 10:30:00 | SPY | ETF | 530.46 | 530.8802 | 529.01 | 529.05 | 1940400.0 |
| 2024-05-23 11:00:00 | SPY | ETF | 529.06 | 530.685 | 528.98 | 530.525 | 2068139.0 |
| 2024-05-23 11:30:00 | SPY | ETF | 530.535 | 531.484 | 530.52 | 531.08 | 1476445.0 |
| 2024-05-23 12:00:00 | SPY | ETF | 531.08 | 531.42 | 530.37 | 531.245 | 1303222.0 |
| 2024-05-23 12:30:00 | SPY | ETF | 531.2328 | 531.345 | 529.54 | 529.54 | 1331601.0 |
| 2024-05-23 13:00:00 | SPY | ETF | 529.56 | 529.84 | 528.83 | 529.4804 | 1639979.0 |
| 2024-05-23 13:30:00 | SPY | ETF | 529.48 | 529.48 | 526.57 | 526.7 | 2554160.0 |
| 2024-05-23 14:00:00 | SPY | ETF | 526.72 | 526.85 | 525.46 | 525.7101 | 3341527.0 |
| 2024-05-23 14:30:00 | SPY | ETF | 525.71 | 526.31 | 524.85 | 524.94 | 2556908.0 |
| 2024-05-23 15:00:00 | SPY | ETF | 524.94 | 525.66 | 524.72 | 525.19 | 2872985.0 |
| 2024-05-23 15:30:00 | SPY | ETF | 525.2 | 526.26 | 525.19 | 525.95 | 8353823.0 |
| 2024-05-23 16:00:00 | SPY | ETF | 525.96 | 530.2218 | 525.52 | 525.981 | 3972792.0 |
| 2024-05-23 16:30:00 | SPY | ETF | 526.02 | 526.1 | 525.91 | 525.98 | 263458.0 |
| 2024-05-23 17:00:00 | SPY | ETF | 525.91 | 526.0 | 525.7 | 525.71 | 78873.0 |
| 2024-05-23 17:30:00 | SPY | ETF | 525.75 | 525.85 | 525.71 | 525.78 | 19403.0 |
| 2024-05-23 18:00:00 | SPY | ETF | 525.86 | 526.12 | 525.86 | 526.01 | 38908.0 |
| 2024-05-23 18:30:00 | SPY | ETF | 526.03 | 526.08 | 525.98 | 526.01 | 4035.0 |
| 2024-05-23 19:00:00 | SPY | ETF | 526.03 | 526.38 | 526.03 | 526.38 | 22734.0 |
| 2024-05-23 19:30:00 | SPY | ETF | 526.3382 | 526.38 | 526.0 | 526.1 | 5126.0 |
| 2024-05-23 04:00:00 | QQQ | ETF | 459.12 | 459.7 | 459.12 | 459.67 | 65061.0 |
| 2024-05-23 04:30:00 | QQQ | ETF | 459.71 | 459.76 | 459.37 | 459.43 | 19855.0 |
| 2024-05-23 05:00:00 | QQQ | ETF | 459.34 | 459.69 | 459.31 | 459.69 | 4499.0 |
| 2024-05-23 05:30:00 | QQQ | ETF | 459.8 | 459.88 | 459.73 | 459.73 | 36595.0 |
| 2024-05-23 06:00:00 | QQQ | ETF | 459.7 | 459.86 | 459.61 | 459.85 | 13778.0 |
| 2024-05-23 06:30:00 | QQQ | ETF | 459.79 | 460.29 | 459.79 | 460.23 | 37402.0 |
| 2024-05-23 07:00:00 | QQQ | ETF | 460.19 | 460.52 | 460.131 | 460.52 | 60708.0 |
| 2024-05-23 07:30:00 | QQQ | ETF | 460.52 | 460.75 | 460.49 | 460.7 | 70564.0 |
| 2024-05-23 08:00:00 | QQQ | ETF | 460.3 | 461.13 | 459.31 | 461.05 | 155507.0 |
| 2024-05-23 08:30:00 | QQQ | ETF | 460.99 | 461.5 | 460.86 | 461.081 | 137254.0 |
| 2024-05-23 09:00:00 | QQQ | ETF | 461.15 | 461.15 | 460.31 | 460.6 | 352475.0 |
| 2024-05-23 09:30:00 | QQQ | ETF | 460.57 | 460.58 | 457.07 | 457.4 | 4641156.0 |
| 2024-05-23 10:00:00 | QQQ | ETF | 457.4 | 458.89 | 457.3 | 458.4 | 2565460.0 |
| 2024-05-23 10:30:00 | QQQ | ETF | 458.44 | 458.93 | 456.19 | 456.3153 | 2209428.0 |
| 2024-05-23 11:00:00 | QQQ | ETF | 456.33 | 458.51 | 456.29 | 458.44 | 1566126.0 |
| 2024-05-23 11:30:00 | QQQ | ETF | 458.45 | 459.2999 | 458.41 | 458.92 | 1292960.0 |
| 2024-05-23 12:00:00 | QQQ | ETF | 458.9213 | 459.3683 | 458.24 | 459.16 | 957615.0 |
| 2024-05-23 12:30:00 | QQQ | ETF | 459.15 | 459.23 | 457.21 | 457.215 | 1145692.0 |
> showing 50 of 32,529 rows — these rows as CSV