PREVIEW / etf_5min / 2020-02-21
file: by_date/etf_5min/2020/2020-02-21.parquet size: 1.6 MB rows: 68,380
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 |
|---|---|---|---|---|---|---|---|
| 2020-02-21 04:00:00 | SPY | ETF | 335.41 | 335.52 | 335.41 | 335.52 | 682.0 |
| 2020-02-21 04:05:00 | SPY | ETF | 335.51 | 335.51 | 335.49 | 335.49 | 1450.0 |
| 2020-02-21 04:10:00 | SPY | ETF | 335.37 | 335.46 | 335.31 | 335.34 | 1990.0 |
| 2020-02-21 04:15:00 | SPY | ETF | 335.29 | 335.29 | 335.29 | 335.29 | 590.0 |
| 2020-02-21 04:20:00 | SPY | ETF | 335.22 | 335.27 | 335.1 | 335.1 | 6586.0 |
| 2020-02-21 04:25:00 | SPY | ETF | 335.2 | 335.2 | 335.2 | 335.2 | 600.0 |
| 2020-02-21 04:30:00 | SPY | ETF | 335.35 | 335.35 | 335.12 | 335.12 | 810.0 |
| 2020-02-21 04:35:00 | SPY | ETF | 335.17 | 335.17 | 335.14 | 335.14 | 1361.0 |
| 2020-02-21 04:40:00 | SPY | ETF | 335.19 | 335.4 | 335.19 | 335.4 | 3152.0 |
| 2020-02-21 04:45:00 | SPY | ETF | 335.4 | 335.43 | 335.4 | 335.43 | 988.0 |
| 2020-02-21 04:50:00 | SPY | ETF | 335.16 | 335.16 | 334.9 | 334.9 | 7817.0 |
| 2020-02-21 04:55:00 | SPY | ETF | 334.89 | 334.96 | 334.89 | 334.96 | 2246.0 |
| 2020-02-21 05:00:00 | SPY | ETF | 335.05 | 335.35 | 335.05 | 335.32 | 2634.0 |
| 2020-02-21 05:05:00 | SPY | ETF | 335.29 | 335.4 | 335.29 | 335.39 | 2122.0 |
| 2020-02-21 05:10:00 | SPY | ETF | 335.3 | 335.5 | 335.3 | 335.5 | 3421.0 |
| 2020-02-21 05:15:00 | SPY | ETF | 335.47 | 335.52 | 335.44 | 335.52 | 8485.0 |
| 2020-02-21 05:20:00 | SPY | ETF | 335.52 | 335.56 | 335.47 | 335.48 | 3671.0 |
| 2020-02-21 05:25:00 | SPY | ETF | 335.49 | 335.52 | 335.49 | 335.52 | 390.0 |
| 2020-02-21 05:30:00 | SPY | ETF | 335.44 | 335.44 | 335.44 | 335.44 | 110.0 |
| 2020-02-21 05:35:00 | SPY | ETF | 335.39 | 335.39 | 335.39 | 335.39 | 100.0 |
| 2020-02-21 05:40:00 | SPY | ETF | 335.45 | 335.45 | 335.45 | 335.45 | 210.0 |
| 2020-02-21 05:45:00 | SPY | ETF | 335.44 | 335.44 | 335.44 | 335.44 | 500.0 |
| 2020-02-21 05:50:00 | SPY | ETF | 335.48 | 335.69 | 335.42 | 335.69 | 3618.0 |
| 2020-02-21 05:55:00 | SPY | ETF | 335.62 | 335.62 | 335.54 | 335.54 | 705.0 |
| 2020-02-21 06:00:00 | SPY | ETF | 335.45 | 335.45 | 335.45 | 335.45 | 210.0 |
| 2020-02-21 06:05:00 | SPY | ETF | 335.33 | 335.33 | 335.17 | 335.2 | 1143.0 |
| 2020-02-21 06:10:00 | SPY | ETF | 335.2 | 335.32 | 335.2 | 335.26 | 13115.0 |
| 2020-02-21 06:15:00 | SPY | ETF | 335.19 | 335.36 | 335.17 | 335.34 | 6149.0 |
| 2020-02-21 06:20:00 | SPY | ETF | 335.32 | 335.34 | 335.26 | 335.34 | 10521.0 |
| 2020-02-21 06:25:00 | SPY | ETF | 335.33 | 335.4 | 335.33 | 335.4 | 1020.0 |
| 2020-02-21 06:30:00 | SPY | ETF | 335.45 | 335.51 | 335.45 | 335.51 | 1423.0 |
| 2020-02-21 06:35:00 | SPY | ETF | 335.6 | 335.6 | 335.56 | 335.56 | 540.0 |
| 2020-02-21 06:40:00 | SPY | ETF | 335.58 | 335.6 | 335.58 | 335.6 | 1140.0 |
| 2020-02-21 06:45:00 | SPY | ETF | 335.7 | 335.7 | 335.61 | 335.61 | 4040.0 |
| 2020-02-21 06:50:00 | SPY | ETF | 335.54 | 335.55 | 335.5 | 335.5 | 3125.0 |
| 2020-02-21 06:55:00 | SPY | ETF | 335.45 | 335.5 | 335.4 | 335.4 | 10519.0 |
| 2020-02-21 07:00:00 | SPY | ETF | 335.47 | 335.59 | 335.44 | 335.45 | 16440.0 |
| 2020-02-21 07:05:00 | SPY | ETF | 335.41 | 335.45 | 335.39 | 335.41 | 22837.0 |
| 2020-02-21 07:10:00 | SPY | ETF | 335.43 | 335.46 | 335.36 | 335.4 | 3395.0 |
| 2020-02-21 07:15:00 | SPY | ETF | 335.38 | 335.44 | 335.36 | 335.41 | 8434.0 |
| 2020-02-21 07:20:00 | SPY | ETF | 335.43 | 335.59 | 335.43 | 335.52 | 12262.0 |
| 2020-02-21 07:25:00 | SPY | ETF | 335.52 | 335.58 | 335.5 | 335.56 | 4079.0 |
| 2020-02-21 07:30:00 | SPY | ETF | 335.56 | 335.66 | 335.55 | 335.62 | 5748.0 |
| 2020-02-21 07:35:00 | SPY | ETF | 335.68 | 335.81 | 335.66 | 335.69 | 4776.0 |
| 2020-02-21 07:40:00 | SPY | ETF | 335.7 | 335.75 | 335.68 | 335.72 | 1825.0 |
| 2020-02-21 07:45:00 | SPY | ETF | 335.76 | 335.98 | 335.76 | 335.97 | 19802.0 |
| 2020-02-21 07:50:00 | SPY | ETF | 335.97 | 335.97 | 335.79 | 335.84 | 31905.0 |
| 2020-02-21 07:55:00 | SPY | ETF | 335.82 | 335.89 | 335.82 | 335.82 | 7144.0 |
| 2020-02-21 08:00:00 | SPY | ETF | 335.5 | 335.95 | 334.32 | 335.82 | 61350.0 |
| 2020-02-21 08:05:00 | SPY | ETF | 335.82 | 335.83 | 335.73 | 335.78 | 4398.0 |
> showing 50 of 68,380 rows — these rows as CSV