PREVIEW / etf_5min / 2016-02-12
file: by_date/etf_5min/2016/2016-02-12.parquet size: 1.2 MB rows: 52,733
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-02-12 04:00:00 | SPY | ETF | 184.35 | 184.45 | 184.1 | 184.1 | 17119.0 |
| 2016-02-12 04:05:00 | SPY | ETF | 184.22 | 184.45 | 184.21 | 184.45 | 1195.0 |
| 2016-02-12 04:10:00 | SPY | ETF | 184.46 | 184.52 | 184.41 | 184.5 | 1761.0 |
| 2016-02-12 04:15:00 | SPY | ETF | 184.48 | 184.7 | 184.48 | 184.7 | 1770.0 |
| 2016-02-12 04:20:00 | SPY | ETF | 184.84 | 184.85 | 184.47 | 184.47 | 2580.0 |
| 2016-02-12 04:25:00 | SPY | ETF | 184.54 | 184.61 | 184.53 | 184.54 | 3468.0 |
| 2016-02-12 04:30:00 | SPY | ETF | 184.61 | 184.77 | 184.61 | 184.77 | 3818.0 |
| 2016-02-12 04:35:00 | SPY | ETF | 184.62 | 184.62 | 184.39 | 184.39 | 1530.0 |
| 2016-02-12 04:40:00 | SPY | ETF | 184.47 | 184.58 | 184.32 | 184.32 | 3173.0 |
| 2016-02-12 04:45:00 | SPY | ETF | 184.3 | 184.48 | 184.23 | 184.38 | 7231.0 |
| 2016-02-12 04:50:00 | SPY | ETF | 184.46 | 184.47 | 184.33 | 184.33 | 2791.0 |
| 2016-02-12 04:55:00 | SPY | ETF | 184.58 | 184.58 | 184.54 | 184.54 | 319.0 |
| 2016-02-12 05:00:00 | SPY | ETF | 184.61 | 184.66 | 184.42 | 184.42 | 2269.0 |
| 2016-02-12 05:05:00 | SPY | ETF | 184.43 | 184.61 | 184.41 | 184.55 | 14315.0 |
| 2016-02-12 05:10:00 | SPY | ETF | 184.63 | 184.7 | 184.6 | 184.66 | 4560.0 |
| 2016-02-12 05:15:00 | SPY | ETF | 184.75 | 184.75 | 184.75 | 184.75 | 1000.0 |
| 2016-02-12 05:20:00 | SPY | ETF | 184.78 | 184.87 | 184.78 | 184.81 | 3419.0 |
| 2016-02-12 05:25:00 | SPY | ETF | 184.76 | 184.76 | 184.6 | 184.6 | 4337.0 |
| 2016-02-12 05:30:00 | SPY | ETF | 184.62 | 184.62 | 184.56 | 184.57 | 1448.0 |
| 2016-02-12 05:35:00 | SPY | ETF | 184.54 | 184.56 | 184.54 | 184.56 | 635.0 |
| 2016-02-12 05:40:00 | SPY | ETF | 184.5 | 184.5 | 184.44 | 184.49 | 6433.0 |
| 2016-02-12 05:45:00 | SPY | ETF | 184.41 | 184.41 | 184.33 | 184.38 | 6325.0 |
| 2016-02-12 05:50:00 | SPY | ETF | 184.49 | 184.52 | 184.38 | 184.41 | 3080.0 |
| 2016-02-12 05:55:00 | SPY | ETF | 184.36 | 184.44 | 184.35 | 184.39 | 2466.0 |
| 2016-02-12 06:00:00 | SPY | ETF | 184.35 | 184.48 | 184.35 | 184.48 | 4107.0 |
| 2016-02-12 06:05:00 | SPY | ETF | 184.46 | 184.53 | 184.46 | 184.53 | 5670.0 |
| 2016-02-12 06:10:00 | SPY | ETF | 184.41 | 184.48 | 184.41 | 184.48 | 720.0 |
| 2016-02-12 06:15:00 | SPY | ETF | 184.48 | 184.63 | 184.48 | 184.63 | 2489.0 |
| 2016-02-12 06:20:00 | SPY | ETF | 184.63 | 184.66 | 184.63 | 184.63 | 910.0 |
| 2016-02-12 06:25:00 | SPY | ETF | 184.56 | 184.61 | 184.56 | 184.61 | 365.0 |
| 2016-02-12 06:30:00 | SPY | ETF | 184.66 | 184.7 | 184.64 | 184.7 | 17530.0 |
| 2016-02-12 06:35:00 | SPY | ETF | 184.68 | 184.77 | 184.68 | 184.72 | 1161.0 |
| 2016-02-12 06:40:00 | SPY | ETF | 184.71 | 184.77 | 184.66 | 184.76 | 66505.0 |
| 2016-02-12 06:45:00 | SPY | ETF | 184.78 | 185.21 | 184.78 | 185.1 | 49515.0 |
| 2016-02-12 06:50:00 | SPY | ETF | 185.13 | 185.29 | 185.13 | 185.19 | 28255.0 |
| 2016-02-12 06:55:00 | SPY | ETF | 185.24 | 185.35 | 185.12 | 185.17 | 18660.0 |
| 2016-02-12 07:00:00 | SPY | ETF | 185.17 | 185.17 | 184.99 | 185.1 | 78892.0 |
| 2016-02-12 07:05:00 | SPY | ETF | 185.1 | 185.11 | 185.0 | 185.0 | 17290.0 |
| 2016-02-12 07:10:00 | SPY | ETF | 185.03 | 185.03 | 184.85 | 184.92 | 42493.0 |
| 2016-02-12 07:15:00 | SPY | ETF | 184.92 | 184.98 | 184.85 | 184.9 | 56923.0 |
| 2016-02-12 07:20:00 | SPY | ETF | 184.9 | 184.93 | 184.77 | 184.89 | 18600.0 |
| 2016-02-12 07:25:00 | SPY | ETF | 184.9 | 184.95 | 184.85 | 184.9 | 9294.0 |
| 2016-02-12 07:30:00 | SPY | ETF | 184.92 | 185.03 | 184.92 | 185.03 | 34606.0 |
| 2016-02-12 07:35:00 | SPY | ETF | 185.03 | 185.05 | 184.91 | 184.92 | 21124.0 |
| 2016-02-12 07:40:00 | SPY | ETF | 184.9 | 184.94 | 184.78 | 184.86 | 16236.0 |
| 2016-02-12 07:45:00 | SPY | ETF | 184.82 | 184.82 | 184.61 | 184.65 | 28178.0 |
| 2016-02-12 07:50:00 | SPY | ETF | 184.71 | 184.92 | 184.7 | 184.78 | 33882.0 |
| 2016-02-12 07:55:00 | SPY | ETF | 184.78 | 184.86 | 184.71 | 184.73 | 18245.0 |
| 2016-02-12 08:00:00 | SPY | ETF | 184.73 | 185.12 | 184.54 | 184.54 | 98836.0 |
| 2016-02-12 08:05:00 | SPY | ETF | 184.1 | 184.62 | 184.1 | 184.43 | 134552.0 |
> showing 50 of 52,733 rows — these rows as CSV