PREVIEW / etf_5min / 2023-02-27
file: by_date/etf_5min/2023/2023-02-27.parquet size: 1.9 MB rows: 93,122
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-02-27 04:00:00 | SPY | ETF | 397.86 | 398.17 | 397.6 | 398.02 | 13267.0 |
| 2023-02-27 04:05:00 | SPY | ETF | 397.95 | 398.02 | 397.86 | 397.92 | 5911.0 |
| 2023-02-27 04:10:00 | SPY | ETF | 397.98 | 397.98 | 397.98 | 397.98 | 450.0 |
| 2023-02-27 04:15:00 | SPY | ETF | 398.0 | 398.06 | 398.0 | 398.05 | 5390.0 |
| 2023-02-27 04:20:00 | SPY | ETF | 398.08 | 398.27 | 398.08 | 398.27 | 3773.0 |
| 2023-02-27 04:25:00 | SPY | ETF | 398.21 | 398.27 | 398.21 | 398.27 | 1900.0 |
| 2023-02-27 04:30:00 | SPY | ETF | 398.26 | 398.44 | 398.26 | 398.38 | 3500.0 |
| 2023-02-27 04:35:00 | SPY | ETF | 398.37 | 398.37 | 398.27 | 398.34 | 975.0 |
| 2023-02-27 04:40:00 | SPY | ETF | 398.3 | 398.5 | 398.28 | 398.43 | 9198.0 |
| 2023-02-27 04:45:00 | SPY | ETF | 398.41 | 398.48 | 398.31 | 398.31 | 6413.0 |
| 2023-02-27 04:50:00 | SPY | ETF | 398.31 | 398.35 | 398.2 | 398.21 | 2180.0 |
| 2023-02-27 04:55:00 | SPY | ETF | 398.21 | 398.25 | 398.15 | 398.15 | 1600.0 |
| 2023-02-27 05:00:00 | SPY | ETF | 398.16 | 398.37 | 398.16 | 398.37 | 1350.0 |
| 2023-02-27 05:05:00 | SPY | ETF | 398.35 | 398.36 | 398.31 | 398.31 | 1507.0 |
| 2023-02-27 05:10:00 | SPY | ETF | 398.37 | 398.62 | 398.36 | 398.62 | 5580.0 |
| 2023-02-27 05:15:00 | SPY | ETF | 398.5 | 398.5 | 398.29 | 398.29 | 1023.0 |
| 2023-02-27 05:20:00 | SPY | ETF | 398.33 | 398.33 | 398.25 | 398.25 | 729.0 |
| 2023-02-27 05:35:00 | SPY | ETF | 398.34 | 398.34 | 398.31 | 398.31 | 400.0 |
| 2023-02-27 05:40:00 | SPY | ETF | 398.26 | 398.28 | 398.23 | 398.26 | 2000.0 |
| 2023-02-27 05:45:00 | SPY | ETF | 398.26 | 398.38 | 398.26 | 398.38 | 1157.0 |
| 2023-02-27 05:50:00 | SPY | ETF | 398.38 | 398.38 | 398.23 | 398.3 | 15800.0 |
| 2023-02-27 05:55:00 | SPY | ETF | 398.37 | 398.39 | 398.2 | 398.2 | 7012.0 |
| 2023-02-27 06:00:00 | SPY | ETF | 398.16 | 398.26 | 398.16 | 398.26 | 595.0 |
| 2023-02-27 06:05:00 | SPY | ETF | 398.2 | 398.32 | 398.02 | 398.3 | 14920.0 |
| 2023-02-27 06:10:00 | SPY | ETF | 398.24 | 398.29 | 398.24 | 398.29 | 1379.0 |
| 2023-02-27 06:15:00 | SPY | ETF | 398.3 | 398.3 | 398.24 | 398.24 | 2300.0 |
| 2023-02-27 06:20:00 | SPY | ETF | 398.31 | 398.31 | 398.28 | 398.28 | 3200.0 |
| 2023-02-27 06:25:00 | SPY | ETF | 398.22 | 398.43 | 398.22 | 398.42 | 8450.0 |
| 2023-02-27 06:30:00 | SPY | ETF | 398.39 | 398.5 | 398.39 | 398.41 | 1410.0 |
| 2023-02-27 06:35:00 | SPY | ETF | 398.45 | 398.45 | 398.23 | 398.25 | 30214.0 |
| 2023-02-27 06:40:00 | SPY | ETF | 398.24 | 398.34 | 398.24 | 398.31 | 16000.0 |
| 2023-02-27 06:45:00 | SPY | ETF | 398.26 | 398.32 | 398.26 | 398.32 | 250.0 |
| 2023-02-27 06:50:00 | SPY | ETF | 398.22 | 398.26 | 398.19 | 398.25 | 17500.0 |
| 2023-02-27 06:55:00 | SPY | ETF | 398.18 | 398.28 | 398.15 | 398.28 | 16178.0 |
| 2023-02-27 07:00:00 | SPY | ETF | 398.26 | 398.44 | 398.02 | 398.4 | 68722.0 |
| 2023-02-27 07:05:00 | SPY | ETF | 398.37 | 398.5 | 398.34 | 398.4 | 6081.0 |
| 2023-02-27 07:10:00 | SPY | ETF | 398.4 | 398.5 | 398.39 | 398.5 | 7159.0 |
| 2023-02-27 07:15:00 | SPY | ETF | 398.5 | 398.6 | 398.5 | 398.57 | 10892.0 |
| 2023-02-27 07:20:00 | SPY | ETF | 398.59 | 398.59 | 398.31 | 398.31 | 22115.0 |
| 2023-02-27 07:25:00 | SPY | ETF | 398.35 | 398.35 | 398.23 | 398.33 | 8567.0 |
| 2023-02-27 07:30:00 | SPY | ETF | 398.31 | 398.6 | 398.31 | 398.58 | 15820.0 |
| 2023-02-27 07:35:00 | SPY | ETF | 398.58 | 398.58 | 398.37 | 398.37 | 35575.0 |
| 2023-02-27 07:40:00 | SPY | ETF | 398.39 | 398.45 | 398.36 | 398.411 | 3199.0 |
| 2023-02-27 07:45:00 | SPY | ETF | 398.46 | 398.47 | 398.39 | 398.42 | 2743.0 |
| 2023-02-27 07:50:00 | SPY | ETF | 398.41 | 398.42 | 398.18 | 398.18 | 6869.0 |
| 2023-02-27 07:55:00 | SPY | ETF | 398.16 | 398.2 | 398.02 | 398.2 | 13043.0 |
| 2023-02-27 08:00:00 | SPY | ETF | 398.16 | 398.58 | 396.56 | 398.15 | 56059.0 |
| 2023-02-27 08:05:00 | SPY | ETF | 398.16 | 398.33 | 398.13 | 398.3 | 16775.0 |
| 2023-02-27 08:10:00 | SPY | ETF | 398.31 | 398.39 | 398.29 | 398.35 | 4499.0 |
| 2023-02-27 08:15:00 | SPY | ETF | 398.38 | 398.62 | 398.32 | 398.54 | 13265.0 |
> showing 50 of 93,122 rows — these rows as CSV