PREVIEW / etf_30min / 2024-12-13
file: by_date/etf_30min/2024/2024-12-13.parquet size: 910 KB rows: 35,714
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-12-13 04:00:00 | SPY | ETF | 606.11 | 606.39 | 606.1 | 606.31 | 9927.0 |
| 2024-12-13 04:30:00 | SPY | ETF | 606.25 | 606.56 | 606.2 | 606.53 | 12957.0 |
| 2024-12-13 05:00:00 | SPY | ETF | 606.63 | 606.69 | 606.55 | 606.69 | 2994.0 |
| 2024-12-13 05:30:00 | SPY | ETF | 606.6 | 606.75 | 606.59 | 606.75 | 1887.0 |
| 2024-12-13 06:00:00 | SPY | ETF | 606.72 | 606.82 | 606.65 | 606.65 | 15060.0 |
| 2024-12-13 06:30:00 | SPY | ETF | 606.64 | 606.79 | 606.56 | 606.65 | 33425.0 |
| 2024-12-13 07:00:00 | SPY | ETF | 606.65 | 606.84 | 606.6 | 606.79 | 88317.0 |
| 2024-12-13 07:30:00 | SPY | ETF | 606.8 | 606.96 | 606.73 | 606.93 | 86890.0 |
| 2024-12-13 08:00:00 | SPY | ETF | 606.82 | 607.15 | 605.1 | 607.01 | 75018.0 |
| 2024-12-13 08:30:00 | SPY | ETF | 607.03 | 607.16 | 606.73 | 606.86 | 113088.0 |
| 2024-12-13 09:00:00 | SPY | ETF | 606.8 | 606.8 | 606.0 | 606.36 | 189391.0 |
| 2024-12-13 09:30:00 | SPY | ETF | 606.4 | 607.13 | 606.01 | 606.15 | 2627223.0 |
| 2024-12-13 10:00:00 | SPY | ETF | 606.17 | 606.2 | 604.92 | 605.01 | 2010726.0 |
| 2024-12-13 10:30:00 | SPY | ETF | 605.01 | 605.2674 | 603.43 | 603.47 | 1828915.0 |
| 2024-12-13 11:00:00 | SPY | ETF | 603.47 | 604.03 | 603.03 | 603.6798 | 1383485.0 |
| 2024-12-13 11:30:00 | SPY | ETF | 603.6625 | 604.66 | 603.32 | 603.81 | 1446682.0 |
| 2024-12-13 12:00:00 | SPY | ETF | 603.785 | 603.99 | 603.12 | 603.2368 | 764860.0 |
| 2024-12-13 12:30:00 | SPY | ETF | 603.24 | 603.53 | 602.83 | 602.91 | 972783.0 |
| 2024-12-13 13:00:00 | SPY | ETF | 602.9 | 604.07 | 602.81 | 603.9788 | 904777.0 |
| 2024-12-13 13:30:00 | SPY | ETF | 603.97 | 604.42 | 603.68 | 604.1 | 704928.0 |
| 2024-12-13 14:00:00 | SPY | ETF | 604.11 | 604.5286 | 603.9201 | 604.38 | 1039457.0 |
| 2024-12-13 14:30:00 | SPY | ETF | 604.4 | 604.63 | 604.15 | 604.3001 | 1202052.0 |
| 2024-12-13 15:00:00 | SPY | ETF | 604.29 | 604.52 | 603.77 | 604.27 | 1374497.0 |
| 2024-12-13 15:30:00 | SPY | ETF | 604.26 | 604.7 | 604.1 | 604.26 | 3273347.0 |
| 2024-12-13 16:00:00 | SPY | ETF | 604.31 | 604.31 | 603.39 | 603.4001 | 2381720.0 |
| 2024-12-13 16:30:00 | SPY | ETF | 603.4 | 603.8192 | 603.39 | 603.75 | 122747.0 |
| 2024-12-13 17:00:00 | SPY | ETF | 603.75 | 604.21 | 603.72 | 604.04 | 71011.0 |
| 2024-12-13 17:30:00 | SPY | ETF | 604.08 | 604.08 | 603.91 | 603.95 | 6401.0 |
| 2024-12-13 18:00:00 | SPY | ETF | 603.91 | 604.08 | 603.85 | 603.99 | 12549.0 |
| 2024-12-13 18:30:00 | SPY | ETF | 604.02 | 604.08 | 603.94 | 603.99 | 1715.0 |
| 2024-12-13 19:00:00 | SPY | ETF | 603.8748 | 603.99 | 603.85 | 603.99 | 2045.0 |
| 2024-12-13 19:30:00 | SPY | ETF | 603.9 | 604.08 | 603.68 | 603.85 | 5115.0 |
| 2024-12-13 04:00:00 | QQQ | ETF | 528.42 | 529.96 | 528.42 | 529.89 | 38562.0 |
| 2024-12-13 04:30:00 | QQQ | ETF | 529.9 | 530.23 | 529.52 | 530.23 | 12944.0 |
| 2024-12-13 05:00:00 | QQQ | ETF | 530.2 | 530.37 | 530.08 | 530.33 | 8125.0 |
| 2024-12-13 05:30:00 | QQQ | ETF | 530.24 | 530.46 | 530.18 | 530.35 | 44847.0 |
| 2024-12-13 06:00:00 | QQQ | ETF | 530.34 | 530.58 | 530.26 | 530.36 | 34095.0 |
| 2024-12-13 06:30:00 | QQQ | ETF | 530.41 | 530.63 | 530.22 | 530.22 | 59790.0 |
| 2024-12-13 07:00:00 | QQQ | ETF | 530.23 | 531.12 | 530.11 | 531.03 | 101447.0 |
| 2024-12-13 07:30:00 | QQQ | ETF | 531.08 | 531.38 | 530.89 | 531.32 | 80428.0 |
| 2024-12-13 08:00:00 | QQQ | ETF | 530.5 | 531.57 | 528.33 | 531.42 | 204340.0 |
| 2024-12-13 08:30:00 | QQQ | ETF | 531.42 | 531.5 | 530.87 | 531.09 | 196043.0 |
| 2024-12-13 09:00:00 | QQQ | ETF | 531.04 | 531.059 | 530.0 | 530.4 | 332243.0 |
| 2024-12-13 09:30:00 | QQQ | ETF | 530.46 | 533.1661 | 530.29 | 532.52 | 3340276.0 |
| 2024-12-13 10:00:00 | QQQ | ETF | 532.52 | 532.61 | 530.53 | 530.63 | 1793059.0 |
| 2024-12-13 10:30:00 | QQQ | ETF | 530.63 | 531.26 | 527.77 | 527.7901 | 1965820.0 |
| 2024-12-13 11:00:00 | QQQ | ETF | 527.83 | 529.0 | 527.3001 | 528.0702 | 2092086.0 |
| 2024-12-13 11:30:00 | QQQ | ETF | 528.13 | 529.51 | 527.5 | 528.13 | 1046436.0 |
| 2024-12-13 12:00:00 | QQQ | ETF | 528.08 | 529.1299 | 527.95 | 528.09 | 556086.0 |
| 2024-12-13 12:30:00 | QQQ | ETF | 528.05 | 528.7 | 527.64 | 527.74 | 661217.0 |
> showing 50 of 35,714 rows — these rows as CSV