PREVIEW / etf_5min / 2021-09-27
file: by_date/etf_5min/2021/2021-09-27.parquet size: 1.7 MB rows: 82,227
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-09-27 04:00:00 | SPY | ETF | 445.02 | 445.07 | 445.0 | 445.02 | 7255.0 |
| 2021-09-27 04:05:00 | SPY | ETF | 445.17 | 445.23 | 445.13 | 445.2 | 826.0 |
| 2021-09-27 04:10:00 | SPY | ETF | 445.07 | 445.08 | 445.07 | 445.07 | 700.0 |
| 2021-09-27 04:15:00 | SPY | ETF | 445.13 | 445.15 | 445.08 | 445.08 | 403.0 |
| 2021-09-27 04:20:00 | SPY | ETF | 445.03 | 445.07 | 444.96 | 445.07 | 1397.0 |
| 2021-09-27 04:25:00 | SPY | ETF | 445.03 | 445.14 | 445.03 | 445.14 | 201.0 |
| 2021-09-27 04:30:00 | SPY | ETF | 445.13 | 445.13 | 445.1 | 445.13 | 3300.0 |
| 2021-09-27 04:35:00 | SPY | ETF | 445.11 | 445.18 | 445.11 | 445.18 | 649.0 |
| 2021-09-27 04:40:00 | SPY | ETF | 445.22 | 445.23 | 445.22 | 445.23 | 413.0 |
| 2021-09-27 04:45:00 | SPY | ETF | 445.18 | 445.18 | 445.03 | 445.05 | 2734.0 |
| 2021-09-27 04:50:00 | SPY | ETF | 445.11 | 445.2 | 445.11 | 445.2 | 600.0 |
| 2021-09-27 05:00:00 | SPY | ETF | 445.3 | 445.4 | 445.3 | 445.36 | 536.0 |
| 2021-09-27 05:05:00 | SPY | ETF | 445.35 | 445.4 | 445.35 | 445.4 | 1013.0 |
| 2021-09-27 05:10:00 | SPY | ETF | 445.48 | 445.53 | 445.48 | 445.5 | 450.0 |
| 2021-09-27 05:15:00 | SPY | ETF | 445.42 | 445.42 | 445.42 | 445.42 | 2498.0 |
| 2021-09-27 05:20:00 | SPY | ETF | 445.42 | 445.46 | 445.42 | 445.46 | 5123.0 |
| 2021-09-27 05:25:00 | SPY | ETF | 445.48 | 445.48 | 445.18 | 445.18 | 5400.0 |
| 2021-09-27 05:30:00 | SPY | ETF | 445.08 | 445.16 | 444.75 | 444.75 | 2140.0 |
| 2021-09-27 05:35:00 | SPY | ETF | 444.5 | 444.91 | 444.44 | 444.91 | 2200.0 |
| 2021-09-27 05:40:00 | SPY | ETF | 444.81 | 444.81 | 444.71 | 444.76 | 1800.0 |
| 2021-09-27 05:45:00 | SPY | ETF | 444.61 | 444.76 | 444.59 | 444.76 | 800.0 |
| 2021-09-27 05:50:00 | SPY | ETF | 444.75 | 444.75 | 444.71 | 444.71 | 200.0 |
| 2021-09-27 05:55:00 | SPY | ETF | 444.3 | 444.34 | 444.28 | 444.28 | 2885.0 |
| 2021-09-27 06:00:00 | SPY | ETF | 444.28 | 444.28 | 444.02 | 444.02 | 3045.0 |
| 2021-09-27 06:05:00 | SPY | ETF | 444.14 | 444.34 | 444.14 | 444.34 | 2221.0 |
| 2021-09-27 06:10:00 | SPY | ETF | 444.35 | 444.46 | 444.35 | 444.46 | 1839.0 |
| 2021-09-27 06:15:00 | SPY | ETF | 444.44 | 444.44 | 444.36 | 444.36 | 2200.0 |
| 2021-09-27 06:20:00 | SPY | ETF | 444.42 | 444.42 | 444.09 | 444.1 | 3040.0 |
| 2021-09-27 06:25:00 | SPY | ETF | 444.2 | 444.29 | 444.2 | 444.29 | 830.0 |
| 2021-09-27 06:30:00 | SPY | ETF | 444.17 | 444.17 | 444.17 | 444.17 | 100.0 |
| 2021-09-27 06:40:00 | SPY | ETF | 444.19 | 444.19 | 444.19 | 444.19 | 200.0 |
| 2021-09-27 06:45:00 | SPY | ETF | 444.02 | 444.02 | 443.77 | 443.77 | 4152.0 |
| 2021-09-27 06:50:00 | SPY | ETF | 443.7 | 443.92 | 443.7 | 443.82 | 3100.0 |
| 2021-09-27 06:55:00 | SPY | ETF | 443.62 | 443.72 | 443.55 | 443.58 | 20973.0 |
| 2021-09-27 07:00:00 | SPY | ETF | 443.58 | 443.78 | 443.55 | 443.74 | 3630.0 |
| 2021-09-27 07:05:00 | SPY | ETF | 443.6 | 443.68 | 443.2 | 443.27 | 26643.0 |
| 2021-09-27 07:10:00 | SPY | ETF | 443.3 | 443.57 | 443.3 | 443.55 | 13490.0 |
| 2021-09-27 07:15:00 | SPY | ETF | 443.53 | 443.72 | 443.37 | 443.7 | 4764.0 |
| 2021-09-27 07:20:00 | SPY | ETF | 443.63 | 443.63 | 443.55 | 443.55 | 4152.0 |
| 2021-09-27 07:25:00 | SPY | ETF | 443.53 | 443.53 | 443.49 | 443.5 | 1698.0 |
| 2021-09-27 07:30:00 | SPY | ETF | 443.55 | 443.72 | 443.45 | 443.67 | 5431.0 |
| 2021-09-27 07:35:00 | SPY | ETF | 443.68 | 443.68 | 443.5 | 443.61 | 5620.0 |
| 2021-09-27 07:40:00 | SPY | ETF | 443.54 | 443.67 | 443.53 | 443.67 | 6412.0 |
| 2021-09-27 07:45:00 | SPY | ETF | 443.65 | 443.7 | 443.61 | 443.66 | 4333.0 |
| 2021-09-27 07:50:00 | SPY | ETF | 443.62 | 443.62 | 443.57 | 443.61 | 2103.0 |
| 2021-09-27 07:55:00 | SPY | ETF | 443.56 | 443.57 | 443.45 | 443.52 | 2502.0 |
| 2021-09-27 08:00:00 | SPY | ETF | 443.44 | 446.14 | 443.06 | 443.15 | 66135.0 |
| 2021-09-27 08:05:00 | SPY | ETF | 443.2 | 443.28 | 443.11 | 443.13 | 10365.0 |
| 2021-09-27 08:10:00 | SPY | ETF | 443.17 | 443.18 | 442.7 | 442.86 | 58103.0 |
| 2021-09-27 08:15:00 | SPY | ETF | 442.85 | 442.94 | 442.65 | 442.76 | 51489.0 |
> showing 50 of 82,227 rows — these rows as CSV