PREVIEW / etf_30min / 2024-11-27
file: by_date/etf_30min/2024/2024-11-27.parquet size: 881 KB rows: 35,500
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-11-27 04:00:00 | SPY | ETF | 600.11 | 600.4 | 599.91 | 599.96 | 8045.0 |
| 2024-11-27 04:30:00 | SPY | ETF | 600.0 | 600.01 | 599.68 | 599.87 | 27074.0 |
| 2024-11-27 05:00:00 | SPY | ETF | 599.97 | 600.08 | 599.76 | 600.0 | 3017.0 |
| 2024-11-27 05:30:00 | SPY | ETF | 600.03 | 600.03 | 599.89 | 599.91 | 1212.0 |
| 2024-11-27 06:00:00 | SPY | ETF | 600.06 | 600.07 | 599.59 | 599.63 | 9572.0 |
| 2024-11-27 06:30:00 | SPY | ETF | 599.8 | 600.24 | 599.78 | 600.16 | 7797.0 |
| 2024-11-27 07:00:00 | SPY | ETF | 600.21 | 600.45 | 599.95 | 600.24 | 38870.0 |
| 2024-11-27 07:30:00 | SPY | ETF | 600.22 | 600.5 | 600.22 | 600.35 | 55045.0 |
| 2024-11-27 08:00:00 | SPY | ETF | 600.19 | 602.0225 | 599.8196 | 600.59 | 301308.0 |
| 2024-11-27 08:30:00 | SPY | ETF | 600.73 | 600.98 | 600.6 | 600.75 | 132668.0 |
| 2024-11-27 09:00:00 | SPY | ETF | 600.75 | 600.75 | 600.35 | 600.47 | 137991.0 |
| 2024-11-27 09:30:00 | SPY | ETF | 600.47 | 600.85 | 599.94 | 600.44 | 2378458.0 |
| 2024-11-27 10:00:00 | SPY | ETF | 600.42 | 600.42 | 599.23 | 599.35 | 2096488.0 |
| 2024-11-27 10:30:00 | SPY | ETF | 599.37 | 599.59 | 598.55 | 598.86 | 1957559.0 |
| 2024-11-27 11:00:00 | SPY | ETF | 598.86 | 598.9 | 598.25 | 598.4599 | 1349557.0 |
| 2024-11-27 11:30:00 | SPY | ETF | 598.43 | 599.15 | 598.01 | 598.15 | 1295105.0 |
| 2024-11-27 12:00:00 | SPY | ETF | 598.14 | 598.29 | 597.28 | 598.22 | 1415532.0 |
| 2024-11-27 12:30:00 | SPY | ETF | 598.22 | 598.46 | 597.77 | 598.375 | 915382.0 |
| 2024-11-27 13:00:00 | SPY | ETF | 598.375 | 598.86 | 598.18 | 598.4778 | 859219.0 |
| 2024-11-27 13:30:00 | SPY | ETF | 598.46 | 599.12 | 598.36 | 598.9294 | 1357819.0 |
| 2024-11-27 14:00:00 | SPY | ETF | 598.94 | 599.1099 | 598.655 | 598.71 | 711087.0 |
| 2024-11-27 14:30:00 | SPY | ETF | 598.71 | 599.1 | 598.42 | 598.7099 | 954943.0 |
| 2024-11-27 15:00:00 | SPY | ETF | 598.71 | 598.99 | 598.31 | 598.55 | 1288869.0 |
| 2024-11-27 15:30:00 | SPY | ETF | 598.545 | 598.98 | 597.94 | 598.79 | 3535722.0 |
| 2024-11-27 16:00:00 | SPY | ETF | 598.78 | 598.94 | 598.58 | 598.8 | 1692946.0 |
| 2024-11-27 16:30:00 | SPY | ETF | 598.8 | 598.85 | 598.65 | 598.76 | 76508.0 |
| 2024-11-27 17:00:00 | SPY | ETF | 598.8571 | 598.8571 | 598.65 | 598.75 | 4983.0 |
| 2024-11-27 17:30:00 | SPY | ETF | 598.82 | 598.86 | 598.75 | 598.83 | 4538.0 |
| 2024-11-27 18:00:00 | SPY | ETF | 598.75 | 599.31 | 598.75 | 599.16 | 15102.0 |
| 2024-11-27 18:30:00 | SPY | ETF | 599.15 | 599.22 | 599.15 | 599.19 | 5176.0 |
| 2024-11-27 19:00:00 | SPY | ETF | 599.21 | 599.43 | 599.21 | 599.42 | 3869.0 |
| 2024-11-27 19:30:00 | SPY | ETF | 599.41 | 599.41 | 599.31 | 599.4 | 8958.0 |
| 2024-11-27 04:00:00 | QQQ | ETF | 508.17 | 508.52 | 507.62 | 507.7 | 24201.0 |
| 2024-11-27 04:30:00 | QQQ | ETF | 507.7 | 507.81 | 507.38 | 507.76 | 34497.0 |
| 2024-11-27 05:00:00 | QQQ | ETF | 507.8 | 507.9 | 507.57 | 507.9 | 8526.0 |
| 2024-11-27 05:30:00 | QQQ | ETF | 507.93 | 508.21 | 507.69 | 508.14 | 14133.0 |
| 2024-11-27 06:00:00 | QQQ | ETF | 508.08 | 508.15 | 507.53 | 507.53 | 13871.0 |
| 2024-11-27 06:30:00 | QQQ | ETF | 507.54 | 508.03 | 507.54 | 508.02 | 11519.0 |
| 2024-11-27 07:00:00 | QQQ | ETF | 508.04 | 508.34 | 507.7 | 508.05 | 65452.0 |
| 2024-11-27 07:30:00 | QQQ | ETF | 508.03 | 508.52 | 508.03 | 508.38 | 64927.0 |
| 2024-11-27 08:00:00 | QQQ | ETF | 508.06 | 509.31 | 507.605 | 508.5411 | 73028.0 |
| 2024-11-27 08:30:00 | QQQ | ETF | 508.67 | 508.87 | 508.3501 | 508.6 | 80812.0 |
| 2024-11-27 09:00:00 | QQQ | ETF | 508.61 | 508.64 | 508.1 | 508.2 | 98936.0 |
| 2024-11-27 09:30:00 | QQQ | ETF | 508.17 | 508.24 | 505.85 | 506.38 | 2594565.0 |
| 2024-11-27 10:00:00 | QQQ | ETF | 506.38 | 506.38 | 504.07 | 504.33 | 1596189.0 |
| 2024-11-27 10:30:00 | QQQ | ETF | 504.29 | 504.5799 | 503.16 | 503.58 | 1510589.0 |
| 2024-11-27 11:00:00 | QQQ | ETF | 503.58 | 503.71 | 502.46 | 503.11 | 1316096.0 |
| 2024-11-27 11:30:00 | QQQ | ETF | 503.02 | 504.0 | 502.42 | 502.92 | 1058433.0 |
| 2024-11-27 12:00:00 | QQQ | ETF | 502.88 | 503.23 | 501.93 | 503.09 | 1046317.0 |
| 2024-11-27 12:30:00 | QQQ | ETF | 503.11 | 503.66 | 502.66 | 503.59 | 936190.0 |
> showing 50 of 35,500 rows — these rows as CSV