PREVIEW / etf_5min / 2014-05-06
file: by_date/etf_5min/2014/2014-05-06.parquet size: 974 KB rows: 41,338
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-05-06 04:00:00 | SPY | ETF | 188.5 | 188.62 | 188.5 | 188.55 | 500.0 |
| 2014-05-06 04:05:00 | SPY | ETF | 188.57 | 188.57 | 188.53 | 188.53 | 442.0 |
| 2014-05-06 04:15:00 | SPY | ETF | 188.36 | 188.36 | 188.36 | 188.36 | 100.0 |
| 2014-05-06 04:25:00 | SPY | ETF | 188.27 | 188.27 | 188.25 | 188.25 | 310.0 |
| 2014-05-06 04:40:00 | SPY | ETF | 188.34 | 188.35 | 188.34 | 188.35 | 335.0 |
| 2014-05-06 04:50:00 | SPY | ETF | 188.32 | 188.32 | 188.32 | 188.32 | 107.0 |
| 2014-05-06 05:25:00 | SPY | ETF | 188.53 | 188.53 | 188.53 | 188.53 | 424.0 |
| 2014-05-06 06:00:00 | SPY | ETF | 188.42 | 188.42 | 188.42 | 188.42 | 122.0 |
| 2014-05-06 06:05:00 | SPY | ETF | 188.39 | 188.39 | 188.39 | 188.39 | 1900.0 |
| 2014-05-06 06:15:00 | SPY | ETF | 188.41 | 188.41 | 188.41 | 188.41 | 100.0 |
| 2014-05-06 06:20:00 | SPY | ETF | 188.41 | 188.41 | 188.41 | 188.41 | 226.0 |
| 2014-05-06 06:35:00 | SPY | ETF | 188.38 | 188.38 | 188.35 | 188.35 | 1700.0 |
| 2014-05-06 06:45:00 | SPY | ETF | 188.36 | 188.36 | 188.31 | 188.31 | 317.0 |
| 2014-05-06 06:55:00 | SPY | ETF | 188.3 | 188.3 | 188.26 | 188.26 | 900.0 |
| 2014-05-06 07:00:00 | SPY | ETF | 188.27 | 188.27 | 188.15 | 188.15 | 5100.0 |
| 2014-05-06 07:05:00 | SPY | ETF | 188.18 | 188.19 | 188.1 | 188.1 | 10513.0 |
| 2014-05-06 07:10:00 | SPY | ETF | 188.14 | 188.15 | 188.11 | 188.11 | 2950.0 |
| 2014-05-06 07:15:00 | SPY | ETF | 188.1 | 188.15 | 188.1 | 188.15 | 1100.0 |
| 2014-05-06 07:20:00 | SPY | ETF | 188.16 | 188.19 | 188.16 | 188.19 | 2600.0 |
| 2014-05-06 07:25:00 | SPY | ETF | 188.2 | 188.2 | 188.2 | 188.2 | 600.0 |
| 2014-05-06 07:30:00 | SPY | ETF | 188.21 | 188.21 | 188.18 | 188.18 | 1130.0 |
| 2014-05-06 07:35:00 | SPY | ETF | 188.2 | 188.2 | 188.17 | 188.18 | 2409.0 |
| 2014-05-06 07:45:00 | SPY | ETF | 188.16 | 188.16 | 188.11 | 188.15 | 13821.0 |
| 2014-05-06 07:55:00 | SPY | ETF | 188.15 | 188.22 | 188.15 | 188.22 | 4878.0 |
| 2014-05-06 08:00:00 | SPY | ETF | 188.2 | 188.21 | 188.13 | 188.19 | 6700.0 |
| 2014-05-06 08:05:00 | SPY | ETF | 188.2 | 188.2 | 188.17 | 188.17 | 8680.0 |
| 2014-05-06 08:10:00 | SPY | ETF | 188.17 | 188.18 | 188.13 | 188.18 | 11575.0 |
| 2014-05-06 08:15:00 | SPY | ETF | 188.19 | 188.19 | 188.0 | 188.0 | 70969.0 |
| 2014-05-06 08:20:00 | SPY | ETF | 188.0 | 188.05 | 187.99 | 188.05 | 39772.0 |
| 2014-05-06 08:25:00 | SPY | ETF | 188.03 | 188.05 | 187.99 | 187.99 | 39868.0 |
| 2014-05-06 08:30:00 | SPY | ETF | 188.02 | 188.04 | 187.95 | 187.95 | 14183.0 |
| 2014-05-06 08:35:00 | SPY | ETF | 187.96 | 187.99 | 187.93 | 187.94 | 41426.0 |
| 2014-05-06 08:40:00 | SPY | ETF | 187.94 | 187.94 | 187.83 | 187.83 | 95229.0 |
| 2014-05-06 08:45:00 | SPY | ETF | 187.83 | 187.88 | 187.81 | 187.87 | 123043.0 |
| 2014-05-06 08:50:00 | SPY | ETF | 187.87 | 187.87 | 187.82 | 187.84 | 63450.0 |
| 2014-05-06 08:55:00 | SPY | ETF | 187.83 | 187.87 | 187.83 | 187.84 | 41042.0 |
| 2014-05-06 09:00:00 | SPY | ETF | 187.85 | 187.9 | 187.83 | 187.89 | 16772.0 |
| 2014-05-06 09:05:00 | SPY | ETF | 187.89 | 187.97 | 187.89 | 187.97 | 43389.0 |
| 2014-05-06 09:10:00 | SPY | ETF | 187.96 | 187.99 | 187.93 | 187.96 | 41849.0 |
| 2014-05-06 09:15:00 | SPY | ETF | 187.96 | 187.97 | 187.9 | 187.91 | 68716.0 |
| 2014-05-06 09:20:00 | SPY | ETF | 187.92 | 187.97 | 187.91 | 187.97 | 84829.0 |
| 2014-05-06 09:25:00 | SPY | ETF | 187.97 | 188.02 | 187.93 | 188.0 | 261447.0 |
| 2014-05-06 09:30:00 | SPY | ETF | 188.0 | 188.03 | 187.79 | 187.9 | 2747856.0 |
| 2014-05-06 09:35:00 | SPY | ETF | 187.9 | 187.97 | 187.62 | 187.69 | 2983861.0 |
| 2014-05-06 09:40:00 | SPY | ETF | 187.69 | 187.72 | 187.51 | 187.65 | 1862969.0 |
| 2014-05-06 09:45:00 | SPY | ETF | 187.65 | 187.93 | 187.57 | 187.81 | 2328227.0 |
| 2014-05-06 09:50:00 | SPY | ETF | 187.805 | 187.88 | 187.6 | 187.72 | 1730178.0 |
| 2014-05-06 09:55:00 | SPY | ETF | 187.73 | 187.87 | 187.59 | 187.87 | 892463.0 |
| 2014-05-06 10:00:00 | SPY | ETF | 187.87 | 187.87 | 187.65 | 187.77 | 2225496.0 |
| 2014-05-06 10:05:00 | SPY | ETF | 187.77 | 187.8 | 187.56 | 187.59 | 1022604.0 |
> showing 50 of 41,338 rows — these rows as CSV