PREVIEW / etf_5min / 2021-10-18
file: by_date/etf_5min/2021/2021-10-18.parquet size: 1.8 MB rows: 84,101
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-18 04:00:00 | SPY | ETF | 445.1 | 445.62 | 444.35 | 444.81 | 38907.0 |
| 2021-10-18 04:05:00 | SPY | ETF | 444.81 | 444.81 | 444.71 | 444.76 | 5920.0 |
| 2021-10-18 04:10:00 | SPY | ETF | 444.94 | 445.0 | 444.75 | 444.9 | 19745.0 |
| 2021-10-18 04:15:00 | SPY | ETF | 444.85 | 444.89 | 444.83 | 444.87 | 500.0 |
| 2021-10-18 04:20:00 | SPY | ETF | 444.86 | 445.01 | 444.85 | 444.87 | 1737.0 |
| 2021-10-18 04:25:00 | SPY | ETF | 444.81 | 444.81 | 444.71 | 444.75 | 1295.0 |
| 2021-10-18 04:30:00 | SPY | ETF | 444.76 | 444.76 | 444.59 | 444.62 | 1500.0 |
| 2021-10-18 04:35:00 | SPY | ETF | 444.58 | 444.58 | 444.52 | 444.52 | 400.0 |
| 2021-10-18 04:40:00 | SPY | ETF | 444.5 | 444.5 | 444.5 | 444.5 | 6250.0 |
| 2021-10-18 04:45:00 | SPY | ETF | 444.58 | 444.68 | 444.54 | 444.6 | 2800.0 |
| 2021-10-18 04:50:00 | SPY | ETF | 444.52 | 444.52 | 444.5 | 444.5 | 1200.0 |
| 2021-10-18 04:55:00 | SPY | ETF | 444.49 | 444.49 | 444.38 | 444.41 | 421.0 |
| 2021-10-18 05:00:00 | SPY | ETF | 444.37 | 444.41 | 444.08 | 444.11 | 9026.0 |
| 2021-10-18 05:05:00 | SPY | ETF | 444.19 | 444.34 | 444.18 | 444.26 | 819.0 |
| 2021-10-18 05:10:00 | SPY | ETF | 444.26 | 444.26 | 444.08 | 444.11 | 1825.0 |
| 2021-10-18 05:15:00 | SPY | ETF | 444.1 | 444.34 | 444.08 | 444.34 | 3050.0 |
| 2021-10-18 05:20:00 | SPY | ETF | 444.3 | 444.36 | 444.28 | 444.31 | 1600.0 |
| 2021-10-18 05:25:00 | SPY | ETF | 444.37 | 444.43 | 444.37 | 444.41 | 2925.0 |
| 2021-10-18 05:30:00 | SPY | ETF | 444.57 | 444.57 | 444.41 | 444.41 | 300.0 |
| 2021-10-18 05:35:00 | SPY | ETF | 444.35 | 444.35 | 444.35 | 444.35 | 100.0 |
| 2021-10-18 05:40:00 | SPY | ETF | 444.26 | 444.26 | 444.22 | 444.22 | 800.0 |
| 2021-10-18 05:45:00 | SPY | ETF | 444.15 | 444.23 | 444.11 | 444.23 | 700.0 |
| 2021-10-18 05:50:00 | SPY | ETF | 444.2 | 444.2 | 444.2 | 444.2 | 250.0 |
| 2021-10-18 05:55:00 | SPY | ETF | 444.16 | 444.19 | 444.16 | 444.19 | 200.0 |
| 2021-10-18 06:00:00 | SPY | ETF | 444.19 | 444.32 | 444.19 | 444.32 | 314.0 |
| 2021-10-18 06:05:00 | SPY | ETF | 444.31 | 444.32 | 444.31 | 444.32 | 200.0 |
| 2021-10-18 06:10:00 | SPY | ETF | 444.25 | 444.31 | 443.96 | 443.99 | 3567.0 |
| 2021-10-18 06:15:00 | SPY | ETF | 443.9 | 443.9 | 443.7 | 443.78 | 9343.0 |
| 2021-10-18 06:20:00 | SPY | ETF | 443.85 | 444.0 | 443.85 | 444.0 | 1186.0 |
| 2021-10-18 06:25:00 | SPY | ETF | 443.98 | 444.11 | 443.98 | 444.07 | 1290.0 |
| 2021-10-18 06:30:00 | SPY | ETF | 444.08 | 444.24 | 444.08 | 444.2 | 3421.0 |
| 2021-10-18 06:35:00 | SPY | ETF | 444.24 | 444.24 | 444.14 | 444.2 | 5002.0 |
| 2021-10-18 06:40:00 | SPY | ETF | 444.36 | 444.42 | 444.31 | 444.42 | 10900.0 |
| 2021-10-18 06:45:00 | SPY | ETF | 444.26 | 444.26 | 444.25 | 444.25 | 2342.0 |
| 2021-10-18 06:50:00 | SPY | ETF | 444.27 | 444.27 | 444.11 | 444.11 | 11404.0 |
| 2021-10-18 06:55:00 | SPY | ETF | 444.22 | 444.25 | 444.22 | 444.24 | 302.0 |
| 2021-10-18 07:00:00 | SPY | ETF | 444.16 | 444.34 | 444.16 | 444.34 | 11309.0 |
| 2021-10-18 07:05:00 | SPY | ETF | 444.329 | 444.65 | 444.3 | 444.65 | 27635.0 |
| 2021-10-18 07:10:00 | SPY | ETF | 444.6 | 444.63 | 444.58 | 444.63 | 4481.0 |
| 2021-10-18 07:15:00 | SPY | ETF | 444.66 | 444.71 | 444.61 | 444.7 | 19968.0 |
| 2021-10-18 07:20:00 | SPY | ETF | 444.7 | 444.83 | 444.68 | 444.83 | 36587.0 |
| 2021-10-18 07:25:00 | SPY | ETF | 444.81 | 445.02 | 444.74 | 445.02 | 95111.0 |
| 2021-10-18 07:30:00 | SPY | ETF | 445.04 | 445.04 | 444.77 | 444.77 | 16953.0 |
| 2021-10-18 07:35:00 | SPY | ETF | 444.78 | 444.86 | 444.45 | 444.5 | 27931.0 |
| 2021-10-18 07:40:00 | SPY | ETF | 444.52 | 444.64 | 444.47 | 444.51 | 13206.0 |
| 2021-10-18 07:45:00 | SPY | ETF | 444.5 | 444.5 | 444.43 | 444.45 | 35595.0 |
| 2021-10-18 07:50:00 | SPY | ETF | 444.45 | 444.6 | 444.45 | 444.58 | 7739.0 |
| 2021-10-18 07:55:00 | SPY | ETF | 444.57 | 444.57 | 444.47 | 444.51 | 2439.0 |
| 2021-10-18 08:00:00 | SPY | ETF | 443.9596 | 446.204 | 443.75 | 444.08 | 109489.0 |
| 2021-10-18 08:05:00 | SPY | ETF | 444.13 | 444.4 | 444.12 | 444.37 | 26684.0 |
> showing 50 of 84,101 rows — these rows as CSV