PREVIEW / etf_5min / 2021-10-29
file: by_date/etf_5min/2021/2021-10-29.parquet size: 1.8 MB rows: 83,436
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-10-29 04:00:00 | SPY | ETF | 456.6 | 456.6 | 456.2 | 456.22 | 4602.0 |
| 2021-10-29 04:05:00 | SPY | ETF | 456.4 | 456.55 | 456.32 | 456.33 | 5145.0 |
| 2021-10-29 04:10:00 | SPY | ETF | 456.32 | 456.43 | 456.32 | 456.36 | 574.0 |
| 2021-10-29 04:15:00 | SPY | ETF | 456.44 | 456.44 | 456.35 | 456.38 | 10135.0 |
| 2021-10-29 04:20:00 | SPY | ETF | 456.5 | 456.53 | 456.43 | 456.43 | 2200.0 |
| 2021-10-29 04:25:00 | SPY | ETF | 456.35 | 456.35 | 455.91 | 455.91 | 7104.0 |
| 2021-10-29 04:30:00 | SPY | ETF | 455.89 | 456.2 | 455.89 | 456.2 | 1203.0 |
| 2021-10-29 04:35:00 | SPY | ETF | 456.06 | 456.06 | 455.81 | 455.96 | 1628.0 |
| 2021-10-29 04:40:00 | SPY | ETF | 455.96 | 455.96 | 455.87 | 455.96 | 668.0 |
| 2021-10-29 04:45:00 | SPY | ETF | 456.0 | 456.0 | 455.9 | 455.9 | 200.0 |
| 2021-10-29 04:50:00 | SPY | ETF | 455.82 | 456.13 | 455.82 | 456.13 | 6627.0 |
| 2021-10-29 04:55:00 | SPY | ETF | 456.07 | 456.22 | 456.07 | 456.22 | 600.0 |
| 2021-10-29 05:00:00 | SPY | ETF | 456.11 | 456.24 | 456.11 | 456.23 | 1462.0 |
| 2021-10-29 05:05:00 | SPY | ETF | 456.17 | 456.32 | 456.17 | 456.31 | 1533.0 |
| 2021-10-29 05:10:00 | SPY | ETF | 456.38 | 456.4 | 456.22 | 456.22 | 813.0 |
| 2021-10-29 05:15:00 | SPY | ETF | 456.23 | 456.23 | 456.17 | 456.17 | 480.0 |
| 2021-10-29 05:20:00 | SPY | ETF | 455.94 | 456.15 | 455.8 | 456.15 | 1310.0 |
| 2021-10-29 05:25:00 | SPY | ETF | 456.06 | 456.06 | 455.99 | 456.02 | 522.0 |
| 2021-10-29 05:30:00 | SPY | ETF | 456.08 | 456.08 | 456.07 | 456.07 | 200.0 |
| 2021-10-29 05:35:00 | SPY | ETF | 456.08 | 456.15 | 456.08 | 456.09 | 894.0 |
| 2021-10-29 05:40:00 | SPY | ETF | 455.92 | 456.03 | 455.92 | 455.99 | 777.0 |
| 2021-10-29 05:45:00 | SPY | ETF | 456.01 | 456.02 | 456.01 | 456.02 | 550.0 |
| 2021-10-29 05:55:00 | SPY | ETF | 456.12 | 456.2 | 456.12 | 456.18 | 1107.0 |
| 2021-10-29 06:00:00 | SPY | ETF | 456.29 | 456.32 | 456.26 | 456.3 | 1956.0 |
| 2021-10-29 06:05:00 | SPY | ETF | 456.19 | 456.19 | 456.1 | 456.1 | 500.0 |
| 2021-10-29 06:10:00 | SPY | ETF | 456.03 | 456.06 | 455.6 | 455.6 | 3295.0 |
| 2021-10-29 06:15:00 | SPY | ETF | 455.58 | 455.65 | 455.58 | 455.6 | 4575.0 |
| 2021-10-29 06:20:00 | SPY | ETF | 455.65 | 455.65 | 455.5 | 455.51 | 32163.0 |
| 2021-10-29 06:25:00 | SPY | ETF | 455.52 | 455.6 | 455.51 | 455.6 | 23364.0 |
| 2021-10-29 06:30:00 | SPY | ETF | 455.62 | 456.05 | 455.61 | 455.82 | 17274.0 |
| 2021-10-29 06:35:00 | SPY | ETF | 455.85 | 455.97 | 455.85 | 455.88 | 2728.0 |
| 2021-10-29 06:40:00 | SPY | ETF | 455.92 | 455.99 | 455.85 | 455.97 | 5274.0 |
| 2021-10-29 06:45:00 | SPY | ETF | 456.0 | 456.09 | 456.0 | 456.05 | 5058.0 |
| 2021-10-29 06:50:00 | SPY | ETF | 456.03 | 456.03 | 455.96 | 455.99 | 2006.0 |
| 2021-10-29 06:55:00 | SPY | ETF | 455.96 | 456.09 | 455.81 | 456.09 | 5410.0 |
| 2021-10-29 07:00:00 | SPY | ETF | 455.99 | 456.12 | 455.99 | 456.09 | 17734.0 |
| 2021-10-29 07:05:00 | SPY | ETF | 456.1 | 456.12 | 455.95 | 456.03 | 27035.0 |
| 2021-10-29 07:10:00 | SPY | ETF | 456.03 | 456.18 | 456.03 | 456.08 | 7377.0 |
| 2021-10-29 07:15:00 | SPY | ETF | 456.08 | 456.11 | 456.04 | 456.08 | 13959.0 |
| 2021-10-29 07:20:00 | SPY | ETF | 456.07 | 456.14 | 456.07 | 456.11 | 13973.0 |
| 2021-10-29 07:25:00 | SPY | ETF | 456.12 | 456.16 | 456.07 | 456.1 | 12974.0 |
| 2021-10-29 07:30:00 | SPY | ETF | 456.1 | 456.14 | 455.95 | 456.04 | 10548.0 |
| 2021-10-29 07:35:00 | SPY | ETF | 456.05 | 456.5 | 456.05 | 456.41 | 9687.0 |
| 2021-10-29 07:40:00 | SPY | ETF | 456.4 | 456.4 | 456.23 | 456.3 | 23231.0 |
| 2021-10-29 07:45:00 | SPY | ETF | 456.33 | 456.44 | 456.25 | 456.36 | 18734.0 |
| 2021-10-29 07:50:00 | SPY | ETF | 456.42 | 456.49 | 456.38 | 456.39 | 38034.0 |
| 2021-10-29 07:55:00 | SPY | ETF | 456.4 | 456.42 | 456.13 | 456.15 | 19766.0 |
| 2021-10-29 08:00:00 | SPY | ETF | 456.12 | 456.4401 | 455.8904 | 456.13 | 32489.0 |
| 2021-10-29 08:05:00 | SPY | ETF | 456.13 | 456.38 | 455.96 | 456.35 | 23090.0 |
| 2021-10-29 08:10:00 | SPY | ETF | 456.38 | 456.48 | 456.32 | 456.35 | 20414.0 |
> showing 50 of 83,436 rows — these rows as CSV