PREVIEW / etf_5min / 2022-04-27
file: by_date/etf_5min/2022/2022-04-27.parquet size: 2.0 MB rows: 100,767
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-27 04:00:00 | SPY | ETF | 419.0 | 420.22 | 419.0 | 419.77 | 57590.0 |
| 2022-04-27 04:05:00 | SPY | ETF | 419.6 | 419.73 | 419.41 | 419.6 | 1918.0 |
| 2022-04-27 04:10:00 | SPY | ETF | 419.95 | 420.56 | 419.84 | 420.56 | 4815.0 |
| 2022-04-27 04:15:00 | SPY | ETF | 420.57 | 420.92 | 420.51 | 420.9 | 39051.0 |
| 2022-04-27 04:20:00 | SPY | ETF | 420.5 | 421.0 | 420.5 | 420.68 | 13035.0 |
| 2022-04-27 04:25:00 | SPY | ETF | 420.5 | 420.53 | 420.3 | 420.3 | 11600.0 |
| 2022-04-27 04:30:00 | SPY | ETF | 420.31 | 420.52 | 419.85 | 419.93 | 5335.0 |
| 2022-04-27 04:35:00 | SPY | ETF | 419.9 | 420.15 | 419.76 | 420.08 | 6800.0 |
| 2022-04-27 04:40:00 | SPY | ETF | 420.2 | 420.2 | 420.05 | 420.05 | 1200.0 |
| 2022-04-27 04:45:00 | SPY | ETF | 420.01 | 420.01 | 419.3 | 419.45 | 8726.0 |
| 2022-04-27 04:50:00 | SPY | ETF | 419.32 | 419.68 | 419.26 | 419.57 | 41655.0 |
| 2022-04-27 04:55:00 | SPY | ETF | 419.57 | 420.1 | 419.56 | 419.8 | 57498.0 |
| 2022-04-27 05:00:00 | SPY | ETF | 419.77 | 420.13 | 419.77 | 419.95 | 23500.0 |
| 2022-04-27 05:05:00 | SPY | ETF | 419.98 | 420.26 | 419.75 | 419.75 | 16810.0 |
| 2022-04-27 05:10:00 | SPY | ETF | 419.69 | 420.13 | 419.69 | 420.01 | 5520.0 |
| 2022-04-27 05:15:00 | SPY | ETF | 419.92 | 420.02 | 419.62 | 420.02 | 4350.0 |
| 2022-04-27 05:20:00 | SPY | ETF | 419.92 | 420.15 | 419.9 | 419.96 | 5300.0 |
| 2022-04-27 05:25:00 | SPY | ETF | 420.08 | 420.38 | 420.03 | 420.14 | 27294.0 |
| 2022-04-27 05:30:00 | SPY | ETF | 420.1 | 420.1 | 419.62 | 419.62 | 1800.0 |
| 2022-04-27 05:35:00 | SPY | ETF | 419.66 | 420.1 | 419.65 | 420.1 | 8999.0 |
| 2022-04-27 05:40:00 | SPY | ETF | 420.08 | 420.19 | 420.01 | 420.02 | 18325.0 |
| 2022-04-27 05:45:00 | SPY | ETF | 420.05 | 420.05 | 419.7 | 419.78 | 3720.0 |
| 2022-04-27 05:50:00 | SPY | ETF | 419.84 | 420.24 | 419.84 | 420.17 | 8699.0 |
| 2022-04-27 05:55:00 | SPY | ETF | 420.16 | 420.49 | 420.13 | 420.41 | 21461.0 |
| 2022-04-27 06:00:00 | SPY | ETF | 420.46 | 420.71 | 420.45 | 420.54 | 48112.0 |
| 2022-04-27 06:05:00 | SPY | ETF | 420.51 | 420.71 | 420.51 | 420.6 | 7869.0 |
| 2022-04-27 06:10:00 | SPY | ETF | 420.6 | 420.75 | 420.6 | 420.67 | 24811.0 |
| 2022-04-27 06:15:00 | SPY | ETF | 420.68 | 420.68 | 420.51 | 420.51 | 21662.0 |
| 2022-04-27 06:20:00 | SPY | ETF | 420.34 | 420.49 | 420.31 | 420.46 | 29845.0 |
| 2022-04-27 06:25:00 | SPY | ETF | 420.41 | 420.42 | 420.31 | 420.39 | 6451.0 |
| 2022-04-27 06:30:00 | SPY | ETF | 420.33 | 420.4 | 420.25 | 420.32 | 3336.0 |
| 2022-04-27 06:35:00 | SPY | ETF | 420.29 | 420.55 | 420.17 | 420.29 | 10536.0 |
| 2022-04-27 06:40:00 | SPY | ETF | 420.41 | 420.41 | 420.2 | 420.2 | 1768.0 |
| 2022-04-27 06:45:00 | SPY | ETF | 420.15 | 420.51 | 419.4 | 420.22 | 32782.0 |
| 2022-04-27 06:50:00 | SPY | ETF | 420.17 | 420.72 | 420.1 | 420.72 | 22637.0 |
| 2022-04-27 06:55:00 | SPY | ETF | 420.66 | 420.76 | 420.4 | 420.46 | 10251.0 |
| 2022-04-27 07:00:00 | SPY | ETF | 420.49 | 420.49 | 419.51 | 419.58 | 49447.0 |
| 2022-04-27 07:05:00 | SPY | ETF | 419.56 | 419.59 | 418.97 | 419.0 | 39905.0 |
| 2022-04-27 07:10:00 | SPY | ETF | 419.0 | 419.27 | 418.97 | 419.2 | 23723.0 |
| 2022-04-27 07:15:00 | SPY | ETF | 419.21 | 419.28 | 418.7 | 418.84 | 20970.0 |
| 2022-04-27 07:20:00 | SPY | ETF | 418.88 | 418.9 | 418.1 | 418.23 | 26067.0 |
| 2022-04-27 07:25:00 | SPY | ETF | 418.24 | 418.24 | 417.65 | 417.71 | 43237.0 |
| 2022-04-27 07:30:00 | SPY | ETF | 417.66 | 418.0 | 417.45 | 417.8 | 35969.0 |
| 2022-04-27 07:35:00 | SPY | ETF | 417.78 | 418.0 | 417.71 | 417.92 | 42644.0 |
| 2022-04-27 07:40:00 | SPY | ETF | 417.9 | 418.27 | 417.84 | 418.15 | 37534.0 |
| 2022-04-27 07:45:00 | SPY | ETF | 418.2 | 418.62 | 418.2 | 418.45 | 26953.0 |
| 2022-04-27 07:50:00 | SPY | ETF | 418.42 | 418.54 | 418.0 | 418.11 | 25776.0 |
| 2022-04-27 07:55:00 | SPY | ETF | 418.05 | 418.3 | 417.62 | 417.89 | 37369.0 |
| 2022-04-27 08:00:00 | SPY | ETF | 419.6999 | 420.75 | 416.1 | 418.62 | 104956.0 |
| 2022-04-27 08:05:00 | SPY | ETF | 418.59 | 418.9 | 418.15 | 418.9 | 37916.0 |
> showing 50 of 100,767 rows — these rows as CSV