PREVIEW / etf_30min / 2024-06-11
file: by_date/etf_30min/2024/2024-06-11.parquet size: 793 KB rows: 31,222
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-11 04:00:00 | SPY | ETF | 535.92 | 535.92 | 535.02 | 535.12 | 10643.0 |
| 2024-06-11 04:30:00 | SPY | ETF | 535.1 | 535.17 | 534.64 | 534.64 | 9560.0 |
| 2024-06-11 05:00:00 | SPY | ETF | 534.55 | 534.76 | 534.41 | 534.41 | 3672.0 |
| 2024-06-11 05:30:00 | SPY | ETF | 534.49 | 534.55 | 534.25 | 534.25 | 8316.0 |
| 2024-06-11 06:00:00 | SPY | ETF | 534.05 | 534.4 | 533.81 | 534.38 | 21505.0 |
| 2024-06-11 06:30:00 | SPY | ETF | 534.48 | 534.48 | 534.18 | 534.43 | 4400.0 |
| 2024-06-11 07:00:00 | SPY | ETF | 534.41 | 534.41 | 533.55 | 533.85 | 60979.0 |
| 2024-06-11 07:30:00 | SPY | ETF | 533.9 | 534.22 | 533.83 | 534.11 | 52226.0 |
| 2024-06-11 08:00:00 | SPY | ETF | 533.9 | 535.88 | 533.6 | 534.18 | 94129.0 |
| 2024-06-11 08:30:00 | SPY | ETF | 534.18 | 534.33 | 533.89 | 534.13 | 56272.0 |
| 2024-06-11 09:00:00 | SPY | ETF | 534.1 | 534.39 | 534.03 | 534.08 | 81253.0 |
| 2024-06-11 09:30:00 | SPY | ETF | 534.1 | 534.1 | 532.05 | 532.765 | 3188064.0 |
| 2024-06-11 10:00:00 | SPY | ETF | 532.76 | 533.815 | 532.58 | 533.72 | 1713741.0 |
| 2024-06-11 10:30:00 | SPY | ETF | 533.71 | 534.71 | 533.6 | 534.69 | 1197318.0 |
| 2024-06-11 11:00:00 | SPY | ETF | 534.71 | 534.74 | 533.98 | 534.43 | 1179647.0 |
| 2024-06-11 11:30:00 | SPY | ETF | 534.45 | 534.76 | 533.6708 | 533.8101 | 1519288.0 |
| 2024-06-11 12:00:00 | SPY | ETF | 533.82 | 534.0699 | 533.55 | 533.84 | 850714.0 |
| 2024-06-11 12:30:00 | SPY | ETF | 533.8595 | 534.27 | 533.77 | 534.1 | 765057.0 |
| 2024-06-11 13:00:00 | SPY | ETF | 534.12 | 534.81 | 533.72 | 534.25 | 1580311.0 |
| 2024-06-11 13:30:00 | SPY | ETF | 534.2436 | 535.24 | 534.195 | 535.2 | 931808.0 |
| 2024-06-11 14:00:00 | SPY | ETF | 535.21 | 536.23 | 534.94 | 536.2 | 1570479.0 |
| 2024-06-11 14:30:00 | SPY | ETF | 536.21 | 536.64 | 535.8104 | 536.2 | 1959750.0 |
| 2024-06-11 15:00:00 | SPY | ETF | 536.2 | 536.56 | 535.81 | 535.86 | 2332373.0 |
| 2024-06-11 15:30:00 | SPY | ETF | 535.86 | 537.01 | 535.62 | 536.91 | 5468459.0 |
| 2024-06-11 16:00:00 | SPY | ETF | 536.9 | 537.12 | 536.394 | 536.9 | 1823285.0 |
| 2024-06-11 16:30:00 | SPY | ETF | 536.91 | 536.95 | 536.78 | 536.94 | 102963.0 |
| 2024-06-11 17:00:00 | SPY | ETF | 536.92 | 536.98 | 536.79 | 536.94 | 70412.0 |
| 2024-06-11 17:30:00 | SPY | ETF | 536.9 | 536.9469 | 536.85 | 536.94 | 3965.0 |
| 2024-06-11 18:00:00 | SPY | ETF | 536.94 | 536.95 | 536.6 | 536.86 | 49212.0 |
| 2024-06-11 18:30:00 | SPY | ETF | 536.93 | 537.03 | 536.9 | 537.03 | 6198.0 |
| 2024-06-11 19:00:00 | SPY | ETF | 537.06 | 537.21 | 537.06 | 537.18 | 22800.0 |
| 2024-06-11 19:30:00 | SPY | ETF | 537.2 | 537.2 | 536.95 | 537.0299 | 6719.0 |
| 2024-06-11 04:00:00 | QQQ | ETF | 464.46 | 464.62 | 464.01 | 464.19 | 8219.0 |
| 2024-06-11 04:30:00 | QQQ | ETF | 464.19 | 464.29 | 463.56 | 463.65 | 7113.0 |
| 2024-06-11 05:00:00 | QQQ | ETF | 463.7 | 463.95 | 463.62 | 463.62 | 7715.0 |
| 2024-06-11 05:30:00 | QQQ | ETF | 463.66 | 463.75 | 463.4 | 463.4 | 5032.0 |
| 2024-06-11 06:00:00 | QQQ | ETF | 463.2 | 463.64 | 463.11 | 463.6 | 13747.0 |
| 2024-06-11 06:30:00 | QQQ | ETF | 463.5 | 463.73 | 463.39 | 463.56 | 10315.0 |
| 2024-06-11 07:00:00 | QQQ | ETF | 463.62 | 463.62 | 462.9 | 463.21 | 43076.0 |
| 2024-06-11 07:30:00 | QQQ | ETF | 463.24 | 463.54 | 463.17 | 463.46 | 19181.0 |
| 2024-06-11 08:00:00 | QQQ | ETF | 463.6 | 464.8 | 462.87 | 463.61 | 53894.0 |
| 2024-06-11 08:30:00 | QQQ | ETF | 463.64 | 463.74 | 463.28 | 463.51 | 34357.0 |
| 2024-06-11 09:00:00 | QQQ | ETF | 463.46 | 464.83 | 463.2 | 463.48 | 110364.0 |
| 2024-06-11 09:30:00 | QQQ | ETF | 463.56 | 464.3 | 462.03 | 462.96 | 2321810.0 |
| 2024-06-11 10:00:00 | QQQ | ETF | 462.94 | 464.39 | 462.81 | 464.28 | 1648153.0 |
| 2024-06-11 10:30:00 | QQQ | ETF | 464.31 | 465.45 | 464.0905 | 465.43 | 1409063.0 |
| 2024-06-11 11:00:00 | QQQ | ETF | 465.4 | 465.4799 | 464.51 | 464.98 | 1225286.0 |
| 2024-06-11 11:30:00 | QQQ | ETF | 464.98 | 465.285 | 463.705 | 464.03 | 995091.0 |
| 2024-06-11 12:00:00 | QQQ | ETF | 464.05 | 464.7 | 463.98 | 464.5 | 524818.0 |
| 2024-06-11 12:30:00 | QQQ | ETF | 464.5001 | 464.86 | 464.389 | 464.56 | 413187.0 |
> showing 50 of 31,222 rows — these rows as CSV