PREVIEW / etf_30min / 2024-07-23
file: by_date/etf_30min/2024/2024-07-23.parquet size: 822 KB rows: 33,175
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-07-23 04:00:00 | SPY | ETF | 553.02 | 553.45 | 552.7 | 553.15 | 6582.0 |
| 2024-07-23 04:30:00 | SPY | ETF | 553.26 | 553.83 | 553.26 | 553.72 | 8045.0 |
| 2024-07-23 05:00:00 | SPY | ETF | 553.68 | 554.63 | 553.68 | 554.55 | 24193.0 |
| 2024-07-23 05:30:00 | SPY | ETF | 554.56 | 554.6 | 554.5 | 554.57 | 5811.0 |
| 2024-07-23 06:00:00 | SPY | ETF | 554.61 | 554.99 | 554.45 | 554.99 | 4308.0 |
| 2024-07-23 06:30:00 | SPY | ETF | 554.99 | 555.19 | 554.7 | 554.98 | 23645.0 |
| 2024-07-23 07:00:00 | SPY | ETF | 554.92 | 555.37 | 554.92 | 555.37 | 113787.0 |
| 2024-07-23 07:30:00 | SPY | ETF | 555.4 | 555.57 | 555.15 | 555.23 | 60985.0 |
| 2024-07-23 08:00:00 | SPY | ETF | 555.21 | 555.5081 | 552.83 | 554.45 | 70655.0 |
| 2024-07-23 08:30:00 | SPY | ETF | 554.49 | 554.77 | 554.07 | 554.72 | 48497.0 |
| 2024-07-23 09:00:00 | SPY | ETF | 554.73 | 554.97 | 554.261 | 554.47 | 112666.0 |
| 2024-07-23 09:30:00 | SPY | ETF | 554.54 | 555.81 | 554.13 | 555.52 | 2504652.0 |
| 2024-07-23 10:00:00 | SPY | ETF | 555.5401 | 556.41 | 555.26 | 556.0001 | 1884170.0 |
| 2024-07-23 10:30:00 | SPY | ETF | 556.02 | 556.17 | 554.28 | 554.92 | 1659845.0 |
| 2024-07-23 11:00:00 | SPY | ETF | 554.93 | 556.735 | 554.9 | 556.43 | 1457561.0 |
| 2024-07-23 11:30:00 | SPY | ETF | 556.4255 | 556.65 | 555.99 | 556.2 | 1007043.0 |
| 2024-07-23 12:00:00 | SPY | ETF | 556.17 | 556.36 | 554.53 | 555.0651 | 1175611.0 |
| 2024-07-23 12:30:00 | SPY | ETF | 555.06 | 555.15 | 554.18 | 554.61 | 1067998.0 |
| 2024-07-23 13:00:00 | SPY | ETF | 554.61 | 555.0 | 554.21 | 554.76 | 1127203.0 |
| 2024-07-23 13:30:00 | SPY | ETF | 554.73 | 555.36 | 554.27 | 555.245 | 800002.0 |
| 2024-07-23 14:00:00 | SPY | ETF | 555.24 | 555.55 | 554.53 | 554.8886 | 1115081.0 |
| 2024-07-23 14:30:00 | SPY | ETF | 554.9 | 555.39 | 554.79 | 555.0901 | 810551.0 |
| 2024-07-23 15:00:00 | SPY | ETF | 555.1 | 555.35 | 554.75 | 555.21 | 906811.0 |
| 2024-07-23 15:30:00 | SPY | ETF | 555.17 | 555.18 | 553.275 | 553.72 | 4491070.0 |
| 2024-07-23 16:00:00 | SPY | ETF | 553.73 | 554.91 | 553.23 | 554.19 | 2392176.0 |
| 2024-07-23 16:30:00 | SPY | ETF | 554.18 | 554.51 | 553.99 | 554.0 | 123823.0 |
| 2024-07-23 17:00:00 | SPY | ETF | 554.013 | 554.16 | 553.07 | 553.07 | 231798.0 |
| 2024-07-23 17:30:00 | SPY | ETF | 553.13 | 553.38 | 552.56 | 552.6 | 64196.0 |
| 2024-07-23 18:00:00 | SPY | ETF | 552.51 | 552.51 | 551.25 | 551.52 | 168682.0 |
| 2024-07-23 18:30:00 | SPY | ETF | 551.511 | 552.12 | 551.511 | 551.82 | 24512.0 |
| 2024-07-23 19:00:00 | SPY | ETF | 551.73 | 551.76 | 551.52 | 551.6085 | 27624.0 |
| 2024-07-23 19:30:00 | SPY | ETF | 551.52 | 551.62 | 551.32 | 551.34 | 46450.0 |
| 2024-07-23 04:00:00 | QQQ | ETF | 480.52 | 480.52 | 479.52 | 479.71 | 45759.0 |
| 2024-07-23 04:30:00 | QQQ | ETF | 479.71 | 480.72 | 479.71 | 480.52 | 39050.0 |
| 2024-07-23 05:00:00 | QQQ | ETF | 480.54 | 481.7 | 480.54 | 481.52 | 33723.0 |
| 2024-07-23 05:30:00 | QQQ | ETF | 481.64 | 481.69 | 481.39 | 481.41 | 14595.0 |
| 2024-07-23 06:00:00 | QQQ | ETF | 481.4 | 481.94 | 481.33 | 481.92 | 18064.0 |
| 2024-07-23 06:30:00 | QQQ | ETF | 482.02 | 482.26 | 481.64 | 481.77 | 23241.0 |
| 2024-07-23 07:00:00 | QQQ | ETF | 481.75 | 482.6 | 481.75 | 482.56 | 130712.0 |
| 2024-07-23 07:30:00 | QQQ | ETF | 482.57 | 482.82 | 482.04 | 482.34 | 152429.0 |
| 2024-07-23 08:00:00 | QQQ | ETF | 481.7603 | 482.78 | 479.5 | 481.28 | 123492.0 |
| 2024-07-23 08:30:00 | QQQ | ETF | 481.33 | 481.77 | 480.64 | 481.7104 | 103703.0 |
| 2024-07-23 09:00:00 | QQQ | ETF | 481.73 | 482.03 | 481.21 | 481.42 | 154614.0 |
| 2024-07-23 09:30:00 | QQQ | ETF | 481.42 | 483.28 | 480.87 | 482.58 | 2400287.0 |
| 2024-07-23 10:00:00 | QQQ | ETF | 482.64 | 483.57 | 481.5 | 482.88 | 1474492.0 |
| 2024-07-23 10:30:00 | QQQ | ETF | 482.88 | 482.95 | 480.7 | 481.68 | 1564866.0 |
| 2024-07-23 11:00:00 | QQQ | ETF | 481.65 | 484.43 | 481.64 | 483.93 | 1280823.0 |
| 2024-07-23 11:30:00 | QQQ | ETF | 483.95 | 484.1606 | 483.0789 | 483.2401 | 766337.0 |
| 2024-07-23 12:00:00 | QQQ | ETF | 483.23 | 483.4143 | 480.95 | 481.61 | 1277680.0 |
| 2024-07-23 12:30:00 | QQQ | ETF | 481.58 | 481.93 | 480.72 | 481.2401 | 954400.0 |
> showing 50 of 33,175 rows — these rows as CSV