PREVIEW / etf_5min / 2014-10-08
file: by_date/etf_5min/2014/2014-10-08.parquet size: 1.1 MB rows: 47,156
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-10-08 04:00:00 | SPY | ETF | 193.5 | 193.5 | 193.5 | 193.5 | 400.0 |
| 2014-10-08 04:05:00 | SPY | ETF | 193.61 | 193.61 | 193.61 | 193.61 | 100.0 |
| 2014-10-08 04:15:00 | SPY | ETF | 193.63 | 193.69 | 193.63 | 193.69 | 257.0 |
| 2014-10-08 04:20:00 | SPY | ETF | 193.58 | 193.58 | 193.58 | 193.58 | 100.0 |
| 2014-10-08 04:25:00 | SPY | ETF | 193.5 | 193.5 | 193.5 | 193.5 | 146.0 |
| 2014-10-08 04:35:00 | SPY | ETF | 193.51 | 193.51 | 193.51 | 193.51 | 100.0 |
| 2014-10-08 04:45:00 | SPY | ETF | 193.39 | 193.39 | 193.26 | 193.32 | 1460.0 |
| 2014-10-08 04:50:00 | SPY | ETF | 193.31 | 193.31 | 193.3 | 193.3 | 1700.0 |
| 2014-10-08 04:55:00 | SPY | ETF | 193.27 | 193.27 | 193.26 | 193.26 | 200.0 |
| 2014-10-08 05:05:00 | SPY | ETF | 193.21 | 193.21 | 193.15 | 193.15 | 1684.0 |
| 2014-10-08 05:15:00 | SPY | ETF | 193.22 | 193.27 | 193.21 | 193.26 | 783.0 |
| 2014-10-08 05:20:00 | SPY | ETF | 193.29 | 193.29 | 193.29 | 193.29 | 100.0 |
| 2014-10-08 05:25:00 | SPY | ETF | 193.35 | 193.35 | 193.35 | 193.35 | 100.0 |
| 2014-10-08 05:30:00 | SPY | ETF | 193.33 | 193.33 | 193.33 | 193.33 | 2000.0 |
| 2014-10-08 05:35:00 | SPY | ETF | 193.35 | 193.35 | 193.35 | 193.35 | 1200.0 |
| 2014-10-08 05:40:00 | SPY | ETF | 193.33 | 193.33 | 193.33 | 193.33 | 1507.0 |
| 2014-10-08 05:45:00 | SPY | ETF | 193.32 | 193.35 | 193.32 | 193.35 | 2851.0 |
| 2014-10-08 05:50:00 | SPY | ETF | 193.3 | 193.3 | 193.23 | 193.23 | 2900.0 |
| 2014-10-08 05:55:00 | SPY | ETF | 193.25 | 193.25 | 193.23 | 193.23 | 767.0 |
| 2014-10-08 06:00:00 | SPY | ETF | 193.29 | 193.33 | 193.29 | 193.33 | 2803.0 |
| 2014-10-08 06:05:00 | SPY | ETF | 193.34 | 193.36 | 193.33 | 193.36 | 1000.0 |
| 2014-10-08 06:10:00 | SPY | ETF | 193.38 | 193.38 | 193.36 | 193.36 | 2684.0 |
| 2014-10-08 06:15:00 | SPY | ETF | 193.36 | 193.36 | 193.31 | 193.35 | 2100.0 |
| 2014-10-08 06:20:00 | SPY | ETF | 193.34 | 193.35 | 193.34 | 193.35 | 1003.0 |
| 2014-10-08 06:25:00 | SPY | ETF | 193.32 | 193.4 | 193.32 | 193.4 | 800.0 |
| 2014-10-08 06:30:00 | SPY | ETF | 193.37 | 193.37 | 193.37 | 193.37 | 165.0 |
| 2014-10-08 06:35:00 | SPY | ETF | 193.37 | 193.38 | 193.36 | 193.38 | 2070.0 |
| 2014-10-08 06:40:00 | SPY | ETF | 193.39 | 193.45 | 193.39 | 193.41 | 31600.0 |
| 2014-10-08 06:45:00 | SPY | ETF | 193.45 | 193.58 | 193.45 | 193.58 | 32035.0 |
| 2014-10-08 06:50:00 | SPY | ETF | 193.56 | 193.61 | 193.53 | 193.61 | 30850.0 |
| 2014-10-08 06:55:00 | SPY | ETF | 193.61 | 193.66 | 193.61 | 193.63 | 2763.0 |
| 2014-10-08 07:00:00 | SPY | ETF | 193.7 | 193.7 | 193.62 | 193.68 | 26975.0 |
| 2014-10-08 07:05:00 | SPY | ETF | 193.66 | 193.75 | 193.66 | 193.75 | 11690.0 |
| 2014-10-08 07:10:00 | SPY | ETF | 193.65 | 193.74 | 193.64 | 193.74 | 893.0 |
| 2014-10-08 07:15:00 | SPY | ETF | 193.74 | 193.74 | 193.66 | 193.71 | 10350.0 |
| 2014-10-08 07:20:00 | SPY | ETF | 193.69 | 193.87 | 193.69 | 193.87 | 11970.0 |
| 2014-10-08 07:25:00 | SPY | ETF | 193.84 | 193.86 | 193.77 | 193.77 | 12428.0 |
| 2014-10-08 07:30:00 | SPY | ETF | 193.8 | 193.84 | 193.8 | 193.82 | 4600.0 |
| 2014-10-08 07:35:00 | SPY | ETF | 193.84 | 193.92 | 193.82 | 193.9 | 95263.0 |
| 2014-10-08 07:40:00 | SPY | ETF | 193.87 | 193.92 | 193.85 | 193.92 | 63452.0 |
| 2014-10-08 07:45:00 | SPY | ETF | 193.89 | 193.93 | 193.89 | 193.93 | 10971.0 |
| 2014-10-08 07:50:00 | SPY | ETF | 193.85 | 193.85 | 193.76 | 193.85 | 53059.0 |
| 2014-10-08 07:55:00 | SPY | ETF | 193.82 | 193.83 | 193.77 | 193.77 | 12735.0 |
| 2014-10-08 08:00:00 | SPY | ETF | 193.85 | 193.88 | 193.77 | 193.85 | 49270.0 |
| 2014-10-08 08:05:00 | SPY | ETF | 193.82 | 193.82 | 193.62 | 193.81 | 142647.0 |
| 2014-10-08 08:10:00 | SPY | ETF | 193.8 | 193.85 | 193.76 | 193.79 | 57856.0 |
| 2014-10-08 08:15:00 | SPY | ETF | 193.79 | 193.79 | 193.66 | 193.66 | 107184.0 |
| 2014-10-08 08:20:00 | SPY | ETF | 193.66 | 193.7 | 193.59 | 193.69 | 70054.0 |
| 2014-10-08 08:25:00 | SPY | ETF | 193.72 | 193.76 | 193.7 | 193.7 | 31686.0 |
| 2014-10-08 08:30:00 | SPY | ETF | 193.7 | 193.74 | 193.65 | 193.66 | 35755.0 |
> showing 50 of 47,156 rows — these rows as CSV