PREVIEW / etf_30min / 2024-08-22
file: by_date/etf_30min/2024/2024-08-22.parquet size: 817 KB rows: 32,387
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-08-22 04:00:00 | SPY | ETF | 561.01 | 561.25 | 560.97 | 561.1 | 3494.0 |
| 2024-08-22 04:30:00 | SPY | ETF | 561.34 | 561.35 | 561.2 | 561.27 | 4109.0 |
| 2024-08-22 05:00:00 | SPY | ETF | 561.29 | 561.64 | 561.29 | 561.34 | 4771.0 |
| 2024-08-22 05:30:00 | SPY | ETF | 561.38 | 561.43 | 561.11 | 561.11 | 4554.0 |
| 2024-08-22 06:00:00 | SPY | ETF | 561.14 | 561.52 | 561.14 | 561.45 | 2493.0 |
| 2024-08-22 06:30:00 | SPY | ETF | 561.35 | 561.75 | 561.35 | 561.75 | 7745.0 |
| 2024-08-22 07:00:00 | SPY | ETF | 561.72 | 562.2 | 561.65 | 562.03 | 75906.0 |
| 2024-08-22 07:30:00 | SPY | ETF | 562.06 | 562.16 | 561.74 | 562.05 | 67025.0 |
| 2024-08-22 08:00:00 | SPY | ETF | 561.75 | 562.38 | 560.27 | 561.9 | 123435.0 |
| 2024-08-22 08:30:00 | SPY | ETF | 561.65 | 562.34 | 561.41 | 562.2 | 100356.0 |
| 2024-08-22 09:00:00 | SPY | ETF | 562.23 | 562.57 | 562.15 | 562.56 | 158483.0 |
| 2024-08-22 09:30:00 | SPY | ETF | 562.56 | 563.18 | 561.63 | 562.3599 | 3481879.0 |
| 2024-08-22 10:00:00 | SPY | ETF | 562.38 | 562.475 | 560.5301 | 561.11 | 2374361.0 |
| 2024-08-22 10:30:00 | SPY | ETF | 561.1 | 561.14 | 560.16 | 560.53 | 1393357.0 |
| 2024-08-22 11:00:00 | SPY | ETF | 560.53 | 561.2499 | 559.04 | 559.1684 | 1366947.0 |
| 2024-08-22 11:30:00 | SPY | ETF | 559.16 | 559.33 | 557.06 | 557.7401 | 2334430.0 |
| 2024-08-22 12:00:00 | SPY | ETF | 557.73 | 559.92 | 557.72 | 559.68 | 1615464.0 |
| 2024-08-22 12:30:00 | SPY | ETF | 559.68 | 560.07 | 557.261 | 557.58 | 2012899.0 |
| 2024-08-22 13:00:00 | SPY | ETF | 557.5894 | 558.42 | 556.89 | 557.4801 | 2109042.0 |
| 2024-08-22 13:30:00 | SPY | ETF | 557.49 | 557.63 | 555.24 | 555.52 | 2086177.0 |
| 2024-08-22 14:00:00 | SPY | ETF | 555.53 | 557.11 | 555.265 | 557.05 | 1767410.0 |
| 2024-08-22 14:30:00 | SPY | ETF | 557.04 | 557.3 | 555.89 | 556.0 | 1266064.0 |
| 2024-08-22 15:00:00 | SPY | ETF | 556.03 | 557.18 | 555.55 | 555.78 | 1935040.0 |
| 2024-08-22 15:30:00 | SPY | ETF | 555.83 | 556.49 | 554.98 | 556.21 | 7384728.0 |
| 2024-08-22 16:00:00 | SPY | ETF | 556.2 | 556.66 | 555.74 | 556.55 | 3221643.0 |
| 2024-08-22 16:30:00 | SPY | ETF | 556.55 | 556.89 | 556.48 | 556.59 | 83343.0 |
| 2024-08-22 17:00:00 | SPY | ETF | 556.64 | 556.75 | 556.22 | 556.7387 | 67996.0 |
| 2024-08-22 17:30:00 | SPY | ETF | 556.65 | 556.89 | 556.52 | 556.79 | 36192.0 |
| 2024-08-22 18:00:00 | SPY | ETF | 556.67 | 556.89 | 556.66 | 556.88 | 49129.0 |
| 2024-08-22 18:30:00 | SPY | ETF | 556.84 | 557.09 | 556.84 | 557.06 | 27319.0 |
| 2024-08-22 19:00:00 | SPY | ETF | 557.13 | 557.13 | 556.94 | 556.94 | 4572.0 |
| 2024-08-22 19:30:00 | SPY | ETF | 557.0 | 557.17 | 556.86 | 557.17 | 11672.0 |
| 2024-08-22 04:00:00 | QQQ | ETF | 482.83 | 483.03 | 482.45 | 482.8 | 14179.0 |
| 2024-08-22 04:30:00 | QQQ | ETF | 482.88 | 482.99 | 482.85 | 482.9 | 2338.0 |
| 2024-08-22 05:00:00 | QQQ | ETF | 483.05 | 483.3 | 483.0 | 483.05 | 23391.0 |
| 2024-08-22 05:30:00 | QQQ | ETF | 483.0 | 483.0 | 482.86 | 482.86 | 1295.0 |
| 2024-08-22 06:00:00 | QQQ | ETF | 483.09 | 483.52 | 483.09 | 483.37 | 6232.0 |
| 2024-08-22 06:30:00 | QQQ | ETF | 483.51 | 483.91 | 483.51 | 483.89 | 12128.0 |
| 2024-08-22 07:00:00 | QQQ | ETF | 483.85 | 484.59 | 483.76 | 484.27 | 60004.0 |
| 2024-08-22 07:30:00 | QQQ | ETF | 484.37 | 484.45 | 484.02 | 484.36 | 49447.0 |
| 2024-08-22 08:00:00 | QQQ | ETF | 484.02 | 484.77 | 482.35 | 484.14 | 139739.0 |
| 2024-08-22 08:30:00 | QQQ | ETF | 484.0 | 484.65 | 483.5 | 484.48 | 149335.0 |
| 2024-08-22 09:00:00 | QQQ | ETF | 484.58 | 484.98 | 484.44 | 484.83 | 97585.0 |
| 2024-08-22 09:30:00 | QQQ | ETF | 484.87 | 485.54 | 483.59 | 484.38 | 2361646.0 |
| 2024-08-22 10:00:00 | QQQ | ETF | 484.44 | 484.55 | 482.13 | 482.942 | 1989394.0 |
| 2024-08-22 10:30:00 | QQQ | ETF | 482.915 | 482.915 | 481.44 | 481.99 | 1485893.0 |
| 2024-08-22 11:00:00 | QQQ | ETF | 482.0 | 482.8774 | 480.25 | 480.345 | 1429589.0 |
| 2024-08-22 11:30:00 | QQQ | ETF | 480.35 | 480.44 | 476.8 | 477.96 | 3249093.0 |
| 2024-08-22 12:00:00 | QQQ | ETF | 477.95 | 480.62 | 477.79 | 480.43 | 1840371.0 |
| 2024-08-22 12:30:00 | QQQ | ETF | 480.45 | 480.829 | 477.49 | 477.85 | 1837583.0 |
> showing 50 of 32,387 rows — these rows as CSV