PREVIEW / etf_5min / 2016-01-25
file: by_date/etf_5min/2016/2016-01-25.parquet size: 1.2 MB rows: 50,326
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-25 04:00:00 | SPY | ETF | 189.7 | 189.71 | 189.37 | 189.42 | 6509.0 |
| 2016-01-25 04:05:00 | SPY | ETF | 189.56 | 189.61 | 189.55 | 189.61 | 1720.0 |
| 2016-01-25 04:10:00 | SPY | ETF | 189.81 | 189.81 | 189.79 | 189.79 | 460.0 |
| 2016-01-25 04:15:00 | SPY | ETF | 189.87 | 189.9 | 189.71 | 189.71 | 896.0 |
| 2016-01-25 04:20:00 | SPY | ETF | 189.66 | 189.7 | 189.66 | 189.7 | 205.0 |
| 2016-01-25 04:25:00 | SPY | ETF | 189.74 | 189.92 | 189.7 | 189.92 | 3700.0 |
| 2016-01-25 04:30:00 | SPY | ETF | 189.77 | 189.84 | 189.73 | 189.84 | 340.0 |
| 2016-01-25 04:35:00 | SPY | ETF | 189.87 | 190.04 | 189.87 | 190.04 | 785.0 |
| 2016-01-25 04:40:00 | SPY | ETF | 190.02 | 190.18 | 190.02 | 190.17 | 800.0 |
| 2016-01-25 04:45:00 | SPY | ETF | 190.07 | 190.07 | 190.07 | 190.07 | 190.0 |
| 2016-01-25 04:50:00 | SPY | ETF | 189.87 | 189.87 | 189.87 | 189.87 | 305.0 |
| 2016-01-25 05:00:00 | SPY | ETF | 189.99 | 190.02 | 189.99 | 190.02 | 200.0 |
| 2016-01-25 05:05:00 | SPY | ETF | 189.99 | 189.99 | 189.82 | 189.83 | 601.0 |
| 2016-01-25 05:10:00 | SPY | ETF | 190.0 | 190.0 | 189.99 | 189.99 | 200.0 |
| 2016-01-25 05:15:00 | SPY | ETF | 189.97 | 190.06 | 189.97 | 190.06 | 300.0 |
| 2016-01-25 05:20:00 | SPY | ETF | 190.28 | 190.32 | 190.21 | 190.21 | 830.0 |
| 2016-01-25 05:25:00 | SPY | ETF | 190.34 | 190.5 | 190.34 | 190.44 | 6251.0 |
| 2016-01-25 05:30:00 | SPY | ETF | 190.38 | 190.38 | 190.33 | 190.33 | 800.0 |
| 2016-01-25 05:35:00 | SPY | ETF | 190.32 | 190.32 | 190.32 | 190.32 | 100.0 |
| 2016-01-25 05:45:00 | SPY | ETF | 190.12 | 190.12 | 190.12 | 190.12 | 200.0 |
| 2016-01-25 05:50:00 | SPY | ETF | 190.24 | 190.32 | 190.24 | 190.3 | 1950.0 |
| 2016-01-25 05:55:00 | SPY | ETF | 190.22 | 190.22 | 190.22 | 190.22 | 400.0 |
| 2016-01-25 06:00:00 | SPY | ETF | 190.13 | 190.29 | 190.13 | 190.18 | 1110.0 |
| 2016-01-25 06:05:00 | SPY | ETF | 190.05 | 190.05 | 190.02 | 190.02 | 1505.0 |
| 2016-01-25 06:10:00 | SPY | ETF | 190.02 | 190.04 | 190.0 | 190.04 | 1455.0 |
| 2016-01-25 06:15:00 | SPY | ETF | 190.05 | 190.05 | 190.05 | 190.05 | 500.0 |
| 2016-01-25 06:25:00 | SPY | ETF | 190.06 | 190.13 | 190.06 | 190.13 | 6200.0 |
| 2016-01-25 06:30:00 | SPY | ETF | 190.04 | 190.07 | 189.97 | 190.07 | 6850.0 |
| 2016-01-25 06:35:00 | SPY | ETF | 190.03 | 190.03 | 189.88 | 189.9 | 9930.0 |
| 2016-01-25 06:40:00 | SPY | ETF | 189.9 | 189.99 | 189.84 | 189.91 | 2376.0 |
| 2016-01-25 06:45:00 | SPY | ETF | 189.91 | 189.94 | 189.85 | 189.85 | 4400.0 |
| 2016-01-25 06:50:00 | SPY | ETF | 189.91 | 189.92 | 189.91 | 189.92 | 3000.0 |
| 2016-01-25 06:55:00 | SPY | ETF | 190.0 | 190.12 | 190.0 | 190.08 | 9236.0 |
| 2016-01-25 07:00:00 | SPY | ETF | 190.09 | 190.12 | 190.01 | 190.03 | 10945.0 |
| 2016-01-25 07:05:00 | SPY | ETF | 190.09 | 190.16 | 190.07 | 190.09 | 7818.0 |
| 2016-01-25 07:10:00 | SPY | ETF | 190.1 | 190.18 | 190.1 | 190.15 | 1800.0 |
| 2016-01-25 07:15:00 | SPY | ETF | 190.2 | 190.35 | 190.2 | 190.35 | 39930.0 |
| 2016-01-25 07:20:00 | SPY | ETF | 190.37 | 190.37 | 190.22 | 190.22 | 33590.0 |
| 2016-01-25 07:25:00 | SPY | ETF | 190.27 | 190.27 | 190.15 | 190.15 | 10310.0 |
| 2016-01-25 07:30:00 | SPY | ETF | 190.17 | 190.23 | 190.14 | 190.23 | 1570.0 |
| 2016-01-25 07:35:00 | SPY | ETF | 190.25 | 190.25 | 190.21 | 190.23 | 2200.0 |
| 2016-01-25 07:40:00 | SPY | ETF | 190.27 | 190.27 | 190.15 | 190.15 | 10600.0 |
| 2016-01-25 07:45:00 | SPY | ETF | 190.14 | 190.21 | 190.11 | 190.15 | 13400.0 |
| 2016-01-25 07:50:00 | SPY | ETF | 190.19 | 190.25 | 190.19 | 190.25 | 21339.0 |
| 2016-01-25 07:55:00 | SPY | ETF | 190.23 | 190.32 | 190.23 | 190.31 | 12900.0 |
| 2016-01-25 08:00:00 | SPY | ETF | 190.28 | 190.3 | 189.98 | 190.0 | 79920.0 |
| 2016-01-25 08:05:00 | SPY | ETF | 189.99 | 190.01 | 189.81 | 189.85 | 101779.0 |
| 2016-01-25 08:10:00 | SPY | ETF | 189.86 | 189.86 | 189.76 | 189.76 | 58837.0 |
| 2016-01-25 08:15:00 | SPY | ETF | 189.79 | 189.85 | 189.7 | 189.71 | 39998.0 |
| 2016-01-25 08:20:00 | SPY | ETF | 189.78 | 189.8 | 189.69 | 189.8 | 43542.0 |
> showing 50 of 50,326 rows — these rows as CSV