PREVIEW / etf_5min / 2023-04-04
file: by_date/etf_5min/2023/2023-04-04.parquet size: 2.0 MB rows: 97,949
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-04-04 04:00:00 | SPY | ETF | 410.7 | 410.74 | 410.65 | 410.71 | 2575.0 |
| 2023-04-04 04:05:00 | SPY | ETF | 410.75 | 410.88 | 410.75 | 410.88 | 400.0 |
| 2023-04-04 04:10:00 | SPY | ETF | 410.87 | 410.93 | 410.87 | 410.93 | 314.0 |
| 2023-04-04 04:15:00 | SPY | ETF | 410.89 | 411.12 | 410.88 | 411.12 | 1719.0 |
| 2023-04-04 04:20:00 | SPY | ETF | 411.36 | 411.47 | 411.25 | 411.47 | 2433.0 |
| 2023-04-04 04:25:00 | SPY | ETF | 411.41 | 411.41 | 411.19 | 411.2 | 2188.0 |
| 2023-04-04 04:30:00 | SPY | ETF | 411.27 | 411.3 | 411.21 | 411.21 | 1000.0 |
| 2023-04-04 04:35:00 | SPY | ETF | 411.16 | 411.17 | 411.14 | 411.17 | 3085.0 |
| 2023-04-04 04:40:00 | SPY | ETF | 411.15 | 411.15 | 410.97 | 411.05 | 8772.0 |
| 2023-04-04 04:45:00 | SPY | ETF | 411.21 | 411.21 | 411.15 | 411.2 | 2668.0 |
| 2023-04-04 04:50:00 | SPY | ETF | 411.22 | 411.22 | 411.22 | 411.22 | 100.0 |
| 2023-04-04 04:55:00 | SPY | ETF | 411.17 | 411.29 | 411.1 | 411.1 | 2447.0 |
| 2023-04-04 05:00:00 | SPY | ETF | 411.24 | 411.24 | 411.16 | 411.17 | 705.0 |
| 2023-04-04 05:10:00 | SPY | ETF | 411.31 | 411.39 | 411.3 | 411.3 | 1399.0 |
| 2023-04-04 05:15:00 | SPY | ETF | 411.4 | 411.51 | 411.4 | 411.51 | 1367.0 |
| 2023-04-04 05:20:00 | SPY | ETF | 411.6 | 411.74 | 411.58 | 411.71 | 2004.0 |
| 2023-04-04 05:25:00 | SPY | ETF | 411.72 | 411.85 | 411.72 | 411.85 | 1002.0 |
| 2023-04-04 05:30:00 | SPY | ETF | 411.78 | 411.78 | 411.75 | 411.76 | 603.0 |
| 2023-04-04 05:35:00 | SPY | ETF | 411.8 | 411.82 | 411.8 | 411.8 | 11117.0 |
| 2023-04-04 05:40:00 | SPY | ETF | 411.88 | 412.13 | 411.87 | 412.02 | 9867.0 |
| 2023-04-04 05:45:00 | SPY | ETF | 412.04 | 412.39 | 412.01 | 412.31 | 3143.0 |
| 2023-04-04 05:50:00 | SPY | ETF | 412.25 | 412.33 | 412.25 | 412.33 | 1512.0 |
| 2023-04-04 05:55:00 | SPY | ETF | 412.3 | 412.3 | 412.21 | 412.24 | 2018.0 |
| 2023-04-04 06:00:00 | SPY | ETF | 412.13 | 412.25 | 412.13 | 412.18 | 3432.0 |
| 2023-04-04 06:05:00 | SPY | ETF | 412.14 | 412.14 | 412.11 | 412.11 | 298.0 |
| 2023-04-04 06:10:00 | SPY | ETF | 412.08 | 412.08 | 412.0 | 412.08 | 1422.0 |
| 2023-04-04 06:15:00 | SPY | ETF | 412.1 | 412.23 | 412.1 | 412.23 | 700.0 |
| 2023-04-04 06:20:00 | SPY | ETF | 412.2 | 412.25 | 412.15 | 412.18 | 1530.0 |
| 2023-04-04 06:25:00 | SPY | ETF | 412.18 | 412.21 | 412.18 | 412.2 | 8999.0 |
| 2023-04-04 06:30:00 | SPY | ETF | 412.2 | 412.5 | 412.2 | 412.5 | 8804.0 |
| 2023-04-04 06:35:00 | SPY | ETF | 412.5 | 412.66 | 412.48 | 412.66 | 2916.0 |
| 2023-04-04 06:40:00 | SPY | ETF | 412.66 | 412.75 | 412.54 | 412.55 | 9159.0 |
| 2023-04-04 06:45:00 | SPY | ETF | 412.53 | 412.53 | 412.53 | 412.53 | 274.0 |
| 2023-04-04 06:50:00 | SPY | ETF | 412.56 | 412.64 | 412.56 | 412.59 | 1900.0 |
| 2023-04-04 06:55:00 | SPY | ETF | 412.54 | 412.54 | 412.36 | 412.42 | 4803.0 |
| 2023-04-04 07:00:00 | SPY | ETF | 412.4 | 412.44 | 412.33 | 412.44 | 26070.0 |
| 2023-04-04 07:05:00 | SPY | ETF | 412.48 | 412.5 | 412.42 | 412.46 | 10195.0 |
| 2023-04-04 07:10:00 | SPY | ETF | 412.43 | 412.43 | 412.31 | 412.34 | 6292.0 |
| 2023-04-04 07:15:00 | SPY | ETF | 412.25 | 412.25 | 412.09 | 412.09 | 14525.0 |
| 2023-04-04 07:20:00 | SPY | ETF | 412.1 | 412.15 | 412.03 | 412.13 | 8834.0 |
| 2023-04-04 07:25:00 | SPY | ETF | 412.13 | 412.2 | 412.07 | 412.19 | 6508.0 |
| 2023-04-04 07:30:00 | SPY | ETF | 412.14 | 412.21 | 412.14 | 412.19 | 5810.0 |
| 2023-04-04 07:35:00 | SPY | ETF | 412.16 | 412.3 | 412.16 | 412.3 | 6010.0 |
| 2023-04-04 07:40:00 | SPY | ETF | 412.31 | 412.31 | 412.1 | 412.1 | 4306.0 |
| 2023-04-04 07:45:00 | SPY | ETF | 412.11 | 412.14 | 412.05 | 412.05 | 5849.0 |
| 2023-04-04 07:50:00 | SPY | ETF | 412.1 | 412.16 | 412.01 | 412.08 | 13090.0 |
| 2023-04-04 07:55:00 | SPY | ETF | 412.1 | 412.2 | 412.1 | 412.14 | 5703.0 |
| 2023-04-04 08:00:00 | SPY | ETF | 412.37 | 412.74 | 410.75 | 412.39 | 45049.0 |
| 2023-04-04 08:05:00 | SPY | ETF | 412.38 | 412.4 | 412.26 | 412.26 | 8714.0 |
| 2023-04-04 08:10:00 | SPY | ETF | 412.22 | 412.26 | 412.15 | 412.23 | 8365.0 |
> showing 50 of 97,949 rows — these rows as CSV