PREVIEW / etf_30min / 2024-08-05
file: by_date/etf_30min/2024/2024-08-05.parquet size: 925 KB rows: 40,005
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-05 04:00:00 | SPY | ETF | 523.78 | 523.99 | 519.65 | 521.54 | 305176.0 |
| 2024-08-05 04:30:00 | SPY | ETF | 521.74 | 522.23 | 519.7 | 519.94 | 136185.0 |
| 2024-08-05 05:00:00 | SPY | ETF | 519.99 | 521.0 | 518.94 | 520.0 | 89501.0 |
| 2024-08-05 05:30:00 | SPY | ETF | 519.8 | 520.41 | 517.49 | 520.01 | 157616.0 |
| 2024-08-05 06:00:00 | SPY | ETF | 519.94 | 520.03 | 516.85 | 517.77 | 248290.0 |
| 2024-08-05 06:30:00 | SPY | ETF | 518.22 | 518.43 | 516.13 | 518.25 | 352169.0 |
| 2024-08-05 07:00:00 | SPY | ETF | 518.36 | 519.0 | 516.76 | 516.84 | 663715.0 |
| 2024-08-05 07:30:00 | SPY | ETF | 517.0 | 517.62 | 514.24 | 515.28 | 886394.0 |
| 2024-08-05 08:00:00 | SPY | ETF | 518.53 | 524.5 | 508.6 | 509.58 | 2185970.0 |
| 2024-08-05 08:30:00 | SPY | ETF | 509.71 | 513.12 | 507.83 | 510.92 | 2454529.0 |
| 2024-08-05 09:00:00 | SPY | ETF | 510.83 | 515.26 | 510.46 | 511.71 | 1743805.0 |
| 2024-08-05 09:30:00 | SPY | ETF | 511.64 | 518.04 | 510.27 | 515.22 | 18839979.0 |
| 2024-08-05 10:00:00 | SPY | ETF | 515.25 | 520.93 | 514.61 | 514.64 | 9567544.0 |
| 2024-08-05 10:30:00 | SPY | ETF | 514.65 | 519.17 | 514.62 | 516.43 | 5594999.0 |
| 2024-08-05 11:00:00 | SPY | ETF | 516.41 | 521.0 | 515.35 | 519.68 | 5675757.0 |
| 2024-08-05 11:30:00 | SPY | ETF | 519.675 | 521.95 | 519.1 | 520.4201 | 4423159.0 |
| 2024-08-05 12:00:00 | SPY | ETF | 520.41 | 523.58 | 519.695 | 523.57 | 3357319.0 |
| 2024-08-05 12:30:00 | SPY | ETF | 523.55 | 523.55 | 518.44 | 518.91 | 4220703.0 |
| 2024-08-05 13:00:00 | SPY | ETF | 518.9 | 520.8 | 518.25 | 519.66 | 3664557.0 |
| 2024-08-05 13:30:00 | SPY | ETF | 519.64 | 520.88 | 518.71 | 519.06 | 2905408.0 |
| 2024-08-05 14:00:00 | SPY | ETF | 519.04 | 519.18 | 517.73 | 518.95 | 3238761.0 |
| 2024-08-05 14:30:00 | SPY | ETF | 518.91 | 519.4 | 515.61 | 515.72 | 4518437.0 |
| 2024-08-05 15:00:00 | SPY | ETF | 515.73 | 517.2 | 515.31 | 516.43 | 4995471.0 |
| 2024-08-05 15:30:00 | SPY | ETF | 516.45 | 517.75 | 514.88 | 517.41 | 18371886.0 |
| 2024-08-05 16:00:00 | SPY | ETF | 517.41 | 520.57 | 516.92 | 519.45 | 8413289.0 |
| 2024-08-05 16:30:00 | SPY | ETF | 519.4 | 520.37 | 517.38 | 520.37 | 2493204.0 |
| 2024-08-05 17:00:00 | SPY | ETF | 520.43 | 520.43 | 519.9643 | 520.05 | 220885.0 |
| 2024-08-05 17:30:00 | SPY | ETF | 520.05 | 520.57 | 520.05 | 520.39 | 52779.0 |
| 2024-08-05 18:00:00 | SPY | ETF | 520.54 | 522.8 | 520.54 | 522.41 | 132234.0 |
| 2024-08-05 18:30:00 | SPY | ETF | 522.51 | 522.51 | 520.84 | 521.62 | 55741.0 |
| 2024-08-05 19:00:00 | SPY | ETF | 521.86 | 522.2 | 521.2935 | 521.55 | 41710.0 |
| 2024-08-05 19:30:00 | SPY | ETF | 521.56 | 522.92 | 521.56 | 522.81 | 262911.0 |
| 2024-08-05 20:00:00 | SPY | ETF | 522.92 | 522.92 | 522.92 | 522.92 | 100.0 |
| 2024-08-05 04:00:00 | QQQ | ETF | 434.88 | 435.53 | 430.42 | 433.67 | 258982.0 |
| 2024-08-05 04:30:00 | QQQ | ETF | 433.92 | 434.28 | 430.68 | 431.18 | 119269.0 |
| 2024-08-05 05:00:00 | QQQ | ETF | 431.16 | 432.62 | 429.5 | 430.77 | 166260.0 |
| 2024-08-05 05:30:00 | QQQ | ETF | 430.78 | 431.46 | 427.54 | 430.88 | 176900.0 |
| 2024-08-05 06:00:00 | QQQ | ETF | 430.77 | 430.84 | 427.71 | 428.86 | 78732.0 |
| 2024-08-05 06:30:00 | QQQ | ETF | 428.96 | 430.04 | 426.59 | 429.99 | 270646.0 |
| 2024-08-05 07:00:00 | QQQ | ETF | 429.94 | 430.9 | 428.27 | 428.54 | 400916.0 |
| 2024-08-05 07:30:00 | QQQ | ETF | 428.72 | 429.44 | 425.5 | 426.79 | 603577.0 |
| 2024-08-05 08:00:00 | QQQ | ETF | 430.46 | 436.17 | 421.23 | 422.4 | 1441075.0 |
| 2024-08-05 08:30:00 | QQQ | ETF | 422.84 | 425.6 | 420.0 | 423.8 | 1387622.0 |
| 2024-08-05 09:00:00 | QQQ | ETF | 423.96 | 428.03 | 423.9 | 424.68 | 1454764.0 |
| 2024-08-05 09:30:00 | QQQ | ETF | 424.71 | 434.2 | 423.45 | 432.53 | 11823509.0 |
| 2024-08-05 10:00:00 | QQQ | ETF | 432.54 | 438.07 | 431.86 | 431.91 | 6553959.0 |
| 2024-08-05 10:30:00 | QQQ | ETF | 431.92 | 437.27 | 431.73 | 433.99 | 4725161.0 |
| 2024-08-05 11:00:00 | QQQ | ETF | 433.96 | 439.91 | 432.68 | 437.83 | 4715932.0 |
| 2024-08-05 11:30:00 | QQQ | ETF | 437.82 | 439.82 | 436.54 | 437.91 | 3312510.0 |
| 2024-08-05 12:00:00 | QQQ | ETF | 437.855 | 442.29 | 436.89 | 442.16 | 2957558.0 |
> showing 50 of 40,005 rows — these rows as CSV