PREVIEW / etf_5min / 2015-08-24
file: by_date/etf_5min/2015/2015-08-24.parquet size: 1.5 MB rows: 66,572
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-08-24 04:00:00 | SPY | ETF | 194.32 | 194.32 | 193.89 | 194.14 | 17956.0 |
| 2015-08-24 04:05:00 | SPY | ETF | 194.14 | 194.26 | 193.92 | 194.17 | 1845.0 |
| 2015-08-24 04:10:00 | SPY | ETF | 194.21 | 194.25 | 194.07 | 194.07 | 14367.0 |
| 2015-08-24 04:15:00 | SPY | ETF | 194.12 | 194.34 | 194.07 | 194.24 | 26715.0 |
| 2015-08-24 04:20:00 | SPY | ETF | 194.27 | 194.27 | 194.07 | 194.07 | 10870.0 |
| 2015-08-24 04:25:00 | SPY | ETF | 194.12 | 194.22 | 194.1 | 194.15 | 50250.0 |
| 2015-08-24 04:30:00 | SPY | ETF | 194.14 | 194.14 | 193.7 | 193.72 | 30162.0 |
| 2015-08-24 04:35:00 | SPY | ETF | 193.8 | 194.04 | 193.75 | 194.04 | 11950.0 |
| 2015-08-24 04:40:00 | SPY | ETF | 194.04 | 194.17 | 193.97 | 193.98 | 9965.0 |
| 2015-08-24 04:45:00 | SPY | ETF | 193.94 | 194.13 | 193.9 | 194.07 | 15011.0 |
| 2015-08-24 04:50:00 | SPY | ETF | 194.04 | 194.24 | 194.04 | 194.13 | 14673.0 |
| 2015-08-24 04:55:00 | SPY | ETF | 194.19 | 194.56 | 194.19 | 194.53 | 24531.0 |
| 2015-08-24 05:00:00 | SPY | ETF | 194.52 | 194.57 | 194.45 | 194.54 | 18212.0 |
| 2015-08-24 05:05:00 | SPY | ETF | 194.55 | 194.55 | 194.35 | 194.35 | 31102.0 |
| 2015-08-24 05:10:00 | SPY | ETF | 194.28 | 194.52 | 194.28 | 194.52 | 1553.0 |
| 2015-08-24 05:15:00 | SPY | ETF | 194.44 | 194.58 | 194.4 | 194.48 | 64560.0 |
| 2015-08-24 05:20:00 | SPY | ETF | 194.51 | 194.67 | 194.49 | 194.55 | 62734.0 |
| 2015-08-24 05:25:00 | SPY | ETF | 194.61 | 194.65 | 194.55 | 194.57 | 28706.0 |
| 2015-08-24 05:30:00 | SPY | ETF | 194.58 | 194.97 | 194.58 | 194.93 | 49142.0 |
| 2015-08-24 05:35:00 | SPY | ETF | 194.93 | 194.95 | 194.75 | 194.77 | 91525.0 |
| 2015-08-24 05:40:00 | SPY | ETF | 194.73 | 194.78 | 194.62 | 194.62 | 27799.0 |
| 2015-08-24 05:45:00 | SPY | ETF | 194.63 | 194.63 | 194.38 | 194.48 | 63742.0 |
| 2015-08-24 05:50:00 | SPY | ETF | 194.48 | 194.56 | 194.38 | 194.38 | 52300.0 |
| 2015-08-24 05:55:00 | SPY | ETF | 194.35 | 194.39 | 194.15 | 194.15 | 16200.0 |
| 2015-08-24 06:00:00 | SPY | ETF | 194.18 | 194.39 | 193.78 | 193.82 | 110629.0 |
| 2015-08-24 06:05:00 | SPY | ETF | 193.84 | 194.02 | 193.7 | 193.9 | 31570.0 |
| 2015-08-24 06:10:00 | SPY | ETF | 193.92 | 193.95 | 193.49 | 193.66 | 123598.0 |
| 2015-08-24 06:15:00 | SPY | ETF | 193.66 | 193.66 | 193.1 | 193.1 | 71856.0 |
| 2015-08-24 06:20:00 | SPY | ETF | 193.06 | 193.42 | 193.01 | 193.27 | 178536.0 |
| 2015-08-24 06:25:00 | SPY | ETF | 193.27 | 193.52 | 193.21 | 193.42 | 91626.0 |
| 2015-08-24 06:30:00 | SPY | ETF | 193.4 | 193.4 | 193.26 | 193.32 | 84370.0 |
| 2015-08-24 06:35:00 | SPY | ETF | 193.32 | 193.33 | 193.06 | 193.08 | 56400.0 |
| 2015-08-24 06:40:00 | SPY | ETF | 193.15 | 193.57 | 193.03 | 193.57 | 62030.0 |
| 2015-08-24 06:45:00 | SPY | ETF | 193.57 | 193.69 | 193.41 | 193.42 | 52147.0 |
| 2015-08-24 06:50:00 | SPY | ETF | 193.45 | 193.52 | 193.33 | 193.36 | 34535.0 |
| 2015-08-24 06:55:00 | SPY | ETF | 193.36 | 194.22 | 193.36 | 194.13 | 55686.0 |
| 2015-08-24 07:00:00 | SPY | ETF | 194.13 | 194.13 | 193.54 | 193.54 | 93694.0 |
| 2015-08-24 07:05:00 | SPY | ETF | 193.57 | 193.67 | 193.46 | 193.49 | 61624.0 |
| 2015-08-24 07:10:00 | SPY | ETF | 193.4 | 193.43 | 193.08 | 193.21 | 142685.0 |
| 2015-08-24 07:15:00 | SPY | ETF | 193.24 | 193.36 | 193.13 | 193.28 | 148435.0 |
| 2015-08-24 07:20:00 | SPY | ETF | 193.25 | 193.45 | 193.2 | 193.45 | 172539.0 |
| 2015-08-24 07:25:00 | SPY | ETF | 193.44 | 193.45 | 192.97 | 192.97 | 133942.0 |
| 2015-08-24 07:30:00 | SPY | ETF | 193.04 | 193.09 | 192.74 | 192.76 | 134852.0 |
| 2015-08-24 07:35:00 | SPY | ETF | 192.78 | 192.88 | 192.0 | 192.04 | 551648.0 |
| 2015-08-24 07:40:00 | SPY | ETF | 192.03 | 192.36 | 191.11 | 191.37 | 661203.0 |
| 2015-08-24 07:45:00 | SPY | ETF | 191.41 | 192.37 | 191.31 | 192.37 | 889195.0 |
| 2015-08-24 07:50:00 | SPY | ETF | 192.35 | 192.57 | 192.02 | 192.1 | 362460.0 |
| 2015-08-24 07:55:00 | SPY | ETF | 192.06 | 192.21 | 190.55 | 190.81 | 1330969.0 |
| 2015-08-24 08:00:00 | SPY | ETF | 190.82 | 194.04 | 189.95 | 192.81 | 1400121.0 |
| 2015-08-24 08:05:00 | SPY | ETF | 190.63 | 190.65 | 189.96 | 190.59 | 1204203.0 |
> showing 50 of 66,572 rows — these rows as CSV