PREVIEW / etf_1min / 2014-01-29
file: by_date/etf_1min/2014/2014-01-29.parquet size: 2.5 MB rows: 126,846
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-01-29 04:00:00 | SPY | ETF | 180.05 | 180.05 | 180.05 | 180.05 | 10028.0 |
| 2014-01-29 04:01:00 | SPY | ETF | 180.05 | 180.05 | 180.05 | 180.05 | 212.0 |
| 2014-01-29 04:02:00 | SPY | ETF | 180.04 | 180.04 | 179.97 | 179.98 | 25000.0 |
| 2014-01-29 04:03:00 | SPY | ETF | 179.97 | 179.97 | 179.97 | 179.97 | 3000.0 |
| 2014-01-29 04:04:00 | SPY | ETF | 179.97 | 179.97 | 179.97 | 179.97 | 5000.0 |
| 2014-01-29 04:05:00 | SPY | ETF | 179.92 | 179.92 | 179.89 | 179.89 | 2000.0 |
| 2014-01-29 04:07:00 | SPY | ETF | 179.82 | 179.82 | 179.77 | 179.77 | 26500.0 |
| 2014-01-29 04:10:00 | SPY | ETF | 179.77 | 179.77 | 179.72 | 179.72 | 5720.0 |
| 2014-01-29 04:11:00 | SPY | ETF | 179.72 | 179.72 | 179.65 | 179.65 | 6360.0 |
| 2014-01-29 04:12:00 | SPY | ETF | 179.62 | 179.62 | 179.6 | 179.62 | 8850.0 |
| 2014-01-29 04:13:00 | SPY | ETF | 179.6 | 179.6 | 179.44 | 179.46 | 33445.0 |
| 2014-01-29 04:14:00 | SPY | ETF | 179.45 | 179.45 | 179.45 | 179.45 | 1900.0 |
| 2014-01-29 04:15:00 | SPY | ETF | 179.45 | 179.45 | 179.43 | 179.43 | 1800.0 |
| 2014-01-29 04:17:00 | SPY | ETF | 179.5 | 179.5 | 179.48 | 179.5 | 3504.0 |
| 2014-01-29 04:18:00 | SPY | ETF | 179.53 | 179.53 | 179.53 | 179.53 | 200.0 |
| 2014-01-29 04:19:00 | SPY | ETF | 179.58 | 179.58 | 179.56 | 179.56 | 10700.0 |
| 2014-01-29 04:21:00 | SPY | ETF | 179.55 | 179.55 | 179.54 | 179.54 | 330.0 |
| 2014-01-29 04:23:00 | SPY | ETF | 179.58 | 179.58 | 179.58 | 179.58 | 100.0 |
| 2014-01-29 04:25:00 | SPY | ETF | 179.6 | 179.6 | 179.6 | 179.6 | 500.0 |
| 2014-01-29 04:30:00 | SPY | ETF | 179.67 | 179.67 | 179.67 | 179.67 | 117.0 |
| 2014-01-29 04:32:00 | SPY | ETF | 179.64 | 179.64 | 179.64 | 179.64 | 100.0 |
| 2014-01-29 04:34:00 | SPY | ETF | 179.62 | 179.62 | 179.62 | 179.62 | 200.0 |
| 2014-01-29 04:35:00 | SPY | ETF | 179.55 | 179.55 | 179.55 | 179.55 | 1100.0 |
| 2014-01-29 04:38:00 | SPY | ETF | 179.61 | 179.61 | 179.61 | 179.61 | 300.0 |
| 2014-01-29 04:40:00 | SPY | ETF | 179.68 | 179.68 | 179.68 | 179.68 | 4061.0 |
| 2014-01-29 04:41:00 | SPY | ETF | 179.78 | 179.78 | 179.78 | 179.78 | 134.0 |
| 2014-01-29 04:42:00 | SPY | ETF | 179.76 | 179.76 | 179.76 | 179.76 | 100.0 |
| 2014-01-29 04:43:00 | SPY | ETF | 179.76 | 179.76 | 179.76 | 179.76 | 300.0 |
| 2014-01-29 04:48:00 | SPY | ETF | 179.66 | 179.66 | 179.66 | 179.66 | 230.0 |
| 2014-01-29 04:52:00 | SPY | ETF | 179.73 | 179.73 | 179.73 | 179.73 | 2000.0 |
| 2014-01-29 04:53:00 | SPY | ETF | 179.7 | 179.7 | 179.7 | 179.7 | 200.0 |
| 2014-01-29 04:56:00 | SPY | ETF | 179.74 | 179.74 | 179.74 | 179.74 | 199.0 |
| 2014-01-29 04:57:00 | SPY | ETF | 179.7 | 179.7 | 179.7 | 179.7 | 200.0 |
| 2014-01-29 04:59:00 | SPY | ETF | 179.72 | 179.72 | 179.72 | 179.72 | 200.0 |
| 2014-01-29 05:02:00 | SPY | ETF | 179.7 | 179.7 | 179.7 | 179.7 | 341.0 |
| 2014-01-29 05:09:00 | SPY | ETF | 179.69 | 179.69 | 179.67 | 179.67 | 200.0 |
| 2014-01-29 05:11:00 | SPY | ETF | 179.62 | 179.62 | 179.62 | 179.62 | 100.0 |
| 2014-01-29 05:12:00 | SPY | ETF | 179.62 | 179.62 | 179.62 | 179.62 | 201.0 |
| 2014-01-29 05:15:00 | SPY | ETF | 179.64 | 179.64 | 179.6 | 179.6 | 9025.0 |
| 2014-01-29 05:17:00 | SPY | ETF | 179.58 | 179.58 | 179.55 | 179.55 | 4100.0 |
| 2014-01-29 05:20:00 | SPY | ETF | 179.57 | 179.57 | 179.57 | 179.57 | 100.0 |
| 2014-01-29 05:21:00 | SPY | ETF | 179.55 | 179.55 | 179.55 | 179.55 | 500.0 |
| 2014-01-29 05:22:00 | SPY | ETF | 179.57 | 179.57 | 179.57 | 179.57 | 298.0 |
| 2014-01-29 05:25:00 | SPY | ETF | 179.6 | 179.6 | 179.6 | 179.6 | 2000.0 |
| 2014-01-29 05:26:00 | SPY | ETF | 179.65 | 179.65 | 179.63 | 179.63 | 1200.0 |
| 2014-01-29 05:32:00 | SPY | ETF | 179.64 | 179.65 | 179.64 | 179.65 | 15000.0 |
| 2014-01-29 05:34:00 | SPY | ETF | 179.62 | 179.62 | 179.59 | 179.59 | 5200.0 |
| 2014-01-29 05:36:00 | SPY | ETF | 179.57 | 179.57 | 179.57 | 179.57 | 186.0 |
| 2014-01-29 05:37:00 | SPY | ETF | 179.53 | 179.53 | 179.5 | 179.5 | 1000.0 |
| 2014-01-29 05:38:00 | SPY | ETF | 179.46 | 179.48 | 179.45 | 179.48 | 408.0 |
> showing 50 of 126,846 rows — these rows as CSV