PREVIEW / etf_5min / 2021-02-17
file: by_date/etf_5min/2021/2021-02-17.parquet size: 1.9 MB rows: 87,242
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-17 04:00:00 | SPY | ETF | 392.39 | 392.74 | 392.39 | 392.62 | 17266.0 |
| 2021-02-17 04:05:00 | SPY | ETF | 392.53 | 392.58 | 392.44 | 392.44 | 1300.0 |
| 2021-02-17 04:10:00 | SPY | ETF | 392.49 | 392.49 | 392.2 | 392.35 | 3400.0 |
| 2021-02-17 04:15:00 | SPY | ETF | 392.3 | 392.3 | 392.1 | 392.14 | 4100.0 |
| 2021-02-17 04:20:00 | SPY | ETF | 392.19 | 392.33 | 392.19 | 392.33 | 1000.0 |
| 2021-02-17 04:25:00 | SPY | ETF | 392.27 | 392.27 | 392.27 | 392.27 | 100.0 |
| 2021-02-17 04:30:00 | SPY | ETF | 392.29 | 392.3 | 392.2 | 392.2 | 1700.0 |
| 2021-02-17 04:35:00 | SPY | ETF | 392.25 | 392.25 | 391.8 | 391.85 | 3721.0 |
| 2021-02-17 04:40:00 | SPY | ETF | 391.92 | 391.98 | 391.91 | 391.93 | 1200.0 |
| 2021-02-17 04:45:00 | SPY | ETF | 391.96 | 391.96 | 391.77 | 391.77 | 3400.0 |
| 2021-02-17 04:50:00 | SPY | ETF | 391.84 | 391.95 | 391.84 | 391.94 | 2000.0 |
| 2021-02-17 04:55:00 | SPY | ETF | 391.95 | 391.95 | 391.95 | 391.95 | 100.0 |
| 2021-02-17 05:00:00 | SPY | ETF | 391.95 | 391.99 | 391.95 | 391.98 | 400.0 |
| 2021-02-17 05:05:00 | SPY | ETF | 392.0 | 392.04 | 392.0 | 392.04 | 650.0 |
| 2021-02-17 05:10:00 | SPY | ETF | 392.17 | 392.25 | 392.1 | 392.1 | 500.0 |
| 2021-02-17 05:15:00 | SPY | ETF | 392.12 | 392.12 | 392.12 | 392.12 | 100.0 |
| 2021-02-17 05:25:00 | SPY | ETF | 392.26 | 392.26 | 392.26 | 392.26 | 300.0 |
| 2021-02-17 05:30:00 | SPY | ETF | 392.3 | 392.3 | 392.29 | 392.29 | 600.0 |
| 2021-02-17 05:35:00 | SPY | ETF | 392.26 | 392.26 | 392.26 | 392.26 | 300.0 |
| 2021-02-17 05:40:00 | SPY | ETF | 392.21 | 392.3 | 392.21 | 392.3 | 800.0 |
| 2021-02-17 05:45:00 | SPY | ETF | 392.34 | 392.34 | 392.26 | 392.26 | 500.0 |
| 2021-02-17 05:50:00 | SPY | ETF | 392.23 | 392.23 | 392.22 | 392.22 | 200.0 |
| 2021-02-17 05:55:00 | SPY | ETF | 392.07 | 392.12 | 392.04 | 392.09 | 28800.0 |
| 2021-02-17 06:00:00 | SPY | ETF | 392.14 | 392.28 | 392.14 | 392.24 | 750.0 |
| 2021-02-17 06:05:00 | SPY | ETF | 392.21 | 392.24 | 392.0 | 392.1 | 6900.0 |
| 2021-02-17 06:10:00 | SPY | ETF | 392.07 | 392.17 | 392.07 | 392.17 | 300.0 |
| 2021-02-17 06:15:00 | SPY | ETF | 392.09 | 392.09 | 391.97 | 391.98 | 2200.0 |
| 2021-02-17 06:20:00 | SPY | ETF | 392.06 | 392.06 | 392.06 | 392.06 | 100.0 |
| 2021-02-17 06:25:00 | SPY | ETF | 392.14 | 392.14 | 392.14 | 392.14 | 100.0 |
| 2021-02-17 06:30:00 | SPY | ETF | 392.17 | 392.17 | 392.17 | 392.17 | 200.0 |
| 2021-02-17 06:35:00 | SPY | ETF | 392.18 | 392.2 | 392.18 | 392.2 | 300.0 |
| 2021-02-17 06:45:00 | SPY | ETF | 392.27 | 392.27 | 392.27 | 392.27 | 1900.0 |
| 2021-02-17 06:50:00 | SPY | ETF | 392.29 | 392.32 | 392.29 | 392.32 | 11200.0 |
| 2021-02-17 06:55:00 | SPY | ETF | 392.29 | 392.34 | 392.25 | 392.34 | 2180.0 |
| 2021-02-17 07:00:00 | SPY | ETF | 392.31 | 392.39 | 392.25 | 392.39 | 6895.0 |
| 2021-02-17 07:05:00 | SPY | ETF | 392.39 | 392.42 | 392.33 | 392.37 | 15652.0 |
| 2021-02-17 07:10:00 | SPY | ETF | 392.33 | 392.33 | 392.24 | 392.25 | 25073.0 |
| 2021-02-17 07:15:00 | SPY | ETF | 392.28 | 392.3 | 392.22 | 392.29 | 4088.0 |
| 2021-02-17 07:20:00 | SPY | ETF | 392.3 | 392.3 | 392.25 | 392.3 | 6088.0 |
| 2021-02-17 07:25:00 | SPY | ETF | 392.27 | 392.3 | 392.23 | 392.3 | 4508.0 |
| 2021-02-17 07:30:00 | SPY | ETF | 392.3 | 392.43 | 392.25 | 392.43 | 6508.0 |
| 2021-02-17 07:35:00 | SPY | ETF | 392.43 | 392.67 | 392.43 | 392.58 | 16409.0 |
| 2021-02-17 07:40:00 | SPY | ETF | 392.59 | 392.61 | 392.54 | 392.55 | 14119.0 |
| 2021-02-17 07:45:00 | SPY | ETF | 392.61 | 392.66 | 392.57 | 392.66 | 81912.0 |
| 2021-02-17 07:50:00 | SPY | ETF | 392.66 | 392.68 | 392.59 | 392.63 | 2010.0 |
| 2021-02-17 07:55:00 | SPY | ETF | 392.65 | 392.65 | 392.56 | 392.56 | 4769.0 |
| 2021-02-17 08:00:00 | SPY | ETF | 392.64 | 393.0 | 391.83 | 392.56 | 90495.0 |
| 2021-02-17 08:05:00 | SPY | ETF | 392.55 | 392.58 | 392.5 | 392.5 | 37745.0 |
| 2021-02-17 08:10:00 | SPY | ETF | 392.53 | 392.6 | 392.5 | 392.5 | 40350.0 |
| 2021-02-17 08:15:00 | SPY | ETF | 392.5 | 392.54 | 392.18 | 392.29 | 65823.0 |
> showing 50 of 87,242 rows — these rows as CSV