PREVIEW / etf_5min / 2016-02-19
file: by_date/etf_5min/2016/2016-02-19.parquet size: 1.1 MB rows: 47,771
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-02-19 04:00:00 | SPY | ETF | 192.78 | 192.78 | 192.63 | 192.63 | 1121.0 |
| 2016-02-19 04:05:00 | SPY | ETF | 192.59 | 192.59 | 192.59 | 192.59 | 300.0 |
| 2016-02-19 04:10:00 | SPY | ETF | 192.7 | 192.76 | 192.66 | 192.66 | 4962.0 |
| 2016-02-19 04:15:00 | SPY | ETF | 192.68 | 192.71 | 192.63 | 192.63 | 7251.0 |
| 2016-02-19 04:20:00 | SPY | ETF | 192.56 | 192.56 | 192.53 | 192.53 | 283.0 |
| 2016-02-19 04:35:00 | SPY | ETF | 192.49 | 192.49 | 192.49 | 192.49 | 1270.0 |
| 2016-02-19 04:40:00 | SPY | ETF | 192.44 | 192.44 | 192.44 | 192.44 | 570.0 |
| 2016-02-19 04:45:00 | SPY | ETF | 192.47 | 192.47 | 192.45 | 192.45 | 2260.0 |
| 2016-02-19 04:50:00 | SPY | ETF | 192.58 | 192.63 | 192.58 | 192.63 | 309.0 |
| 2016-02-19 04:55:00 | SPY | ETF | 192.59 | 192.59 | 192.58 | 192.58 | 1030.0 |
| 2016-02-19 05:00:00 | SPY | ETF | 192.61 | 192.61 | 192.55 | 192.55 | 3059.0 |
| 2016-02-19 05:05:00 | SPY | ETF | 192.48 | 192.49 | 192.45 | 192.45 | 1802.0 |
| 2016-02-19 05:10:00 | SPY | ETF | 192.39 | 192.49 | 192.3 | 192.34 | 7020.0 |
| 2016-02-19 05:15:00 | SPY | ETF | 192.31 | 192.31 | 192.29 | 192.29 | 321.0 |
| 2016-02-19 05:20:00 | SPY | ETF | 192.48 | 192.5 | 192.48 | 192.5 | 253.0 |
| 2016-02-19 05:40:00 | SPY | ETF | 192.29 | 192.29 | 192.23 | 192.25 | 621.0 |
| 2016-02-19 05:50:00 | SPY | ETF | 192.04 | 192.07 | 192.04 | 192.07 | 1326.0 |
| 2016-02-19 05:55:00 | SPY | ETF | 192.05 | 192.05 | 192.0 | 192.0 | 1004.0 |
| 2016-02-19 06:00:00 | SPY | ETF | 192.07 | 192.07 | 192.07 | 192.07 | 1014.0 |
| 2016-02-19 06:05:00 | SPY | ETF | 192.0 | 192.01 | 191.95 | 192.01 | 1314.0 |
| 2016-02-19 06:10:00 | SPY | ETF | 192.05 | 192.05 | 192.05 | 192.05 | 1124.0 |
| 2016-02-19 06:15:00 | SPY | ETF | 191.9 | 191.9 | 191.9 | 191.9 | 353.0 |
| 2016-02-19 06:20:00 | SPY | ETF | 191.82 | 191.82 | 191.75 | 191.8 | 8216.0 |
| 2016-02-19 06:25:00 | SPY | ETF | 191.8 | 191.9 | 191.79 | 191.9 | 2445.0 |
| 2016-02-19 06:30:00 | SPY | ETF | 191.9 | 191.9 | 191.9 | 191.9 | 515.0 |
| 2016-02-19 06:35:00 | SPY | ETF | 191.77 | 191.77 | 191.77 | 191.77 | 127.0 |
| 2016-02-19 06:40:00 | SPY | ETF | 191.83 | 191.83 | 191.76 | 191.76 | 25856.0 |
| 2016-02-19 06:45:00 | SPY | ETF | 191.65 | 191.7 | 191.36 | 191.36 | 32867.0 |
| 2016-02-19 06:50:00 | SPY | ETF | 191.38 | 191.39 | 191.22 | 191.3 | 18897.0 |
| 2016-02-19 06:55:00 | SPY | ETF | 191.35 | 191.47 | 191.35 | 191.47 | 5191.0 |
| 2016-02-19 07:00:00 | SPY | ETF | 191.39 | 191.39 | 191.34 | 191.39 | 28933.0 |
| 2016-02-19 07:05:00 | SPY | ETF | 191.37 | 191.42 | 191.36 | 191.42 | 2699.0 |
| 2016-02-19 07:10:00 | SPY | ETF | 191.44 | 191.56 | 191.44 | 191.55 | 8920.0 |
| 2016-02-19 07:15:00 | SPY | ETF | 191.53 | 191.53 | 191.38 | 191.4 | 13979.0 |
| 2016-02-19 07:20:00 | SPY | ETF | 191.42 | 191.45 | 191.34 | 191.43 | 13571.0 |
| 2016-02-19 07:25:00 | SPY | ETF | 191.43 | 191.54 | 191.43 | 191.5 | 28438.0 |
| 2016-02-19 07:30:00 | SPY | ETF | 191.5 | 191.67 | 191.5 | 191.67 | 253685.0 |
| 2016-02-19 07:35:00 | SPY | ETF | 191.66 | 191.67 | 191.61 | 191.64 | 32372.0 |
| 2016-02-19 07:40:00 | SPY | ETF | 191.63 | 191.76 | 191.63 | 191.75 | 14585.0 |
| 2016-02-19 07:45:00 | SPY | ETF | 191.75 | 191.75 | 191.62 | 191.62 | 33728.0 |
| 2016-02-19 07:50:00 | SPY | ETF | 191.6 | 191.7 | 191.55 | 191.67 | 65118.0 |
| 2016-02-19 07:55:00 | SPY | ETF | 191.67 | 191.92 | 191.67 | 191.87 | 73735.0 |
| 2016-02-19 08:00:00 | SPY | ETF | 191.4936 | 192.2042 | 191.34 | 191.75 | 397534.0 |
| 2016-02-19 08:05:00 | SPY | ETF | 191.74 | 191.74 | 191.65 | 191.65 | 67072.0 |
| 2016-02-19 08:10:00 | SPY | ETF | 191.67 | 191.78 | 191.67 | 191.72 | 412566.0 |
| 2016-02-19 08:15:00 | SPY | ETF | 191.7 | 191.7 | 191.59 | 191.62 | 150588.0 |
| 2016-02-19 08:20:00 | SPY | ETF | 191.61 | 191.73 | 191.57 | 191.62 | 1027508.0 |
| 2016-02-19 08:25:00 | SPY | ETF | 191.63 | 191.66 | 191.57 | 191.65 | 18888.0 |
| 2016-02-19 08:30:00 | SPY | ETF | 191.65 | 191.65 | 191.36 | 191.57 | 243518.0 |
| 2016-02-19 08:35:00 | SPY | ETF | 191.57 | 191.83 | 191.57 | 191.74 | 150415.0 |
> showing 50 of 47,771 rows — these rows as CSV