PREVIEW / etf_5min / 2022-04-07
file: by_date/etf_5min/2022/2022-04-07.parquet size: 1.9 MB rows: 93,596
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-07 04:00:00 | SPY | ETF | 445.74 | 446.4 | 445.61 | 446.35 | 10144.0 |
| 2022-04-07 04:05:00 | SPY | ETF | 446.35 | 446.65 | 446.35 | 446.48 | 3293.0 |
| 2022-04-07 04:10:00 | SPY | ETF | 446.7 | 446.73 | 446.27 | 446.36 | 1946.0 |
| 2022-04-07 04:15:00 | SPY | ETF | 446.49 | 446.63 | 446.19 | 446.4 | 10445.0 |
| 2022-04-07 04:20:00 | SPY | ETF | 446.66 | 446.66 | 446.6 | 446.62 | 1699.0 |
| 2022-04-07 04:25:00 | SPY | ETF | 446.51 | 446.74 | 446.51 | 446.72 | 2145.0 |
| 2022-04-07 04:30:00 | SPY | ETF | 446.59 | 446.79 | 446.51 | 446.51 | 1500.0 |
| 2022-04-07 04:35:00 | SPY | ETF | 446.66 | 446.66 | 446.39 | 446.39 | 1100.0 |
| 2022-04-07 04:40:00 | SPY | ETF | 446.75 | 446.75 | 446.75 | 446.75 | 100.0 |
| 2022-04-07 04:45:00 | SPY | ETF | 446.74 | 446.88 | 446.74 | 446.8 | 2140.0 |
| 2022-04-07 04:50:00 | SPY | ETF | 446.96 | 447.01 | 446.96 | 447.01 | 315.0 |
| 2022-04-07 04:55:00 | SPY | ETF | 447.29 | 447.5 | 447.29 | 447.5 | 600.0 |
| 2022-04-07 05:00:00 | SPY | ETF | 447.41 | 447.41 | 447.38 | 447.38 | 837.0 |
| 2022-04-07 05:05:00 | SPY | ETF | 447.3 | 447.31 | 447.1 | 447.1 | 2103.0 |
| 2022-04-07 05:10:00 | SPY | ETF | 447.1 | 447.11 | 447.1 | 447.11 | 500.0 |
| 2022-04-07 05:15:00 | SPY | ETF | 447.24 | 447.5 | 447.24 | 447.39 | 12913.0 |
| 2022-04-07 05:20:00 | SPY | ETF | 447.29 | 447.56 | 447.25 | 447.41 | 2498.0 |
| 2022-04-07 05:25:00 | SPY | ETF | 447.27 | 447.29 | 447.27 | 447.27 | 700.0 |
| 2022-04-07 05:30:00 | SPY | ETF | 447.35 | 447.48 | 447.35 | 447.48 | 1700.0 |
| 2022-04-07 05:35:00 | SPY | ETF | 447.41 | 447.41 | 447.36 | 447.36 | 424.0 |
| 2022-04-07 05:40:00 | SPY | ETF | 447.65 | 447.8 | 447.65 | 447.69 | 13199.0 |
| 2022-04-07 05:45:00 | SPY | ETF | 447.54 | 447.65 | 447.54 | 447.65 | 2500.0 |
| 2022-04-07 05:50:00 | SPY | ETF | 447.57 | 447.7 | 447.55 | 447.7 | 1098.0 |
| 2022-04-07 05:55:00 | SPY | ETF | 447.67 | 447.9 | 447.67 | 447.9 | 2849.0 |
| 2022-04-07 06:00:00 | SPY | ETF | 447.88 | 447.96 | 447.85 | 447.94 | 3685.0 |
| 2022-04-07 06:05:00 | SPY | ETF | 447.9 | 447.94 | 447.9 | 447.94 | 1229.0 |
| 2022-04-07 06:10:00 | SPY | ETF | 447.86 | 447.86 | 447.85 | 447.85 | 1500.0 |
| 2022-04-07 06:15:00 | SPY | ETF | 447.92 | 447.99 | 447.77 | 447.85 | 1464.0 |
| 2022-04-07 06:20:00 | SPY | ETF | 447.9 | 447.98 | 447.86 | 447.92 | 1113.0 |
| 2022-04-07 06:25:00 | SPY | ETF | 447.86 | 447.89 | 447.85 | 447.89 | 1024.0 |
| 2022-04-07 06:30:00 | SPY | ETF | 447.84 | 447.84 | 447.71 | 447.71 | 2161.0 |
| 2022-04-07 06:35:00 | SPY | ETF | 447.81 | 447.9 | 447.81 | 447.9 | 399.0 |
| 2022-04-07 06:45:00 | SPY | ETF | 447.66 | 447.68 | 447.66 | 447.68 | 799.0 |
| 2022-04-07 06:50:00 | SPY | ETF | 447.8 | 447.8 | 447.71 | 447.71 | 16241.0 |
| 2022-04-07 06:55:00 | SPY | ETF | 447.6 | 447.66 | 447.55 | 447.57 | 1048.0 |
| 2022-04-07 07:00:00 | SPY | ETF | 447.54 | 447.61 | 447.24 | 447.27 | 21713.0 |
| 2022-04-07 07:05:00 | SPY | ETF | 447.33 | 448.65 | 447.31 | 447.59 | 54319.0 |
| 2022-04-07 07:10:00 | SPY | ETF | 447.75 | 448.22 | 447.51 | 447.9 | 31140.0 |
| 2022-04-07 07:15:00 | SPY | ETF | 447.85 | 447.92 | 447.65 | 447.68 | 18997.0 |
| 2022-04-07 07:20:00 | SPY | ETF | 447.63 | 447.65 | 447.27 | 447.27 | 29675.0 |
| 2022-04-07 07:25:00 | SPY | ETF | 447.32 | 447.37 | 447.1 | 447.27 | 8595.0 |
| 2022-04-07 07:30:00 | SPY | ETF | 447.17 | 447.5 | 446.91 | 447.1 | 8172.0 |
| 2022-04-07 07:35:00 | SPY | ETF | 446.95 | 447.17 | 446.95 | 446.99 | 2017.0 |
| 2022-04-07 07:40:00 | SPY | ETF | 446.91 | 447.28 | 446.91 | 447.21 | 19430.0 |
| 2022-04-07 07:45:00 | SPY | ETF | 447.21 | 447.35 | 447.1 | 447.12 | 17140.0 |
| 2022-04-07 07:50:00 | SPY | ETF | 447.01 | 447.2 | 447.01 | 447.1 | 25557.0 |
| 2022-04-07 07:55:00 | SPY | ETF | 447.1 | 447.35 | 447.08 | 447.34 | 31233.0 |
| 2022-04-07 08:00:00 | SPY | ETF | 448.4801 | 448.5 | 444.95 | 446.79 | 79075.0 |
| 2022-04-07 08:05:00 | SPY | ETF | 446.7896 | 446.86 | 446.64 | 446.77 | 49483.0 |
| 2022-04-07 08:10:00 | SPY | ETF | 446.72 | 446.85 | 445.53 | 446.48 | 246501.0 |
> showing 50 of 93,596 rows — these rows as CSV