PREVIEW / etf_5min / 2020-02-24
file: by_date/etf_5min/2020/2020-02-24.parquet size: 1.9 MB rows: 82,453
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-24 04:00:00 | SPY | ETF | 326.4 | 326.46 | 325.6 | 325.67 | 70221.0 |
| 2020-02-24 04:05:00 | SPY | ETF | 325.7 | 326.0 | 325.56 | 325.93 | 60020.0 |
| 2020-02-24 04:10:00 | SPY | ETF | 325.94 | 326.03 | 325.45 | 325.57 | 192641.0 |
| 2020-02-24 04:15:00 | SPY | ETF | 325.6 | 325.6 | 324.95 | 324.95 | 98586.0 |
| 2020-02-24 04:20:00 | SPY | ETF | 324.88 | 325.2 | 324.83 | 325.15 | 19500.0 |
| 2020-02-24 04:25:00 | SPY | ETF | 325.16 | 325.16 | 324.49 | 325.04 | 23512.0 |
| 2020-02-24 04:30:00 | SPY | ETF | 324.93 | 325.32 | 324.64 | 324.83 | 26609.0 |
| 2020-02-24 04:35:00 | SPY | ETF | 324.84 | 324.84 | 324.19 | 324.72 | 90197.0 |
| 2020-02-24 04:40:00 | SPY | ETF | 324.72 | 325.09 | 324.45 | 325.09 | 20527.0 |
| 2020-02-24 04:45:00 | SPY | ETF | 325.09 | 325.54 | 325.09 | 325.54 | 26816.0 |
| 2020-02-24 04:50:00 | SPY | ETF | 325.55 | 325.55 | 325.34 | 325.53 | 4517.0 |
| 2020-02-24 04:55:00 | SPY | ETF | 325.56 | 325.85 | 325.48 | 325.8 | 72618.0 |
| 2020-02-24 05:00:00 | SPY | ETF | 325.7 | 325.8 | 325.65 | 325.74 | 1506.0 |
| 2020-02-24 05:05:00 | SPY | ETF | 325.82 | 325.87 | 325.46 | 325.46 | 3673.0 |
| 2020-02-24 05:10:00 | SPY | ETF | 325.48 | 325.57 | 325.36 | 325.37 | 3029.0 |
| 2020-02-24 05:15:00 | SPY | ETF | 325.4 | 325.59 | 325.4 | 325.59 | 2244.0 |
| 2020-02-24 05:20:00 | SPY | ETF | 325.53 | 325.55 | 325.4 | 325.4 | 2617.0 |
| 2020-02-24 05:25:00 | SPY | ETF | 325.5 | 325.5 | 325.3 | 325.3 | 4788.0 |
| 2020-02-24 05:30:00 | SPY | ETF | 325.29 | 325.29 | 325.08 | 325.12 | 8930.0 |
| 2020-02-24 05:35:00 | SPY | ETF | 325.07 | 325.12 | 324.78 | 324.95 | 10588.0 |
| 2020-02-24 05:40:00 | SPY | ETF | 325.02 | 325.23 | 325.01 | 325.05 | 35402.0 |
| 2020-02-24 05:45:00 | SPY | ETF | 325.05 | 325.1 | 324.59 | 324.6 | 64801.0 |
| 2020-02-24 05:50:00 | SPY | ETF | 324.68 | 324.84 | 324.61 | 324.75 | 26576.0 |
| 2020-02-24 05:55:00 | SPY | ETF | 324.55 | 324.63 | 324.36 | 324.63 | 34679.0 |
| 2020-02-24 06:00:00 | SPY | ETF | 324.64 | 324.67 | 324.27 | 324.64 | 26500.0 |
| 2020-02-24 06:05:00 | SPY | ETF | 324.62 | 324.79 | 324.17 | 324.19 | 43517.0 |
| 2020-02-24 06:10:00 | SPY | ETF | 324.17 | 324.57 | 324.17 | 324.54 | 18369.0 |
| 2020-02-24 06:15:00 | SPY | ETF | 324.51 | 324.94 | 324.44 | 324.93 | 10449.0 |
| 2020-02-24 06:20:00 | SPY | ETF | 324.83 | 325.18 | 324.83 | 325.1 | 15880.0 |
| 2020-02-24 06:25:00 | SPY | ETF | 325.06 | 325.19 | 324.86 | 325.14 | 87290.0 |
| 2020-02-24 06:30:00 | SPY | ETF | 325.1 | 325.35 | 325.1 | 325.34 | 66239.0 |
| 2020-02-24 06:35:00 | SPY | ETF | 325.3 | 325.62 | 325.3 | 325.62 | 73348.0 |
| 2020-02-24 06:40:00 | SPY | ETF | 325.68 | 325.75 | 325.5 | 325.51 | 80883.0 |
| 2020-02-24 06:45:00 | SPY | ETF | 325.58 | 325.93 | 325.58 | 325.76 | 80797.0 |
| 2020-02-24 06:50:00 | SPY | ETF | 325.81 | 326.12 | 325.77 | 326.06 | 91779.0 |
| 2020-02-24 06:55:00 | SPY | ETF | 326.01 | 326.04 | 325.69 | 325.7 | 42956.0 |
| 2020-02-24 07:00:00 | SPY | ETF | 325.77 | 326.32 | 325.72 | 326.3 | 178216.0 |
| 2020-02-24 07:05:00 | SPY | ETF | 326.31 | 326.47 | 326.16 | 326.4 | 116605.0 |
| 2020-02-24 07:10:00 | SPY | ETF | 326.37 | 326.43 | 326.07 | 326.16 | 103579.0 |
| 2020-02-24 07:15:00 | SPY | ETF | 326.25 | 326.25 | 325.82 | 325.9 | 97368.0 |
| 2020-02-24 07:20:00 | SPY | ETF | 325.9 | 326.07 | 325.87 | 325.97 | 57505.0 |
| 2020-02-24 07:25:00 | SPY | ETF | 325.93 | 325.97 | 325.76 | 325.78 | 34360.0 |
| 2020-02-24 07:30:00 | SPY | ETF | 325.79 | 326.08 | 325.79 | 326.01 | 64905.0 |
| 2020-02-24 07:35:00 | SPY | ETF | 326.0 | 326.01 | 325.51 | 325.52 | 72758.0 |
| 2020-02-24 07:40:00 | SPY | ETF | 325.55 | 325.57 | 325.02 | 325.21 | 78928.0 |
| 2020-02-24 07:45:00 | SPY | ETF | 325.21 | 325.4 | 325.17 | 325.35 | 74487.0 |
| 2020-02-24 07:50:00 | SPY | ETF | 325.36 | 325.41 | 325.1 | 325.1 | 330664.0 |
| 2020-02-24 07:55:00 | SPY | ETF | 325.06 | 325.41 | 325.06 | 325.4 | 298012.0 |
| 2020-02-24 08:00:00 | SPY | ETF | 326.2301 | 329.23 | 324.58 | 325.58 | 279810.0 |
| 2020-02-24 08:05:00 | SPY | ETF | 325.57 | 325.75 | 325.54 | 325.64 | 121389.0 |
> showing 50 of 82,453 rows — these rows as CSV