PREVIEW / etf_30min / 2024-03-11
file: by_date/etf_30min/2024/2024-03-11.parquet size: 795 KB rows: 32,091
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-03-11 04:00:00 | SPY | ETF | 511.3 | 511.55 | 510.2 | 511.0 | 8238.0 |
| 2024-03-11 04:30:00 | SPY | ETF | 510.91 | 511.44 | 509.72 | 510.67 | 9943.0 |
| 2024-03-11 05:00:00 | SPY | ETF | 510.99 | 511.41 | 510.91 | 511.4 | 10267.0 |
| 2024-03-11 05:30:00 | SPY | ETF | 511.17 | 511.17 | 510.82 | 511.16 | 39930.0 |
| 2024-03-11 06:00:00 | SPY | ETF | 511.23 | 511.27 | 510.52 | 510.52 | 12741.0 |
| 2024-03-11 06:30:00 | SPY | ETF | 511.16 | 511.66 | 511.11 | 511.35 | 7356.0 |
| 2024-03-11 07:00:00 | SPY | ETF | 511.46 | 511.5 | 510.99 | 511.09 | 17085.0 |
| 2024-03-11 07:30:00 | SPY | ETF | 511.03 | 511.03 | 510.34 | 510.6 | 23718.0 |
| 2024-03-11 08:00:00 | SPY | ETF | 510.9393 | 511.71 | 509.35 | 509.7 | 158698.0 |
| 2024-03-11 08:30:00 | SPY | ETF | 509.65 | 509.98 | 509.37 | 509.9 | 100724.0 |
| 2024-03-11 09:00:00 | SPY | ETF | 509.89 | 510.71 | 509.89 | 510.46 | 196324.0 |
| 2024-03-11 09:30:00 | SPY | ETF | 510.48 | 510.94 | 509.4299 | 509.4299 | 6081983.0 |
| 2024-03-11 10:00:00 | SPY | ETF | 509.43 | 509.63 | 508.5 | 508.995 | 4234671.0 |
| 2024-03-11 10:30:00 | SPY | ETF | 508.99 | 510.73 | 508.95 | 510.59 | 3644378.0 |
| 2024-03-11 11:00:00 | SPY | ETF | 510.59 | 510.87 | 509.395 | 509.49 | 2984332.0 |
| 2024-03-11 11:30:00 | SPY | ETF | 509.48 | 510.895 | 509.2 | 510.8399 | 2621510.0 |
| 2024-03-11 12:00:00 | SPY | ETF | 510.83 | 510.8699 | 509.98 | 510.55 | 2321973.0 |
| 2024-03-11 12:30:00 | SPY | ETF | 510.55 | 511.16 | 510.51 | 511.0 | 2555431.0 |
| 2024-03-11 13:00:00 | SPY | ETF | 511.0 | 511.34 | 510.2 | 511.24 | 2246312.0 |
| 2024-03-11 13:30:00 | SPY | ETF | 511.24 | 511.57 | 510.31 | 511.05 | 2078708.0 |
| 2024-03-11 14:00:00 | SPY | ETF | 511.05 | 511.24 | 510.695 | 511.19 | 1527571.0 |
| 2024-03-11 14:30:00 | SPY | ETF | 511.1987 | 511.88 | 510.83 | 511.61 | 1951242.0 |
| 2024-03-11 15:00:00 | SPY | ETF | 511.6 | 511.6199 | 510.82 | 510.87 | 2150357.0 |
| 2024-03-11 15:30:00 | SPY | ETF | 510.875 | 511.6 | 510.54 | 511.26 | 6776697.0 |
| 2024-03-11 16:00:00 | SPY | ETF | 511.26 | 511.65 | 511.13 | 511.45 | 2772033.0 |
| 2024-03-11 16:30:00 | SPY | ETF | 511.52 | 511.85 | 511.52 | 511.76 | 251534.0 |
| 2024-03-11 17:00:00 | SPY | ETF | 511.73 | 511.73 | 511.28 | 511.28 | 70115.0 |
| 2024-03-11 17:30:00 | SPY | ETF | 511.65 | 511.79 | 511.64 | 511.7 | 20410.0 |
| 2024-03-11 18:00:00 | SPY | ETF | 511.8 | 512.6 | 511.8 | 512.47 | 77026.0 |
| 2024-03-11 18:30:00 | SPY | ETF | 512.43 | 512.55 | 512.34 | 512.4 | 12378.0 |
| 2024-03-11 19:00:00 | SPY | ETF | 512.38 | 512.47 | 512.31 | 512.43 | 4519.0 |
| 2024-03-11 19:30:00 | SPY | ETF | 512.45 | 512.69 | 512.41 | 512.69 | 34563.0 |
| 2024-03-11 04:00:00 | QQQ | ETF | 438.68 | 439.02 | 436.65 | 438.15 | 42131.0 |
| 2024-03-11 04:30:00 | QQQ | ETF | 438.15 | 438.58 | 437.11 | 438.09 | 53349.0 |
| 2024-03-11 05:00:00 | QQQ | ETF | 438.47 | 439.36 | 438.47 | 439.07 | 74102.0 |
| 2024-03-11 05:30:00 | QQQ | ETF | 439.07 | 439.12 | 438.51 | 438.72 | 39626.0 |
| 2024-03-11 06:00:00 | QQQ | ETF | 438.89 | 438.95 | 437.86 | 438.14 | 62971.0 |
| 2024-03-11 06:30:00 | QQQ | ETF | 438.21 | 439.3 | 438.21 | 438.88 | 22392.0 |
| 2024-03-11 07:00:00 | QQQ | ETF | 438.92 | 439.09 | 438.18 | 438.28 | 51832.0 |
| 2024-03-11 07:30:00 | QQQ | ETF | 438.22 | 438.32 | 437.45 | 437.7 | 79089.0 |
| 2024-03-11 08:00:00 | QQQ | ETF | 437.67 | 439.349 | 436.22 | 436.71 | 505905.0 |
| 2024-03-11 08:30:00 | QQQ | ETF | 436.72 | 437.06 | 436.22 | 436.96 | 155385.0 |
| 2024-03-11 09:00:00 | QQQ | ETF | 436.87 | 437.84 | 436.84 | 437.38 | 206010.0 |
| 2024-03-11 09:30:00 | QQQ | ETF | 437.51 | 438.13 | 435.66 | 435.69 | 5355700.0 |
| 2024-03-11 10:00:00 | QQQ | ETF | 435.69 | 436.71 | 435.44 | 436.39 | 2969472.0 |
| 2024-03-11 10:30:00 | QQQ | ETF | 436.4 | 438.63 | 436.33 | 438.13 | 3105250.0 |
| 2024-03-11 11:00:00 | QQQ | ETF | 438.1 | 438.52 | 436.36 | 436.42 | 2570214.0 |
| 2024-03-11 11:30:00 | QQQ | ETF | 436.43 | 438.18 | 436.12 | 438.06 | 1931713.0 |
| 2024-03-11 12:00:00 | QQQ | ETF | 438.05 | 438.0889 | 436.8 | 437.45 | 1810216.0 |
| 2024-03-11 12:30:00 | QQQ | ETF | 437.48 | 438.05 | 437.23 | 437.84 | 1329358.0 |
> showing 50 of 32,091 rows — these rows as CSV