PREVIEW / etf_5min / 2023-05-02
file: by_date/etf_5min/2023/2023-05-02.parquet size: 2.0 MB rows: 98,458
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-05-02 04:00:00 | SPY | ETF | 415.16 | 415.25 | 415.12 | 415.14 | 1818.0 |
| 2023-05-02 04:05:00 | SPY | ETF | 415.24 | 415.28 | 415.12 | 415.28 | 1205.0 |
| 2023-05-02 04:10:00 | SPY | ETF | 415.2 | 415.2 | 415.18 | 415.18 | 624.0 |
| 2023-05-02 04:15:00 | SPY | ETF | 415.21 | 415.21 | 415.21 | 415.21 | 100.0 |
| 2023-05-02 04:20:00 | SPY | ETF | 415.17 | 415.18 | 415.0 | 415.0 | 2145.0 |
| 2023-05-02 04:25:00 | SPY | ETF | 415.09 | 415.1 | 415.09 | 415.1 | 1508.0 |
| 2023-05-02 04:30:00 | SPY | ETF | 415.14 | 415.18 | 415.14 | 415.15 | 2100.0 |
| 2023-05-02 04:35:00 | SPY | ETF | 415.05 | 415.1 | 414.96 | 415.1 | 6605.0 |
| 2023-05-02 04:40:00 | SPY | ETF | 415.11 | 415.21 | 415.11 | 415.2 | 1340.0 |
| 2023-05-02 04:45:00 | SPY | ETF | 415.23 | 415.25 | 415.23 | 415.25 | 1450.0 |
| 2023-05-02 04:50:00 | SPY | ETF | 415.2 | 415.2 | 415.01 | 415.01 | 3600.0 |
| 2023-05-02 04:55:00 | SPY | ETF | 415.01 | 415.05 | 415.01 | 415.05 | 1120.0 |
| 2023-05-02 05:00:00 | SPY | ETF | 415.06 | 415.08 | 415.06 | 415.08 | 1736.0 |
| 2023-05-02 05:05:00 | SPY | ETF | 415.11 | 415.11 | 414.96 | 414.96 | 731.0 |
| 2023-05-02 05:10:00 | SPY | ETF | 415.03 | 415.03 | 414.91 | 414.91 | 300.0 |
| 2023-05-02 05:15:00 | SPY | ETF | 414.89 | 414.92 | 414.89 | 414.92 | 1048.0 |
| 2023-05-02 05:20:00 | SPY | ETF | 415.1 | 415.1 | 414.99 | 414.99 | 980.0 |
| 2023-05-02 05:25:00 | SPY | ETF | 414.98 | 415.05 | 414.98 | 415.0 | 43100.0 |
| 2023-05-02 05:30:00 | SPY | ETF | 415.0 | 415.0 | 414.93 | 414.98 | 13925.0 |
| 2023-05-02 05:35:00 | SPY | ETF | 415.02 | 415.28 | 415.02 | 415.26 | 16066.0 |
| 2023-05-02 05:40:00 | SPY | ETF | 415.35 | 415.39 | 415.31 | 415.39 | 3941.0 |
| 2023-05-02 05:45:00 | SPY | ETF | 415.4 | 415.4 | 415.35 | 415.36 | 3247.0 |
| 2023-05-02 05:50:00 | SPY | ETF | 415.3 | 415.36 | 415.3 | 415.3 | 1500.0 |
| 2023-05-02 05:55:00 | SPY | ETF | 415.2 | 415.2 | 415.2 | 415.2 | 938.0 |
| 2023-05-02 06:00:00 | SPY | ETF | 415.08 | 415.08 | 414.81 | 414.81 | 30460.0 |
| 2023-05-02 06:05:00 | SPY | ETF | 414.79 | 414.97 | 414.79 | 414.97 | 2002.0 |
| 2023-05-02 06:10:00 | SPY | ETF | 414.89 | 414.97 | 414.7 | 414.97 | 5611.0 |
| 2023-05-02 06:15:00 | SPY | ETF | 414.88 | 414.88 | 414.88 | 414.88 | 800.0 |
| 2023-05-02 06:20:00 | SPY | ETF | 414.93 | 414.96 | 414.9 | 414.96 | 1230.0 |
| 2023-05-02 06:25:00 | SPY | ETF | 414.98 | 414.98 | 414.96 | 414.98 | 1153.0 |
| 2023-05-02 06:30:00 | SPY | ETF | 414.95 | 414.97 | 414.95 | 414.97 | 350.0 |
| 2023-05-02 06:35:00 | SPY | ETF | 414.99 | 415.02 | 414.97 | 415.02 | 1700.0 |
| 2023-05-02 06:40:00 | SPY | ETF | 414.95 | 415.0 | 414.89 | 414.91 | 6992.0 |
| 2023-05-02 06:45:00 | SPY | ETF | 414.9 | 415.15 | 414.9 | 415.15 | 27659.0 |
| 2023-05-02 06:50:00 | SPY | ETF | 415.15 | 415.19 | 415.15 | 415.15 | 34684.0 |
| 2023-05-02 06:55:00 | SPY | ETF | 415.11 | 415.13 | 415.11 | 415.13 | 700.0 |
| 2023-05-02 07:00:00 | SPY | ETF | 415.13 | 415.15 | 415.05 | 415.05 | 19026.0 |
| 2023-05-02 07:05:00 | SPY | ETF | 415.08 | 415.2 | 415.06 | 415.2 | 3550.0 |
| 2023-05-02 07:10:00 | SPY | ETF | 415.23 | 415.25 | 415.17 | 415.25 | 37650.0 |
| 2023-05-02 07:15:00 | SPY | ETF | 415.25 | 415.34 | 415.25 | 415.29 | 5797.0 |
| 2023-05-02 07:20:00 | SPY | ETF | 415.37 | 415.37 | 415.27 | 415.27 | 6656.0 |
| 2023-05-02 07:25:00 | SPY | ETF | 415.2 | 415.2 | 415.12 | 415.12 | 4308.0 |
| 2023-05-02 07:30:00 | SPY | ETF | 415.09 | 415.1 | 415.01 | 415.01 | 11293.0 |
| 2023-05-02 07:35:00 | SPY | ETF | 415.11 | 415.11 | 415.02 | 415.04 | 3500.0 |
| 2023-05-02 07:40:00 | SPY | ETF | 415.02 | 415.149 | 415.02 | 415.11 | 765.0 |
| 2023-05-02 07:45:00 | SPY | ETF | 415.16 | 415.18 | 414.95 | 414.95 | 9757.0 |
| 2023-05-02 07:50:00 | SPY | ETF | 414.94 | 414.98 | 414.91 | 414.97 | 5159.0 |
| 2023-05-02 07:55:00 | SPY | ETF | 415.01 | 415.08 | 414.99 | 415.06 | 10606.0 |
| 2023-05-02 08:00:00 | SPY | ETF | 415.1 | 416.1 | 414.8 | 414.87 | 26310.0 |
| 2023-05-02 08:05:00 | SPY | ETF | 414.86 | 414.93 | 414.86 | 414.92 | 3552.0 |
> showing 50 of 98,458 rows — these rows as CSV