PREVIEW / etf_5min / 2015-05-29
file: by_date/etf_5min/2015/2015-05-29.parquet size: 1.1 MB rows: 46,355
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-29 04:00:00 | SPY | ETF | 211.89 | 211.89 | 211.76 | 211.76 | 6890.0 |
| 2015-05-29 04:05:00 | SPY | ETF | 212.4 | 212.4 | 211.8 | 211.83 | 4925.0 |
| 2015-05-29 04:10:00 | SPY | ETF | 211.98 | 211.98 | 211.98 | 211.98 | 100.0 |
| 2015-05-29 04:20:00 | SPY | ETF | 212.06 | 212.06 | 212.06 | 212.06 | 150.0 |
| 2015-05-29 04:30:00 | SPY | ETF | 211.94 | 211.94 | 211.94 | 211.94 | 100.0 |
| 2015-05-29 04:35:00 | SPY | ETF | 212.0 | 212.0 | 212.0 | 212.0 | 200.0 |
| 2015-05-29 04:40:00 | SPY | ETF | 211.99 | 211.99 | 211.99 | 211.99 | 100.0 |
| 2015-05-29 04:50:00 | SPY | ETF | 212.1 | 212.1 | 212.08 | 212.08 | 250.0 |
| 2015-05-29 05:10:00 | SPY | ETF | 212.06 | 212.06 | 211.99 | 211.99 | 1000.0 |
| 2015-05-29 05:20:00 | SPY | ETF | 212.06 | 212.06 | 212.02 | 212.02 | 600.0 |
| 2015-05-29 05:25:00 | SPY | ETF | 212.0 | 212.0 | 211.88 | 211.95 | 13605.0 |
| 2015-05-29 05:30:00 | SPY | ETF | 211.89 | 211.89 | 211.88 | 211.88 | 16165.0 |
| 2015-05-29 05:35:00 | SPY | ETF | 211.96 | 212.05 | 211.96 | 212.05 | 12212.0 |
| 2015-05-29 05:40:00 | SPY | ETF | 212.06 | 212.06 | 212.01 | 212.03 | 9616.0 |
| 2015-05-29 05:45:00 | SPY | ETF | 212.06 | 212.06 | 212.02 | 212.02 | 3500.0 |
| 2015-05-29 05:50:00 | SPY | ETF | 212.04 | 212.04 | 212.04 | 212.04 | 100.0 |
| 2015-05-29 06:00:00 | SPY | ETF | 212.15 | 212.15 | 212.13 | 212.13 | 2550.0 |
| 2015-05-29 06:05:00 | SPY | ETF | 212.16 | 212.16 | 212.16 | 212.16 | 300.0 |
| 2015-05-29 06:10:00 | SPY | ETF | 212.18 | 212.18 | 212.18 | 212.18 | 100.0 |
| 2015-05-29 06:15:00 | SPY | ETF | 212.31 | 212.41 | 212.31 | 212.36 | 1013.0 |
| 2015-05-29 06:20:00 | SPY | ETF | 212.36 | 212.36 | 212.34 | 212.35 | 1015.0 |
| 2015-05-29 06:25:00 | SPY | ETF | 212.5 | 212.54 | 212.5 | 212.54 | 10436.0 |
| 2015-05-29 06:30:00 | SPY | ETF | 212.57 | 212.75 | 212.57 | 212.63 | 15400.0 |
| 2015-05-29 06:35:00 | SPY | ETF | 212.65 | 212.71 | 212.63 | 212.66 | 28169.0 |
| 2015-05-29 06:40:00 | SPY | ETF | 212.66 | 212.66 | 212.64 | 212.65 | 9400.0 |
| 2015-05-29 06:45:00 | SPY | ETF | 212.61 | 212.67 | 212.59 | 212.67 | 3160.0 |
| 2015-05-29 06:50:00 | SPY | ETF | 212.6 | 212.6 | 212.6 | 212.6 | 101.0 |
| 2015-05-29 06:55:00 | SPY | ETF | 212.6 | 212.65 | 212.56 | 212.56 | 4621.0 |
| 2015-05-29 07:00:00 | SPY | ETF | 212.57 | 212.63 | 212.57 | 212.63 | 704.0 |
| 2015-05-29 07:05:00 | SPY | ETF | 212.59 | 212.6 | 212.57 | 212.58 | 10500.0 |
| 2015-05-29 07:10:00 | SPY | ETF | 212.56 | 212.56 | 212.5 | 212.5 | 4619.0 |
| 2015-05-29 07:15:00 | SPY | ETF | 212.53 | 212.55 | 212.45 | 212.45 | 1115.0 |
| 2015-05-29 07:20:00 | SPY | ETF | 212.44 | 212.48 | 212.38 | 212.48 | 2162.0 |
| 2015-05-29 07:25:00 | SPY | ETF | 212.45 | 212.45 | 212.36 | 212.45 | 13503.0 |
| 2015-05-29 07:30:00 | SPY | ETF | 212.45 | 212.45 | 212.42 | 212.44 | 5301.0 |
| 2015-05-29 07:35:00 | SPY | ETF | 212.5 | 212.5 | 212.48 | 212.48 | 25225.0 |
| 2015-05-29 07:40:00 | SPY | ETF | 212.43 | 212.45 | 212.42 | 212.44 | 2050.0 |
| 2015-05-29 07:45:00 | SPY | ETF | 212.4 | 212.47 | 212.36 | 212.44 | 29068.0 |
| 2015-05-29 07:50:00 | SPY | ETF | 212.44 | 212.47 | 212.39 | 212.4 | 49377.0 |
| 2015-05-29 07:55:00 | SPY | ETF | 212.4 | 212.43 | 212.4 | 212.42 | 6933.0 |
| 2015-05-29 08:00:00 | SPY | ETF | 212.45 | 212.66 | 212.17 | 212.17 | 121827.0 |
| 2015-05-29 08:05:00 | SPY | ETF | 212.45 | 212.48 | 212.35 | 212.35 | 109818.0 |
| 2015-05-29 08:10:00 | SPY | ETF | 212.35 | 212.37 | 212.29 | 212.35 | 36445.0 |
| 2015-05-29 08:15:00 | SPY | ETF | 212.34 | 212.41 | 212.34 | 212.39 | 43602.0 |
| 2015-05-29 08:20:00 | SPY | ETF | 212.4 | 212.4 | 212.31 | 212.39 | 66200.0 |
| 2015-05-29 08:25:00 | SPY | ETF | 212.4 | 212.42 | 212.33 | 212.37 | 57487.0 |
| 2015-05-29 08:30:00 | SPY | ETF | 212.35 | 212.55 | 212.35 | 212.4 | 82288.0 |
| 2015-05-29 08:35:00 | SPY | ETF | 212.39 | 212.39 | 212.15 | 212.15 | 132473.0 |
| 2015-05-29 08:40:00 | SPY | ETF | 212.18 | 212.23 | 212.15 | 212.23 | 93934.0 |
| 2015-05-29 08:45:00 | SPY | ETF | 212.24 | 212.32 | 212.24 | 212.27 | 34316.0 |
> showing 50 of 46,355 rows — these rows as CSV