PREVIEW / etf_30min / 2024-03-07
file: by_date/etf_30min/2024/2024-03-07.parquet size: 819 KB rows: 32,732
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-07 04:00:00 | SPY | ETF | 508.7 | 509.99 | 508.7 | 509.95 | 16537.0 |
| 2024-03-07 04:30:00 | SPY | ETF | 510.0 | 510.09 | 509.86 | 510.07 | 2579.0 |
| 2024-03-07 05:00:00 | SPY | ETF | 510.23 | 510.69 | 510.23 | 510.65 | 13073.0 |
| 2024-03-07 05:30:00 | SPY | ETF | 510.71 | 511.23 | 510.68 | 511.15 | 15961.0 |
| 2024-03-07 06:00:00 | SPY | ETF | 511.18 | 511.24 | 510.87 | 510.87 | 13828.0 |
| 2024-03-07 06:30:00 | SPY | ETF | 510.9 | 511.2 | 510.9 | 510.98 | 10475.0 |
| 2024-03-07 07:00:00 | SPY | ETF | 510.99 | 511.62 | 510.98 | 511.44 | 67364.0 |
| 2024-03-07 07:30:00 | SPY | ETF | 511.47 | 511.5 | 511.14 | 511.25 | 40837.0 |
| 2024-03-07 08:00:00 | SPY | ETF | 510.9903 | 511.9 | 508.0 | 511.85 | 235029.0 |
| 2024-03-07 08:30:00 | SPY | ETF | 511.95 | 512.45 | 511.73 | 512.11 | 217024.0 |
| 2024-03-07 09:00:00 | SPY | ETF | 512.13 | 513.29 | 512.0 | 513.11 | 416961.0 |
| 2024-03-07 09:30:00 | SPY | ETF | 513.11 | 513.635 | 512.18 | 513.406 | 5466428.0 |
| 2024-03-07 10:00:00 | SPY | ETF | 513.42 | 514.19 | 513.0 | 514.18 | 3015981.0 |
| 2024-03-07 10:30:00 | SPY | ETF | 514.18 | 514.87 | 513.81 | 514.37 | 3915002.0 |
| 2024-03-07 11:00:00 | SPY | ETF | 514.36 | 514.57 | 513.945 | 514.425 | 2334971.0 |
| 2024-03-07 11:30:00 | SPY | ETF | 514.42 | 514.73 | 513.77 | 514.62 | 2611882.0 |
| 2024-03-07 12:00:00 | SPY | ETF | 514.61 | 514.96 | 514.335 | 514.46 | 2271139.0 |
| 2024-03-07 12:30:00 | SPY | ETF | 514.46 | 514.665 | 514.02 | 514.55 | 2381244.0 |
| 2024-03-07 13:00:00 | SPY | ETF | 514.545 | 514.99 | 514.24 | 514.98 | 1971682.0 |
| 2024-03-07 13:30:00 | SPY | ETF | 514.99 | 515.89 | 514.83 | 515.705 | 3009220.0 |
| 2024-03-07 14:00:00 | SPY | ETF | 515.71 | 515.86 | 515.1 | 515.22 | 2595948.0 |
| 2024-03-07 14:30:00 | SPY | ETF | 515.215 | 515.4 | 514.76 | 514.905 | 2064729.0 |
| 2024-03-07 15:00:00 | SPY | ETF | 514.9 | 514.9 | 514.07 | 514.6 | 2717333.0 |
| 2024-03-07 15:30:00 | SPY | ETF | 514.61 | 515.65 | 514.55 | 514.87 | 7740112.0 |
| 2024-03-07 16:00:00 | SPY | ETF | 514.87 | 514.87 | 513.31 | 514.11 | 2830838.0 |
| 2024-03-07 16:30:00 | SPY | ETF | 514.1 | 514.68 | 514.01 | 514.59 | 203391.0 |
| 2024-03-07 17:00:00 | SPY | ETF | 514.65 | 514.65 | 514.5 | 514.55 | 13739.0 |
| 2024-03-07 17:30:00 | SPY | ETF | 514.6 | 515.0442 | 514.6 | 514.75 | 207674.0 |
| 2024-03-07 18:00:00 | SPY | ETF | 514.81 | 515.05 | 514.62 | 514.8 | 72224.0 |
| 2024-03-07 18:30:00 | SPY | ETF | 514.81 | 514.85 | 514.67 | 514.79 | 11070.0 |
| 2024-03-07 19:00:00 | SPY | ETF | 514.95 | 514.95 | 514.46 | 514.85 | 13029.0 |
| 2024-03-07 19:30:00 | SPY | ETF | 514.83 | 515.1 | 514.83 | 514.91 | 8375.0 |
| 2024-03-07 04:00:00 | QQQ | ETF | 437.4 | 439.65 | 437.39 | 439.57 | 70178.0 |
| 2024-03-07 04:30:00 | QQQ | ETF | 439.56 | 439.82 | 439.31 | 439.69 | 40739.0 |
| 2024-03-07 05:00:00 | QQQ | ETF | 439.79 | 440.24 | 439.79 | 440.01 | 38645.0 |
| 2024-03-07 05:30:00 | QQQ | ETF | 440.08 | 440.91 | 440.08 | 440.89 | 49861.0 |
| 2024-03-07 06:00:00 | QQQ | ETF | 440.78 | 441.0 | 440.29 | 440.5 | 50137.0 |
| 2024-03-07 06:30:00 | QQQ | ETF | 440.48 | 440.94 | 440.47 | 440.62 | 22701.0 |
| 2024-03-07 07:00:00 | QQQ | ETF | 440.65 | 441.27 | 440.52 | 441.1 | 79257.0 |
| 2024-03-07 07:30:00 | QQQ | ETF | 441.11 | 441.16 | 440.77 | 440.9 | 101223.0 |
| 2024-03-07 08:00:00 | QQQ | ETF | 440.6022 | 441.55 | 436.03 | 441.4 | 186221.0 |
| 2024-03-07 08:30:00 | QQQ | ETF | 441.37 | 441.9084 | 441.37 | 441.64 | 258369.0 |
| 2024-03-07 09:00:00 | QQQ | ETF | 441.6995 | 442.54 | 441.34 | 442.39 | 210723.0 |
| 2024-03-07 09:30:00 | QQQ | ETF | 442.39 | 443.43 | 440.86 | 442.65 | 4385621.0 |
| 2024-03-07 10:00:00 | QQQ | ETF | 442.66 | 443.77 | 442.24 | 443.75 | 2693927.0 |
| 2024-03-07 10:30:00 | QQQ | ETF | 443.76 | 444.82 | 443.29 | 444.05 | 2608741.0 |
| 2024-03-07 11:00:00 | QQQ | ETF | 444.055 | 445.0892 | 443.84 | 444.93 | 1731307.0 |
| 2024-03-07 11:30:00 | QQQ | ETF | 444.93 | 445.4 | 444.28 | 445.3 | 1674294.0 |
| 2024-03-07 12:00:00 | QQQ | ETF | 445.29 | 445.95 | 445.0489 | 445.44 | 1840112.0 |
| 2024-03-07 12:30:00 | QQQ | ETF | 445.44 | 445.665 | 444.915 | 445.485 | 1580242.0 |
> showing 50 of 32,732 rows — these rows as CSV