PREVIEW / etf_5min / 2016-05-24
file: by_date/etf_5min/2016/2016-05-24.parquet size: 1.1 MB rows: 49,314
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-24 04:00:00 | SPY | ETF | 205.16 | 205.5 | 205.16 | 205.5 | 770.0 |
| 2016-05-24 04:05:00 | SPY | ETF | 205.56 | 205.56 | 205.56 | 205.56 | 300.0 |
| 2016-05-24 04:10:00 | SPY | ETF | 205.46 | 205.46 | 205.46 | 205.46 | 500.0 |
| 2016-05-24 04:15:00 | SPY | ETF | 205.55 | 205.55 | 205.5 | 205.5 | 1101.0 |
| 2016-05-24 04:20:00 | SPY | ETF | 205.49 | 205.51 | 205.49 | 205.51 | 601.0 |
| 2016-05-24 04:25:00 | SPY | ETF | 205.5 | 205.5 | 205.39 | 205.39 | 2704.0 |
| 2016-05-24 04:30:00 | SPY | ETF | 205.46 | 205.51 | 205.46 | 205.51 | 1528.0 |
| 2016-05-24 04:35:00 | SPY | ETF | 205.45 | 205.45 | 205.45 | 205.45 | 101.0 |
| 2016-05-24 04:45:00 | SPY | ETF | 205.59 | 205.6 | 205.59 | 205.6 | 301.0 |
| 2016-05-24 04:50:00 | SPY | ETF | 205.51 | 205.54 | 205.51 | 205.51 | 738.0 |
| 2016-05-24 05:00:00 | SPY | ETF | 205.43 | 205.51 | 205.43 | 205.51 | 1302.0 |
| 2016-05-24 05:05:00 | SPY | ETF | 205.45 | 205.5 | 205.45 | 205.5 | 500.0 |
| 2016-05-24 05:10:00 | SPY | ETF | 205.5 | 205.5 | 205.5 | 205.5 | 1000.0 |
| 2016-05-24 05:15:00 | SPY | ETF | 205.51 | 205.6 | 205.51 | 205.6 | 1653.0 |
| 2016-05-24 05:20:00 | SPY | ETF | 205.61 | 205.71 | 205.6 | 205.6 | 4833.0 |
| 2016-05-24 05:25:00 | SPY | ETF | 205.63 | 205.66 | 205.63 | 205.66 | 603.0 |
| 2016-05-24 05:35:00 | SPY | ETF | 205.64 | 205.7 | 205.64 | 205.7 | 7195.0 |
| 2016-05-24 05:40:00 | SPY | ETF | 205.78 | 205.78 | 205.75 | 205.75 | 582.0 |
| 2016-05-24 05:45:00 | SPY | ETF | 205.82 | 205.82 | 205.78 | 205.78 | 618.0 |
| 2016-05-24 05:50:00 | SPY | ETF | 205.73 | 205.76 | 205.73 | 205.76 | 1403.0 |
| 2016-05-24 05:55:00 | SPY | ETF | 205.73 | 205.73 | 205.73 | 205.73 | 115.0 |
| 2016-05-24 06:00:00 | SPY | ETF | 205.76 | 205.76 | 205.68 | 205.7 | 1964.0 |
| 2016-05-24 06:05:00 | SPY | ETF | 205.71 | 205.71 | 205.71 | 205.71 | 2002.0 |
| 2016-05-24 06:10:00 | SPY | ETF | 205.64 | 205.66 | 205.64 | 205.66 | 2300.0 |
| 2016-05-24 06:15:00 | SPY | ETF | 205.66 | 205.67 | 205.66 | 205.67 | 4400.0 |
| 2016-05-24 06:20:00 | SPY | ETF | 205.71 | 205.71 | 205.69 | 205.69 | 30601.0 |
| 2016-05-24 06:25:00 | SPY | ETF | 205.69 | 205.69 | 205.67 | 205.67 | 10003.0 |
| 2016-05-24 06:30:00 | SPY | ETF | 205.69 | 205.73 | 205.68 | 205.73 | 10402.0 |
| 2016-05-24 06:35:00 | SPY | ETF | 205.73 | 205.82 | 205.73 | 205.8 | 5147.0 |
| 2016-05-24 06:40:00 | SPY | ETF | 205.83 | 205.83 | 205.8 | 205.8 | 7253.0 |
| 2016-05-24 06:45:00 | SPY | ETF | 205.85 | 205.86 | 205.8 | 205.8 | 3082.0 |
| 2016-05-24 06:50:00 | SPY | ETF | 205.78 | 205.78 | 205.72 | 205.73 | 3431.0 |
| 2016-05-24 06:55:00 | SPY | ETF | 205.7 | 205.78 | 205.69 | 205.72 | 2220.0 |
| 2016-05-24 07:00:00 | SPY | ETF | 205.75 | 205.81 | 205.75 | 205.81 | 8010.0 |
| 2016-05-24 07:05:00 | SPY | ETF | 205.81 | 205.85 | 205.77 | 205.83 | 9032.0 |
| 2016-05-24 07:10:00 | SPY | ETF | 205.81 | 205.83 | 205.77 | 205.77 | 5889.0 |
| 2016-05-24 07:15:00 | SPY | ETF | 205.75 | 205.75 | 205.75 | 205.75 | 600.0 |
| 2016-05-24 07:20:00 | SPY | ETF | 205.79 | 205.79 | 205.79 | 205.79 | 2700.0 |
| 2016-05-24 07:25:00 | SPY | ETF | 205.78 | 205.79 | 205.75 | 205.79 | 4853.0 |
| 2016-05-24 07:30:00 | SPY | ETF | 205.77 | 205.81 | 205.77 | 205.81 | 3554.0 |
| 2016-05-24 07:35:00 | SPY | ETF | 205.8 | 205.87 | 205.8 | 205.86 | 11770.0 |
| 2016-05-24 07:40:00 | SPY | ETF | 205.86 | 205.94 | 205.86 | 205.93 | 9627.0 |
| 2016-05-24 07:45:00 | SPY | ETF | 205.94 | 205.94 | 205.9 | 205.91 | 63671.0 |
| 2016-05-24 07:50:00 | SPY | ETF | 205.9 | 205.95 | 205.88 | 205.91 | 8691.0 |
| 2016-05-24 07:55:00 | SPY | ETF | 205.88 | 205.91 | 205.88 | 205.88 | 3285.0 |
| 2016-05-24 08:00:00 | SPY | ETF | 205.88 | 205.97 | 205.235 | 205.235 | 157312.0 |
| 2016-05-24 08:05:00 | SPY | ETF | 205.98 | 206.04 | 205.95 | 206.04 | 92850.0 |
| 2016-05-24 08:10:00 | SPY | ETF | 206.04 | 206.29 | 206.03 | 206.16 | 146390.0 |
| 2016-05-24 08:15:00 | SPY | ETF | 206.17 | 206.26 | 206.16 | 206.23 | 282379.0 |
| 2016-05-24 08:20:00 | SPY | ETF | 206.21 | 206.22 | 206.19 | 206.19 | 10138.0 |
> showing 50 of 49,314 rows — these rows as CSV