PREVIEW / etf_5min / 2014-05-15
file: by_date/etf_5min/2014/2014-05-15.parquet size: 1.0 MB rows: 44,144
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-15 04:05:00 | SPY | ETF | 189.16 | 189.16 | 189.16 | 189.16 | 150.0 |
| 2014-05-15 04:10:00 | SPY | ETF | 189.07 | 189.07 | 189.07 | 189.07 | 100.0 |
| 2014-05-15 04:15:00 | SPY | ETF | 189.01 | 189.01 | 188.93 | 188.93 | 350.0 |
| 2014-05-15 04:30:00 | SPY | ETF | 188.9 | 188.9 | 188.9 | 188.9 | 1841.0 |
| 2014-05-15 04:35:00 | SPY | ETF | 188.86 | 188.86 | 188.86 | 188.86 | 200.0 |
| 2014-05-15 04:40:00 | SPY | ETF | 188.85 | 188.85 | 188.85 | 188.85 | 249.0 |
| 2014-05-15 04:45:00 | SPY | ETF | 188.9 | 188.9 | 188.9 | 188.9 | 8700.0 |
| 2014-05-15 04:50:00 | SPY | ETF | 188.94 | 188.94 | 188.94 | 188.94 | 200.0 |
| 2014-05-15 05:00:00 | SPY | ETF | 188.94 | 188.94 | 188.94 | 188.94 | 200.0 |
| 2014-05-15 05:05:00 | SPY | ETF | 189.0 | 189.0 | 189.0 | 189.0 | 1000.0 |
| 2014-05-15 05:10:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 100.0 |
| 2014-05-15 05:35:00 | SPY | ETF | 189.0 | 189.0 | 188.93 | 188.93 | 5992.0 |
| 2014-05-15 05:45:00 | SPY | ETF | 188.92 | 188.92 | 188.91 | 188.91 | 520.0 |
| 2014-05-15 05:50:00 | SPY | ETF | 188.95 | 188.95 | 188.88 | 188.88 | 900.0 |
| 2014-05-15 05:55:00 | SPY | ETF | 188.88 | 188.92 | 188.88 | 188.92 | 2600.0 |
| 2014-05-15 06:00:00 | SPY | ETF | 188.88 | 188.88 | 188.84 | 188.84 | 746.0 |
| 2014-05-15 06:05:00 | SPY | ETF | 188.92 | 188.92 | 188.92 | 188.92 | 598.0 |
| 2014-05-15 06:10:00 | SPY | ETF | 188.96 | 188.96 | 188.96 | 188.96 | 318.0 |
| 2014-05-15 06:15:00 | SPY | ETF | 188.96 | 188.96 | 188.93 | 188.93 | 10000.0 |
| 2014-05-15 06:20:00 | SPY | ETF | 188.93 | 188.93 | 188.92 | 188.92 | 500.0 |
| 2014-05-15 06:25:00 | SPY | ETF | 188.93 | 188.93 | 188.88 | 188.88 | 700.0 |
| 2014-05-15 06:30:00 | SPY | ETF | 188.91 | 188.91 | 188.91 | 188.91 | 100.0 |
| 2014-05-15 06:35:00 | SPY | ETF | 188.9 | 188.96 | 188.9 | 188.96 | 1805.0 |
| 2014-05-15 06:40:00 | SPY | ETF | 188.97 | 189.0 | 188.96 | 189.0 | 1100.0 |
| 2014-05-15 06:45:00 | SPY | ETF | 189.03 | 189.03 | 189.03 | 189.03 | 100.0 |
| 2014-05-15 06:50:00 | SPY | ETF | 189.04 | 189.04 | 189.0 | 189.0 | 2011.0 |
| 2014-05-15 06:55:00 | SPY | ETF | 189.0 | 189.0 | 188.96 | 188.96 | 989.0 |
| 2014-05-15 07:00:00 | SPY | ETF | 188.96 | 188.96 | 188.9 | 188.9 | 19007.0 |
| 2014-05-15 07:05:00 | SPY | ETF | 188.9 | 188.94 | 188.9 | 188.94 | 18361.0 |
| 2014-05-15 07:10:00 | SPY | ETF | 188.93 | 188.93 | 188.91 | 188.93 | 14128.0 |
| 2014-05-15 07:15:00 | SPY | ETF | 188.89 | 188.95 | 188.85 | 188.86 | 70404.0 |
| 2014-05-15 07:20:00 | SPY | ETF | 188.88 | 188.88 | 188.87 | 188.87 | 700.0 |
| 2014-05-15 07:25:00 | SPY | ETF | 188.86 | 188.86 | 188.79 | 188.81 | 111175.0 |
| 2014-05-15 07:30:00 | SPY | ETF | 188.79 | 188.81 | 188.78 | 188.79 | 17100.0 |
| 2014-05-15 07:35:00 | SPY | ETF | 188.79 | 188.79 | 188.68 | 188.69 | 38022.0 |
| 2014-05-15 07:40:00 | SPY | ETF | 188.69 | 188.75 | 188.67 | 188.74 | 36263.0 |
| 2014-05-15 07:45:00 | SPY | ETF | 188.74 | 188.82 | 188.74 | 188.82 | 97311.0 |
| 2014-05-15 07:50:00 | SPY | ETF | 188.81 | 188.81 | 188.8 | 188.8 | 1200.0 |
| 2014-05-15 07:55:00 | SPY | ETF | 188.77 | 188.8 | 188.77 | 188.78 | 27345.0 |
| 2014-05-15 08:00:00 | SPY | ETF | 188.82 | 188.82 | 188.67 | 188.74 | 71343.0 |
| 2014-05-15 08:05:00 | SPY | ETF | 188.76 | 188.79 | 188.72 | 188.78 | 10246.0 |
| 2014-05-15 08:10:00 | SPY | ETF | 188.77 | 188.84 | 188.77 | 188.79 | 48450.0 |
| 2014-05-15 08:15:00 | SPY | ETF | 188.81 | 188.81 | 188.76 | 188.8 | 22891.0 |
| 2014-05-15 08:20:00 | SPY | ETF | 188.84 | 188.85 | 188.8 | 188.81 | 20066.0 |
| 2014-05-15 08:25:00 | SPY | ETF | 188.84 | 188.84 | 188.8 | 188.8 | 15413.0 |
| 2014-05-15 08:30:00 | SPY | ETF | 188.85 | 189.03 | 188.82 | 188.91 | 381092.0 |
| 2014-05-15 08:35:00 | SPY | ETF | 188.92 | 189.03 | 188.92 | 188.95 | 166935.0 |
| 2014-05-15 08:40:00 | SPY | ETF | 188.94 | 188.96 | 188.82 | 188.82 | 133250.0 |
| 2014-05-15 08:45:00 | SPY | ETF | 188.81 | 188.81 | 188.69 | 188.71 | 210135.0 |
| 2014-05-15 08:50:00 | SPY | ETF | 188.72 | 188.8 | 188.7 | 188.77 | 275870.0 |
> showing 50 of 44,144 rows — these rows as CSV