PREVIEW / etf_5min / 2021-12-17
file: by_date/etf_5min/2021/2021-12-17.parquet size: 1.9 MB rows: 90,437
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-12-17 04:00:00 | SPY | ETF | 464.91 | 464.91 | 463.93 | 464.1 | 18674.0 |
| 2021-12-17 04:05:00 | SPY | ETF | 464.03 | 464.03 | 463.7 | 463.92 | 4546.0 |
| 2021-12-17 04:10:00 | SPY | ETF | 463.81 | 463.81 | 462.97 | 462.97 | 17950.0 |
| 2021-12-17 04:15:00 | SPY | ETF | 462.67 | 463.85 | 462.5 | 463.85 | 20606.0 |
| 2021-12-17 04:20:00 | SPY | ETF | 463.71 | 464.1 | 463.67 | 464.04 | 5540.0 |
| 2021-12-17 04:25:00 | SPY | ETF | 464.12 | 464.28 | 464.02 | 464.02 | 9457.0 |
| 2021-12-17 04:30:00 | SPY | ETF | 464.07 | 464.14 | 463.96 | 463.96 | 2660.0 |
| 2021-12-17 04:35:00 | SPY | ETF | 464.09 | 464.09 | 463.91 | 463.91 | 3100.0 |
| 2021-12-17 04:40:00 | SPY | ETF | 463.52 | 463.52 | 463.45 | 463.45 | 200.0 |
| 2021-12-17 04:45:00 | SPY | ETF | 463.3 | 463.48 | 463.04 | 463.44 | 4157.0 |
| 2021-12-17 04:50:00 | SPY | ETF | 463.35 | 464.0 | 463.35 | 464.0 | 1954.0 |
| 2021-12-17 04:55:00 | SPY | ETF | 464.09 | 464.09 | 464.08 | 464.08 | 200.0 |
| 2021-12-17 05:00:00 | SPY | ETF | 464.21 | 464.31 | 464.07 | 464.07 | 3308.0 |
| 2021-12-17 05:05:00 | SPY | ETF | 464.12 | 464.22 | 464.03 | 464.03 | 1760.0 |
| 2021-12-17 05:10:00 | SPY | ETF | 464.23 | 464.23 | 463.87 | 463.87 | 26160.0 |
| 2021-12-17 05:15:00 | SPY | ETF | 463.67 | 463.92 | 463.66 | 463.87 | 762.0 |
| 2021-12-17 05:20:00 | SPY | ETF | 463.98 | 463.98 | 463.75 | 463.75 | 1100.0 |
| 2021-12-17 05:25:00 | SPY | ETF | 463.37 | 463.43 | 463.28 | 463.39 | 3505.0 |
| 2021-12-17 05:30:00 | SPY | ETF | 463.3 | 463.61 | 463.23 | 463.61 | 550.0 |
| 2021-12-17 05:40:00 | SPY | ETF | 463.43 | 463.43 | 463.12 | 463.22 | 7775.0 |
| 2021-12-17 05:45:00 | SPY | ETF | 463.2 | 463.37 | 463.11 | 463.11 | 1396.0 |
| 2021-12-17 05:50:00 | SPY | ETF | 463.08 | 463.19 | 462.8 | 462.98 | 9184.0 |
| 2021-12-17 05:55:00 | SPY | ETF | 463.18 | 463.32 | 463.05 | 463.32 | 950.0 |
| 2021-12-17 06:00:00 | SPY | ETF | 463.33 | 463.45 | 463.22 | 463.22 | 1330.0 |
| 2021-12-17 06:05:00 | SPY | ETF | 463.53 | 463.53 | 463.25 | 463.25 | 4770.0 |
| 2021-12-17 06:10:00 | SPY | ETF | 463.28 | 463.34 | 463.28 | 463.34 | 2100.0 |
| 2021-12-17 06:15:00 | SPY | ETF | 463.05 | 463.05 | 463.04 | 463.04 | 400.0 |
| 2021-12-17 06:20:00 | SPY | ETF | 463.35 | 463.57 | 463.35 | 463.55 | 2730.0 |
| 2021-12-17 06:25:00 | SPY | ETF | 463.74 | 463.8 | 463.73 | 463.8 | 2970.0 |
| 2021-12-17 06:30:00 | SPY | ETF | 463.76 | 463.76 | 463.76 | 463.76 | 129.0 |
| 2021-12-17 06:35:00 | SPY | ETF | 463.51 | 463.6 | 463.48 | 463.6 | 2120.0 |
| 2021-12-17 06:40:00 | SPY | ETF | 463.63 | 463.84 | 463.63 | 463.84 | 7471.0 |
| 2021-12-17 06:45:00 | SPY | ETF | 463.78 | 463.78 | 463.49 | 463.59 | 7398.0 |
| 2021-12-17 06:50:00 | SPY | ETF | 463.57 | 463.58 | 463.43 | 463.43 | 6695.0 |
| 2021-12-17 06:55:00 | SPY | ETF | 463.37 | 463.79 | 463.34 | 463.79 | 2016.0 |
| 2021-12-17 07:00:00 | SPY | ETF | 463.81 | 463.92 | 463.72 | 463.87 | 31187.0 |
| 2021-12-17 07:05:00 | SPY | ETF | 463.8 | 463.84 | 463.71 | 463.71 | 14616.0 |
| 2021-12-17 07:10:00 | SPY | ETF | 463.73 | 463.74 | 463.19 | 463.42 | 89913.0 |
| 2021-12-17 07:15:00 | SPY | ETF | 463.24 | 463.34 | 463.24 | 463.33 | 5538.0 |
| 2021-12-17 07:20:00 | SPY | ETF | 463.44 | 463.5 | 463.21 | 463.21 | 4106.0 |
| 2021-12-17 07:25:00 | SPY | ETF | 463.14 | 463.16 | 462.78 | 462.85 | 52464.0 |
| 2021-12-17 07:30:00 | SPY | ETF | 463.031 | 463.031 | 462.65 | 462.73 | 18886.0 |
| 2021-12-17 07:35:00 | SPY | ETF | 462.72 | 462.9 | 462.55 | 462.55 | 45892.0 |
| 2021-12-17 07:40:00 | SPY | ETF | 462.55 | 462.64 | 462.45 | 462.51 | 56489.0 |
| 2021-12-17 07:45:00 | SPY | ETF | 462.51 | 462.58 | 461.88 | 462.01 | 62983.0 |
| 2021-12-17 07:50:00 | SPY | ETF | 461.99 | 462.03 | 461.46 | 461.8 | 83089.0 |
| 2021-12-17 07:55:00 | SPY | ETF | 461.75 | 462.13 | 461.75 | 461.98 | 21194.0 |
| 2021-12-17 08:00:00 | SPY | ETF | 463.83 | 465.05 | 461.5 | 462.17 | 58411.0 |
| 2021-12-17 08:05:00 | SPY | ETF | 462.14 | 462.17 | 461.67 | 461.74 | 45500.0 |
| 2021-12-17 08:10:00 | SPY | ETF | 461.74 | 461.99 | 461.71 | 461.94 | 12435.0 |
> showing 50 of 90,437 rows — these rows as CSV