PREVIEW / etf_5min / 2021-08-26
file: by_date/etf_5min/2021/2021-08-26.parquet size: 1.7 MB rows: 76,934
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-08-26 04:00:00 | SPY | ETF | 448.16 | 448.63 | 448.16 | 448.63 | 540.0 |
| 2021-08-26 04:05:00 | SPY | ETF | 448.49 | 448.49 | 448.46 | 448.46 | 1129.0 |
| 2021-08-26 04:10:00 | SPY | ETF | 448.58 | 448.58 | 448.54 | 448.54 | 643.0 |
| 2021-08-26 04:15:00 | SPY | ETF | 448.63 | 448.71 | 448.61 | 448.71 | 1583.0 |
| 2021-08-26 04:20:00 | SPY | ETF | 448.59 | 448.59 | 448.59 | 448.59 | 600.0 |
| 2021-08-26 04:30:00 | SPY | ETF | 448.56 | 448.63 | 448.56 | 448.58 | 5575.0 |
| 2021-08-26 04:35:00 | SPY | ETF | 448.58 | 448.58 | 448.58 | 448.58 | 188.0 |
| 2021-08-26 04:40:00 | SPY | ETF | 448.56 | 448.56 | 448.56 | 448.56 | 200.0 |
| 2021-08-26 04:55:00 | SPY | ETF | 448.51 | 448.51 | 448.51 | 448.51 | 998.0 |
| 2021-08-26 05:00:00 | SPY | ETF | 448.36 | 448.36 | 448.23 | 448.23 | 2407.0 |
| 2021-08-26 05:05:00 | SPY | ETF | 448.23 | 448.27 | 448.23 | 448.27 | 1100.0 |
| 2021-08-26 05:10:00 | SPY | ETF | 448.29 | 448.36 | 448.29 | 448.36 | 700.0 |
| 2021-08-26 05:30:00 | SPY | ETF | 448.21 | 448.31 | 448.21 | 448.31 | 3225.0 |
| 2021-08-26 05:35:00 | SPY | ETF | 448.33 | 448.33 | 448.3 | 448.3 | 1189.0 |
| 2021-08-26 05:40:00 | SPY | ETF | 448.34 | 448.34 | 448.31 | 448.31 | 460.0 |
| 2021-08-26 05:45:00 | SPY | ETF | 448.43 | 448.43 | 448.43 | 448.43 | 100.0 |
| 2021-08-26 05:50:00 | SPY | ETF | 448.41 | 448.41 | 448.38 | 448.38 | 399.0 |
| 2021-08-26 05:55:00 | SPY | ETF | 448.51 | 448.51 | 448.51 | 448.51 | 104.0 |
| 2021-08-26 06:00:00 | SPY | ETF | 448.63 | 448.63 | 448.63 | 448.63 | 900.0 |
| 2021-08-26 06:05:00 | SPY | ETF | 448.51 | 448.51 | 448.48 | 448.48 | 368.0 |
| 2021-08-26 06:10:00 | SPY | ETF | 448.44 | 448.44 | 448.44 | 448.44 | 387.0 |
| 2021-08-26 06:20:00 | SPY | ETF | 448.49 | 448.49 | 448.49 | 448.49 | 1250.0 |
| 2021-08-26 06:30:00 | SPY | ETF | 448.51 | 448.51 | 448.51 | 448.51 | 100.0 |
| 2021-08-26 06:35:00 | SPY | ETF | 448.59 | 448.59 | 448.59 | 448.59 | 100.0 |
| 2021-08-26 06:45:00 | SPY | ETF | 448.61 | 448.66 | 448.59 | 448.59 | 688.0 |
| 2021-08-26 06:50:00 | SPY | ETF | 448.64 | 448.7 | 448.61 | 448.61 | 924.0 |
| 2021-08-26 06:55:00 | SPY | ETF | 448.61 | 448.61 | 448.61 | 448.61 | 300.0 |
| 2021-08-26 07:00:00 | SPY | ETF | 448.6 | 448.6 | 448.56 | 448.56 | 2184.0 |
| 2021-08-26 07:05:00 | SPY | ETF | 448.61 | 448.61 | 448.54 | 448.56 | 8242.0 |
| 2021-08-26 07:10:00 | SPY | ETF | 448.56 | 448.59 | 448.53 | 448.57 | 10683.0 |
| 2021-08-26 07:15:00 | SPY | ETF | 448.57 | 448.62 | 448.57 | 448.62 | 2449.0 |
| 2021-08-26 07:20:00 | SPY | ETF | 448.64 | 448.91 | 448.64 | 448.91 | 16743.0 |
| 2021-08-26 07:25:00 | SPY | ETF | 448.89 | 448.91 | 448.82 | 448.82 | 2425.0 |
| 2021-08-26 07:30:00 | SPY | ETF | 448.8 | 448.8 | 448.7 | 448.75 | 7676.0 |
| 2021-08-26 07:35:00 | SPY | ETF | 448.75 | 448.85 | 448.7 | 448.85 | 5969.0 |
| 2021-08-26 07:40:00 | SPY | ETF | 448.85 | 448.88 | 448.82 | 448.84 | 10023.0 |
| 2021-08-26 07:45:00 | SPY | ETF | 448.83 | 448.87 | 448.83 | 448.87 | 3385.0 |
| 2021-08-26 07:50:00 | SPY | ETF | 448.86 | 448.87 | 448.82 | 448.82 | 3239.0 |
| 2021-08-26 07:55:00 | SPY | ETF | 448.81 | 448.83 | 448.8 | 448.83 | 4640.0 |
| 2021-08-26 08:00:00 | SPY | ETF | 448.6104 | 448.89 | 448.5596 | 448.88 | 20214.0 |
| 2021-08-26 08:05:00 | SPY | ETF | 448.85 | 448.89 | 448.83 | 448.89 | 6042.0 |
| 2021-08-26 08:10:00 | SPY | ETF | 448.87 | 448.91 | 448.86 | 448.909 | 5450.0 |
| 2021-08-26 08:15:00 | SPY | ETF | 448.89 | 448.9 | 448.87 | 448.88 | 2394.0 |
| 2021-08-26 08:20:00 | SPY | ETF | 448.87 | 448.89 | 448.86 | 448.89 | 4300.0 |
| 2021-08-26 08:25:00 | SPY | ETF | 448.88 | 448.94 | 448.88 | 448.93 | 6622.0 |
| 2021-08-26 08:30:00 | SPY | ETF | 448.92 | 448.92 | 448.83 | 448.83 | 11175.0 |
| 2021-08-26 08:35:00 | SPY | ETF | 448.83 | 448.83 | 448.15 | 448.3 | 143051.0 |
| 2021-08-26 08:40:00 | SPY | ETF | 448.32 | 448.53 | 448.2 | 448.36 | 51899.0 |
| 2021-08-26 08:45:00 | SPY | ETF | 448.36 | 448.58 | 448.33 | 448.52 | 19233.0 |
| 2021-08-26 08:50:00 | SPY | ETF | 448.54 | 448.54 | 448.4 | 448.48 | 10235.0 |
> showing 50 of 76,934 rows — these rows as CSV