PREVIEW / etf_5min / 2023-09-08
file: by_date/etf_5min/2023/2023-09-08.parquet size: 1.9 MB rows: 90,871
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-08 04:00:00 | SPY | ETF | 445.75 | 445.79 | 445.55 | 445.55 | 3418.0 |
| 2023-09-08 04:05:00 | SPY | ETF | 445.78 | 445.86 | 445.57 | 445.57 | 1110.0 |
| 2023-09-08 04:10:00 | SPY | ETF | 445.33 | 445.41 | 445.26 | 445.26 | 498.0 |
| 2023-09-08 04:15:00 | SPY | ETF | 445.15 | 445.15 | 444.85 | 444.85 | 5176.0 |
| 2023-09-08 04:20:00 | SPY | ETF | 444.75 | 444.9 | 444.74 | 444.75 | 2112.0 |
| 2023-09-08 04:25:00 | SPY | ETF | 444.74 | 444.84 | 444.38 | 444.64 | 4321.0 |
| 2023-09-08 04:35:00 | SPY | ETF | 444.38 | 444.45 | 444.35 | 444.44 | 1007.0 |
| 2023-09-08 04:40:00 | SPY | ETF | 444.66 | 444.66 | 444.66 | 444.66 | 300.0 |
| 2023-09-08 04:45:00 | SPY | ETF | 444.65 | 444.65 | 444.45 | 444.45 | 340.0 |
| 2023-09-08 04:50:00 | SPY | ETF | 444.48 | 444.48 | 444.38 | 444.38 | 547.0 |
| 2023-09-08 04:55:00 | SPY | ETF | 444.42 | 444.42 | 444.36 | 444.38 | 12456.0 |
| 2023-09-08 05:00:00 | SPY | ETF | 444.13 | 444.13 | 443.79 | 443.84 | 7700.0 |
| 2023-09-08 05:05:00 | SPY | ETF | 443.88 | 443.93 | 443.83 | 443.83 | 1935.0 |
| 2023-09-08 05:10:00 | SPY | ETF | 443.96 | 444.14 | 443.96 | 444.12 | 983.0 |
| 2023-09-08 05:15:00 | SPY | ETF | 444.0 | 444.0 | 443.84 | 443.88 | 547.0 |
| 2023-09-08 05:20:00 | SPY | ETF | 443.96 | 443.97 | 443.83 | 443.95 | 5967.0 |
| 2023-09-08 05:25:00 | SPY | ETF | 443.97 | 443.97 | 443.97 | 443.97 | 169.0 |
| 2023-09-08 05:35:00 | SPY | ETF | 443.92 | 443.92 | 443.78 | 443.85 | 5538.0 |
| 2023-09-08 05:40:00 | SPY | ETF | 443.95 | 444.02 | 443.95 | 444.02 | 251.0 |
| 2023-09-08 05:45:00 | SPY | ETF | 444.02 | 444.27 | 444.02 | 444.27 | 2539.0 |
| 2023-09-08 05:50:00 | SPY | ETF | 444.17 | 444.17 | 444.0 | 444.0 | 765.0 |
| 2023-09-08 05:55:00 | SPY | ETF | 444.04 | 444.04 | 443.97 | 443.97 | 700.0 |
| 2023-09-08 06:00:00 | SPY | ETF | 443.88 | 444.01 | 443.88 | 444.01 | 1400.0 |
| 2023-09-08 06:05:00 | SPY | ETF | 443.97 | 444.08 | 443.97 | 444.08 | 940.0 |
| 2023-09-08 06:10:00 | SPY | ETF | 444.12 | 444.19 | 444.12 | 444.19 | 522.0 |
| 2023-09-08 06:15:00 | SPY | ETF | 444.1 | 444.21 | 444.1 | 444.21 | 301.0 |
| 2023-09-08 06:20:00 | SPY | ETF | 444.13 | 444.45 | 444.13 | 444.3 | 11479.0 |
| 2023-09-08 06:25:00 | SPY | ETF | 444.32 | 444.36 | 444.22 | 444.23 | 17338.0 |
| 2023-09-08 06:30:00 | SPY | ETF | 444.4 | 444.45 | 444.36 | 444.45 | 1384.0 |
| 2023-09-08 06:35:00 | SPY | ETF | 444.48 | 444.55 | 444.44 | 444.44 | 2322.0 |
| 2023-09-08 06:40:00 | SPY | ETF | 444.44 | 444.44 | 444.41 | 444.41 | 250.0 |
| 2023-09-08 06:45:00 | SPY | ETF | 444.49 | 444.55 | 444.39 | 444.55 | 745.0 |
| 2023-09-08 06:50:00 | SPY | ETF | 444.6 | 444.61 | 444.54 | 444.58 | 3890.0 |
| 2023-09-08 06:55:00 | SPY | ETF | 444.58 | 444.6 | 444.5 | 444.55 | 3329.0 |
| 2023-09-08 07:00:00 | SPY | ETF | 444.65 | 444.65 | 444.51 | 444.51 | 1935.0 |
| 2023-09-08 07:05:00 | SPY | ETF | 444.57 | 444.66 | 444.56 | 444.66 | 1123.0 |
| 2023-09-08 07:10:00 | SPY | ETF | 444.59 | 444.59 | 444.48 | 444.48 | 9105.0 |
| 2023-09-08 07:15:00 | SPY | ETF | 444.45 | 444.45 | 444.22 | 444.22 | 3688.0 |
| 2023-09-08 07:20:00 | SPY | ETF | 444.29 | 444.29 | 444.11 | 444.11 | 4818.0 |
| 2023-09-08 07:25:00 | SPY | ETF | 444.09 | 444.11 | 444.0 | 444.11 | 6422.0 |
| 2023-09-08 07:30:00 | SPY | ETF | 444.05 | 444.25 | 443.99 | 444.24 | 2201.0 |
| 2023-09-08 07:35:00 | SPY | ETF | 444.14 | 444.229 | 443.96 | 444.01 | 8511.0 |
| 2023-09-08 07:40:00 | SPY | ETF | 444.0 | 444.0 | 443.85 | 444.0 | 11895.0 |
| 2023-09-08 07:45:00 | SPY | ETF | 444.05 | 444.05 | 443.84 | 444.02 | 2476.0 |
| 2023-09-08 07:50:00 | SPY | ETF | 444.09 | 444.25 | 444.05 | 444.21 | 1934.0 |
| 2023-09-08 07:55:00 | SPY | ETF | 444.22 | 444.35 | 444.201 | 444.29 | 2778.0 |
| 2023-09-08 08:00:00 | SPY | ETF | 444.25 | 446.0 | 443.8796 | 444.44 | 47781.0 |
| 2023-09-08 08:05:00 | SPY | ETF | 444.41 | 444.55 | 444.38 | 444.55 | 19015.0 |
| 2023-09-08 08:10:00 | SPY | ETF | 444.53 | 444.69 | 444.53 | 444.68 | 9431.0 |
| 2023-09-08 08:15:00 | SPY | ETF | 444.68 | 444.7 | 444.59 | 444.62 | 5331.0 |
> showing 50 of 90,871 rows — these rows as CSV