PREVIEW / etf_5min / 2021-02-05
file: by_date/etf_5min/2021/2021-02-05.parquet size: 1.8 MB rows: 85,033
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-02-05 04:00:00 | SPY | ETF | 387.06 | 387.06 | 386.88 | 387.0 | 7632.0 |
| 2021-02-05 04:05:00 | SPY | ETF | 387.0 | 387.02 | 386.92 | 387.02 | 1800.0 |
| 2021-02-05 04:10:00 | SPY | ETF | 387.06 | 387.14 | 387.06 | 387.14 | 2400.0 |
| 2021-02-05 04:15:00 | SPY | ETF | 387.1 | 387.1 | 387.02 | 387.02 | 200.0 |
| 2021-02-05 04:20:00 | SPY | ETF | 387.05 | 387.2 | 387.05 | 387.19 | 700.0 |
| 2021-02-05 04:25:00 | SPY | ETF | 387.14 | 387.15 | 387.14 | 387.15 | 700.0 |
| 2021-02-05 04:30:00 | SPY | ETF | 387.21 | 387.5 | 387.21 | 387.5 | 2028.0 |
| 2021-02-05 04:35:00 | SPY | ETF | 387.47 | 387.5 | 387.42 | 387.42 | 800.0 |
| 2021-02-05 04:40:00 | SPY | ETF | 387.42 | 387.66 | 387.42 | 387.62 | 3434.0 |
| 2021-02-05 04:45:00 | SPY | ETF | 387.66 | 387.66 | 387.57 | 387.57 | 4197.0 |
| 2021-02-05 04:50:00 | SPY | ETF | 387.58 | 387.59 | 387.57 | 387.59 | 1168.0 |
| 2021-02-05 04:55:00 | SPY | ETF | 387.55 | 387.55 | 387.46 | 387.47 | 15171.0 |
| 2021-02-05 05:00:00 | SPY | ETF | 387.46 | 387.47 | 387.46 | 387.47 | 2600.0 |
| 2021-02-05 05:05:00 | SPY | ETF | 387.52 | 387.57 | 387.52 | 387.57 | 1300.0 |
| 2021-02-05 05:10:00 | SPY | ETF | 387.55 | 387.57 | 387.55 | 387.57 | 1600.0 |
| 2021-02-05 05:20:00 | SPY | ETF | 387.73 | 387.73 | 387.58 | 387.58 | 1100.0 |
| 2021-02-05 05:25:00 | SPY | ETF | 387.59 | 387.59 | 387.52 | 387.56 | 2730.0 |
| 2021-02-05 05:30:00 | SPY | ETF | 387.57 | 387.72 | 387.57 | 387.72 | 550.0 |
| 2021-02-05 05:35:00 | SPY | ETF | 387.65 | 387.8 | 387.65 | 387.8 | 1701.0 |
| 2021-02-05 05:40:00 | SPY | ETF | 387.79 | 387.98 | 387.79 | 387.94 | 1300.0 |
| 2021-02-05 05:45:00 | SPY | ETF | 387.87 | 387.96 | 387.87 | 387.89 | 1100.0 |
| 2021-02-05 05:50:00 | SPY | ETF | 387.82 | 387.82 | 387.77 | 387.78 | 1267.0 |
| 2021-02-05 05:55:00 | SPY | ETF | 387.85 | 387.85 | 387.78 | 387.78 | 2000.0 |
| 2021-02-05 06:00:00 | SPY | ETF | 387.97 | 387.97 | 387.97 | 387.97 | 19987.0 |
| 2021-02-05 06:05:00 | SPY | ETF | 387.97 | 388.24 | 387.97 | 388.24 | 3980.0 |
| 2021-02-05 06:10:00 | SPY | ETF | 388.22 | 388.22 | 388.12 | 388.12 | 494.0 |
| 2021-02-05 06:15:00 | SPY | ETF | 388.1 | 388.14 | 387.97 | 388.14 | 1976.0 |
| 2021-02-05 06:20:00 | SPY | ETF | 388.09 | 388.12 | 388.09 | 388.12 | 453.0 |
| 2021-02-05 06:25:00 | SPY | ETF | 388.1 | 388.15 | 388.1 | 388.15 | 450.0 |
| 2021-02-05 06:30:00 | SPY | ETF | 387.97 | 387.98 | 387.89 | 387.96 | 2600.0 |
| 2021-02-05 06:35:00 | SPY | ETF | 387.92 | 387.94 | 387.92 | 387.94 | 1320.0 |
| 2021-02-05 06:40:00 | SPY | ETF | 387.99 | 388.01 | 387.99 | 388.01 | 499.0 |
| 2021-02-05 06:45:00 | SPY | ETF | 387.92 | 388.03 | 387.92 | 388.03 | 2499.0 |
| 2021-02-05 06:50:00 | SPY | ETF | 388.05 | 388.15 | 388.05 | 388.09 | 1924.0 |
| 2021-02-05 06:55:00 | SPY | ETF | 388.12 | 388.14 | 388.05 | 388.14 | 4290.0 |
| 2021-02-05 07:00:00 | SPY | ETF | 388.11 | 388.12 | 387.93 | 387.98 | 36308.0 |
| 2021-02-05 07:05:00 | SPY | ETF | 388.04 | 388.05 | 387.92 | 388.05 | 5779.0 |
| 2021-02-05 07:10:00 | SPY | ETF | 387.99 | 388.02 | 387.94 | 388.0 | 14505.0 |
| 2021-02-05 07:15:00 | SPY | ETF | 387.98 | 388.12 | 387.96 | 388.0 | 6310.0 |
| 2021-02-05 07:20:00 | SPY | ETF | 388.01 | 388.04 | 387.9 | 387.9 | 24068.0 |
| 2021-02-05 07:25:00 | SPY | ETF | 387.95 | 388.0 | 387.94 | 387.999 | 1841.0 |
| 2021-02-05 07:30:00 | SPY | ETF | 387.97 | 387.98 | 387.8 | 387.8 | 24276.0 |
| 2021-02-05 07:35:00 | SPY | ETF | 387.89 | 387.95 | 387.88 | 387.94 | 1777.0 |
| 2021-02-05 07:40:00 | SPY | ETF | 387.93 | 387.93 | 387.79 | 387.79 | 8000.0 |
| 2021-02-05 07:45:00 | SPY | ETF | 387.77 | 387.88 | 387.77 | 387.82 | 1469.0 |
| 2021-02-05 07:50:00 | SPY | ETF | 387.84 | 387.84 | 387.72 | 387.79 | 8580.0 |
| 2021-02-05 07:55:00 | SPY | ETF | 387.87 | 387.87 | 387.77 | 387.8 | 8226.0 |
| 2021-02-05 08:00:00 | SPY | ETF | 387.8 | 388.09 | 386.81 | 387.74 | 31102.0 |
| 2021-02-05 08:05:00 | SPY | ETF | 387.72 | 387.74 | 387.66 | 387.67 | 9983.0 |
| 2021-02-05 08:10:00 | SPY | ETF | 387.64 | 387.65 | 387.52 | 387.52 | 15543.0 |
> showing 50 of 85,033 rows — these rows as CSV