PREVIEW / etf_1min / 2016-01-25
file: by_date/etf_1min/2016/2016-01-25.parquet size: 2.7 MB rows: 143,311
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-25 04:00:00 | SPY | ETF | 189.7 | 189.71 | 189.7 | 189.71 | 1525.0 |
| 2016-01-25 04:01:00 | SPY | ETF | 189.64 | 189.64 | 189.64 | 189.64 | 460.0 |
| 2016-01-25 04:02:00 | SPY | ETF | 189.5 | 189.5 | 189.46 | 189.46 | 1699.0 |
| 2016-01-25 04:03:00 | SPY | ETF | 189.49 | 189.49 | 189.37 | 189.4 | 2525.0 |
| 2016-01-25 04:04:00 | SPY | ETF | 189.45 | 189.45 | 189.42 | 189.42 | 300.0 |
| 2016-01-25 04:05:00 | SPY | ETF | 189.56 | 189.56 | 189.56 | 189.56 | 820.0 |
| 2016-01-25 04:06:00 | SPY | ETF | 189.55 | 189.55 | 189.55 | 189.55 | 800.0 |
| 2016-01-25 04:07:00 | SPY | ETF | 189.61 | 189.61 | 189.61 | 189.61 | 100.0 |
| 2016-01-25 04:13:00 | SPY | ETF | 189.81 | 189.81 | 189.81 | 189.81 | 360.0 |
| 2016-01-25 04:14:00 | SPY | ETF | 189.79 | 189.79 | 189.79 | 189.79 | 100.0 |
| 2016-01-25 04:15:00 | SPY | ETF | 189.87 | 189.9 | 189.87 | 189.89 | 796.0 |
| 2016-01-25 04:18:00 | SPY | ETF | 189.71 | 189.71 | 189.71 | 189.71 | 100.0 |
| 2016-01-25 04:21:00 | SPY | ETF | 189.66 | 189.66 | 189.66 | 189.66 | 105.0 |
| 2016-01-25 04:24:00 | SPY | ETF | 189.7 | 189.7 | 189.7 | 189.7 | 100.0 |
| 2016-01-25 04:26:00 | SPY | ETF | 189.74 | 189.74 | 189.74 | 189.74 | 2700.0 |
| 2016-01-25 04:27:00 | SPY | ETF | 189.71 | 189.71 | 189.7 | 189.7 | 300.0 |
| 2016-01-25 04:28:00 | SPY | ETF | 189.85 | 189.85 | 189.85 | 189.85 | 100.0 |
| 2016-01-25 04:29:00 | SPY | ETF | 189.89 | 189.92 | 189.89 | 189.92 | 600.0 |
| 2016-01-25 04:31:00 | SPY | ETF | 189.77 | 189.77 | 189.77 | 189.77 | 100.0 |
| 2016-01-25 04:32:00 | SPY | ETF | 189.73 | 189.73 | 189.73 | 189.73 | 140.0 |
| 2016-01-25 04:33:00 | SPY | ETF | 189.84 | 189.84 | 189.84 | 189.84 | 100.0 |
| 2016-01-25 04:35:00 | SPY | ETF | 189.87 | 189.87 | 189.87 | 189.87 | 100.0 |
| 2016-01-25 04:36:00 | SPY | ETF | 189.95 | 189.95 | 189.95 | 189.95 | 200.0 |
| 2016-01-25 04:37:00 | SPY | ETF | 189.97 | 190.0 | 189.97 | 190.0 | 320.0 |
| 2016-01-25 04:38:00 | SPY | ETF | 190.04 | 190.04 | 190.04 | 190.04 | 165.0 |
| 2016-01-25 04:40:00 | SPY | ETF | 190.02 | 190.02 | 190.02 | 190.02 | 100.0 |
| 2016-01-25 04:41:00 | SPY | ETF | 190.05 | 190.05 | 190.05 | 190.05 | 300.0 |
| 2016-01-25 04:44:00 | SPY | ETF | 190.18 | 190.18 | 190.17 | 190.17 | 400.0 |
| 2016-01-25 04:47:00 | SPY | ETF | 190.07 | 190.07 | 190.07 | 190.07 | 190.0 |
| 2016-01-25 04:52:00 | SPY | ETF | 189.87 | 189.87 | 189.87 | 189.87 | 305.0 |
| 2016-01-25 05:02:00 | SPY | ETF | 189.99 | 190.02 | 189.99 | 190.02 | 200.0 |
| 2016-01-25 05:05:00 | SPY | ETF | 189.99 | 189.99 | 189.99 | 189.99 | 101.0 |
| 2016-01-25 05:08:00 | SPY | ETF | 189.89 | 189.89 | 189.89 | 189.89 | 100.0 |
| 2016-01-25 05:09:00 | SPY | ETF | 189.82 | 189.83 | 189.82 | 189.83 | 400.0 |
| 2016-01-25 05:14:00 | SPY | ETF | 190.0 | 190.0 | 189.99 | 189.99 | 200.0 |
| 2016-01-25 05:15:00 | SPY | ETF | 189.97 | 189.97 | 189.97 | 189.97 | 200.0 |
| 2016-01-25 05:18:00 | SPY | ETF | 190.06 | 190.06 | 190.06 | 190.06 | 100.0 |
| 2016-01-25 05:22:00 | SPY | ETF | 190.28 | 190.32 | 190.28 | 190.32 | 330.0 |
| 2016-01-25 05:24:00 | SPY | ETF | 190.21 | 190.21 | 190.21 | 190.21 | 500.0 |
| 2016-01-25 05:27:00 | SPY | ETF | 190.34 | 190.34 | 190.34 | 190.34 | 305.0 |
| 2016-01-25 05:28:00 | SPY | ETF | 190.44 | 190.5 | 190.44 | 190.44 | 5946.0 |
| 2016-01-25 05:30:00 | SPY | ETF | 190.38 | 190.38 | 190.38 | 190.38 | 300.0 |
| 2016-01-25 05:33:00 | SPY | ETF | 190.33 | 190.33 | 190.33 | 190.33 | 500.0 |
| 2016-01-25 05:38:00 | SPY | ETF | 190.32 | 190.32 | 190.32 | 190.32 | 100.0 |
| 2016-01-25 05:48:00 | SPY | ETF | 190.12 | 190.12 | 190.12 | 190.12 | 200.0 |
| 2016-01-25 05:53:00 | SPY | ETF | 190.24 | 190.32 | 190.24 | 190.32 | 650.0 |
| 2016-01-25 05:54:00 | SPY | ETF | 190.3 | 190.3 | 190.3 | 190.3 | 1300.0 |
| 2016-01-25 05:56:00 | SPY | ETF | 190.22 | 190.22 | 190.22 | 190.22 | 400.0 |
| 2016-01-25 06:01:00 | SPY | ETF | 190.13 | 190.13 | 190.13 | 190.13 | 100.0 |
| 2016-01-25 06:03:00 | SPY | ETF | 190.29 | 190.29 | 190.29 | 190.29 | 110.0 |
> showing 50 of 143,311 rows — these rows as CSV