PREVIEW / etf_1min / 2020-02-20
file: by_date/etf_1min/2020/2020-02-20.parquet size: 3.6 MB rows: 184,210
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 |
|---|---|---|---|---|---|---|---|
| 2020-02-20 04:00:00 | SPY | ETF | 337.59 | 338.09 | 337.59 | 338.03 | 3013.0 |
| 2020-02-20 04:01:00 | SPY | ETF | 338.09 | 338.09 | 338.09 | 338.09 | 320.0 |
| 2020-02-20 04:03:00 | SPY | ETF | 338.11 | 338.11 | 338.11 | 338.11 | 380.0 |
| 2020-02-20 04:04:00 | SPY | ETF | 338.1 | 338.1 | 338.1 | 338.1 | 260.0 |
| 2020-02-20 04:06:00 | SPY | ETF | 338.11 | 338.11 | 338.11 | 338.11 | 420.0 |
| 2020-02-20 04:07:00 | SPY | ETF | 338.12 | 338.16 | 338.11 | 338.16 | 600.0 |
| 2020-02-20 04:10:00 | SPY | ETF | 338.13 | 338.15 | 338.13 | 338.15 | 231.0 |
| 2020-02-20 04:12:00 | SPY | ETF | 338.27 | 338.27 | 338.27 | 338.27 | 205.0 |
| 2020-02-20 04:13:00 | SPY | ETF | 338.27 | 338.27 | 338.27 | 338.27 | 168.0 |
| 2020-02-20 04:18:00 | SPY | ETF | 338.16 | 338.17 | 338.16 | 338.17 | 740.0 |
| 2020-02-20 04:22:00 | SPY | ETF | 338.06 | 338.06 | 338.06 | 338.06 | 164.0 |
| 2020-02-20 04:23:00 | SPY | ETF | 338.02 | 338.02 | 337.97 | 337.97 | 1236.0 |
| 2020-02-20 04:24:00 | SPY | ETF | 337.92 | 337.92 | 337.92 | 337.92 | 327.0 |
| 2020-02-20 04:25:00 | SPY | ETF | 337.95 | 337.95 | 337.95 | 337.95 | 307.0 |
| 2020-02-20 04:26:00 | SPY | ETF | 337.96 | 337.96 | 337.96 | 337.96 | 100.0 |
| 2020-02-20 04:30:00 | SPY | ETF | 338.0 | 338.0 | 338.0 | 338.0 | 683.0 |
| 2020-02-20 04:31:00 | SPY | ETF | 338.05 | 338.05 | 338.05 | 338.05 | 1504.0 |
| 2020-02-20 04:40:00 | SPY | ETF | 338.18 | 338.18 | 338.18 | 338.18 | 505.0 |
| 2020-02-20 04:43:00 | SPY | ETF | 338.3 | 338.3 | 338.3 | 338.3 | 600.0 |
| 2020-02-20 04:44:00 | SPY | ETF | 338.23 | 338.23 | 338.23 | 338.23 | 300.0 |
| 2020-02-20 04:45:00 | SPY | ETF | 338.18 | 338.18 | 338.18 | 338.18 | 420.0 |
| 2020-02-20 04:56:00 | SPY | ETF | 338.22 | 338.22 | 338.22 | 338.22 | 205.0 |
| 2020-02-20 04:58:00 | SPY | ETF | 338.3 | 338.3 | 338.3 | 338.3 | 525.0 |
| 2020-02-20 04:59:00 | SPY | ETF | 338.23 | 338.25 | 338.23 | 338.25 | 420.0 |
| 2020-02-20 05:07:00 | SPY | ETF | 338.28 | 338.28 | 338.24 | 338.24 | 220.0 |
| 2020-02-20 05:10:00 | SPY | ETF | 338.21 | 338.21 | 338.21 | 338.21 | 127.0 |
| 2020-02-20 05:11:00 | SPY | ETF | 338.21 | 338.21 | 338.21 | 338.21 | 100.0 |
| 2020-02-20 05:15:00 | SPY | ETF | 338.2 | 338.2 | 338.2 | 338.2 | 100.0 |
| 2020-02-20 05:17:00 | SPY | ETF | 338.23 | 338.23 | 338.23 | 338.23 | 100.0 |
| 2020-02-20 05:18:00 | SPY | ETF | 338.18 | 338.18 | 338.18 | 338.18 | 400.0 |
| 2020-02-20 05:20:00 | SPY | ETF | 338.01 | 338.01 | 337.99 | 337.99 | 373.0 |
| 2020-02-20 05:21:00 | SPY | ETF | 337.99 | 338.01 | 337.99 | 337.99 | 410.0 |
| 2020-02-20 05:22:00 | SPY | ETF | 338.01 | 338.01 | 338.01 | 338.01 | 100.0 |
| 2020-02-20 05:31:00 | SPY | ETF | 338.08 | 338.08 | 338.08 | 338.08 | 431.0 |
| 2020-02-20 05:35:00 | SPY | ETF | 338.04 | 338.04 | 338.04 | 338.04 | 100.0 |
| 2020-02-20 05:44:00 | SPY | ETF | 337.98 | 337.98 | 337.98 | 337.98 | 708.0 |
| 2020-02-20 05:47:00 | SPY | ETF | 337.91 | 337.92 | 337.9 | 337.9 | 1740.0 |
| 2020-02-20 05:48:00 | SPY | ETF | 337.88 | 337.9 | 337.88 | 337.9 | 760.0 |
| 2020-02-20 05:49:00 | SPY | ETF | 337.85 | 337.86 | 337.85 | 337.86 | 1600.0 |
| 2020-02-20 05:50:00 | SPY | ETF | 337.9 | 337.9 | 337.9 | 337.9 | 300.0 |
| 2020-02-20 05:51:00 | SPY | ETF | 337.85 | 337.85 | 337.83 | 337.85 | 4979.0 |
| 2020-02-20 05:52:00 | SPY | ETF | 337.95 | 337.95 | 337.95 | 337.95 | 140.0 |
| 2020-02-20 05:54:00 | SPY | ETF | 337.91 | 337.91 | 337.91 | 337.91 | 220.0 |
| 2020-02-20 05:56:00 | SPY | ETF | 337.95 | 337.96 | 337.95 | 337.96 | 562.0 |
| 2020-02-20 05:57:00 | SPY | ETF | 337.98 | 337.98 | 337.98 | 337.98 | 100.0 |
| 2020-02-20 06:00:00 | SPY | ETF | 337.95 | 337.96 | 337.95 | 337.95 | 1319.0 |
| 2020-02-20 06:01:00 | SPY | ETF | 337.9 | 337.9 | 337.88 | 337.88 | 420.0 |
| 2020-02-20 06:02:00 | SPY | ETF | 337.87 | 337.87 | 337.86 | 337.86 | 1820.0 |
| 2020-02-20 06:03:00 | SPY | ETF | 337.86 | 337.86 | 337.86 | 337.86 | 1010.0 |
| 2020-02-20 06:06:00 | SPY | ETF | 337.89 | 337.93 | 337.89 | 337.93 | 450.0 |
> showing 50 of 184,210 rows — these rows as CSV