PREVIEW / etf_5min / 2021-02-19
file: by_date/etf_5min/2021/2021-02-19.parquet size: 1.8 MB rows: 84,923
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-19 04:00:00 | SPY | ETF | 391.08 | 391.08 | 390.76 | 390.82 | 2375.0 |
| 2021-02-19 04:05:00 | SPY | ETF | 390.79 | 390.94 | 390.74 | 390.84 | 3668.0 |
| 2021-02-19 04:10:00 | SPY | ETF | 390.83 | 391.13 | 390.83 | 391.09 | 2300.0 |
| 2021-02-19 04:15:00 | SPY | ETF | 391.26 | 391.37 | 391.26 | 391.34 | 900.0 |
| 2021-02-19 04:20:00 | SPY | ETF | 391.39 | 391.39 | 391.31 | 391.31 | 2310.0 |
| 2021-02-19 04:25:00 | SPY | ETF | 391.37 | 391.37 | 391.22 | 391.22 | 1700.0 |
| 2021-02-19 04:30:00 | SPY | ETF | 391.38 | 391.5 | 391.38 | 391.5 | 7499.0 |
| 2021-02-19 04:35:00 | SPY | ETF | 391.6 | 391.9 | 391.6 | 391.9 | 12621.0 |
| 2021-02-19 04:40:00 | SPY | ETF | 392.0 | 392.03 | 391.88 | 392.03 | 1480.0 |
| 2021-02-19 04:45:00 | SPY | ETF | 391.77 | 391.77 | 391.7 | 391.7 | 2300.0 |
| 2021-02-19 04:50:00 | SPY | ETF | 391.75 | 391.76 | 391.73 | 391.73 | 300.0 |
| 2021-02-19 04:55:00 | SPY | ETF | 391.69 | 391.69 | 391.59 | 391.59 | 400.0 |
| 2021-02-19 05:00:00 | SPY | ETF | 391.69 | 391.77 | 391.67 | 391.76 | 13700.0 |
| 2021-02-19 05:05:00 | SPY | ETF | 391.82 | 391.82 | 391.82 | 391.82 | 1000.0 |
| 2021-02-19 05:10:00 | SPY | ETF | 391.82 | 391.98 | 391.22 | 391.96 | 6025.0 |
| 2021-02-19 05:15:00 | SPY | ETF | 391.94 | 392.17 | 391.94 | 392.08 | 6950.0 |
| 2021-02-19 05:20:00 | SPY | ETF | 391.94 | 391.94 | 391.83 | 391.83 | 900.0 |
| 2021-02-19 05:25:00 | SPY | ETF | 391.75 | 391.75 | 391.75 | 391.75 | 100.0 |
| 2021-02-19 05:30:00 | SPY | ETF | 391.75 | 391.77 | 391.75 | 391.77 | 800.0 |
| 2021-02-19 05:35:00 | SPY | ETF | 391.64 | 391.64 | 391.64 | 391.64 | 300.0 |
| 2021-02-19 05:40:00 | SPY | ETF | 391.81 | 391.81 | 391.74 | 391.78 | 800.0 |
| 2021-02-19 05:45:00 | SPY | ETF | 391.85 | 391.85 | 391.8 | 391.8 | 5600.0 |
| 2021-02-19 05:50:00 | SPY | ETF | 391.88 | 391.88 | 391.83 | 391.85 | 2097.0 |
| 2021-02-19 05:55:00 | SPY | ETF | 391.89 | 391.94 | 391.89 | 391.94 | 400.0 |
| 2021-02-19 06:00:00 | SPY | ETF | 391.89 | 391.93 | 391.7 | 391.7 | 1100.0 |
| 2021-02-19 06:05:00 | SPY | ETF | 391.63 | 391.69 | 391.59 | 391.59 | 4817.0 |
| 2021-02-19 06:10:00 | SPY | ETF | 391.55 | 391.56 | 391.45 | 391.45 | 5840.0 |
| 2021-02-19 06:15:00 | SPY | ETF | 391.41 | 391.46 | 391.4 | 391.4 | 1700.0 |
| 2021-02-19 06:25:00 | SPY | ETF | 391.51 | 391.62 | 391.51 | 391.62 | 15551.0 |
| 2021-02-19 06:30:00 | SPY | ETF | 391.57 | 391.59 | 391.31 | 391.31 | 1906.0 |
| 2021-02-19 06:35:00 | SPY | ETF | 391.41 | 391.49 | 391.4 | 391.42 | 2900.0 |
| 2021-02-19 06:40:00 | SPY | ETF | 391.5 | 391.51 | 391.49 | 391.49 | 300.0 |
| 2021-02-19 06:45:00 | SPY | ETF | 391.51 | 391.51 | 391.51 | 391.51 | 100.0 |
| 2021-02-19 06:50:00 | SPY | ETF | 391.47 | 391.47 | 391.35 | 391.39 | 1800.0 |
| 2021-02-19 06:55:00 | SPY | ETF | 391.38 | 391.44 | 391.3 | 391.44 | 1100.0 |
| 2021-02-19 07:00:00 | SPY | ETF | 391.34 | 391.56 | 391.34 | 391.56 | 10427.0 |
| 2021-02-19 07:05:00 | SPY | ETF | 391.59 | 391.8 | 391.57 | 391.76 | 39751.0 |
| 2021-02-19 07:10:00 | SPY | ETF | 391.7 | 391.77 | 391.68 | 391.75 | 6890.0 |
| 2021-02-19 07:15:00 | SPY | ETF | 391.74 | 391.8 | 391.74 | 391.8 | 200.0 |
| 2021-02-19 07:20:00 | SPY | ETF | 391.8 | 392.0 | 391.8 | 391.98 | 4770.0 |
| 2021-02-19 07:25:00 | SPY | ETF | 392.01 | 392.24 | 392.01 | 392.19 | 12532.0 |
| 2021-02-19 07:30:00 | SPY | ETF | 392.22 | 392.51 | 392.19 | 392.39 | 48640.0 |
| 2021-02-19 07:35:00 | SPY | ETF | 392.44 | 392.5 | 392.2 | 392.25 | 51759.0 |
| 2021-02-19 07:40:00 | SPY | ETF | 392.2 | 392.2 | 392.01 | 392.05 | 38105.0 |
| 2021-02-19 07:45:00 | SPY | ETF | 392.12 | 392.12 | 392.0 | 392.05 | 101649.0 |
| 2021-02-19 07:50:00 | SPY | ETF | 392.08 | 392.15 | 392.08 | 392.1 | 33040.0 |
| 2021-02-19 07:55:00 | SPY | ETF | 392.18 | 392.23 | 392.08 | 392.14 | 16226.0 |
| 2021-02-19 08:00:00 | SPY | ETF | 391.6701 | 392.51 | 390.0 | 392.2 | 102982.0 |
| 2021-02-19 08:05:00 | SPY | ETF | 392.2 | 392.31 | 392.2 | 392.28 | 20674.0 |
| 2021-02-19 08:10:00 | SPY | ETF | 392.24 | 392.46 | 392.24 | 392.39 | 49242.0 |
> showing 50 of 84,923 rows — these rows as CSV