PREVIEW / etf_5min / 2017-11-29
file: by_date/etf_5min/2017/2017-11-29.parquet size: 1.3 MB rows: 57,001
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-11-29 04:05:00 | SPY | ETF | 262.75 | 262.75 | 262.75 | 262.75 | 100.0 |
| 2017-11-29 04:25:00 | SPY | ETF | 262.79 | 262.79 | 262.79 | 262.79 | 300.0 |
| 2017-11-29 04:30:00 | SPY | ETF | 262.88 | 262.89 | 262.88 | 262.89 | 319.0 |
| 2017-11-29 04:35:00 | SPY | ETF | 262.86 | 262.86 | 262.86 | 262.86 | 100.0 |
| 2017-11-29 04:45:00 | SPY | ETF | 262.9 | 262.9 | 262.9 | 262.9 | 100.0 |
| 2017-11-29 04:50:00 | SPY | ETF | 262.89 | 262.89 | 262.88 | 262.88 | 400.0 |
| 2017-11-29 04:55:00 | SPY | ETF | 262.9 | 262.9 | 262.86 | 262.86 | 3200.0 |
| 2017-11-29 05:00:00 | SPY | ETF | 262.88 | 262.88 | 262.82 | 262.82 | 1151.0 |
| 2017-11-29 05:05:00 | SPY | ETF | 262.79 | 262.82 | 262.79 | 262.82 | 1051.0 |
| 2017-11-29 05:20:00 | SPY | ETF | 262.87 | 262.87 | 262.87 | 262.87 | 600.0 |
| 2017-11-29 05:25:00 | SPY | ETF | 262.84 | 262.84 | 262.84 | 262.84 | 250.0 |
| 2017-11-29 05:30:00 | SPY | ETF | 262.88 | 262.88 | 262.88 | 262.88 | 200.0 |
| 2017-11-29 05:35:00 | SPY | ETF | 262.87 | 262.87 | 262.87 | 262.87 | 500.0 |
| 2017-11-29 05:40:00 | SPY | ETF | 262.92 | 262.92 | 262.92 | 262.92 | 300.0 |
| 2017-11-29 05:45:00 | SPY | ETF | 262.87 | 262.87 | 262.87 | 262.87 | 600.0 |
| 2017-11-29 05:50:00 | SPY | ETF | 262.92 | 262.92 | 262.92 | 262.92 | 500.0 |
| 2017-11-29 05:55:00 | SPY | ETF | 262.93 | 262.98 | 262.92 | 262.98 | 6510.0 |
| 2017-11-29 06:00:00 | SPY | ETF | 262.94 | 263.01 | 262.94 | 263.01 | 200.0 |
| 2017-11-29 06:05:00 | SPY | ETF | 263.04 | 263.04 | 263.04 | 263.04 | 257.0 |
| 2017-11-29 06:10:00 | SPY | ETF | 263.06 | 263.06 | 262.99 | 263.0 | 9028.0 |
| 2017-11-29 06:20:00 | SPY | ETF | 263.0 | 263.1 | 262.99 | 263.1 | 2000.0 |
| 2017-11-29 06:25:00 | SPY | ETF | 263.1 | 263.12 | 263.1 | 263.12 | 314.0 |
| 2017-11-29 06:30:00 | SPY | ETF | 263.13 | 263.15 | 263.13 | 263.15 | 2500.0 |
| 2017-11-29 06:35:00 | SPY | ETF | 263.13 | 263.14 | 263.13 | 263.14 | 2745.0 |
| 2017-11-29 06:40:00 | SPY | ETF | 263.15 | 263.15 | 263.15 | 263.15 | 150.0 |
| 2017-11-29 06:45:00 | SPY | ETF | 263.14 | 263.14 | 263.14 | 263.14 | 500.0 |
| 2017-11-29 06:50:00 | SPY | ETF | 263.13 | 263.13 | 263.13 | 263.13 | 500.0 |
| 2017-11-29 06:55:00 | SPY | ETF | 263.12 | 263.12 | 263.12 | 263.12 | 1200.0 |
| 2017-11-29 07:00:00 | SPY | ETF | 263.12 | 263.15 | 263.12 | 263.13 | 19090.0 |
| 2017-11-29 07:05:00 | SPY | ETF | 263.11 | 263.14 | 263.11 | 263.12 | 19497.0 |
| 2017-11-29 07:10:00 | SPY | ETF | 263.13 | 263.14 | 263.13 | 263.14 | 969.0 |
| 2017-11-29 07:15:00 | SPY | ETF | 263.13 | 263.15 | 263.12 | 263.15 | 31522.0 |
| 2017-11-29 07:20:00 | SPY | ETF | 263.14 | 263.14 | 263.12 | 263.12 | 600.0 |
| 2017-11-29 07:25:00 | SPY | ETF | 263.12 | 263.16 | 263.12 | 263.15 | 18169.0 |
| 2017-11-29 07:30:00 | SPY | ETF | 263.15 | 263.15 | 263.14 | 263.14 | 1100.0 |
| 2017-11-29 07:35:00 | SPY | ETF | 263.13 | 263.13 | 263.07 | 263.07 | 3676.0 |
| 2017-11-29 07:40:00 | SPY | ETF | 263.06 | 263.14 | 263.04 | 263.12 | 16662.0 |
| 2017-11-29 07:45:00 | SPY | ETF | 263.14 | 263.15 | 263.12 | 263.14 | 19060.0 |
| 2017-11-29 07:50:00 | SPY | ETF | 263.12 | 263.12 | 263.05 | 263.05 | 23282.0 |
| 2017-11-29 07:55:00 | SPY | ETF | 263.06 | 263.06 | 263.04 | 263.05 | 5907.0 |
| 2017-11-29 08:00:00 | SPY | ETF | 263.09 | 263.13 | 263.07 | 263.09 | 12568.0 |
| 2017-11-29 08:05:00 | SPY | ETF | 263.09 | 263.12 | 263.07 | 263.1 | 12164.0 |
| 2017-11-29 08:10:00 | SPY | ETF | 263.1 | 263.1 | 263.0 | 263.02 | 38995.0 |
| 2017-11-29 08:15:00 | SPY | ETF | 263.04 | 263.06 | 263.0 | 263.02 | 6902.0 |
| 2017-11-29 08:20:00 | SPY | ETF | 263.01 | 263.05 | 263.01 | 263.05 | 9121.0 |
| 2017-11-29 08:25:00 | SPY | ETF | 263.06 | 263.07 | 263.03 | 263.04 | 13987.0 |
| 2017-11-29 08:30:00 | SPY | ETF | 263.02 | 263.05 | 262.97 | 262.97 | 53842.0 |
| 2017-11-29 08:35:00 | SPY | ETF | 262.98 | 263.01 | 262.97 | 262.99 | 25748.0 |
| 2017-11-29 08:40:00 | SPY | ETF | 263.0 | 263.02 | 262.94 | 262.95 | 42889.0 |
| 2017-11-29 08:45:00 | SPY | ETF | 262.94 | 262.96 | 262.89 | 262.9 | 49089.0 |
> showing 50 of 57,001 rows — these rows as CSV