PREVIEW / etf_30min / 2024-09-26
file: by_date/etf_30min/2024/2024-09-26.parquet size: 869 KB rows: 35,125
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-26 04:00:00 | SPY | ETF | 573.72 | 574.74 | 573.72 | 574.68 | 23976.0 |
| 2024-09-26 04:30:00 | SPY | ETF | 574.68 | 574.82 | 574.33 | 574.57 | 16971.0 |
| 2024-09-26 05:00:00 | SPY | ETF | 574.52 | 574.54 | 574.22 | 574.45 | 12264.0 |
| 2024-09-26 05:30:00 | SPY | ETF | 574.38 | 574.6 | 574.38 | 574.43 | 5872.0 |
| 2024-09-26 06:00:00 | SPY | ETF | 574.43 | 574.6 | 574.31 | 574.57 | 21441.0 |
| 2024-09-26 06:30:00 | SPY | ETF | 574.56 | 574.85 | 574.48 | 574.78 | 12283.0 |
| 2024-09-26 07:00:00 | SPY | ETF | 574.89 | 574.9 | 574.27 | 574.7 | 244244.0 |
| 2024-09-26 07:30:00 | SPY | ETF | 574.68 | 574.8 | 574.35 | 574.37 | 44945.0 |
| 2024-09-26 08:00:00 | SPY | ETF | 574.76 | 574.8396 | 572.6 | 574.6 | 170645.0 |
| 2024-09-26 08:30:00 | SPY | ETF | 574.69 | 574.97 | 574.3 | 574.65 | 137169.0 |
| 2024-09-26 09:00:00 | SPY | ETF | 574.7 | 575.0 | 574.45 | 574.45 | 249457.0 |
| 2024-09-26 09:30:00 | SPY | ETF | 574.4 | 574.71 | 573.165 | 573.545 | 4097870.0 |
| 2024-09-26 10:00:00 | SPY | ETF | 573.56 | 574.15 | 572.43 | 572.624 | 2109365.0 |
| 2024-09-26 10:30:00 | SPY | ETF | 572.62 | 573.44 | 571.03 | 571.235 | 2857893.0 |
| 2024-09-26 11:00:00 | SPY | ETF | 571.24 | 572.12 | 570.9 | 571.3399 | 1769570.0 |
| 2024-09-26 11:30:00 | SPY | ETF | 571.2801 | 572.5702 | 570.98 | 572.4201 | 1216059.0 |
| 2024-09-26 12:00:00 | SPY | ETF | 572.41 | 572.42 | 571.13 | 571.2499 | 1245287.0 |
| 2024-09-26 12:30:00 | SPY | ETF | 571.24 | 571.4298 | 570.8398 | 571.08 | 1169997.0 |
| 2024-09-26 13:00:00 | SPY | ETF | 571.07 | 571.425 | 569.9 | 571.09 | 1623467.0 |
| 2024-09-26 13:30:00 | SPY | ETF | 571.1 | 571.76 | 571.07 | 571.53 | 1359098.0 |
| 2024-09-26 14:00:00 | SPY | ETF | 571.55 | 572.73 | 571.54 | 572.42 | 1586149.0 |
| 2024-09-26 14:30:00 | SPY | ETF | 572.41 | 572.45 | 571.94 | 572.26 | 1172691.0 |
| 2024-09-26 15:00:00 | SPY | ETF | 572.24 | 572.47 | 571.94 | 572.12 | 1970093.0 |
| 2024-09-26 15:30:00 | SPY | ETF | 572.12 | 572.75 | 571.82 | 572.29 | 4525812.0 |
| 2024-09-26 16:00:00 | SPY | ETF | 572.28 | 572.57 | 572.15 | 572.36 | 1576436.0 |
| 2024-09-26 16:30:00 | SPY | ETF | 572.36 | 572.49 | 572.27 | 572.36 | 163796.0 |
| 2024-09-26 17:00:00 | SPY | ETF | 572.3426 | 572.44 | 572.3 | 572.44 | 32937.0 |
| 2024-09-26 17:30:00 | SPY | ETF | 572.35 | 572.42 | 572.3 | 572.38 | 22444.0 |
| 2024-09-26 18:00:00 | SPY | ETF | 572.36 | 573.07 | 572.36 | 572.95 | 34773.0 |
| 2024-09-26 18:30:00 | SPY | ETF | 572.9475 | 573.0 | 572.78 | 572.8 | 15162.0 |
| 2024-09-26 19:00:00 | SPY | ETF | 572.8 | 572.877 | 572.62 | 572.66 | 8182.0 |
| 2024-09-26 19:30:00 | SPY | ETF | 572.65 | 572.65 | 572.29 | 572.4 | 77956.0 |
| 2024-09-26 04:00:00 | QQQ | ETF | 491.72 | 493.07 | 491.3 | 492.8 | 87132.0 |
| 2024-09-26 04:30:00 | QQQ | ETF | 492.78 | 492.96 | 492.29 | 492.45 | 12642.0 |
| 2024-09-26 05:00:00 | QQQ | ETF | 492.51 | 492.54 | 492.21 | 492.54 | 19280.0 |
| 2024-09-26 05:30:00 | QQQ | ETF | 492.52 | 492.79 | 492.45 | 492.57 | 14964.0 |
| 2024-09-26 06:00:00 | QQQ | ETF | 492.59 | 492.8 | 492.41 | 492.78 | 25720.0 |
| 2024-09-26 06:30:00 | QQQ | ETF | 492.8 | 493.23 | 492.68 | 493.23 | 39849.0 |
| 2024-09-26 07:00:00 | QQQ | ETF | 493.22 | 493.23 | 492.76 | 493.23 | 82353.0 |
| 2024-09-26 07:30:00 | QQQ | ETF | 493.19 | 493.39 | 492.97 | 493.02 | 66536.0 |
| 2024-09-26 08:00:00 | QQQ | ETF | 492.85 | 493.41 | 490.0 | 493.11 | 303417.0 |
| 2024-09-26 08:30:00 | QQQ | ETF | 493.27 | 493.81 | 492.8 | 493.73 | 181071.0 |
| 2024-09-26 09:00:00 | QQQ | ETF | 493.76 | 494.21 | 493.39 | 493.45 | 386821.0 |
| 2024-09-26 09:30:00 | QQQ | ETF | 493.37 | 493.7 | 491.0 | 491.55 | 3997904.0 |
| 2024-09-26 10:00:00 | QQQ | ETF | 491.55 | 491.74 | 489.42 | 489.59 | 1522533.0 |
| 2024-09-26 10:30:00 | QQQ | ETF | 489.66 | 490.085 | 486.25 | 486.4427 | 2874358.0 |
| 2024-09-26 11:00:00 | QQQ | ETF | 486.42 | 488.33 | 485.8 | 487.44 | 2222970.0 |
| 2024-09-26 11:30:00 | QQQ | ETF | 487.38 | 489.0405 | 486.76 | 489.0 | 1190697.0 |
| 2024-09-26 12:00:00 | QQQ | ETF | 489.0 | 489.0 | 487.13 | 487.4 | 1113863.0 |
| 2024-09-26 12:30:00 | QQQ | ETF | 487.46 | 487.74 | 486.78 | 487.33 | 606611.0 |
> showing 50 of 35,125 rows — these rows as CSV