PREVIEW / etf_5min / 2015-09-01
file: by_date/etf_5min/2015/2015-09-01.parquet size: 1.3 MB rows: 55,294
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-09-01 04:00:00 | SPY | ETF | 193.47 | 193.65 | 193.18 | 193.52 | 10032.0 |
| 2015-09-01 04:05:00 | SPY | ETF | 193.5 | 193.5 | 193.48 | 193.5 | 605.0 |
| 2015-09-01 04:10:00 | SPY | ETF | 193.41 | 193.52 | 193.25 | 193.52 | 4459.0 |
| 2015-09-01 04:15:00 | SPY | ETF | 193.5 | 193.55 | 193.21 | 193.21 | 721.0 |
| 2015-09-01 04:20:00 | SPY | ETF | 193.18 | 193.34 | 193.18 | 193.2 | 4731.0 |
| 2015-09-01 04:25:00 | SPY | ETF | 193.27 | 193.52 | 193.27 | 193.45 | 25312.0 |
| 2015-09-01 04:30:00 | SPY | ETF | 193.48 | 193.48 | 193.1 | 193.2 | 5606.0 |
| 2015-09-01 04:35:00 | SPY | ETF | 193.04 | 193.04 | 192.8 | 192.95 | 12379.0 |
| 2015-09-01 04:40:00 | SPY | ETF | 193.05 | 193.07 | 192.9 | 192.94 | 9750.0 |
| 2015-09-01 04:45:00 | SPY | ETF | 193.0 | 193.0 | 192.88 | 192.94 | 15999.0 |
| 2015-09-01 04:50:00 | SPY | ETF | 193.02 | 193.1 | 192.93 | 192.93 | 30615.0 |
| 2015-09-01 04:55:00 | SPY | ETF | 192.87 | 192.99 | 192.8 | 192.93 | 13545.0 |
| 2015-09-01 05:00:00 | SPY | ETF | 192.89 | 193.16 | 192.83 | 193.16 | 33057.0 |
| 2015-09-01 05:05:00 | SPY | ETF | 193.04 | 193.52 | 193.01 | 193.44 | 62035.0 |
| 2015-09-01 05:10:00 | SPY | ETF | 193.45 | 193.6 | 193.31 | 193.38 | 11765.0 |
| 2015-09-01 05:15:00 | SPY | ETF | 193.4 | 193.4 | 193.15 | 193.29 | 10510.0 |
| 2015-09-01 05:20:00 | SPY | ETF | 193.27 | 193.27 | 193.06 | 193.06 | 1700.0 |
| 2015-09-01 05:25:00 | SPY | ETF | 193.06 | 193.12 | 192.88 | 192.88 | 4780.0 |
| 2015-09-01 05:30:00 | SPY | ETF | 192.91 | 193.03 | 192.81 | 193.03 | 23490.0 |
| 2015-09-01 05:35:00 | SPY | ETF | 193.03 | 193.29 | 192.99 | 193.28 | 37035.0 |
| 2015-09-01 05:40:00 | SPY | ETF | 193.21 | 193.35 | 193.2 | 193.2 | 13005.0 |
| 2015-09-01 05:45:00 | SPY | ETF | 193.35 | 193.5 | 193.34 | 193.5 | 4720.0 |
| 2015-09-01 05:50:00 | SPY | ETF | 193.41 | 193.58 | 193.4 | 193.54 | 16290.0 |
| 2015-09-01 05:55:00 | SPY | ETF | 193.51 | 193.56 | 193.33 | 193.33 | 2425.0 |
| 2015-09-01 06:00:00 | SPY | ETF | 193.35 | 193.58 | 193.35 | 193.58 | 6876.0 |
| 2015-09-01 06:05:00 | SPY | ETF | 193.57 | 193.6 | 193.38 | 193.42 | 5930.0 |
| 2015-09-01 06:10:00 | SPY | ETF | 193.56 | 193.68 | 193.54 | 193.6 | 57984.0 |
| 2015-09-01 06:15:00 | SPY | ETF | 193.54 | 193.7 | 193.51 | 193.7 | 11024.0 |
| 2015-09-01 06:20:00 | SPY | ETF | 193.74 | 193.85 | 193.66 | 193.81 | 13020.0 |
| 2015-09-01 06:25:00 | SPY | ETF | 193.74 | 193.93 | 193.71 | 193.93 | 5410.0 |
| 2015-09-01 06:30:00 | SPY | ETF | 193.9 | 194.06 | 193.75 | 193.85 | 36269.0 |
| 2015-09-01 06:35:00 | SPY | ETF | 193.81 | 193.81 | 193.55 | 193.55 | 29990.0 |
| 2015-09-01 06:40:00 | SPY | ETF | 193.58 | 193.68 | 193.54 | 193.59 | 54698.0 |
| 2015-09-01 06:45:00 | SPY | ETF | 193.66 | 193.72 | 193.58 | 193.64 | 28225.0 |
| 2015-09-01 06:50:00 | SPY | ETF | 193.6 | 193.63 | 193.41 | 193.6 | 50364.0 |
| 2015-09-01 06:55:00 | SPY | ETF | 193.6 | 193.86 | 193.6 | 193.82 | 129029.0 |
| 2015-09-01 07:00:00 | SPY | ETF | 193.81 | 193.91 | 193.69 | 193.81 | 166528.0 |
| 2015-09-01 07:05:00 | SPY | ETF | 193.77 | 193.95 | 193.74 | 193.95 | 17169.0 |
| 2015-09-01 07:10:00 | SPY | ETF | 193.95 | 194.02 | 193.9 | 194.02 | 17465.0 |
| 2015-09-01 07:15:00 | SPY | ETF | 194.02 | 194.13 | 194.02 | 194.03 | 158933.0 |
| 2015-09-01 07:20:00 | SPY | ETF | 194.06 | 194.15 | 193.87 | 194.01 | 51017.0 |
| 2015-09-01 07:25:00 | SPY | ETF | 194.0 | 194.26 | 194.0 | 194.06 | 30644.0 |
| 2015-09-01 07:30:00 | SPY | ETF | 194.06 | 194.06 | 193.83 | 193.92 | 75799.0 |
| 2015-09-01 07:35:00 | SPY | ETF | 193.92 | 193.92 | 193.51 | 193.55 | 129018.0 |
| 2015-09-01 07:40:00 | SPY | ETF | 193.55 | 193.71 | 193.54 | 193.55 | 64145.0 |
| 2015-09-01 07:45:00 | SPY | ETF | 193.56 | 193.89 | 193.55 | 193.86 | 97038.0 |
| 2015-09-01 07:50:00 | SPY | ETF | 193.86 | 193.95 | 193.71 | 193.77 | 145467.0 |
| 2015-09-01 07:55:00 | SPY | ETF | 193.8 | 193.94 | 193.7 | 193.7 | 51717.0 |
| 2015-09-01 08:00:00 | SPY | ETF | 193.72 | 194.23 | 193.0 | 193.6 | 348318.0 |
| 2015-09-01 08:05:00 | SPY | ETF | 193.59 | 194.0 | 193.43 | 193.44 | 308220.0 |
> showing 50 of 55,294 rows — these rows as CSV