PREVIEW / etf_30min / 2024-06-10
file: by_date/etf_30min/2024/2024-06-10.parquet size: 783 KB rows: 31,227
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-06-10 04:00:00 | SPY | ETF | 533.49 | 533.54 | 533.13 | 533.13 | 7087.0 |
| 2024-06-10 04:30:00 | SPY | ETF | 533.22 | 533.3 | 532.88 | 532.88 | 2800.0 |
| 2024-06-10 05:00:00 | SPY | ETF | 532.83 | 532.83 | 532.5 | 532.61 | 24604.0 |
| 2024-06-10 05:30:00 | SPY | ETF | 532.64 | 533.0 | 532.64 | 532.8 | 2830.0 |
| 2024-06-10 06:00:00 | SPY | ETF | 532.85 | 533.09 | 532.83 | 533.09 | 8795.0 |
| 2024-06-10 06:30:00 | SPY | ETF | 533.12 | 533.62 | 533.12 | 533.34 | 13066.0 |
| 2024-06-10 07:00:00 | SPY | ETF | 533.33 | 533.64 | 533.26 | 533.64 | 27713.0 |
| 2024-06-10 07:30:00 | SPY | ETF | 533.62 | 533.78 | 533.52 | 533.62 | 59938.0 |
| 2024-06-10 08:00:00 | SPY | ETF | 533.3593 | 534.28 | 533.02 | 533.7599 | 55710.0 |
| 2024-06-10 08:30:00 | SPY | ETF | 533.78 | 533.79 | 533.0 | 533.08 | 97507.0 |
| 2024-06-10 09:00:00 | SPY | ETF | 533.12 | 533.27 | 532.76 | 533.21 | 139292.0 |
| 2024-06-10 09:30:00 | SPY | ETF | 533.18 | 533.27 | 532.57 | 533.09 | 2609002.0 |
| 2024-06-10 10:00:00 | SPY | ETF | 533.1 | 533.63 | 533.03 | 533.59 | 1374224.0 |
| 2024-06-10 10:30:00 | SPY | ETF | 533.585 | 533.9 | 533.43 | 533.74 | 952389.0 |
| 2024-06-10 11:00:00 | SPY | ETF | 533.75 | 534.38 | 533.73 | 534.38 | 1142135.0 |
| 2024-06-10 11:30:00 | SPY | ETF | 534.39 | 535.05 | 534.32 | 534.605 | 1868448.0 |
| 2024-06-10 12:00:00 | SPY | ETF | 534.61 | 535.14 | 534.56 | 534.8693 | 896863.0 |
| 2024-06-10 12:30:00 | SPY | ETF | 534.87 | 535.07 | 534.63 | 534.845 | 852874.0 |
| 2024-06-10 13:00:00 | SPY | ETF | 534.85 | 534.87 | 534.26 | 534.31 | 928644.0 |
| 2024-06-10 13:30:00 | SPY | ETF | 534.3188 | 535.72 | 534.23 | 535.305 | 1685493.0 |
| 2024-06-10 14:00:00 | SPY | ETF | 535.305 | 535.58 | 534.4 | 534.5 | 1218009.0 |
| 2024-06-10 14:30:00 | SPY | ETF | 534.4752 | 535.255 | 534.29 | 535.01 | 1014425.0 |
| 2024-06-10 15:00:00 | SPY | ETF | 535.005 | 535.99 | 534.895 | 535.5801 | 2169849.0 |
| 2024-06-10 15:30:00 | SPY | ETF | 535.6 | 535.73 | 534.7 | 535.65 | 7882431.0 |
| 2024-06-10 16:00:00 | SPY | ETF | 535.65 | 535.78 | 534.89 | 535.16 | 3151210.0 |
| 2024-06-10 16:30:00 | SPY | ETF | 535.16 | 535.66 | 535.14 | 535.38 | 76282.0 |
| 2024-06-10 17:00:00 | SPY | ETF | 535.36 | 535.52 | 535.35 | 535.46 | 31063.0 |
| 2024-06-10 17:30:00 | SPY | ETF | 535.47 | 535.5 | 535.44 | 535.4596 | 3095.0 |
| 2024-06-10 18:00:00 | SPY | ETF | 535.45 | 535.59 | 535.38 | 535.5 | 23982.0 |
| 2024-06-10 18:30:00 | SPY | ETF | 535.49 | 535.51 | 535.35 | 535.39 | 4761.0 |
| 2024-06-10 19:00:00 | SPY | ETF | 535.3 | 535.3 | 534.98 | 534.98 | 8871.0 |
| 2024-06-10 19:30:00 | SPY | ETF | 534.98 | 535.19 | 534.98 | 535.148 | 16466.0 |
| 2024-06-10 04:00:00 | QQQ | ETF | 462.52 | 462.59 | 462.06 | 462.32 | 66339.0 |
| 2024-06-10 04:30:00 | QQQ | ETF | 462.47 | 462.49 | 461.98 | 461.98 | 24710.0 |
| 2024-06-10 05:00:00 | QQQ | ETF | 461.99 | 462.13 | 461.55 | 461.83 | 25050.0 |
| 2024-06-10 05:30:00 | QQQ | ETF | 461.78 | 462.17 | 461.78 | 462.05 | 26350.0 |
| 2024-06-10 06:00:00 | QQQ | ETF | 462.18 | 462.36 | 462.0 | 462.35 | 24134.0 |
| 2024-06-10 06:30:00 | QQQ | ETF | 462.43 | 463.01 | 462.4 | 462.5 | 31660.0 |
| 2024-06-10 07:00:00 | QQQ | ETF | 462.44 | 462.86 | 462.44 | 462.8 | 21052.0 |
| 2024-06-10 07:30:00 | QQQ | ETF | 462.82 | 463.03 | 462.67 | 462.72 | 53197.0 |
| 2024-06-10 08:00:00 | QQQ | ETF | 462.82 | 463.17 | 462.19 | 462.79 | 72538.0 |
| 2024-06-10 08:30:00 | QQQ | ETF | 462.72 | 462.81 | 461.83 | 461.93 | 121046.0 |
| 2024-06-10 09:00:00 | QQQ | ETF | 461.92 | 462.07 | 461.59 | 461.8 | 123114.0 |
| 2024-06-10 09:30:00 | QQQ | ETF | 461.82 | 462.66 | 461.53 | 461.89 | 1627625.0 |
| 2024-06-10 10:00:00 | QQQ | ETF | 461.91 | 462.98 | 461.81 | 462.94 | 1141727.0 |
| 2024-06-10 10:30:00 | QQQ | ETF | 462.94 | 463.75 | 462.615 | 463.67 | 932964.0 |
| 2024-06-10 11:00:00 | QQQ | ETF | 463.69 | 464.26 | 463.59 | 464.25 | 822008.0 |
| 2024-06-10 11:30:00 | QQQ | ETF | 464.29 | 464.81 | 464.07 | 464.1925 | 895099.0 |
| 2024-06-10 12:00:00 | QQQ | ETF | 464.2 | 465.02 | 464.08 | 464.68 | 682174.0 |
| 2024-06-10 12:30:00 | QQQ | ETF | 464.68 | 464.915 | 464.395 | 464.63 | 715415.0 |
> showing 50 of 31,227 rows — these rows as CSV