PREVIEW / etf_5min / 2021-12-09
file: by_date/etf_5min/2021/2021-12-09.parquet size: 1.8 MB rows: 84,594
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-12-09 04:00:00 | SPY | ETF | 468.58 | 468.69 | 468.55 | 468.64 | 2600.0 |
| 2021-12-09 04:05:00 | SPY | ETF | 468.56 | 468.56 | 468.5 | 468.5 | 3800.0 |
| 2021-12-09 04:10:00 | SPY | ETF | 468.42 | 468.44 | 468.29 | 468.29 | 2655.0 |
| 2021-12-09 04:15:00 | SPY | ETF | 468.49 | 468.49 | 468.33 | 468.39 | 400.0 |
| 2021-12-09 04:20:00 | SPY | ETF | 468.4 | 468.62 | 468.4 | 468.62 | 672.0 |
| 2021-12-09 04:30:00 | SPY | ETF | 468.62 | 468.77 | 468.62 | 468.77 | 400.0 |
| 2021-12-09 04:40:00 | SPY | ETF | 468.69 | 468.74 | 468.65 | 468.71 | 12567.0 |
| 2021-12-09 04:45:00 | SPY | ETF | 468.74 | 468.75 | 468.72 | 468.72 | 2000.0 |
| 2021-12-09 04:50:00 | SPY | ETF | 468.7 | 468.7 | 468.7 | 468.7 | 900.0 |
| 2021-12-09 05:00:00 | SPY | ETF | 468.62 | 468.62 | 468.37 | 468.39 | 957.0 |
| 2021-12-09 05:05:00 | SPY | ETF | 468.39 | 468.39 | 468.17 | 468.17 | 2900.0 |
| 2021-12-09 05:10:00 | SPY | ETF | 468.21 | 468.33 | 468.08 | 468.08 | 1295.0 |
| 2021-12-09 05:15:00 | SPY | ETF | 468.21 | 468.22 | 467.91 | 467.91 | 9262.0 |
| 2021-12-09 05:20:00 | SPY | ETF | 467.73 | 467.73 | 467.7 | 467.7 | 1900.0 |
| 2021-12-09 05:25:00 | SPY | ETF | 467.96 | 467.98 | 467.83 | 467.93 | 868.0 |
| 2021-12-09 05:30:00 | SPY | ETF | 468.09 | 468.09 | 467.98 | 467.98 | 1500.0 |
| 2021-12-09 05:35:00 | SPY | ETF | 467.98 | 468.14 | 467.98 | 468.14 | 1292.0 |
| 2021-12-09 05:40:00 | SPY | ETF | 468.18 | 468.18 | 468.09 | 468.09 | 215.0 |
| 2021-12-09 05:45:00 | SPY | ETF | 468.1 | 468.1 | 468.1 | 468.1 | 300.0 |
| 2021-12-09 05:50:00 | SPY | ETF | 468.24 | 468.24 | 468.2 | 468.2 | 200.0 |
| 2021-12-09 05:55:00 | SPY | ETF | 468.22 | 468.22 | 468.14 | 468.14 | 300.0 |
| 2021-12-09 06:00:00 | SPY | ETF | 468.27 | 468.31 | 468.27 | 468.31 | 200.0 |
| 2021-12-09 06:05:00 | SPY | ETF | 468.19 | 468.19 | 468.19 | 468.19 | 100.0 |
| 2021-12-09 06:10:00 | SPY | ETF | 467.9 | 467.9 | 467.5 | 467.56 | 3305.0 |
| 2021-12-09 06:15:00 | SPY | ETF | 467.54 | 467.85 | 467.54 | 467.85 | 8300.0 |
| 2021-12-09 06:20:00 | SPY | ETF | 467.94 | 468.0 | 467.9 | 467.9 | 3954.0 |
| 2021-12-09 06:25:00 | SPY | ETF | 467.91 | 468.03 | 467.86 | 468.03 | 3600.0 |
| 2021-12-09 06:30:00 | SPY | ETF | 468.04 | 468.19 | 468.04 | 468.17 | 4752.0 |
| 2021-12-09 06:35:00 | SPY | ETF | 468.21 | 468.21 | 467.97 | 467.97 | 2827.0 |
| 2021-12-09 06:40:00 | SPY | ETF | 467.96 | 467.96 | 467.81 | 467.85 | 4462.0 |
| 2021-12-09 06:45:00 | SPY | ETF | 467.95 | 467.95 | 467.75 | 467.75 | 5128.0 |
| 2021-12-09 06:50:00 | SPY | ETF | 467.71 | 467.72 | 467.61 | 467.63 | 4299.0 |
| 2021-12-09 06:55:00 | SPY | ETF | 467.84 | 467.93 | 467.81 | 467.93 | 400.0 |
| 2021-12-09 07:00:00 | SPY | ETF | 468.0 | 468.15 | 467.95 | 468.15 | 15401.0 |
| 2021-12-09 07:05:00 | SPY | ETF | 468.11 | 468.28 | 468.11 | 468.2 | 16852.0 |
| 2021-12-09 07:10:00 | SPY | ETF | 468.24 | 468.29 | 468.09 | 468.18 | 16412.0 |
| 2021-12-09 07:15:00 | SPY | ETF | 468.29 | 468.51 | 468.29 | 468.49 | 15750.0 |
| 2021-12-09 07:20:00 | SPY | ETF | 468.48 | 468.48 | 468.3 | 468.3 | 5916.0 |
| 2021-12-09 07:25:00 | SPY | ETF | 468.3 | 468.35 | 468.2 | 468.22 | 6010.0 |
| 2021-12-09 07:30:00 | SPY | ETF | 468.26 | 468.32 | 468.25 | 468.25 | 5915.0 |
| 2021-12-09 07:35:00 | SPY | ETF | 468.26 | 468.27 | 468.16 | 468.27 | 6779.0 |
| 2021-12-09 07:40:00 | SPY | ETF | 468.28 | 468.29 | 468.16 | 468.21 | 12061.0 |
| 2021-12-09 07:45:00 | SPY | ETF | 468.18 | 468.2 | 468.02 | 468.07 | 17206.0 |
| 2021-12-09 07:50:00 | SPY | ETF | 468.08 | 468.08 | 467.99 | 468.05 | 22472.0 |
| 2021-12-09 07:55:00 | SPY | ETF | 468.09 | 468.34 | 468.06 | 468.21 | 10019.0 |
| 2021-12-09 08:00:00 | SPY | ETF | 468.25 | 469.872 | 467.8204 | 468.13 | 51059.0 |
| 2021-12-09 08:05:00 | SPY | ETF | 468.13 | 468.16 | 468.06 | 468.06 | 21943.0 |
| 2021-12-09 08:10:00 | SPY | ETF | 468.05 | 468.09 | 467.7 | 467.74 | 41765.0 |
| 2021-12-09 08:15:00 | SPY | ETF | 467.74 | 467.96 | 467.74 | 467.89 | 26482.0 |
| 2021-12-09 08:20:00 | SPY | ETF | 467.95 | 467.95 | 467.58 | 467.63 | 41287.0 |
> showing 50 of 84,594 rows — these rows as CSV