PREVIEW / etf_5min / 2021-11-10
file: by_date/etf_5min/2021/2021-11-10.parquet size: 1.8 MB rows: 88,930
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-11-10 04:00:00 | SPY | ETF | 466.51 | 466.87 | 466.51 | 466.72 | 3640.0 |
| 2021-11-10 04:05:00 | SPY | ETF | 466.88 | 466.93 | 466.88 | 466.88 | 1650.0 |
| 2021-11-10 04:10:00 | SPY | ETF | 466.56 | 466.59 | 466.52 | 466.59 | 1329.0 |
| 2021-11-10 04:20:00 | SPY | ETF | 466.3 | 466.3 | 466.28 | 466.28 | 200.0 |
| 2021-11-10 04:25:00 | SPY | ETF | 466.45 | 466.45 | 466.45 | 466.45 | 400.0 |
| 2021-11-10 04:30:00 | SPY | ETF | 466.41 | 466.56 | 466.4 | 466.56 | 764.0 |
| 2021-11-10 04:40:00 | SPY | ETF | 466.68 | 466.68 | 466.68 | 466.68 | 100.0 |
| 2021-11-10 04:45:00 | SPY | ETF | 466.78 | 466.92 | 466.78 | 466.92 | 400.0 |
| 2021-11-10 04:50:00 | SPY | ETF | 466.92 | 466.93 | 466.86 | 466.86 | 318.0 |
| 2021-11-10 04:55:00 | SPY | ETF | 466.87 | 466.87 | 466.85 | 466.85 | 400.0 |
| 2021-11-10 05:00:00 | SPY | ETF | 466.88 | 466.88 | 466.75 | 466.83 | 600.0 |
| 2021-11-10 05:05:00 | SPY | ETF | 466.83 | 466.83 | 466.74 | 466.74 | 300.0 |
| 2021-11-10 05:15:00 | SPY | ETF | 466.57 | 466.57 | 466.57 | 466.57 | 400.0 |
| 2021-11-10 05:20:00 | SPY | ETF | 466.62 | 466.66 | 466.59 | 466.59 | 1099.0 |
| 2021-11-10 05:25:00 | SPY | ETF | 466.56 | 466.56 | 466.51 | 466.51 | 573.0 |
| 2021-11-10 05:30:00 | SPY | ETF | 466.47 | 466.47 | 466.23 | 466.31 | 2050.0 |
| 2021-11-10 05:35:00 | SPY | ETF | 466.18 | 466.23 | 466.18 | 466.23 | 300.0 |
| 2021-11-10 05:40:00 | SPY | ETF | 466.08 | 466.13 | 465.89 | 465.99 | 2500.0 |
| 2021-11-10 05:45:00 | SPY | ETF | 466.13 | 466.16 | 466.03 | 466.1 | 2096.0 |
| 2021-11-10 05:50:00 | SPY | ETF | 465.98 | 466.01 | 465.98 | 466.01 | 300.0 |
| 2021-11-10 05:55:00 | SPY | ETF | 466.0 | 466.21 | 466.0 | 466.21 | 700.0 |
| 2021-11-10 06:00:00 | SPY | ETF | 466.27 | 466.28 | 466.21 | 466.23 | 2503.0 |
| 2021-11-10 06:05:00 | SPY | ETF | 466.32 | 466.32 | 466.28 | 466.28 | 525.0 |
| 2021-11-10 06:10:00 | SPY | ETF | 466.34 | 466.34 | 466.3 | 466.3 | 5600.0 |
| 2021-11-10 06:15:00 | SPY | ETF | 466.34 | 466.35 | 465.99 | 465.99 | 1350.0 |
| 2021-11-10 06:20:00 | SPY | ETF | 466.0 | 466.14 | 466.0 | 466.11 | 709.0 |
| 2021-11-10 06:25:00 | SPY | ETF | 466.18 | 466.18 | 466.18 | 466.18 | 100.0 |
| 2021-11-10 06:30:00 | SPY | ETF | 466.28 | 466.29 | 466.15 | 466.15 | 6148.0 |
| 2021-11-10 06:35:00 | SPY | ETF | 466.18 | 466.18 | 465.75 | 465.75 | 3025.0 |
| 2021-11-10 06:40:00 | SPY | ETF | 465.9 | 465.92 | 465.69 | 465.71 | 3743.0 |
| 2021-11-10 06:45:00 | SPY | ETF | 465.75 | 465.82 | 465.75 | 465.82 | 4793.0 |
| 2021-11-10 06:50:00 | SPY | ETF | 465.77 | 465.78 | 465.71 | 465.74 | 920.0 |
| 2021-11-10 06:55:00 | SPY | ETF | 465.73 | 465.83 | 465.69 | 465.83 | 3740.0 |
| 2021-11-10 07:00:00 | SPY | ETF | 465.78 | 465.914 | 465.78 | 465.88 | 8875.0 |
| 2021-11-10 07:05:00 | SPY | ETF | 465.92 | 466.0 | 465.9 | 465.97 | 9561.0 |
| 2021-11-10 07:10:00 | SPY | ETF | 466.03 | 466.28 | 466.0 | 466.26 | 19935.0 |
| 2021-11-10 07:15:00 | SPY | ETF | 466.28 | 466.31 | 466.21 | 466.21 | 11763.0 |
| 2021-11-10 07:20:00 | SPY | ETF | 466.19 | 466.25 | 466.14 | 466.17 | 3726.0 |
| 2021-11-10 07:25:00 | SPY | ETF | 466.18 | 466.3 | 466.18 | 466.3 | 11158.0 |
| 2021-11-10 07:30:00 | SPY | ETF | 466.25 | 466.25 | 465.9 | 465.99 | 62287.0 |
| 2021-11-10 07:35:00 | SPY | ETF | 465.99 | 466.27 | 465.99 | 466.26 | 29460.0 |
| 2021-11-10 07:40:00 | SPY | ETF | 466.29 | 466.42 | 466.28 | 466.42 | 16139.0 |
| 2021-11-10 07:45:00 | SPY | ETF | 466.31 | 466.32 | 466.25 | 466.32 | 38445.0 |
| 2021-11-10 07:50:00 | SPY | ETF | 466.3 | 466.32 | 466.27 | 466.32 | 11717.0 |
| 2021-11-10 07:55:00 | SPY | ETF | 466.23 | 466.34 | 466.23 | 466.28 | 9151.0 |
| 2021-11-10 08:00:00 | SPY | ETF | 465.9399 | 467.0 | 465.7404 | 466.37 | 55961.0 |
| 2021-11-10 08:05:00 | SPY | ETF | 466.37 | 466.59 | 466.35 | 466.5699 | 36593.0 |
| 2021-11-10 08:10:00 | SPY | ETF | 466.57 | 466.65 | 466.4199 | 466.5 | 43674.0 |
| 2021-11-10 08:15:00 | SPY | ETF | 466.52 | 466.6 | 466.45 | 466.54 | 9332.0 |
| 2021-11-10 08:20:00 | SPY | ETF | 466.5 | 466.57 | 466.47 | 466.54 | 7850.0 |
> showing 50 of 88,930 rows — these rows as CSV