PREVIEW / etf_30min / 2024-09-10
file: by_date/etf_30min/2024/2024-09-10.parquet size: 793 KB rows: 32,411
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-09-10 04:00:00 | SPY | ETF | 547.08 | 547.18 | 546.66 | 546.79 | 17981.0 |
| 2024-09-10 04:30:00 | SPY | ETF | 546.7 | 546.7 | 546.13 | 546.2 | 17039.0 |
| 2024-09-10 05:00:00 | SPY | ETF | 546.0 | 546.0 | 544.86 | 545.25 | 12333.0 |
| 2024-09-10 05:30:00 | SPY | ETF | 545.4 | 546.14 | 545.19 | 545.94 | 159584.0 |
| 2024-09-10 06:00:00 | SPY | ETF | 546.26 | 546.26 | 545.52 | 546.23 | 16382.0 |
| 2024-09-10 06:30:00 | SPY | ETF | 546.29 | 546.69 | 545.86 | 545.98 | 16600.0 |
| 2024-09-10 07:00:00 | SPY | ETF | 546.0 | 546.71 | 545.98 | 546.68 | 57941.0 |
| 2024-09-10 07:30:00 | SPY | ETF | 546.6 | 547.03 | 546.07 | 546.86 | 135079.0 |
| 2024-09-10 08:00:00 | SPY | ETF | 546.069 | 547.86 | 545.35 | 547.85 | 197546.0 |
| 2024-09-10 08:30:00 | SPY | ETF | 547.87 | 548.29 | 547.68 | 548.12 | 107021.0 |
| 2024-09-10 09:00:00 | SPY | ETF | 548.12 | 548.5 | 548.02 | 548.33 | 128158.0 |
| 2024-09-10 09:30:00 | SPY | ETF | 548.36 | 548.66 | 547.63 | 547.8698 | 3305350.0 |
| 2024-09-10 10:00:00 | SPY | ETF | 547.87 | 548.11 | 545.5493 | 547.08 | 2547061.0 |
| 2024-09-10 10:30:00 | SPY | ETF | 547.09 | 547.2464 | 545.66 | 546.52 | 1460967.0 |
| 2024-09-10 11:00:00 | SPY | ETF | 546.52 | 547.7 | 546.11 | 547.45 | 1277806.0 |
| 2024-09-10 11:30:00 | SPY | ETF | 547.45 | 547.73 | 544.12 | 544.18 | 1856299.0 |
| 2024-09-10 12:00:00 | SPY | ETF | 544.15 | 544.62 | 543.38 | 544.29 | 1939523.0 |
| 2024-09-10 12:30:00 | SPY | ETF | 544.265 | 545.82 | 544.1101 | 545.14 | 1677079.0 |
| 2024-09-10 13:00:00 | SPY | ETF | 545.13 | 546.96 | 545.03 | 546.36 | 1720333.0 |
| 2024-09-10 13:30:00 | SPY | ETF | 546.36 | 547.1899 | 546.29 | 546.99 | 1266039.0 |
| 2024-09-10 14:00:00 | SPY | ETF | 547.0 | 547.95 | 547.0 | 547.8802 | 1900919.0 |
| 2024-09-10 14:30:00 | SPY | ETF | 547.8925 | 548.36 | 547.83 | 548.2199 | 1475901.0 |
| 2024-09-10 15:00:00 | SPY | ETF | 548.2 | 548.79 | 547.97 | 548.76 | 1940022.0 |
| 2024-09-10 15:30:00 | SPY | ETF | 548.77 | 549.15 | 548.14 | 548.82 | 4232031.0 |
| 2024-09-10 16:00:00 | SPY | ETF | 548.77 | 548.94 | 548.19 | 548.22 | 2104925.0 |
| 2024-09-10 16:30:00 | SPY | ETF | 548.2 | 548.49 | 548.13 | 548.47 | 40939.0 |
| 2024-09-10 17:00:00 | SPY | ETF | 548.48 | 548.67 | 548.3863 | 548.57 | 15696.0 |
| 2024-09-10 17:30:00 | SPY | ETF | 548.5001 | 548.61 | 548.5 | 548.6 | 5976.0 |
| 2024-09-10 18:00:00 | SPY | ETF | 548.55 | 548.55 | 548.22 | 548.25 | 26225.0 |
| 2024-09-10 18:30:00 | SPY | ETF | 548.34 | 548.5 | 548.3 | 548.46 | 28626.0 |
| 2024-09-10 19:00:00 | SPY | ETF | 548.49 | 548.69 | 548.49 | 548.68 | 3409.0 |
| 2024-09-10 19:30:00 | SPY | ETF | 548.65 | 548.663 | 548.04 | 548.3 | 47175.0 |
| 2024-09-10 04:00:00 | QQQ | ETF | 454.38 | 454.6 | 453.89 | 454.21 | 21924.0 |
| 2024-09-10 04:30:00 | QQQ | ETF | 454.13 | 454.15 | 453.37 | 453.51 | 8203.0 |
| 2024-09-10 05:00:00 | QQQ | ETF | 453.35 | 453.35 | 452.06 | 452.71 | 17272.0 |
| 2024-09-10 05:30:00 | QQQ | ETF | 452.7 | 453.55 | 452.55 | 453.33 | 15632.0 |
| 2024-09-10 06:00:00 | QQQ | ETF | 453.39 | 453.77 | 452.83 | 453.72 | 14397.0 |
| 2024-09-10 06:30:00 | QQQ | ETF | 453.75 | 454.27 | 453.52 | 453.67 | 21628.0 |
| 2024-09-10 07:00:00 | QQQ | ETF | 453.68 | 454.41 | 453.66 | 454.4 | 119180.0 |
| 2024-09-10 07:30:00 | QQQ | ETF | 454.3 | 454.99 | 453.7 | 454.81 | 67653.0 |
| 2024-09-10 08:00:00 | QQQ | ETF | 453.95 | 456.05 | 452.273 | 456.05 | 186807.0 |
| 2024-09-10 08:30:00 | QQQ | ETF | 456.03 | 456.53 | 455.78 | 456.29 | 185285.0 |
| 2024-09-10 09:00:00 | QQQ | ETF | 456.25 | 456.73 | 456.08 | 456.26 | 159218.0 |
| 2024-09-10 09:30:00 | QQQ | ETF | 456.24 | 457.82 | 455.4 | 456.41 | 3211234.0 |
| 2024-09-10 10:00:00 | QQQ | ETF | 456.44 | 457.66 | 454.55 | 456.84 | 2173729.0 |
| 2024-09-10 10:30:00 | QQQ | ETF | 456.84 | 456.94 | 454.24 | 455.55 | 1437828.0 |
| 2024-09-10 11:00:00 | QQQ | ETF | 455.52 | 456.89 | 454.97 | 456.68 | 839948.0 |
| 2024-09-10 11:30:00 | QQQ | ETF | 456.73 | 457.03 | 453.0 | 453.04 | 1505726.0 |
| 2024-09-10 12:00:00 | QQQ | ETF | 453.04 | 453.775 | 452.23 | 453.45 | 1552393.0 |
| 2024-09-10 12:30:00 | QQQ | ETF | 453.41 | 455.3 | 453.32 | 454.575 | 946091.0 |
> showing 50 of 32,411 rows — these rows as CSV