PREVIEW / etf_30min / 2024-09-03
file: by_date/etf_30min/2024/2024-09-03.parquet size: 849 KB rows: 34,717
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-09-03 04:00:00 | SPY | ETF | 563.5 | 564.22 | 563.26 | 563.39 | 4233.0 |
| 2024-09-03 04:30:00 | SPY | ETF | 563.15 | 563.15 | 561.8 | 561.8 | 7272.0 |
| 2024-09-03 05:00:00 | SPY | ETF | 561.76 | 562.02 | 560.89 | 561.29 | 16710.0 |
| 2024-09-03 05:30:00 | SPY | ETF | 561.14 | 561.45 | 560.7 | 560.81 | 38122.0 |
| 2024-09-03 06:00:00 | SPY | ETF | 560.75 | 561.19 | 560.5 | 561.19 | 96608.0 |
| 2024-09-03 06:30:00 | SPY | ETF | 561.21 | 561.41 | 560.75 | 561.29 | 39014.0 |
| 2024-09-03 07:00:00 | SPY | ETF | 561.29 | 561.33 | 560.6 | 561.01 | 82809.0 |
| 2024-09-03 07:30:00 | SPY | ETF | 561.33 | 561.45 | 560.7 | 561.05 | 58653.0 |
| 2024-09-03 08:00:00 | SPY | ETF | 561.2884 | 564.0 | 560.6294 | 561.04 | 107087.0 |
| 2024-09-03 08:30:00 | SPY | ETF | 560.95 | 561.43 | 560.62 | 560.7 | 96740.0 |
| 2024-09-03 09:00:00 | SPY | ETF | 560.68 | 561.1215 | 560.26 | 560.48 | 298873.0 |
| 2024-09-03 09:30:00 | SPY | ETF | 560.47 | 560.81 | 558.14 | 559.08 | 4383064.0 |
| 2024-09-03 10:00:00 | SPY | ETF | 559.12 | 559.14 | 556.3214 | 557.19 | 3945393.0 |
| 2024-09-03 10:30:00 | SPY | ETF | 557.18 | 557.18 | 555.1 | 555.3399 | 2909382.0 |
| 2024-09-03 11:00:00 | SPY | ETF | 555.35 | 556.7895 | 555.15 | 556.38 | 2202203.0 |
| 2024-09-03 11:30:00 | SPY | ETF | 556.39 | 556.99 | 555.47 | 555.6 | 1806218.0 |
| 2024-09-03 12:00:00 | SPY | ETF | 555.59 | 556.5 | 555.21 | 555.65 | 1355636.0 |
| 2024-09-03 12:30:00 | SPY | ETF | 555.65 | 555.72 | 554.755 | 554.9 | 1348593.0 |
| 2024-09-03 13:00:00 | SPY | ETF | 554.88 | 555.87 | 554.68 | 555.67 | 1245795.0 |
| 2024-09-03 13:30:00 | SPY | ETF | 555.665 | 555.73 | 554.26 | 554.34 | 1504508.0 |
| 2024-09-03 14:00:00 | SPY | ETF | 554.33 | 554.38 | 552.94 | 553.04 | 2205245.0 |
| 2024-09-03 14:30:00 | SPY | ETF | 553.04 | 553.82 | 552.47 | 552.6302 | 2321619.0 |
| 2024-09-03 15:00:00 | SPY | ETF | 552.63 | 553.16 | 552.31 | 552.53 | 2272670.0 |
| 2024-09-03 15:30:00 | SPY | ETF | 552.53 | 552.755 | 549.51 | 552.16 | 10444027.0 |
| 2024-09-03 16:00:00 | SPY | ETF | 552.16 | 552.55 | 551.17 | 551.24 | 2835131.0 |
| 2024-09-03 16:30:00 | SPY | ETF | 551.43 | 551.71 | 551.09 | 551.6599 | 157225.0 |
| 2024-09-03 17:00:00 | SPY | ETF | 551.59 | 551.64 | 551.38 | 551.39 | 29444.0 |
| 2024-09-03 17:30:00 | SPY | ETF | 551.38 | 551.5 | 551.34 | 551.44 | 76887.0 |
| 2024-09-03 18:00:00 | SPY | ETF | 551.53 | 551.8 | 551.0 | 551.52 | 57342.0 |
| 2024-09-03 18:30:00 | SPY | ETF | 551.66 | 551.79 | 551.1862 | 551.33 | 21629.0 |
| 2024-09-03 19:00:00 | SPY | ETF | 551.2215 | 551.5 | 551.03 | 551.11 | 14564.0 |
| 2024-09-03 19:30:00 | SPY | ETF | 551.12 | 551.3455 | 550.7 | 551.0 | 44216.0 |
| 2024-09-03 04:00:00 | QQQ | ETF | 476.2 | 476.85 | 475.76 | 475.94 | 40860.0 |
| 2024-09-03 04:30:00 | QQQ | ETF | 475.78 | 475.79 | 473.71 | 473.73 | 26953.0 |
| 2024-09-03 05:00:00 | QQQ | ETF | 473.55 | 474.05 | 472.54 | 473.3 | 50311.0 |
| 2024-09-03 05:30:00 | QQQ | ETF | 473.06 | 473.55 | 472.44 | 473.04 | 25394.0 |
| 2024-09-03 06:00:00 | QQQ | ETF | 472.99 | 473.54 | 472.69 | 473.53 | 42216.0 |
| 2024-09-03 06:30:00 | QQQ | ETF | 473.51 | 473.92 | 473.02 | 473.73 | 21390.0 |
| 2024-09-03 07:00:00 | QQQ | ETF | 473.68 | 473.78 | 472.72 | 473.49 | 84160.0 |
| 2024-09-03 07:30:00 | QQQ | ETF | 473.54 | 473.96 | 473.29 | 473.66 | 38040.0 |
| 2024-09-03 08:00:00 | QQQ | ETF | 473.74 | 477.0 | 472.7804 | 473.7 | 105725.0 |
| 2024-09-03 08:30:00 | QQQ | ETF | 473.63 | 474.21 | 473.22 | 473.29 | 66918.0 |
| 2024-09-03 09:00:00 | QQQ | ETF | 473.2 | 473.96 | 472.88 | 473.22 | 110083.0 |
| 2024-09-03 09:30:00 | QQQ | ETF | 473.19 | 473.33 | 469.675 | 470.6199 | 4814859.0 |
| 2024-09-03 10:00:00 | QQQ | ETF | 470.6 | 470.96 | 468.49 | 469.31 | 2885633.0 |
| 2024-09-03 10:30:00 | QQQ | ETF | 469.27 | 469.28 | 465.46 | 465.54 | 3606181.0 |
| 2024-09-03 11:00:00 | QQQ | ETF | 465.555 | 467.31 | 465.22 | 466.395 | 2114962.0 |
| 2024-09-03 11:30:00 | QQQ | ETF | 466.37 | 467.09 | 465.1 | 465.2 | 1476142.0 |
| 2024-09-03 12:00:00 | QQQ | ETF | 465.21 | 466.56 | 464.93 | 465.65 | 1563654.0 |
| 2024-09-03 12:30:00 | QQQ | ETF | 465.63 | 465.81 | 464.84 | 464.98 | 933816.0 |
> showing 50 of 34,717 rows — these rows as CSV