PREVIEW / etf_5min / 2021-01-04
file: by_date/etf_5min/2021/2021-01-04.parquet size: 2.0 MB rows: 90,605
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-01-04 04:00:00 | SPY | ETF | 375.64 | 376.04 | 375.64 | 375.91 | 40156.0 |
| 2021-01-04 04:05:00 | SPY | ETF | 375.9 | 375.98 | 375.84 | 375.89 | 10514.0 |
| 2021-01-04 04:10:00 | SPY | ETF | 375.91 | 376.01 | 375.91 | 376.01 | 4614.0 |
| 2021-01-04 04:15:00 | SPY | ETF | 376.04 | 376.33 | 376.04 | 376.26 | 9380.0 |
| 2021-01-04 04:20:00 | SPY | ETF | 376.29 | 376.39 | 376.22 | 376.39 | 3447.0 |
| 2021-01-04 04:25:00 | SPY | ETF | 376.41 | 376.42 | 376.33 | 376.39 | 4252.0 |
| 2021-01-04 04:30:00 | SPY | ETF | 376.36 | 376.41 | 376.36 | 376.39 | 2686.0 |
| 2021-01-04 04:35:00 | SPY | ETF | 376.44 | 376.62 | 376.44 | 376.45 | 926.0 |
| 2021-01-04 04:40:00 | SPY | ETF | 376.47 | 376.72 | 376.47 | 376.72 | 2249.0 |
| 2021-01-04 04:45:00 | SPY | ETF | 376.74 | 376.74 | 376.45 | 376.62 | 3090.0 |
| 2021-01-04 04:50:00 | SPY | ETF | 376.72 | 376.72 | 376.43 | 376.43 | 3850.0 |
| 2021-01-04 04:55:00 | SPY | ETF | 376.46 | 376.48 | 376.45 | 376.48 | 5795.0 |
| 2021-01-04 05:00:00 | SPY | ETF | 376.51 | 376.59 | 376.49 | 376.55 | 3735.0 |
| 2021-01-04 05:05:00 | SPY | ETF | 376.42 | 376.42 | 376.41 | 376.41 | 1419.0 |
| 2021-01-04 05:10:00 | SPY | ETF | 376.5 | 376.6 | 376.48 | 376.6 | 3313.0 |
| 2021-01-04 05:15:00 | SPY | ETF | 376.61 | 376.61 | 376.25 | 376.25 | 2679.0 |
| 2021-01-04 05:20:00 | SPY | ETF | 376.33 | 376.35 | 376.33 | 376.34 | 843.0 |
| 2021-01-04 05:25:00 | SPY | ETF | 376.18 | 376.18 | 376.15 | 376.15 | 973.0 |
| 2021-01-04 05:30:00 | SPY | ETF | 376.25 | 376.27 | 376.25 | 376.27 | 403.0 |
| 2021-01-04 05:35:00 | SPY | ETF | 376.26 | 376.26 | 376.24 | 376.24 | 1107.0 |
| 2021-01-04 05:40:00 | SPY | ETF | 376.32 | 376.36 | 376.26 | 376.28 | 7763.0 |
| 2021-01-04 05:45:00 | SPY | ETF | 376.31 | 376.38 | 376.31 | 376.38 | 1459.0 |
| 2021-01-04 05:50:00 | SPY | ETF | 376.25 | 376.35 | 376.25 | 376.33 | 1452.0 |
| 2021-01-04 05:55:00 | SPY | ETF | 376.2 | 376.21 | 376.17 | 376.18 | 1233.0 |
| 2021-01-04 06:00:00 | SPY | ETF | 376.23 | 376.36 | 376.23 | 376.34 | 3002.0 |
| 2021-01-04 06:05:00 | SPY | ETF | 376.4 | 376.44 | 376.39 | 376.44 | 2826.0 |
| 2021-01-04 06:10:00 | SPY | ETF | 376.38 | 376.42 | 376.33 | 376.42 | 2169.0 |
| 2021-01-04 06:15:00 | SPY | ETF | 376.42 | 376.42 | 376.35 | 376.37 | 2887.0 |
| 2021-01-04 06:20:00 | SPY | ETF | 376.37 | 376.37 | 376.25 | 376.25 | 2350.0 |
| 2021-01-04 06:25:00 | SPY | ETF | 376.23 | 376.24 | 376.23 | 376.24 | 568.0 |
| 2021-01-04 06:35:00 | SPY | ETF | 376.35 | 376.41 | 376.31 | 376.41 | 10171.0 |
| 2021-01-04 06:40:00 | SPY | ETF | 376.46 | 376.46 | 376.41 | 376.41 | 915.0 |
| 2021-01-04 06:50:00 | SPY | ETF | 376.31 | 376.31 | 376.31 | 376.31 | 151.0 |
| 2021-01-04 06:55:00 | SPY | ETF | 376.22 | 376.22 | 376.19 | 376.19 | 1323.0 |
| 2021-01-04 07:00:00 | SPY | ETF | 376.14 | 376.2 | 376.08 | 376.1 | 16002.0 |
| 2021-01-04 07:05:00 | SPY | ETF | 376.05 | 376.05 | 375.88 | 375.88 | 4592.0 |
| 2021-01-04 07:10:00 | SPY | ETF | 375.91 | 375.95 | 375.9 | 375.95 | 2577.0 |
| 2021-01-04 07:15:00 | SPY | ETF | 376.02 | 376.02 | 375.9 | 375.9 | 6657.0 |
| 2021-01-04 07:20:00 | SPY | ETF | 375.95 | 376.02 | 375.95 | 375.98 | 1203.0 |
| 2021-01-04 07:25:00 | SPY | ETF | 376.02 | 376.14 | 376.02 | 376.14 | 3903.0 |
| 2021-01-04 07:30:00 | SPY | ETF | 376.1 | 376.14 | 376.08 | 376.09 | 2174.0 |
| 2021-01-04 07:35:00 | SPY | ETF | 376.09 | 376.12 | 376.06 | 376.12 | 11570.0 |
| 2021-01-04 07:40:00 | SPY | ETF | 376.12 | 376.15 | 376.01 | 376.04 | 3137.0 |
| 2021-01-04 07:45:00 | SPY | ETF | 376.01 | 376.01 | 375.74 | 375.88 | 4976.0 |
| 2021-01-04 07:50:00 | SPY | ETF | 375.93 | 376.1 | 375.92 | 376.08 | 4648.0 |
| 2021-01-04 07:55:00 | SPY | ETF | 376.06 | 376.19 | 376.06 | 376.18 | 5489.0 |
| 2021-01-04 08:00:00 | SPY | ETF | 376.11 | 376.18 | 374.1 | 376.08 | 70928.0 |
| 2021-01-04 08:05:00 | SPY | ETF | 376.1 | 376.18 | 375.93 | 375.97 | 17447.0 |
| 2021-01-04 08:10:00 | SPY | ETF | 375.99 | 376.06 | 375.99 | 376.01 | 4688.0 |
| 2021-01-04 08:15:00 | SPY | ETF | 376.01 | 376.04 | 375.98 | 376.01 | 8716.0 |
> showing 50 of 90,605 rows — these rows as CSV