PREVIEW / etf_5min / 2023-09-07
file: by_date/etf_5min/2023/2023-09-07.parquet size: 2.0 MB rows: 94,606
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 |
|---|---|---|---|---|---|---|---|
| 2023-09-07 04:00:00 | SPY | ETF | 445.6 | 445.6 | 445.34 | 445.36 | 6821.0 |
| 2023-09-07 04:05:00 | SPY | ETF | 445.34 | 445.4 | 445.13 | 445.13 | 17295.0 |
| 2023-09-07 04:10:00 | SPY | ETF | 445.13 | 445.13 | 444.9 | 444.97 | 1368.0 |
| 2023-09-07 04:15:00 | SPY | ETF | 445.04 | 445.05 | 445.04 | 445.05 | 800.0 |
| 2023-09-07 04:20:00 | SPY | ETF | 444.88 | 444.9 | 444.81 | 444.81 | 1586.0 |
| 2023-09-07 04:25:00 | SPY | ETF | 444.72 | 444.72 | 444.6 | 444.6 | 400.0 |
| 2023-09-07 04:30:00 | SPY | ETF | 444.85 | 444.96 | 444.85 | 444.86 | 2400.0 |
| 2023-09-07 04:35:00 | SPY | ETF | 444.88 | 444.88 | 444.72 | 444.72 | 1500.0 |
| 2023-09-07 04:40:00 | SPY | ETF | 444.75 | 444.75 | 444.7 | 444.72 | 553.0 |
| 2023-09-07 04:45:00 | SPY | ETF | 444.8 | 444.8 | 444.8 | 444.8 | 100.0 |
| 2023-09-07 04:50:00 | SPY | ETF | 445.0 | 445.2 | 445.0 | 445.2 | 750.0 |
| 2023-09-07 04:55:00 | SPY | ETF | 445.17 | 445.21 | 445.15 | 445.19 | 2411.0 |
| 2023-09-07 05:00:00 | SPY | ETF | 445.13 | 445.13 | 445.13 | 445.13 | 100.0 |
| 2023-09-07 05:05:00 | SPY | ETF | 445.39 | 445.39 | 445.39 | 445.39 | 500.0 |
| 2023-09-07 05:10:00 | SPY | ETF | 445.44 | 445.5 | 445.33 | 445.4 | 1600.0 |
| 2023-09-07 05:15:00 | SPY | ETF | 445.5 | 445.5 | 445.42 | 445.42 | 500.0 |
| 2023-09-07 05:20:00 | SPY | ETF | 445.46 | 445.5 | 445.46 | 445.5 | 300.0 |
| 2023-09-07 05:25:00 | SPY | ETF | 445.58 | 445.58 | 445.44 | 445.44 | 800.0 |
| 2023-09-07 05:30:00 | SPY | ETF | 445.57 | 445.64 | 445.57 | 445.64 | 402.0 |
| 2023-09-07 05:35:00 | SPY | ETF | 445.7 | 445.71 | 445.69 | 445.69 | 5773.0 |
| 2023-09-07 05:40:00 | SPY | ETF | 445.6 | 445.74 | 445.6 | 445.7 | 1500.0 |
| 2023-09-07 05:45:00 | SPY | ETF | 445.65 | 445.65 | 445.48 | 445.48 | 600.0 |
| 2023-09-07 05:50:00 | SPY | ETF | 445.32 | 445.32 | 445.29 | 445.29 | 400.0 |
| 2023-09-07 05:55:00 | SPY | ETF | 445.39 | 445.47 | 445.39 | 445.47 | 700.0 |
| 2023-09-07 06:05:00 | SPY | ETF | 445.4 | 445.5 | 445.4 | 445.5 | 2100.0 |
| 2023-09-07 06:10:00 | SPY | ETF | 445.4 | 445.48 | 445.4 | 445.45 | 1200.0 |
| 2023-09-07 06:15:00 | SPY | ETF | 445.47 | 445.48 | 445.39 | 445.39 | 700.0 |
| 2023-09-07 06:20:00 | SPY | ETF | 445.33 | 445.33 | 445.31 | 445.31 | 1275.0 |
| 2023-09-07 06:25:00 | SPY | ETF | 445.31 | 445.31 | 445.28 | 445.28 | 600.0 |
| 2023-09-07 06:30:00 | SPY | ETF | 445.23 | 445.23 | 445.07 | 445.08 | 12900.0 |
| 2023-09-07 06:35:00 | SPY | ETF | 445.04 | 445.15 | 445.04 | 445.15 | 1900.0 |
| 2023-09-07 06:40:00 | SPY | ETF | 445.14 | 445.14 | 445.02 | 445.02 | 5398.0 |
| 2023-09-07 06:45:00 | SPY | ETF | 445.05 | 445.05 | 444.89 | 444.9 | 9571.0 |
| 2023-09-07 06:50:00 | SPY | ETF | 444.86 | 444.99 | 444.66 | 444.9 | 28041.0 |
| 2023-09-07 06:55:00 | SPY | ETF | 444.9 | 445.0 | 444.9 | 444.92 | 13170.0 |
| 2023-09-07 07:00:00 | SPY | ETF | 444.98 | 445.17 | 444.98 | 445.16 | 2440.0 |
| 2023-09-07 07:05:00 | SPY | ETF | 445.19 | 445.26 | 445.19 | 445.25 | 3296.0 |
| 2023-09-07 07:10:00 | SPY | ETF | 445.25 | 445.25 | 444.99 | 445.05 | 6430.0 |
| 2023-09-07 07:15:00 | SPY | ETF | 445.05 | 445.05 | 444.81 | 444.92 | 11901.0 |
| 2023-09-07 07:20:00 | SPY | ETF | 444.93 | 444.965 | 444.7 | 444.71 | 59843.0 |
| 2023-09-07 07:25:00 | SPY | ETF | 444.68 | 444.7 | 444.46 | 444.49 | 28311.0 |
| 2023-09-07 07:30:00 | SPY | ETF | 444.48 | 444.61 | 444.41 | 444.61 | 12751.0 |
| 2023-09-07 07:35:00 | SPY | ETF | 444.6 | 444.7 | 444.6 | 444.7 | 1893.0 |
| 2023-09-07 07:40:00 | SPY | ETF | 444.71 | 444.81 | 444.71 | 444.8 | 9395.0 |
| 2023-09-07 07:45:00 | SPY | ETF | 444.85 | 444.85 | 444.5 | 444.5 | 3278.0 |
| 2023-09-07 07:50:00 | SPY | ETF | 444.54 | 444.56 | 444.44 | 444.44 | 26594.0 |
| 2023-09-07 07:55:00 | SPY | ETF | 444.54 | 444.61 | 444.45 | 444.45 | 12893.0 |
| 2023-09-07 08:00:00 | SPY | ETF | 444.9799 | 446.07 | 444.3301 | 444.4 | 40809.0 |
| 2023-09-07 08:05:00 | SPY | ETF | 444.42 | 444.65 | 444.4 | 444.65 | 10569.0 |
| 2023-09-07 08:10:00 | SPY | ETF | 444.51 | 444.54 | 444.39 | 444.42 | 34529.0 |
> showing 50 of 94,606 rows — these rows as CSV