PREVIEW / etf_5min / 2016-03-02
file: by_date/etf_5min/2016/2016-03-02.parquet size: 1.2 MB rows: 49,697
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-02 04:00:00 | SPY | ETF | 198.6 | 198.6 | 198.36 | 198.36 | 10100.0 |
| 2016-03-02 04:20:00 | SPY | ETF | 198.25 | 198.25 | 198.25 | 198.25 | 600.0 |
| 2016-03-02 04:25:00 | SPY | ETF | 198.2 | 198.2 | 198.08 | 198.15 | 8549.0 |
| 2016-03-02 04:30:00 | SPY | ETF | 198.2 | 198.2 | 198.13 | 198.13 | 1525.0 |
| 2016-03-02 04:35:00 | SPY | ETF | 198.24 | 198.24 | 198.15 | 198.17 | 1008.0 |
| 2016-03-02 04:40:00 | SPY | ETF | 198.15 | 198.18 | 198.05 | 198.05 | 2075.0 |
| 2016-03-02 04:45:00 | SPY | ETF | 198.04 | 198.04 | 197.98 | 197.98 | 970.0 |
| 2016-03-02 04:50:00 | SPY | ETF | 198.12 | 198.12 | 197.95 | 197.95 | 8000.0 |
| 2016-03-02 04:55:00 | SPY | ETF | 197.96 | 197.96 | 197.89 | 197.92 | 3970.0 |
| 2016-03-02 05:00:00 | SPY | ETF | 197.89 | 197.99 | 197.89 | 197.99 | 974.0 |
| 2016-03-02 05:05:00 | SPY | ETF | 197.92 | 197.94 | 197.92 | 197.94 | 5600.0 |
| 2016-03-02 05:10:00 | SPY | ETF | 197.92 | 197.92 | 197.91 | 197.91 | 400.0 |
| 2016-03-02 05:15:00 | SPY | ETF | 197.9 | 197.99 | 197.89 | 197.99 | 660.0 |
| 2016-03-02 05:20:00 | SPY | ETF | 198.01 | 198.04 | 198.01 | 198.01 | 825.0 |
| 2016-03-02 05:25:00 | SPY | ETF | 197.96 | 197.97 | 197.93 | 197.93 | 1410.0 |
| 2016-03-02 05:30:00 | SPY | ETF | 197.99 | 197.99 | 197.99 | 197.99 | 400.0 |
| 2016-03-02 05:35:00 | SPY | ETF | 197.95 | 197.95 | 197.95 | 197.95 | 100.0 |
| 2016-03-02 05:40:00 | SPY | ETF | 197.92 | 197.92 | 197.92 | 197.92 | 100.0 |
| 2016-03-02 05:45:00 | SPY | ETF | 197.9 | 197.9 | 197.9 | 197.9 | 100.0 |
| 2016-03-02 05:55:00 | SPY | ETF | 197.85 | 197.87 | 197.8 | 197.83 | 4925.0 |
| 2016-03-02 06:00:00 | SPY | ETF | 197.83 | 197.89 | 197.83 | 197.88 | 1155.0 |
| 2016-03-02 06:05:00 | SPY | ETF | 197.89 | 197.89 | 197.85 | 197.85 | 2625.0 |
| 2016-03-02 06:10:00 | SPY | ETF | 197.87 | 197.94 | 197.87 | 197.94 | 3000.0 |
| 2016-03-02 06:15:00 | SPY | ETF | 197.91 | 197.94 | 197.87 | 197.89 | 9400.0 |
| 2016-03-02 06:20:00 | SPY | ETF | 197.87 | 197.91 | 197.84 | 197.91 | 4920.0 |
| 2016-03-02 06:25:00 | SPY | ETF | 197.84 | 197.89 | 197.84 | 197.89 | 315.0 |
| 2016-03-02 06:30:00 | SPY | ETF | 197.89 | 197.94 | 197.89 | 197.92 | 8975.0 |
| 2016-03-02 06:35:00 | SPY | ETF | 197.96 | 197.99 | 197.96 | 197.99 | 2400.0 |
| 2016-03-02 06:40:00 | SPY | ETF | 198.0 | 198.03 | 197.99 | 198.03 | 12350.0 |
| 2016-03-02 06:45:00 | SPY | ETF | 197.98 | 197.98 | 197.98 | 197.98 | 100.0 |
| 2016-03-02 06:50:00 | SPY | ETF | 197.98 | 197.98 | 197.98 | 197.98 | 500.0 |
| 2016-03-02 06:55:00 | SPY | ETF | 197.91 | 197.98 | 197.91 | 197.96 | 7000.0 |
| 2016-03-02 07:00:00 | SPY | ETF | 198.02 | 198.02 | 197.88 | 197.89 | 5585.0 |
| 2016-03-02 07:05:00 | SPY | ETF | 197.9 | 197.92 | 197.78 | 197.92 | 39658.0 |
| 2016-03-02 07:10:00 | SPY | ETF | 197.88 | 197.99 | 197.87 | 197.93 | 23745.0 |
| 2016-03-02 07:15:00 | SPY | ETF | 197.93 | 197.93 | 197.91 | 197.92 | 3400.0 |
| 2016-03-02 07:20:00 | SPY | ETF | 197.92 | 197.92 | 197.85 | 197.91 | 20450.0 |
| 2016-03-02 07:25:00 | SPY | ETF | 197.93 | 197.97 | 197.91 | 197.97 | 8885.0 |
| 2016-03-02 07:30:00 | SPY | ETF | 198.0 | 198.05 | 198.0 | 198.0 | 15970.0 |
| 2016-03-02 07:35:00 | SPY | ETF | 198.01 | 198.18 | 198.01 | 198.14 | 23525.0 |
| 2016-03-02 07:40:00 | SPY | ETF | 198.1 | 198.25 | 198.1 | 198.18 | 13800.0 |
| 2016-03-02 07:45:00 | SPY | ETF | 198.19 | 198.19 | 198.11 | 198.11 | 19527.0 |
| 2016-03-02 07:50:00 | SPY | ETF | 198.14 | 198.14 | 198.08 | 198.11 | 12059.0 |
| 2016-03-02 07:55:00 | SPY | ETF | 198.11 | 198.18 | 198.07 | 198.07 | 5704.0 |
| 2016-03-02 08:00:00 | SPY | ETF | 197.9 | 198.13 | 197.88 | 198.0 | 148672.0 |
| 2016-03-02 08:05:00 | SPY | ETF | 198.21 | 198.21 | 197.97 | 197.97 | 131071.0 |
| 2016-03-02 08:10:00 | SPY | ETF | 197.96 | 198.04 | 197.91 | 198.02 | 45278.0 |
| 2016-03-02 08:15:00 | SPY | ETF | 198.05 | 198.2 | 197.98 | 198.11 | 74527.0 |
| 2016-03-02 08:20:00 | SPY | ETF | 198.14 | 198.16 | 197.95 | 198.0 | 62322.0 |
| 2016-03-02 08:25:00 | SPY | ETF | 198.0 | 198.02 | 197.85 | 197.85 | 122643.0 |
> showing 50 of 49,697 rows — these rows as CSV