PREVIEW / etf_5min / 2024-11-21
file: by_date/etf_5min/2024/2024-11-21.parquet size: 2.6 MB rows: 126,645
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-21 04:00:00 | SPY | ETF | 588.85 | 588.86 | 588.31 | 588.36 | 9453.0 |
| 2024-11-21 04:05:00 | SPY | ETF | 588.55 | 588.55 | 587.94 | 587.94 | 1854.0 |
| 2024-11-21 04:10:00 | SPY | ETF | 588.08 | 588.36 | 588.03 | 588.22 | 1843.0 |
| 2024-11-21 04:15:00 | SPY | ETF | 588.3 | 588.3 | 587.82 | 587.92 | 3971.0 |
| 2024-11-21 04:20:00 | SPY | ETF | 587.91 | 587.91 | 587.5 | 587.5 | 882.0 |
| 2024-11-21 04:25:00 | SPY | ETF | 587.71 | 587.71 | 587.23 | 587.49 | 1760.0 |
| 2024-11-21 04:30:00 | SPY | ETF | 587.38 | 587.8 | 587.35 | 587.62 | 3199.0 |
| 2024-11-21 04:35:00 | SPY | ETF | 587.63 | 587.63 | 587.53 | 587.53 | 227.0 |
| 2024-11-21 04:40:00 | SPY | ETF | 588.0 | 588.15 | 588.0 | 588.0 | 1195.0 |
| 2024-11-21 04:45:00 | SPY | ETF | 588.2 | 588.43 | 588.2 | 588.31 | 5573.0 |
| 2024-11-21 04:50:00 | SPY | ETF | 588.17 | 588.25 | 588.12 | 588.25 | 787.0 |
| 2024-11-21 04:55:00 | SPY | ETF | 588.28 | 588.37 | 588.26 | 588.37 | 787.0 |
| 2024-11-21 05:00:00 | SPY | ETF | 588.04 | 588.04 | 588.04 | 588.04 | 100.0 |
| 2024-11-21 05:05:00 | SPY | ETF | 588.49 | 588.75 | 588.49 | 588.75 | 1100.0 |
| 2024-11-21 05:10:00 | SPY | ETF | 588.6 | 588.6 | 588.51 | 588.54 | 1499.0 |
| 2024-11-21 05:15:00 | SPY | ETF | 588.4 | 588.56 | 588.4 | 588.56 | 648.0 |
| 2024-11-21 05:20:00 | SPY | ETF | 588.48 | 588.48 | 588.42 | 588.42 | 249.0 |
| 2024-11-21 05:25:00 | SPY | ETF | 588.5 | 588.62 | 588.5 | 588.62 | 712.0 |
| 2024-11-21 05:30:00 | SPY | ETF | 588.63 | 588.7 | 588.63 | 588.7 | 1907.0 |
| 2024-11-21 05:35:00 | SPY | ETF | 588.95 | 589.04 | 588.95 | 589.04 | 4200.0 |
| 2024-11-21 05:40:00 | SPY | ETF | 589.08 | 589.17 | 589.08 | 589.17 | 500.0 |
| 2024-11-21 05:45:00 | SPY | ETF | 589.04 | 589.07 | 588.91 | 588.91 | 1894.0 |
| 2024-11-21 05:50:00 | SPY | ETF | 589.0 | 589.07 | 588.87 | 588.88 | 515.0 |
| 2024-11-21 05:55:00 | SPY | ETF | 588.8 | 588.97 | 588.8 | 588.87 | 900.0 |
| 2024-11-21 06:00:00 | SPY | ETF | 589.06 | 589.45 | 589.06 | 589.4 | 1186.0 |
| 2024-11-21 06:05:00 | SPY | ETF | 589.24 | 589.85 | 589.24 | 589.85 | 2774.0 |
| 2024-11-21 06:10:00 | SPY | ETF | 589.83 | 589.87 | 589.83 | 589.85 | 2174.0 |
| 2024-11-21 06:15:00 | SPY | ETF | 589.92 | 590.29 | 589.88 | 590.24 | 2481.0 |
| 2024-11-21 06:20:00 | SPY | ETF | 590.16 | 590.5 | 590.16 | 590.47 | 2790.0 |
| 2024-11-21 06:25:00 | SPY | ETF | 590.31 | 590.5 | 590.31 | 590.5 | 2225.0 |
| 2024-11-21 06:30:00 | SPY | ETF | 590.53 | 590.59 | 590.11 | 590.59 | 2266.0 |
| 2024-11-21 06:35:00 | SPY | ETF | 590.7 | 590.81 | 590.28 | 590.29 | 67007.0 |
| 2024-11-21 06:40:00 | SPY | ETF | 590.46 | 590.76 | 590.36 | 590.76 | 6261.0 |
| 2024-11-21 06:45:00 | SPY | ETF | 590.71 | 590.75 | 590.66 | 590.66 | 944.0 |
| 2024-11-21 06:50:00 | SPY | ETF | 590.75 | 590.81 | 590.57 | 590.81 | 2889.0 |
| 2024-11-21 06:55:00 | SPY | ETF | 590.82 | 590.9 | 590.75 | 590.86 | 20578.0 |
| 2024-11-21 07:00:00 | SPY | ETF | 590.74 | 591.34 | 590.67 | 591.34 | 14780.0 |
| 2024-11-21 07:05:00 | SPY | ETF | 591.37 | 591.69 | 591.34 | 591.63 | 15693.0 |
| 2024-11-21 07:10:00 | SPY | ETF | 591.73 | 591.94 | 591.73 | 591.84 | 12107.0 |
| 2024-11-21 07:15:00 | SPY | ETF | 592.0 | 592.57 | 592.0 | 592.53 | 32827.0 |
| 2024-11-21 07:20:00 | SPY | ETF | 592.39 | 592.52 | 592.27 | 592.27 | 12195.0 |
| 2024-11-21 07:25:00 | SPY | ETF | 592.31 | 592.47 | 592.0 | 592.15 | 60243.0 |
| 2024-11-21 07:30:00 | SPY | ETF | 592.27 | 592.37 | 591.86 | 591.93 | 10611.0 |
| 2024-11-21 07:35:00 | SPY | ETF | 592.09 | 592.09 | 591.73 | 591.99 | 10990.0 |
| 2024-11-21 07:40:00 | SPY | ETF | 592.16 | 592.62 | 592.14 | 592.581 | 7472.0 |
| 2024-11-21 07:45:00 | SPY | ETF | 592.56 | 592.65 | 591.77 | 591.82 | 44615.0 |
| 2024-11-21 07:50:00 | SPY | ETF | 591.83 | 591.83 | 591.42 | 591.42 | 37988.0 |
| 2024-11-21 07:55:00 | SPY | ETF | 591.42 | 591.75 | 591.42 | 591.6 | 19446.0 |
| 2024-11-21 08:00:00 | SPY | ETF | 591.18 | 592.65 | 588.0 | 591.59 | 65028.0 |
| 2024-11-21 08:05:00 | SPY | ETF | 591.65 | 591.89 | 591.6 | 591.6 | 9861.0 |
> showing 50 of 126,645 rows — these rows as CSV