PREVIEW / etf_5min / 2017-12-20
file: by_date/etf_5min/2017/2017-12-20.parquet size: 1.3 MB rows: 57,261
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 |
|---|---|---|---|---|---|---|---|
| 2017-12-20 04:00:00 | SPY | ETF | 267.83 | 267.95 | 267.83 | 267.95 | 2650.0 |
| 2017-12-20 04:10:00 | SPY | ETF | 267.97 | 267.97 | 267.96 | 267.96 | 800.0 |
| 2017-12-20 04:15:00 | SPY | ETF | 267.96 | 268.0 | 267.95 | 268.0 | 1150.0 |
| 2017-12-20 04:20:00 | SPY | ETF | 268.05 | 268.05 | 268.05 | 268.05 | 1000.0 |
| 2017-12-20 04:30:00 | SPY | ETF | 268.05 | 268.06 | 268.05 | 268.06 | 300.0 |
| 2017-12-20 04:45:00 | SPY | ETF | 268.0 | 268.0 | 268.0 | 268.0 | 300.0 |
| 2017-12-20 04:50:00 | SPY | ETF | 268.0 | 268.0 | 267.98 | 267.98 | 10200.0 |
| 2017-12-20 05:00:00 | SPY | ETF | 267.98 | 267.98 | 267.98 | 267.98 | 2300.0 |
| 2017-12-20 05:05:00 | SPY | ETF | 267.95 | 267.98 | 267.95 | 267.98 | 700.0 |
| 2017-12-20 05:10:00 | SPY | ETF | 268.05 | 268.05 | 268.05 | 268.05 | 100.0 |
| 2017-12-20 05:15:00 | SPY | ETF | 268.02 | 268.03 | 268.02 | 268.03 | 733.0 |
| 2017-12-20 05:20:00 | SPY | ETF | 268.01 | 268.01 | 268.0 | 268.0 | 3100.0 |
| 2017-12-20 05:30:00 | SPY | ETF | 268.0 | 268.05 | 268.0 | 268.05 | 5200.0 |
| 2017-12-20 05:40:00 | SPY | ETF | 268.03 | 268.03 | 268.03 | 268.03 | 300.0 |
| 2017-12-20 05:45:00 | SPY | ETF | 268.03 | 268.03 | 268.03 | 268.03 | 600.0 |
| 2017-12-20 05:50:00 | SPY | ETF | 268.05 | 268.05 | 268.05 | 268.05 | 600.0 |
| 2017-12-20 05:55:00 | SPY | ETF | 268.05 | 268.1 | 268.05 | 268.1 | 1050.0 |
| 2017-12-20 06:00:00 | SPY | ETF | 268.05 | 268.05 | 268.05 | 268.05 | 302.0 |
| 2017-12-20 06:05:00 | SPY | ETF | 268.0 | 268.04 | 267.99 | 268.04 | 6450.0 |
| 2017-12-20 06:15:00 | SPY | ETF | 267.98 | 267.98 | 267.98 | 267.98 | 610.0 |
| 2017-12-20 06:20:00 | SPY | ETF | 267.95 | 267.97 | 267.93 | 267.93 | 1300.0 |
| 2017-12-20 06:25:00 | SPY | ETF | 267.9 | 267.98 | 267.86 | 267.88 | 7050.0 |
| 2017-12-20 06:30:00 | SPY | ETF | 267.93 | 267.93 | 267.93 | 267.93 | 300.0 |
| 2017-12-20 06:35:00 | SPY | ETF | 267.93 | 267.93 | 267.93 | 267.93 | 1025.0 |
| 2017-12-20 06:40:00 | SPY | ETF | 267.93 | 267.93 | 267.93 | 267.93 | 114.0 |
| 2017-12-20 06:50:00 | SPY | ETF | 267.98 | 267.98 | 267.98 | 267.98 | 100.0 |
| 2017-12-20 06:55:00 | SPY | ETF | 268.0 | 268.0 | 268.0 | 268.0 | 250.0 |
| 2017-12-20 07:00:00 | SPY | ETF | 268.03 | 268.1 | 268.0 | 268.1 | 14569.0 |
| 2017-12-20 07:05:00 | SPY | ETF | 268.1 | 268.12 | 268.09 | 268.11 | 26986.0 |
| 2017-12-20 07:10:00 | SPY | ETF | 268.11 | 268.12 | 268.1 | 268.11 | 27693.0 |
| 2017-12-20 07:15:00 | SPY | ETF | 268.1 | 268.1 | 268.09 | 268.09 | 25300.0 |
| 2017-12-20 07:20:00 | SPY | ETF | 268.1 | 268.1 | 268.06 | 268.1 | 6910.0 |
| 2017-12-20 07:25:00 | SPY | ETF | 268.09 | 268.09 | 268.04 | 268.05 | 3247.0 |
| 2017-12-20 07:30:00 | SPY | ETF | 268.05 | 268.06 | 268.01 | 268.01 | 25600.0 |
| 2017-12-20 07:35:00 | SPY | ETF | 268.01 | 268.02 | 267.99 | 268.02 | 24190.0 |
| 2017-12-20 07:40:00 | SPY | ETF | 268.04 | 268.05 | 268.02 | 268.02 | 10800.0 |
| 2017-12-20 07:45:00 | SPY | ETF | 268.06 | 268.08 | 268.02 | 268.02 | 14624.0 |
| 2017-12-20 07:50:00 | SPY | ETF | 268.02 | 268.05 | 268.02 | 268.05 | 6863.0 |
| 2017-12-20 07:55:00 | SPY | ETF | 268.04 | 268.06 | 268.02 | 268.06 | 6017.0 |
| 2017-12-20 08:00:00 | SPY | ETF | 267.99 | 268.11 | 267.99 | 268.1 | 12798.0 |
| 2017-12-20 08:05:00 | SPY | ETF | 268.11 | 268.12 | 268.09 | 268.1 | 25907.0 |
| 2017-12-20 08:10:00 | SPY | ETF | 268.1 | 268.13 | 268.1 | 268.1 | 12437.0 |
| 2017-12-20 08:15:00 | SPY | ETF | 268.11 | 268.13 | 268.1 | 268.12 | 20018.0 |
| 2017-12-20 08:20:00 | SPY | ETF | 268.13 | 268.15 | 268.1 | 268.15 | 39296.0 |
| 2017-12-20 08:25:00 | SPY | ETF | 268.15 | 268.16 | 268.13 | 268.13 | 99838.0 |
| 2017-12-20 08:30:00 | SPY | ETF | 268.11 | 268.14 | 268.11 | 268.14 | 1154.0 |
| 2017-12-20 08:35:00 | SPY | ETF | 268.14 | 268.14 | 268.08 | 268.08 | 14212.0 |
| 2017-12-20 08:40:00 | SPY | ETF | 268.11 | 268.11 | 268.08 | 268.1 | 34647.0 |
| 2017-12-20 08:45:00 | SPY | ETF | 268.08 | 268.12 | 268.05 | 268.12 | 63366.0 |
| 2017-12-20 08:50:00 | SPY | ETF | 268.12 | 268.12 | 268.09 | 268.09 | 7258.0 |
> showing 50 of 57,261 rows — these rows as CSV