PREVIEW / etf_5min / 2023-08-23
file: by_date/etf_5min/2023/2023-08-23.parquet size: 2.0 MB rows: 98,095
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-08-23 04:00:00 | SPY | ETF | 439.81 | 440.04 | 439.74 | 440.04 | 5042.0 |
| 2023-08-23 04:05:00 | SPY | ETF | 439.96 | 440.24 | 439.96 | 440.24 | 3100.0 |
| 2023-08-23 04:10:00 | SPY | ETF | 440.29 | 440.65 | 440.29 | 440.56 | 4362.0 |
| 2023-08-23 04:15:00 | SPY | ETF | 440.62 | 440.67 | 440.62 | 440.63 | 2915.0 |
| 2023-08-23 04:20:00 | SPY | ETF | 440.6 | 440.6 | 440.5 | 440.5 | 1000.0 |
| 2023-08-23 04:25:00 | SPY | ETF | 440.54 | 440.63 | 440.54 | 440.6 | 4497.0 |
| 2023-08-23 04:30:00 | SPY | ETF | 440.62 | 440.62 | 440.54 | 440.58 | 2370.0 |
| 2023-08-23 04:40:00 | SPY | ETF | 440.57 | 440.57 | 440.48 | 440.48 | 1735.0 |
| 2023-08-23 04:50:00 | SPY | ETF | 440.45 | 440.5 | 440.43 | 440.43 | 2580.0 |
| 2023-08-23 04:55:00 | SPY | ETF | 440.37 | 440.49 | 440.37 | 440.45 | 2500.0 |
| 2023-08-23 05:00:00 | SPY | ETF | 440.39 | 440.57 | 440.39 | 440.57 | 400.0 |
| 2023-08-23 05:05:00 | SPY | ETF | 440.52 | 440.58 | 440.52 | 440.55 | 2004.0 |
| 2023-08-23 05:10:00 | SPY | ETF | 440.62 | 440.62 | 440.5 | 440.5 | 1470.0 |
| 2023-08-23 05:15:00 | SPY | ETF | 440.41 | 440.41 | 440.07 | 440.07 | 5300.0 |
| 2023-08-23 05:20:00 | SPY | ETF | 440.07 | 440.19 | 440.04 | 440.19 | 1175.0 |
| 2023-08-23 05:25:00 | SPY | ETF | 440.12 | 440.2 | 440.12 | 440.2 | 700.0 |
| 2023-08-23 05:30:00 | SPY | ETF | 440.25 | 440.28 | 440.25 | 440.28 | 1000.0 |
| 2023-08-23 05:35:00 | SPY | ETF | 440.24 | 440.33 | 440.24 | 440.33 | 2900.0 |
| 2023-08-23 05:40:00 | SPY | ETF | 440.5 | 440.51 | 440.46 | 440.46 | 765.0 |
| 2023-08-23 05:45:00 | SPY | ETF | 440.39 | 440.4 | 440.3 | 440.4 | 998.0 |
| 2023-08-23 05:50:00 | SPY | ETF | 440.4 | 440.51 | 440.4 | 440.48 | 4000.0 |
| 2023-08-23 05:55:00 | SPY | ETF | 440.48 | 440.48 | 440.41 | 440.41 | 765.0 |
| 2023-08-23 06:00:00 | SPY | ETF | 440.36 | 440.49 | 440.36 | 440.41 | 6298.0 |
| 2023-08-23 06:05:00 | SPY | ETF | 440.23 | 440.31 | 440.23 | 440.31 | 1724.0 |
| 2023-08-23 06:10:00 | SPY | ETF | 440.33 | 440.33 | 440.28 | 440.33 | 5234.0 |
| 2023-08-23 06:15:00 | SPY | ETF | 440.28 | 440.28 | 440.18 | 440.24 | 2264.0 |
| 2023-08-23 06:20:00 | SPY | ETF | 440.25 | 440.29 | 440.17 | 440.17 | 6905.0 |
| 2023-08-23 06:25:00 | SPY | ETF | 440.16 | 440.16 | 439.93 | 439.93 | 3902.0 |
| 2023-08-23 06:30:00 | SPY | ETF | 439.97 | 440.04 | 439.96 | 440.04 | 1273.0 |
| 2023-08-23 06:35:00 | SPY | ETF | 439.92 | 439.92 | 439.8 | 439.8 | 1910.0 |
| 2023-08-23 06:40:00 | SPY | ETF | 439.77 | 439.77 | 439.55 | 439.55 | 4088.0 |
| 2023-08-23 06:45:00 | SPY | ETF | 439.51 | 439.51 | 439.25 | 439.44 | 10758.0 |
| 2023-08-23 06:50:00 | SPY | ETF | 439.36 | 439.36 | 439.32 | 439.33 | 426.0 |
| 2023-08-23 06:55:00 | SPY | ETF | 439.31 | 439.36 | 439.2 | 439.36 | 1390.0 |
| 2023-08-23 07:00:00 | SPY | ETF | 439.4 | 439.41 | 439.02 | 439.1 | 185972.0 |
| 2023-08-23 07:05:00 | SPY | ETF | 439.0 | 439.0 | 438.69 | 438.74 | 22306.0 |
| 2023-08-23 07:10:00 | SPY | ETF | 438.7 | 438.7 | 438.5 | 438.59 | 15749.0 |
| 2023-08-23 07:15:00 | SPY | ETF | 438.53 | 438.71 | 438.53 | 438.64 | 32839.0 |
| 2023-08-23 07:20:00 | SPY | ETF | 438.595 | 438.9 | 438.595 | 438.88 | 19428.0 |
| 2023-08-23 07:25:00 | SPY | ETF | 438.89 | 438.94 | 438.7 | 438.7 | 32629.0 |
| 2023-08-23 07:30:00 | SPY | ETF | 438.65 | 439.06 | 438.65 | 439.06 | 9662.0 |
| 2023-08-23 07:35:00 | SPY | ETF | 439.0 | 439.0 | 438.85 | 438.88 | 13065.0 |
| 2023-08-23 07:40:00 | SPY | ETF | 438.79 | 438.91 | 438.6 | 438.6 | 21991.0 |
| 2023-08-23 07:45:00 | SPY | ETF | 438.59 | 438.9 | 438.59 | 438.9 | 15903.0 |
| 2023-08-23 07:50:00 | SPY | ETF | 438.89 | 438.98 | 438.78 | 438.96 | 38579.0 |
| 2023-08-23 07:55:00 | SPY | ETF | 438.9 | 439.01 | 438.9 | 439.01 | 7658.0 |
| 2023-08-23 08:00:00 | SPY | ETF | 439.19 | 440.6 | 438.53 | 438.84 | 68227.0 |
| 2023-08-23 08:05:00 | SPY | ETF | 438.75 | 438.98 | 438.75 | 438.86 | 11717.0 |
| 2023-08-23 08:10:00 | SPY | ETF | 438.92 | 439.08 | 438.89 | 438.99 | 23337.0 |
| 2023-08-23 08:15:00 | SPY | ETF | 439.0 | 439.15 | 438.83 | 438.84 | 27786.0 |
> showing 50 of 98,095 rows — these rows as CSV