PREVIEW / etf_30min / 2024-05-17
file: by_date/etf_30min/2024/2024-05-17.parquet size: 778 KB rows: 30,812
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-05-17 04:00:00 | SPY | ETF | 528.8 | 528.8 | 528.15 | 528.26 | 8693.0 |
| 2024-05-17 04:30:00 | SPY | ETF | 528.19 | 528.37 | 528.1 | 528.37 | 3094.0 |
| 2024-05-17 05:00:00 | SPY | ETF | 528.4 | 528.74 | 528.4 | 528.64 | 4651.0 |
| 2024-05-17 05:30:00 | SPY | ETF | 528.64 | 528.82 | 528.58 | 528.82 | 2662.0 |
| 2024-05-17 06:00:00 | SPY | ETF | 528.68 | 528.68 | 528.5 | 528.68 | 1511.0 |
| 2024-05-17 06:30:00 | SPY | ETF | 528.74 | 528.75 | 528.55 | 528.75 | 3282.0 |
| 2024-05-17 07:00:00 | SPY | ETF | 528.78 | 528.96 | 528.6 | 528.96 | 31857.0 |
| 2024-05-17 07:30:00 | SPY | ETF | 528.91 | 529.09 | 528.85 | 528.9 | 72989.0 |
| 2024-05-17 08:00:00 | SPY | ETF | 528.8099 | 529.14 | 528.6104 | 529.09 | 58246.0 |
| 2024-05-17 08:30:00 | SPY | ETF | 529.13 | 529.33 | 529.0704 | 529.32 | 134531.0 |
| 2024-05-17 09:00:00 | SPY | ETF | 529.31 | 529.31 | 528.45 | 528.82 | 203096.0 |
| 2024-05-17 09:30:00 | SPY | ETF | 528.82 | 529.2 | 528.36 | 528.745 | 3560680.0 |
| 2024-05-17 10:00:00 | SPY | ETF | 528.76 | 529.18 | 528.342 | 529.17 | 2424614.0 |
| 2024-05-17 10:30:00 | SPY | ETF | 529.17 | 529.3 | 528.98 | 529.11 | 2407931.0 |
| 2024-05-17 11:00:00 | SPY | ETF | 529.11 | 529.125 | 528.39 | 528.76 | 1858696.0 |
| 2024-05-17 11:30:00 | SPY | ETF | 528.76 | 528.8799 | 528.27 | 528.83 | 1465078.0 |
| 2024-05-17 12:00:00 | SPY | ETF | 528.83 | 529.0295 | 528.4594 | 528.56 | 1413978.0 |
| 2024-05-17 12:30:00 | SPY | ETF | 528.5599 | 528.8301 | 528.05 | 528.7899 | 1646833.0 |
| 2024-05-17 13:00:00 | SPY | ETF | 528.78 | 528.9 | 528.485 | 528.695 | 1439851.0 |
| 2024-05-17 13:30:00 | SPY | ETF | 528.7 | 528.88 | 528.5 | 528.72 | 966590.0 |
| 2024-05-17 14:00:00 | SPY | ETF | 528.725 | 528.76 | 527.32 | 527.91 | 2787850.0 |
| 2024-05-17 14:30:00 | SPY | ETF | 527.9 | 528.94 | 527.88 | 528.8051 | 2146792.0 |
| 2024-05-17 15:00:00 | SPY | ETF | 528.81 | 529.31 | 528.62 | 529.22 | 2246476.0 |
| 2024-05-17 15:30:00 | SPY | ETF | 529.21 | 529.52 | 528.76 | 529.43 | 6931961.0 |
| 2024-05-17 16:00:00 | SPY | ETF | 529.42 | 529.5 | 528.669 | 529.41 | 3110255.0 |
| 2024-05-17 16:30:00 | SPY | ETF | 529.41 | 529.5 | 529.38 | 529.48 | 90014.0 |
| 2024-05-17 17:00:00 | SPY | ETF | 529.48 | 529.49 | 529.26 | 529.45 | 28056.0 |
| 2024-05-17 17:30:00 | SPY | ETF | 529.42 | 529.65 | 529.42 | 529.49 | 124787.0 |
| 2024-05-17 18:00:00 | SPY | ETF | 529.48 | 529.7005 | 529.48 | 529.7 | 23973.0 |
| 2024-05-17 18:30:00 | SPY | ETF | 529.6884 | 529.6884 | 529.64 | 529.64 | 4980.0 |
| 2024-05-17 19:00:00 | SPY | ETF | 529.61 | 529.63 | 529.57 | 529.63 | 5072.0 |
| 2024-05-17 19:30:00 | SPY | ETF | 529.66 | 529.7 | 529.6 | 529.6 | 9037.0 |
| 2024-05-17 04:00:00 | QQQ | ETF | 452.0 | 452.0 | 451.32 | 451.49 | 20471.0 |
| 2024-05-17 04:30:00 | QQQ | ETF | 451.41 | 451.68 | 451.3 | 451.68 | 12855.0 |
| 2024-05-17 05:00:00 | QQQ | ETF | 451.74 | 452.06 | 451.74 | 452.0 | 10731.0 |
| 2024-05-17 05:30:00 | QQQ | ETF | 452.08 | 452.22 | 451.98 | 452.22 | 3109.0 |
| 2024-05-17 06:00:00 | QQQ | ETF | 452.26 | 452.38 | 452.01 | 452.36 | 15227.0 |
| 2024-05-17 06:30:00 | QQQ | ETF | 452.32 | 452.42 | 452.16 | 452.42 | 17989.0 |
| 2024-05-17 07:00:00 | QQQ | ETF | 452.45 | 452.5 | 452.19 | 452.5 | 24068.0 |
| 2024-05-17 07:30:00 | QQQ | ETF | 452.5 | 452.67 | 452.43 | 452.48 | 28253.0 |
| 2024-05-17 08:00:00 | QQQ | ETF | 452.4503 | 452.79 | 451.4196 | 452.621 | 58410.0 |
| 2024-05-17 08:30:00 | QQQ | ETF | 452.67 | 452.92 | 452.6499 | 452.88 | 82973.0 |
| 2024-05-17 09:00:00 | QQQ | ETF | 452.89 | 452.89 | 452.11 | 452.16 | 224369.0 |
| 2024-05-17 09:30:00 | QQQ | ETF | 452.11 | 452.48 | 451.35 | 451.78 | 2429627.0 |
| 2024-05-17 10:00:00 | QQQ | ETF | 451.79 | 452.435 | 451.39 | 452.425 | 1991737.0 |
| 2024-05-17 10:30:00 | QQQ | ETF | 452.43 | 452.72 | 452.2501 | 452.44 | 1391905.0 |
| 2024-05-17 11:00:00 | QQQ | ETF | 452.445 | 452.45 | 451.545 | 452.19 | 1109568.0 |
| 2024-05-17 11:30:00 | QQQ | ETF | 452.18 | 452.205 | 451.39 | 452.1501 | 1402598.0 |
| 2024-05-17 12:00:00 | QQQ | ETF | 452.16 | 452.32 | 451.6599 | 451.85 | 771387.0 |
| 2024-05-17 12:30:00 | QQQ | ETF | 451.84 | 451.948 | 451.06 | 451.8391 | 1273116.0 |
> showing 50 of 30,812 rows — these rows as CSV