PREVIEW / etf_5min / 2021-05-13
file: by_date/etf_5min/2021/2021-05-13.parquet size: 1.8 MB rows: 87,471
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-05-13 04:00:00 | SPY | ETF | 403.96 | 404.17 | 403.55 | 404.1 | 19878.0 |
| 2021-05-13 04:05:00 | SPY | ETF | 404.25 | 404.46 | 403.9 | 403.9 | 2097.0 |
| 2021-05-13 04:10:00 | SPY | ETF | 403.8 | 404.0 | 403.45 | 403.46 | 16400.0 |
| 2021-05-13 04:15:00 | SPY | ETF | 403.6 | 404.01 | 403.6 | 403.84 | 13400.0 |
| 2021-05-13 04:20:00 | SPY | ETF | 403.7 | 404.08 | 403.64 | 404.01 | 6350.0 |
| 2021-05-13 04:25:00 | SPY | ETF | 403.76 | 404.09 | 403.73 | 403.8 | 8175.0 |
| 2021-05-13 04:30:00 | SPY | ETF | 403.71 | 403.82 | 403.45 | 403.82 | 3800.0 |
| 2021-05-13 04:35:00 | SPY | ETF | 403.68 | 403.68 | 403.42 | 403.6 | 7999.0 |
| 2021-05-13 04:40:00 | SPY | ETF | 403.43 | 403.55 | 403.21 | 403.46 | 6950.0 |
| 2021-05-13 04:45:00 | SPY | ETF | 403.31 | 403.39 | 402.95 | 402.95 | 16247.0 |
| 2021-05-13 04:50:00 | SPY | ETF | 403.02 | 403.11 | 402.7 | 403.1 | 17250.0 |
| 2021-05-13 04:55:00 | SPY | ETF | 403.09 | 403.83 | 403.09 | 403.67 | 9875.0 |
| 2021-05-13 05:00:00 | SPY | ETF | 403.79 | 404.34 | 403.79 | 404.34 | 7002.0 |
| 2021-05-13 05:05:00 | SPY | ETF | 404.2 | 404.21 | 403.99 | 404.2 | 2588.0 |
| 2021-05-13 05:10:00 | SPY | ETF | 404.2 | 404.23 | 403.89 | 403.99 | 8300.0 |
| 2021-05-13 05:15:00 | SPY | ETF | 403.91 | 403.91 | 403.51 | 403.76 | 9592.0 |
| 2021-05-13 05:20:00 | SPY | ETF | 403.79 | 404.29 | 403.79 | 404.24 | 6214.0 |
| 2021-05-13 05:25:00 | SPY | ETF | 404.3 | 404.54 | 404.3 | 404.44 | 6525.0 |
| 2021-05-13 05:30:00 | SPY | ETF | 404.54 | 404.6 | 404.28 | 404.34 | 2549.0 |
| 2021-05-13 05:35:00 | SPY | ETF | 404.4 | 404.45 | 404.26 | 404.45 | 1300.0 |
| 2021-05-13 05:40:00 | SPY | ETF | 404.48 | 404.48 | 404.36 | 404.42 | 7200.0 |
| 2021-05-13 05:45:00 | SPY | ETF | 404.45 | 404.5 | 404.34 | 404.44 | 3800.0 |
| 2021-05-13 05:50:00 | SPY | ETF | 404.44 | 404.82 | 404.4 | 404.67 | 9700.0 |
| 2021-05-13 05:55:00 | SPY | ETF | 404.68 | 404.75 | 404.32 | 404.32 | 4100.0 |
| 2021-05-13 06:00:00 | SPY | ETF | 404.29 | 404.29 | 403.94 | 403.96 | 800.0 |
| 2021-05-13 06:05:00 | SPY | ETF | 403.74 | 403.83 | 403.4 | 403.73 | 14050.0 |
| 2021-05-13 06:10:00 | SPY | ETF | 403.64 | 403.9 | 403.58 | 403.9 | 7773.0 |
| 2021-05-13 06:15:00 | SPY | ETF | 403.87 | 404.15 | 403.87 | 403.98 | 17000.0 |
| 2021-05-13 06:20:00 | SPY | ETF | 404.01 | 404.01 | 403.89 | 404.0 | 6025.0 |
| 2021-05-13 06:25:00 | SPY | ETF | 404.0 | 404.3 | 404.0 | 404.12 | 23718.0 |
| 2021-05-13 06:30:00 | SPY | ETF | 404.22 | 404.4 | 404.06 | 404.06 | 22395.0 |
| 2021-05-13 06:35:00 | SPY | ETF | 403.92 | 404.36 | 403.92 | 404.36 | 12900.0 |
| 2021-05-13 06:40:00 | SPY | ETF | 404.16 | 404.26 | 404.16 | 404.26 | 1350.0 |
| 2021-05-13 06:45:00 | SPY | ETF | 404.28 | 404.35 | 403.96 | 403.97 | 5621.0 |
| 2021-05-13 06:50:00 | SPY | ETF | 403.93 | 404.23 | 403.74 | 404.23 | 13154.0 |
| 2021-05-13 06:55:00 | SPY | ETF | 404.26 | 404.52 | 404.26 | 404.43 | 4994.0 |
| 2021-05-13 07:00:00 | SPY | ETF | 404.35 | 404.46 | 404.17 | 404.3 | 23926.0 |
| 2021-05-13 07:05:00 | SPY | ETF | 404.33 | 404.35 | 404.24 | 404.27 | 7151.0 |
| 2021-05-13 07:10:00 | SPY | ETF | 404.27 | 404.35 | 404.23 | 404.28 | 5301.0 |
| 2021-05-13 07:15:00 | SPY | ETF | 404.34 | 404.76 | 404.26 | 404.76 | 30034.0 |
| 2021-05-13 07:20:00 | SPY | ETF | 404.73 | 405.38 | 404.73 | 405.18 | 66143.0 |
| 2021-05-13 07:25:00 | SPY | ETF | 405.2 | 405.56 | 405.15 | 405.55 | 55187.0 |
| 2021-05-13 07:30:00 | SPY | ETF | 405.5 | 405.85 | 405.47 | 405.85 | 108769.0 |
| 2021-05-13 07:35:00 | SPY | ETF | 405.88 | 406.2 | 405.65 | 405.83 | 110527.0 |
| 2021-05-13 07:40:00 | SPY | ETF | 405.91 | 406.25 | 405.83 | 406.23 | 58565.0 |
| 2021-05-13 07:45:00 | SPY | ETF | 406.24 | 406.24 | 405.69 | 405.74 | 33143.0 |
| 2021-05-13 07:50:00 | SPY | ETF | 405.72 | 405.8 | 405.5 | 405.68 | 91712.0 |
| 2021-05-13 07:55:00 | SPY | ETF | 405.73 | 405.89 | 405.66 | 405.66 | 130646.0 |
| 2021-05-13 08:00:00 | SPY | ETF | 405.65 | 406.96 | 403.6104 | 405.92 | 154725.0 |
| 2021-05-13 08:05:00 | SPY | ETF | 405.93 | 406.3 | 405.27 | 406.3 | 145424.0 |
> showing 50 of 87,471 rows — these rows as CSV