PREVIEW / etf_5min / 2015-07-15
file: by_date/etf_5min/2015/2015-07-15.parquet size: 1.1 MB rows: 48,212
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-15 04:10:00 | SPY | ETF | 210.79 | 210.8 | 210.78 | 210.8 | 700.0 |
| 2015-07-15 04:15:00 | SPY | ETF | 210.77 | 210.85 | 210.77 | 210.85 | 4506.0 |
| 2015-07-15 04:20:00 | SPY | ETF | 210.83 | 210.85 | 210.82 | 210.82 | 5900.0 |
| 2015-07-15 04:25:00 | SPY | ETF | 210.84 | 210.9 | 210.84 | 210.9 | 710.0 |
| 2015-07-15 04:30:00 | SPY | ETF | 210.85 | 210.85 | 210.85 | 210.85 | 300.0 |
| 2015-07-15 04:40:00 | SPY | ETF | 210.85 | 210.85 | 210.8 | 210.8 | 700.0 |
| 2015-07-15 04:45:00 | SPY | ETF | 210.82 | 210.82 | 210.82 | 210.82 | 300.0 |
| 2015-07-15 04:55:00 | SPY | ETF | 210.9 | 210.95 | 210.9 | 210.92 | 1600.0 |
| 2015-07-15 05:00:00 | SPY | ETF | 210.92 | 210.92 | 210.92 | 210.92 | 5200.0 |
| 2015-07-15 05:05:00 | SPY | ETF | 210.88 | 210.95 | 210.88 | 210.89 | 4000.0 |
| 2015-07-15 05:10:00 | SPY | ETF | 210.88 | 210.9 | 210.88 | 210.9 | 1501.0 |
| 2015-07-15 05:20:00 | SPY | ETF | 210.85 | 210.85 | 210.85 | 210.85 | 100.0 |
| 2015-07-15 05:45:00 | SPY | ETF | 210.89 | 210.89 | 210.89 | 210.89 | 500.0 |
| 2015-07-15 05:50:00 | SPY | ETF | 210.85 | 210.85 | 210.85 | 210.85 | 200.0 |
| 2015-07-15 05:55:00 | SPY | ETF | 210.87 | 210.87 | 210.87 | 210.87 | 2000.0 |
| 2015-07-15 06:05:00 | SPY | ETF | 210.84 | 210.85 | 210.84 | 210.84 | 800.0 |
| 2015-07-15 06:10:00 | SPY | ETF | 210.84 | 210.85 | 210.84 | 210.84 | 930.0 |
| 2015-07-15 06:15:00 | SPY | ETF | 210.87 | 210.87 | 210.87 | 210.87 | 100.0 |
| 2015-07-15 06:25:00 | SPY | ETF | 210.89 | 210.89 | 210.89 | 210.89 | 500.0 |
| 2015-07-15 06:30:00 | SPY | ETF | 210.84 | 210.87 | 210.84 | 210.84 | 1200.0 |
| 2015-07-15 06:35:00 | SPY | ETF | 210.87 | 210.87 | 210.82 | 210.83 | 2600.0 |
| 2015-07-15 06:40:00 | SPY | ETF | 210.84 | 210.84 | 210.84 | 210.84 | 500.0 |
| 2015-07-15 06:45:00 | SPY | ETF | 210.8 | 210.85 | 210.79 | 210.85 | 3500.0 |
| 2015-07-15 06:55:00 | SPY | ETF | 210.8 | 210.8 | 210.8 | 210.8 | 222.0 |
| 2015-07-15 07:00:00 | SPY | ETF | 210.85 | 210.94 | 210.85 | 210.89 | 24550.0 |
| 2015-07-15 07:05:00 | SPY | ETF | 210.86 | 210.93 | 210.86 | 210.89 | 15450.0 |
| 2015-07-15 07:10:00 | SPY | ETF | 210.89 | 210.96 | 210.89 | 210.95 | 5800.0 |
| 2015-07-15 07:15:00 | SPY | ETF | 210.93 | 210.98 | 210.93 | 210.95 | 1040.0 |
| 2015-07-15 07:20:00 | SPY | ETF | 210.94 | 210.94 | 210.91 | 210.91 | 11899.0 |
| 2015-07-15 07:25:00 | SPY | ETF | 210.91 | 210.91 | 210.87 | 210.9 | 1422.0 |
| 2015-07-15 07:30:00 | SPY | ETF | 210.9 | 210.96 | 210.9 | 210.92 | 1200.0 |
| 2015-07-15 07:35:00 | SPY | ETF | 210.91 | 210.98 | 210.91 | 210.98 | 32200.0 |
| 2015-07-15 07:40:00 | SPY | ETF | 210.98 | 210.98 | 210.91 | 210.91 | 12959.0 |
| 2015-07-15 07:45:00 | SPY | ETF | 210.92 | 210.93 | 210.92 | 210.93 | 1168.0 |
| 2015-07-15 07:50:00 | SPY | ETF | 210.92 | 210.95 | 210.92 | 210.93 | 6000.0 |
| 2015-07-15 07:55:00 | SPY | ETF | 210.94 | 210.96 | 210.92 | 210.92 | 5399.0 |
| 2015-07-15 08:00:00 | SPY | ETF | 210.92 | 210.93 | 210.83 | 210.83 | 31954.0 |
| 2015-07-15 08:05:00 | SPY | ETF | 210.9 | 210.9 | 210.85 | 210.85 | 22625.0 |
| 2015-07-15 08:10:00 | SPY | ETF | 210.85 | 210.91 | 210.82 | 210.9 | 33355.0 |
| 2015-07-15 08:15:00 | SPY | ETF | 210.9 | 210.92 | 210.83 | 210.83 | 20850.0 |
| 2015-07-15 08:20:00 | SPY | ETF | 210.85 | 210.89 | 210.85 | 210.88 | 15750.0 |
| 2015-07-15 08:25:00 | SPY | ETF | 210.85 | 210.9 | 210.81 | 210.83 | 17760.0 |
| 2015-07-15 08:30:00 | SPY | ETF | 210.81 | 210.9 | 210.76 | 210.78 | 78932.0 |
| 2015-07-15 08:35:00 | SPY | ETF | 210.81 | 210.88 | 210.74 | 210.87 | 44545.0 |
| 2015-07-15 08:40:00 | SPY | ETF | 210.88 | 210.88 | 210.82 | 210.84 | 53281.0 |
| 2015-07-15 08:45:00 | SPY | ETF | 210.82 | 210.82 | 210.78 | 210.82 | 30823.0 |
| 2015-07-15 08:50:00 | SPY | ETF | 210.82 | 210.88 | 210.8 | 210.87 | 38260.0 |
| 2015-07-15 08:55:00 | SPY | ETF | 210.85 | 210.85 | 210.77 | 210.77 | 31502.0 |
| 2015-07-15 09:00:00 | SPY | ETF | 210.77 | 210.8 | 210.75 | 210.78 | 10242.0 |
| 2015-07-15 09:05:00 | SPY | ETF | 210.77 | 210.83 | 210.77 | 210.81 | 32496.0 |
> showing 50 of 48,212 rows — these rows as CSV