PREVIEW / etf_1min / 2015-12-04
file: by_date/etf_1min/2015/2015-12-04.parquet size: 2.7 MB rows: 139,521
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-12-04 04:00:00 | SPY | ETF | 206.81 | 206.89 | 206.61 | 206.8 | 4384.0 |
| 2015-12-04 04:01:00 | SPY | ETF | 206.83 | 206.83 | 206.83 | 206.83 | 125.0 |
| 2015-12-04 04:02:00 | SPY | ETF | 206.81 | 206.81 | 206.81 | 206.81 | 500.0 |
| 2015-12-04 04:03:00 | SPY | ETF | 206.85 | 206.86 | 206.77 | 206.77 | 1825.0 |
| 2015-12-04 04:04:00 | SPY | ETF | 206.79 | 206.79 | 206.79 | 206.79 | 330.0 |
| 2015-12-04 04:06:00 | SPY | ETF | 206.75 | 206.75 | 206.75 | 206.75 | 220.0 |
| 2015-12-04 04:07:00 | SPY | ETF | 206.76 | 206.82 | 206.76 | 206.82 | 415.0 |
| 2015-12-04 04:08:00 | SPY | ETF | 206.8 | 206.8 | 206.8 | 206.8 | 110.0 |
| 2015-12-04 04:09:00 | SPY | ETF | 206.9 | 206.9 | 206.9 | 206.9 | 390.0 |
| 2015-12-04 04:15:00 | SPY | ETF | 206.8 | 206.8 | 206.8 | 206.8 | 200.0 |
| 2015-12-04 04:18:00 | SPY | ETF | 206.78 | 206.78 | 206.71 | 206.74 | 5125.0 |
| 2015-12-04 04:19:00 | SPY | ETF | 206.79 | 206.81 | 206.79 | 206.81 | 2925.0 |
| 2015-12-04 04:20:00 | SPY | ETF | 206.77 | 206.8 | 206.77 | 206.8 | 1049.0 |
| 2015-12-04 04:21:00 | SPY | ETF | 206.84 | 206.84 | 206.84 | 206.84 | 775.0 |
| 2015-12-04 04:22:00 | SPY | ETF | 206.79 | 206.79 | 206.79 | 206.79 | 130.0 |
| 2015-12-04 04:23:00 | SPY | ETF | 206.84 | 206.84 | 206.84 | 206.84 | 2950.0 |
| 2015-12-04 04:25:00 | SPY | ETF | 206.87 | 206.87 | 206.87 | 206.87 | 800.0 |
| 2015-12-04 04:26:00 | SPY | ETF | 206.84 | 206.84 | 206.84 | 206.84 | 225.0 |
| 2015-12-04 04:27:00 | SPY | ETF | 206.85 | 206.9 | 206.85 | 206.9 | 1525.0 |
| 2015-12-04 04:28:00 | SPY | ETF | 206.87 | 206.87 | 206.87 | 206.87 | 100.0 |
| 2015-12-04 04:29:00 | SPY | ETF | 206.9 | 206.9 | 206.89 | 206.89 | 5100.0 |
| 2015-12-04 04:30:00 | SPY | ETF | 206.84 | 206.84 | 206.82 | 206.82 | 5830.0 |
| 2015-12-04 04:31:00 | SPY | ETF | 206.84 | 206.84 | 206.84 | 206.84 | 564.0 |
| 2015-12-04 04:33:00 | SPY | ETF | 206.87 | 206.87 | 206.87 | 206.87 | 600.0 |
| 2015-12-04 04:34:00 | SPY | ETF | 206.86 | 206.86 | 206.86 | 206.86 | 152.0 |
| 2015-12-04 04:35:00 | SPY | ETF | 206.87 | 206.87 | 206.87 | 206.87 | 400.0 |
| 2015-12-04 04:38:00 | SPY | ETF | 206.77 | 206.77 | 206.77 | 206.77 | 5400.0 |
| 2015-12-04 04:39:00 | SPY | ETF | 206.75 | 206.75 | 206.75 | 206.75 | 100.0 |
| 2015-12-04 04:43:00 | SPY | ETF | 206.67 | 206.67 | 206.62 | 206.62 | 7835.0 |
| 2015-12-04 04:44:00 | SPY | ETF | 206.57 | 206.57 | 206.52 | 206.52 | 631.0 |
| 2015-12-04 04:45:00 | SPY | ETF | 206.56 | 206.68 | 206.56 | 206.66 | 708.0 |
| 2015-12-04 04:46:00 | SPY | ETF | 206.65 | 206.65 | 206.65 | 206.65 | 100.0 |
| 2015-12-04 04:52:00 | SPY | ETF | 206.61 | 206.61 | 206.61 | 206.61 | 300.0 |
| 2015-12-04 04:55:00 | SPY | ETF | 206.65 | 206.65 | 206.65 | 206.65 | 151.0 |
| 2015-12-04 04:59:00 | SPY | ETF | 206.64 | 206.64 | 206.64 | 206.64 | 100.0 |
| 2015-12-04 05:00:00 | SPY | ETF | 206.61 | 206.61 | 206.61 | 206.61 | 100.0 |
| 2015-12-04 05:01:00 | SPY | ETF | 206.62 | 206.62 | 206.62 | 206.62 | 1800.0 |
| 2015-12-04 05:02:00 | SPY | ETF | 206.62 | 206.62 | 206.62 | 206.62 | 300.0 |
| 2015-12-04 05:06:00 | SPY | ETF | 206.6 | 206.62 | 206.6 | 206.62 | 500.0 |
| 2015-12-04 05:08:00 | SPY | ETF | 206.57 | 206.57 | 206.57 | 206.57 | 4625.0 |
| 2015-12-04 05:09:00 | SPY | ETF | 206.52 | 206.52 | 206.46 | 206.46 | 763.0 |
| 2015-12-04 05:13:00 | SPY | ETF | 206.55 | 206.55 | 206.47 | 206.47 | 9225.0 |
| 2015-12-04 05:14:00 | SPY | ETF | 206.43 | 206.43 | 206.43 | 206.43 | 100.0 |
| 2015-12-04 05:19:00 | SPY | ETF | 206.45 | 206.45 | 206.45 | 206.45 | 300.0 |
| 2015-12-04 05:21:00 | SPY | ETF | 206.45 | 206.45 | 206.45 | 206.45 | 200.0 |
| 2015-12-04 05:23:00 | SPY | ETF | 206.47 | 206.47 | 206.47 | 206.47 | 300.0 |
| 2015-12-04 05:24:00 | SPY | ETF | 206.5 | 206.52 | 206.5 | 206.52 | 700.0 |
| 2015-12-04 05:26:00 | SPY | ETF | 206.51 | 206.51 | 206.51 | 206.51 | 280.0 |
| 2015-12-04 05:27:00 | SPY | ETF | 206.52 | 206.52 | 206.52 | 206.52 | 800.0 |
| 2015-12-04 05:28:00 | SPY | ETF | 206.51 | 206.51 | 206.51 | 206.51 | 100.0 |
> showing 50 of 139,521 rows — these rows as CSV