PREVIEW / etf_5min / 2015-09-08
file: by_date/etf_5min/2015/2015-09-08.parquet size: 1.1 MB rows: 48,207
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-08 04:00:00 | SPY | ETF | 196.09 | 196.35 | 195.38 | 196.3 | 7633.0 |
| 2015-09-08 04:05:00 | SPY | ETF | 196.4 | 196.4 | 196.17 | 196.3 | 2100.0 |
| 2015-09-08 04:10:00 | SPY | ETF | 196.09 | 196.09 | 196.09 | 196.09 | 165.0 |
| 2015-09-08 04:15:00 | SPY | ETF | 196.09 | 196.09 | 196.09 | 196.09 | 150.0 |
| 2015-09-08 04:20:00 | SPY | ETF | 196.09 | 196.09 | 196.07 | 196.07 | 600.0 |
| 2015-09-08 04:25:00 | SPY | ETF | 196.16 | 196.24 | 196.15 | 196.24 | 7250.0 |
| 2015-09-08 04:30:00 | SPY | ETF | 196.29 | 196.29 | 196.19 | 196.19 | 2600.0 |
| 2015-09-08 04:35:00 | SPY | ETF | 196.19 | 196.36 | 196.17 | 196.36 | 8700.0 |
| 2015-09-08 04:45:00 | SPY | ETF | 196.24 | 196.4 | 196.24 | 196.4 | 2600.0 |
| 2015-09-08 04:50:00 | SPY | ETF | 196.35 | 196.41 | 196.34 | 196.34 | 16500.0 |
| 2015-09-08 04:55:00 | SPY | ETF | 196.34 | 196.36 | 196.34 | 196.36 | 41100.0 |
| 2015-09-08 05:00:00 | SPY | ETF | 196.45 | 196.65 | 196.44 | 196.59 | 4570.0 |
| 2015-09-08 05:05:00 | SPY | ETF | 196.64 | 196.73 | 196.61 | 196.64 | 4325.0 |
| 2015-09-08 05:10:00 | SPY | ETF | 196.6 | 196.6 | 196.46 | 196.46 | 1300.0 |
| 2015-09-08 05:15:00 | SPY | ETF | 196.47 | 196.5 | 196.41 | 196.41 | 2800.0 |
| 2015-09-08 05:20:00 | SPY | ETF | 196.43 | 196.48 | 196.43 | 196.45 | 5580.0 |
| 2015-09-08 05:25:00 | SPY | ETF | 196.55 | 196.55 | 196.53 | 196.53 | 2650.0 |
| 2015-09-08 05:30:00 | SPY | ETF | 196.54 | 196.6 | 196.53 | 196.6 | 4125.0 |
| 2015-09-08 05:35:00 | SPY | ETF | 196.56 | 196.63 | 196.56 | 196.63 | 1220.0 |
| 2015-09-08 05:40:00 | SPY | ETF | 196.61 | 196.69 | 196.59 | 196.59 | 8175.0 |
| 2015-09-08 05:45:00 | SPY | ETF | 196.63 | 196.66 | 196.63 | 196.64 | 1650.0 |
| 2015-09-08 05:50:00 | SPY | ETF | 196.71 | 196.85 | 196.71 | 196.81 | 7460.0 |
| 2015-09-08 05:55:00 | SPY | ETF | 196.79 | 196.81 | 196.71 | 196.73 | 4605.0 |
| 2015-09-08 06:00:00 | SPY | ETF | 196.73 | 196.77 | 196.68 | 196.68 | 10850.0 |
| 2015-09-08 06:05:00 | SPY | ETF | 196.66 | 196.67 | 196.64 | 196.64 | 4500.0 |
| 2015-09-08 06:10:00 | SPY | ETF | 196.66 | 196.8 | 196.66 | 196.71 | 28735.0 |
| 2015-09-08 06:15:00 | SPY | ETF | 196.63 | 196.72 | 196.6 | 196.72 | 13200.0 |
| 2015-09-08 06:20:00 | SPY | ETF | 196.72 | 196.86 | 196.71 | 196.71 | 19505.0 |
| 2015-09-08 06:25:00 | SPY | ETF | 196.71 | 196.78 | 196.71 | 196.78 | 19000.0 |
| 2015-09-08 06:30:00 | SPY | ETF | 196.82 | 196.86 | 196.7 | 196.71 | 15700.0 |
| 2015-09-08 06:35:00 | SPY | ETF | 196.73 | 196.73 | 196.68 | 196.72 | 4920.0 |
| 2015-09-08 06:40:00 | SPY | ETF | 196.73 | 196.82 | 196.71 | 196.73 | 71820.0 |
| 2015-09-08 06:45:00 | SPY | ETF | 196.73 | 196.84 | 196.71 | 196.73 | 17615.0 |
| 2015-09-08 06:50:00 | SPY | ETF | 196.73 | 196.8 | 196.63 | 196.74 | 11672.0 |
| 2015-09-08 06:55:00 | SPY | ETF | 196.71 | 196.82 | 196.68 | 196.68 | 13030.0 |
| 2015-09-08 07:00:00 | SPY | ETF | 196.68 | 196.68 | 196.45 | 196.51 | 27662.0 |
| 2015-09-08 07:05:00 | SPY | ETF | 196.55 | 196.55 | 196.37 | 196.41 | 31057.0 |
| 2015-09-08 07:10:00 | SPY | ETF | 196.42 | 196.42 | 196.28 | 196.41 | 51651.0 |
| 2015-09-08 07:15:00 | SPY | ETF | 196.38 | 196.52 | 196.38 | 196.45 | 25640.0 |
| 2015-09-08 07:20:00 | SPY | ETF | 196.38 | 196.38 | 196.28 | 196.33 | 33130.0 |
| 2015-09-08 07:25:00 | SPY | ETF | 196.29 | 196.3 | 196.23 | 196.25 | 23790.0 |
| 2015-09-08 07:30:00 | SPY | ETF | 196.23 | 196.43 | 196.23 | 196.43 | 21244.0 |
| 2015-09-08 07:35:00 | SPY | ETF | 196.43 | 196.44 | 196.38 | 196.4 | 45734.0 |
| 2015-09-08 07:40:00 | SPY | ETF | 196.43 | 196.43 | 196.25 | 196.31 | 189217.0 |
| 2015-09-08 07:45:00 | SPY | ETF | 196.28 | 196.34 | 196.24 | 196.28 | 87103.0 |
| 2015-09-08 07:50:00 | SPY | ETF | 196.29 | 196.39 | 196.24 | 196.26 | 20371.0 |
| 2015-09-08 07:55:00 | SPY | ETF | 196.26 | 196.26 | 196.01 | 196.19 | 102603.0 |
| 2015-09-08 08:00:00 | SPY | ETF | 196.18 | 196.66 | 195.93 | 196.03 | 136875.0 |
| 2015-09-08 08:05:00 | SPY | ETF | 196.01 | 196.03 | 195.79 | 195.85 | 316864.0 |
| 2015-09-08 08:10:00 | SPY | ETF | 195.87 | 195.95 | 195.82 | 195.92 | 102121.0 |
> showing 50 of 48,207 rows — these rows as CSV