PREVIEW / etf_5min / 2015-02-09
file: by_date/etf_5min/2015/2015-02-09.parquet size: 1.1 MB rows: 48,325
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-02-09 04:00:00 | SPY | ETF | 204.85 | 204.85 | 204.56 | 204.6 | 42850.0 |
| 2015-02-09 04:05:00 | SPY | ETF | 204.55 | 204.62 | 204.55 | 204.6 | 1300.0 |
| 2015-02-09 04:10:00 | SPY | ETF | 204.59 | 204.6 | 204.55 | 204.6 | 1600.0 |
| 2015-02-09 04:20:00 | SPY | ETF | 204.66 | 204.66 | 204.59 | 204.64 | 4751.0 |
| 2015-02-09 04:25:00 | SPY | ETF | 204.68 | 204.68 | 204.54 | 204.54 | 1070.0 |
| 2015-02-09 04:30:00 | SPY | ETF | 204.63 | 204.74 | 204.63 | 204.71 | 9800.0 |
| 2015-02-09 04:35:00 | SPY | ETF | 204.67 | 204.67 | 204.6 | 204.64 | 1817.0 |
| 2015-02-09 04:40:00 | SPY | ETF | 204.62 | 204.64 | 204.54 | 204.54 | 42000.0 |
| 2015-02-09 04:45:00 | SPY | ETF | 204.51 | 204.61 | 204.51 | 204.61 | 500.0 |
| 2015-02-09 04:50:00 | SPY | ETF | 204.59 | 204.59 | 204.59 | 204.59 | 205.0 |
| 2015-02-09 05:00:00 | SPY | ETF | 204.5 | 204.51 | 204.45 | 204.45 | 2538.0 |
| 2015-02-09 05:05:00 | SPY | ETF | 204.52 | 204.52 | 204.52 | 204.52 | 20000.0 |
| 2015-02-09 05:10:00 | SPY | ETF | 204.57 | 204.57 | 204.54 | 204.54 | 734.0 |
| 2015-02-09 05:15:00 | SPY | ETF | 204.58 | 204.64 | 204.58 | 204.64 | 900.0 |
| 2015-02-09 05:20:00 | SPY | ETF | 204.72 | 204.86 | 204.72 | 204.86 | 10600.0 |
| 2015-02-09 05:25:00 | SPY | ETF | 204.85 | 204.86 | 204.8 | 204.8 | 11217.0 |
| 2015-02-09 05:30:00 | SPY | ETF | 204.81 | 204.9 | 204.8 | 204.9 | 1293.0 |
| 2015-02-09 05:35:00 | SPY | ETF | 204.8 | 204.89 | 204.77 | 204.89 | 1621.0 |
| 2015-02-09 05:40:00 | SPY | ETF | 204.87 | 204.89 | 204.84 | 204.85 | 17340.0 |
| 2015-02-09 05:45:00 | SPY | ETF | 204.99 | 204.99 | 204.99 | 204.99 | 982.0 |
| 2015-02-09 05:50:00 | SPY | ETF | 204.88 | 204.89 | 204.86 | 204.86 | 14280.0 |
| 2015-02-09 05:55:00 | SPY | ETF | 204.81 | 204.81 | 204.81 | 204.81 | 100.0 |
| 2015-02-09 06:05:00 | SPY | ETF | 204.86 | 204.86 | 204.77 | 204.77 | 3238.0 |
| 2015-02-09 06:10:00 | SPY | ETF | 204.83 | 204.83 | 204.8 | 204.8 | 800.0 |
| 2015-02-09 06:15:00 | SPY | ETF | 204.8 | 204.8 | 204.8 | 204.8 | 200.0 |
| 2015-02-09 06:20:00 | SPY | ETF | 204.75 | 204.75 | 204.72 | 204.74 | 32800.0 |
| 2015-02-09 06:25:00 | SPY | ETF | 204.74 | 204.81 | 204.74 | 204.81 | 28726.0 |
| 2015-02-09 06:30:00 | SPY | ETF | 204.78 | 204.78 | 204.57 | 204.57 | 6086.0 |
| 2015-02-09 06:35:00 | SPY | ETF | 204.64 | 204.64 | 204.61 | 204.61 | 420.0 |
| 2015-02-09 06:40:00 | SPY | ETF | 204.55 | 204.55 | 204.5 | 204.51 | 3145.0 |
| 2015-02-09 06:45:00 | SPY | ETF | 204.52 | 204.57 | 204.52 | 204.54 | 13000.0 |
| 2015-02-09 06:50:00 | SPY | ETF | 204.53 | 204.54 | 204.49 | 204.51 | 7449.0 |
| 2015-02-09 06:55:00 | SPY | ETF | 204.52 | 204.54 | 204.46 | 204.49 | 33250.0 |
| 2015-02-09 07:00:00 | SPY | ETF | 204.45 | 204.57 | 204.43 | 204.56 | 29830.0 |
| 2015-02-09 07:05:00 | SPY | ETF | 204.56 | 204.59 | 204.53 | 204.57 | 12665.0 |
| 2015-02-09 07:10:00 | SPY | ETF | 204.64 | 204.64 | 204.55 | 204.55 | 10595.0 |
| 2015-02-09 07:15:00 | SPY | ETF | 204.55 | 204.62 | 204.53 | 204.57 | 24776.0 |
| 2015-02-09 07:20:00 | SPY | ETF | 204.61 | 204.69 | 204.6 | 204.6 | 29229.0 |
| 2015-02-09 07:25:00 | SPY | ETF | 204.64 | 204.64 | 204.55 | 204.62 | 31480.0 |
| 2015-02-09 07:30:00 | SPY | ETF | 204.63 | 204.66 | 204.57 | 204.64 | 11928.0 |
| 2015-02-09 07:35:00 | SPY | ETF | 204.62 | 204.77 | 204.62 | 204.77 | 18389.0 |
| 2015-02-09 07:40:00 | SPY | ETF | 204.78 | 204.92 | 204.78 | 204.87 | 76651.0 |
| 2015-02-09 07:45:00 | SPY | ETF | 204.88 | 204.93 | 204.84 | 204.84 | 22985.0 |
| 2015-02-09 07:50:00 | SPY | ETF | 204.82 | 204.93 | 204.81 | 204.92 | 28896.0 |
| 2015-02-09 07:55:00 | SPY | ETF | 204.9 | 204.92 | 204.85 | 204.86 | 48197.0 |
| 2015-02-09 08:00:00 | SPY | ETF | 204.87 | 204.93 | 204.45 | 204.8 | 149775.0 |
| 2015-02-09 08:05:00 | SPY | ETF | 204.85 | 204.85 | 204.75 | 204.75 | 57128.0 |
| 2015-02-09 08:10:00 | SPY | ETF | 204.76 | 204.82 | 204.76 | 204.81 | 140889.0 |
| 2015-02-09 08:15:00 | SPY | ETF | 204.83 | 204.84 | 204.7 | 204.7 | 49226.0 |
| 2015-02-09 08:20:00 | SPY | ETF | 204.72 | 204.9 | 204.72 | 204.82 | 26560.0 |
> showing 50 of 48,325 rows — these rows as CSV