PREVIEW / etf_5min / 2021-01-21
file: by_date/etf_5min/2021/2021-01-21.parquet size: 1.9 MB rows: 85,330
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-01-21 04:00:00 | SPY | ETF | 384.7 | 384.83 | 384.7 | 384.83 | 1795.0 |
| 2021-01-21 04:05:00 | SPY | ETF | 384.77 | 384.77 | 384.65 | 384.65 | 700.0 |
| 2021-01-21 04:10:00 | SPY | ETF | 384.65 | 384.65 | 384.63 | 384.63 | 1269.0 |
| 2021-01-21 04:15:00 | SPY | ETF | 384.69 | 384.69 | 384.66 | 384.66 | 300.0 |
| 2021-01-21 04:20:00 | SPY | ETF | 384.65 | 384.72 | 384.65 | 384.7 | 900.0 |
| 2021-01-21 04:25:00 | SPY | ETF | 384.6 | 384.6 | 384.6 | 384.6 | 200.0 |
| 2021-01-21 04:30:00 | SPY | ETF | 384.7 | 384.79 | 384.7 | 384.79 | 300.0 |
| 2021-01-21 04:45:00 | SPY | ETF | 384.77 | 384.8 | 384.7 | 384.8 | 721.0 |
| 2021-01-21 05:00:00 | SPY | ETF | 384.65 | 384.65 | 384.65 | 384.65 | 100.0 |
| 2021-01-21 05:05:00 | SPY | ETF | 384.66 | 384.7 | 384.66 | 384.7 | 450.0 |
| 2021-01-21 05:10:00 | SPY | ETF | 384.65 | 384.66 | 384.65 | 384.66 | 500.0 |
| 2021-01-21 05:15:00 | SPY | ETF | 384.6 | 384.7 | 384.6 | 384.7 | 200.0 |
| 2021-01-21 05:20:00 | SPY | ETF | 384.63 | 384.63 | 384.63 | 384.63 | 600.0 |
| 2021-01-21 05:25:00 | SPY | ETF | 384.65 | 384.65 | 384.65 | 384.65 | 600.0 |
| 2021-01-21 05:30:00 | SPY | ETF | 384.64 | 384.64 | 384.6 | 384.6 | 200.0 |
| 2021-01-21 05:35:00 | SPY | ETF | 384.61 | 384.61 | 384.61 | 384.61 | 300.0 |
| 2021-01-21 05:40:00 | SPY | ETF | 384.59 | 384.59 | 384.44 | 384.51 | 1185.0 |
| 2021-01-21 05:45:00 | SPY | ETF | 384.64 | 384.64 | 384.6 | 384.6 | 400.0 |
| 2021-01-21 05:50:00 | SPY | ETF | 384.63 | 384.76 | 384.6 | 384.76 | 3647.0 |
| 2021-01-21 05:55:00 | SPY | ETF | 384.8 | 384.8 | 384.76 | 384.76 | 950.0 |
| 2021-01-21 06:00:00 | SPY | ETF | 384.7 | 384.77 | 384.7 | 384.77 | 900.0 |
| 2021-01-21 06:05:00 | SPY | ETF | 384.78 | 384.78 | 384.72 | 384.72 | 300.0 |
| 2021-01-21 06:15:00 | SPY | ETF | 384.74 | 384.84 | 384.74 | 384.8 | 2705.0 |
| 2021-01-21 06:20:00 | SPY | ETF | 384.85 | 384.94 | 384.85 | 384.94 | 300.0 |
| 2021-01-21 06:25:00 | SPY | ETF | 384.9 | 384.99 | 384.9 | 384.99 | 1038.0 |
| 2021-01-21 06:30:00 | SPY | ETF | 384.93 | 384.93 | 384.77 | 384.83 | 5700.0 |
| 2021-01-21 06:35:00 | SPY | ETF | 384.85 | 384.85 | 384.85 | 384.85 | 100.0 |
| 2021-01-21 06:40:00 | SPY | ETF | 384.84 | 384.84 | 384.75 | 384.75 | 1402.0 |
| 2021-01-21 06:45:00 | SPY | ETF | 384.77 | 384.9 | 384.77 | 384.9 | 5200.0 |
| 2021-01-21 06:50:00 | SPY | ETF | 384.96 | 385.0 | 384.93 | 385.0 | 2554.0 |
| 2021-01-21 06:55:00 | SPY | ETF | 385.02 | 385.12 | 385.0 | 385.12 | 3558.0 |
| 2021-01-21 07:00:00 | SPY | ETF | 385.12 | 385.23 | 385.12 | 385.22 | 18595.0 |
| 2021-01-21 07:05:00 | SPY | ETF | 385.25 | 385.3 | 385.08 | 385.08 | 11792.0 |
| 2021-01-21 07:10:00 | SPY | ETF | 385.091 | 385.1 | 385.0 | 385.0 | 10790.0 |
| 2021-01-21 07:15:00 | SPY | ETF | 385.01 | 385.05 | 385.0 | 385.04 | 29676.0 |
| 2021-01-21 07:20:00 | SPY | ETF | 385.03 | 385.03 | 384.94 | 384.99 | 3146.0 |
| 2021-01-21 07:25:00 | SPY | ETF | 384.97 | 385.1 | 384.96 | 385.1 | 41040.0 |
| 2021-01-21 07:30:00 | SPY | ETF | 385.1 | 385.11 | 384.9 | 384.9 | 19185.0 |
| 2021-01-21 07:35:00 | SPY | ETF | 384.92 | 385.0 | 384.92 | 384.98 | 4300.0 |
| 2021-01-21 07:40:00 | SPY | ETF | 384.96 | 384.96 | 384.9 | 384.9 | 2562.0 |
| 2021-01-21 07:45:00 | SPY | ETF | 384.95 | 384.95 | 384.86 | 384.89 | 4314.0 |
| 2021-01-21 07:50:00 | SPY | ETF | 384.92 | 384.92 | 384.86 | 384.86 | 1000.0 |
| 2021-01-21 07:55:00 | SPY | ETF | 384.87 | 384.91 | 384.74 | 384.91 | 4897.0 |
| 2021-01-21 08:00:00 | SPY | ETF | 384.9 | 385.3 | 384.72 | 384.9 | 26110.0 |
| 2021-01-21 08:05:00 | SPY | ETF | 384.9 | 384.9 | 384.85 | 384.86 | 3499.0 |
| 2021-01-21 08:10:00 | SPY | ETF | 384.85 | 384.91 | 384.84 | 384.86 | 12516.0 |
| 2021-01-21 08:15:00 | SPY | ETF | 384.84 | 384.9 | 384.83 | 384.84 | 5558.0 |
| 2021-01-21 08:20:00 | SPY | ETF | 384.86 | 384.93 | 384.86 | 384.93 | 2314.0 |
| 2021-01-21 08:25:00 | SPY | ETF | 384.95 | 384.98 | 384.85 | 384.98 | 5237.0 |
| 2021-01-21 08:30:00 | SPY | ETF | 384.97 | 384.97 | 384.52 | 384.71 | 70835.0 |
> showing 50 of 85,330 rows — these rows as CSV