PREVIEW / etf_5min / 2016-05-03
file: by_date/etf_5min/2016/2016-05-03.parquet size: 1.2 MB rows: 51,564
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-05-03 04:00:00 | SPY | ETF | 207.65 | 207.65 | 206.71 | 206.71 | 7911.0 |
| 2016-05-03 04:10:00 | SPY | ETF | 206.86 | 206.91 | 206.86 | 206.91 | 330.0 |
| 2016-05-03 04:15:00 | SPY | ETF | 206.93 | 206.93 | 206.93 | 206.93 | 350.0 |
| 2016-05-03 04:20:00 | SPY | ETF | 206.75 | 206.75 | 206.65 | 206.65 | 5828.0 |
| 2016-05-03 04:25:00 | SPY | ETF | 206.63 | 206.63 | 206.63 | 206.63 | 400.0 |
| 2016-05-03 04:40:00 | SPY | ETF | 206.63 | 206.66 | 206.59 | 206.59 | 4516.0 |
| 2016-05-03 04:45:00 | SPY | ETF | 206.57 | 206.61 | 206.52 | 206.6 | 2097.0 |
| 2016-05-03 04:50:00 | SPY | ETF | 206.58 | 206.58 | 206.58 | 206.58 | 102.0 |
| 2016-05-03 05:00:00 | SPY | ETF | 206.64 | 206.7 | 206.64 | 206.64 | 7827.0 |
| 2016-05-03 05:05:00 | SPY | ETF | 206.64 | 206.64 | 206.51 | 206.51 | 4235.0 |
| 2016-05-03 05:10:00 | SPY | ETF | 206.58 | 206.75 | 206.58 | 206.75 | 2745.0 |
| 2016-05-03 05:15:00 | SPY | ETF | 206.7 | 206.76 | 206.7 | 206.76 | 25204.0 |
| 2016-05-03 05:20:00 | SPY | ETF | 206.73 | 206.73 | 206.68 | 206.68 | 11005.0 |
| 2016-05-03 05:25:00 | SPY | ETF | 206.75 | 206.75 | 206.73 | 206.73 | 203.0 |
| 2016-05-03 05:30:00 | SPY | ETF | 206.78 | 206.78 | 206.78 | 206.78 | 2249.0 |
| 2016-05-03 05:35:00 | SPY | ETF | 206.65 | 206.68 | 206.65 | 206.65 | 78007.0 |
| 2016-05-03 05:40:00 | SPY | ETF | 206.7 | 206.7 | 206.55 | 206.55 | 39259.0 |
| 2016-05-03 05:45:00 | SPY | ETF | 206.52 | 206.53 | 206.5 | 206.5 | 76957.0 |
| 2016-05-03 05:50:00 | SPY | ETF | 206.57 | 206.59 | 206.57 | 206.58 | 3102.0 |
| 2016-05-03 05:55:00 | SPY | ETF | 206.52 | 206.56 | 206.51 | 206.56 | 3027.0 |
| 2016-05-03 06:00:00 | SPY | ETF | 206.54 | 206.58 | 206.54 | 206.58 | 18704.0 |
| 2016-05-03 06:05:00 | SPY | ETF | 206.51 | 206.61 | 206.51 | 206.58 | 17010.0 |
| 2016-05-03 06:10:00 | SPY | ETF | 206.6 | 206.61 | 206.53 | 206.58 | 1219.0 |
| 2016-05-03 06:15:00 | SPY | ETF | 206.63 | 206.63 | 206.51 | 206.51 | 4037.0 |
| 2016-05-03 06:20:00 | SPY | ETF | 206.45 | 206.45 | 206.39 | 206.43 | 67854.0 |
| 2016-05-03 06:25:00 | SPY | ETF | 206.43 | 206.53 | 206.43 | 206.53 | 3731.0 |
| 2016-05-03 06:30:00 | SPY | ETF | 206.48 | 206.48 | 206.45 | 206.45 | 5503.0 |
| 2016-05-03 06:35:00 | SPY | ETF | 206.39 | 206.43 | 206.3 | 206.43 | 1894.0 |
| 2016-05-03 06:40:00 | SPY | ETF | 206.43 | 206.45 | 206.43 | 206.45 | 600.0 |
| 2016-05-03 06:45:00 | SPY | ETF | 206.4 | 206.4 | 206.4 | 206.4 | 100.0 |
| 2016-05-03 06:50:00 | SPY | ETF | 206.42 | 206.42 | 206.27 | 206.27 | 16787.0 |
| 2016-05-03 06:55:00 | SPY | ETF | 206.27 | 206.34 | 206.24 | 206.32 | 84656.0 |
| 2016-05-03 07:00:00 | SPY | ETF | 206.33 | 206.35 | 206.23 | 206.26 | 71708.0 |
| 2016-05-03 07:05:00 | SPY | ETF | 206.29 | 206.41 | 206.28 | 206.39 | 147086.0 |
| 2016-05-03 07:10:00 | SPY | ETF | 206.4 | 206.51 | 206.37 | 206.46 | 30960.0 |
| 2016-05-03 07:15:00 | SPY | ETF | 206.48 | 206.51 | 206.46 | 206.47 | 244039.0 |
| 2016-05-03 07:20:00 | SPY | ETF | 206.5 | 206.65 | 206.47 | 206.65 | 188919.0 |
| 2016-05-03 07:25:00 | SPY | ETF | 206.65 | 206.65 | 206.49 | 206.49 | 161553.0 |
| 2016-05-03 07:30:00 | SPY | ETF | 206.49 | 206.5 | 206.38 | 206.45 | 42870.0 |
| 2016-05-03 07:35:00 | SPY | ETF | 206.45 | 206.45 | 206.33 | 206.35 | 55167.0 |
| 2016-05-03 07:40:00 | SPY | ETF | 206.34 | 206.4 | 206.3 | 206.4 | 74082.0 |
| 2016-05-03 07:45:00 | SPY | ETF | 206.4 | 206.43 | 206.38 | 206.4 | 91600.0 |
| 2016-05-03 07:50:00 | SPY | ETF | 206.4 | 206.47 | 206.4 | 206.45 | 40715.0 |
| 2016-05-03 07:55:00 | SPY | ETF | 206.43 | 206.55 | 206.38 | 206.55 | 86498.0 |
| 2016-05-03 08:00:00 | SPY | ETF | 206.55 | 206.61 | 206.27 | 206.45 | 52780.0 |
| 2016-05-03 08:05:00 | SPY | ETF | 207.701 | 207.701 | 206.43 | 206.49 | 86337.0 |
| 2016-05-03 08:10:00 | SPY | ETF | 206.47 | 206.65 | 206.47 | 206.64 | 53056.0 |
| 2016-05-03 08:15:00 | SPY | ETF | 206.64 | 206.64 | 206.49 | 206.5 | 50441.0 |
| 2016-05-03 08:20:00 | SPY | ETF | 206.5 | 206.53 | 206.39 | 206.47 | 55240.0 |
| 2016-05-03 08:25:00 | SPY | ETF | 206.45 | 206.5 | 206.43 | 206.48 | 24227.0 |
> showing 50 of 51,564 rows — these rows as CSV