PREVIEW / etf_5min / 2016-01-13
file: by_date/etf_5min/2016/2016-01-13.parquet size: 1.3 MB rows: 53,825
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-13 04:00:00 | SPY | ETF | 194.82 | 194.94 | 194.69 | 194.74 | 131920.0 |
| 2016-01-13 04:05:00 | SPY | ETF | 194.81 | 194.92 | 194.77 | 194.92 | 4910.0 |
| 2016-01-13 04:10:00 | SPY | ETF | 194.98 | 195.06 | 194.89 | 194.89 | 2285.0 |
| 2016-01-13 04:15:00 | SPY | ETF | 194.93 | 194.93 | 194.78 | 194.89 | 6500.0 |
| 2016-01-13 04:20:00 | SPY | ETF | 194.93 | 195.01 | 194.82 | 194.9 | 2550.0 |
| 2016-01-13 04:25:00 | SPY | ETF | 194.89 | 195.07 | 194.89 | 195.0 | 9972.0 |
| 2016-01-13 04:30:00 | SPY | ETF | 194.99 | 194.99 | 194.77 | 194.85 | 1650.0 |
| 2016-01-13 04:35:00 | SPY | ETF | 194.94 | 194.94 | 194.76 | 194.76 | 2600.0 |
| 2016-01-13 04:40:00 | SPY | ETF | 194.72 | 194.74 | 194.68 | 194.68 | 2225.0 |
| 2016-01-13 04:45:00 | SPY | ETF | 194.66 | 194.83 | 194.66 | 194.82 | 3125.0 |
| 2016-01-13 04:50:00 | SPY | ETF | 194.74 | 194.74 | 194.65 | 194.65 | 1502.0 |
| 2016-01-13 04:55:00 | SPY | ETF | 194.64 | 194.64 | 194.5 | 194.51 | 6050.0 |
| 2016-01-13 05:00:00 | SPY | ETF | 194.53 | 194.58 | 194.51 | 194.58 | 720.0 |
| 2016-01-13 05:05:00 | SPY | ETF | 194.52 | 194.58 | 194.4 | 194.55 | 5265.0 |
| 2016-01-13 05:10:00 | SPY | ETF | 194.6 | 194.65 | 194.58 | 194.58 | 1600.0 |
| 2016-01-13 05:15:00 | SPY | ETF | 194.58 | 194.58 | 194.51 | 194.51 | 5300.0 |
| 2016-01-13 05:20:00 | SPY | ETF | 194.46 | 194.46 | 194.36 | 194.36 | 3900.0 |
| 2016-01-13 05:25:00 | SPY | ETF | 194.41 | 194.48 | 194.41 | 194.46 | 6900.0 |
| 2016-01-13 05:30:00 | SPY | ETF | 194.48 | 194.58 | 194.48 | 194.55 | 1800.0 |
| 2016-01-13 05:35:00 | SPY | ETF | 194.53 | 194.54 | 194.53 | 194.53 | 500.0 |
| 2016-01-13 05:40:00 | SPY | ETF | 194.5 | 194.66 | 194.5 | 194.6 | 2505.0 |
| 2016-01-13 05:45:00 | SPY | ETF | 194.7 | 194.71 | 194.58 | 194.58 | 1300.0 |
| 2016-01-13 05:50:00 | SPY | ETF | 194.53 | 194.57 | 194.49 | 194.49 | 1025.0 |
| 2016-01-13 05:55:00 | SPY | ETF | 194.46 | 194.52 | 194.39 | 194.52 | 2100.0 |
| 2016-01-13 06:00:00 | SPY | ETF | 194.46 | 194.46 | 194.2 | 194.2 | 6879.0 |
| 2016-01-13 06:05:00 | SPY | ETF | 194.26 | 194.31 | 194.2 | 194.27 | 4900.0 |
| 2016-01-13 06:10:00 | SPY | ETF | 194.29 | 194.31 | 194.24 | 194.24 | 2600.0 |
| 2016-01-13 06:15:00 | SPY | ETF | 194.26 | 194.41 | 194.26 | 194.38 | 11900.0 |
| 2016-01-13 06:20:00 | SPY | ETF | 194.39 | 194.39 | 194.25 | 194.3 | 1861.0 |
| 2016-01-13 06:25:00 | SPY | ETF | 194.32 | 194.34 | 194.32 | 194.34 | 600.0 |
| 2016-01-13 06:30:00 | SPY | ETF | 194.24 | 194.24 | 194.08 | 194.12 | 4252.0 |
| 2016-01-13 06:35:00 | SPY | ETF | 194.13 | 194.13 | 193.97 | 194.07 | 10445.0 |
| 2016-01-13 06:40:00 | SPY | ETF | 194.09 | 194.2 | 194.09 | 194.19 | 13427.0 |
| 2016-01-13 06:45:00 | SPY | ETF | 194.14 | 194.14 | 194.1 | 194.1 | 1300.0 |
| 2016-01-13 06:50:00 | SPY | ETF | 194.18 | 194.24 | 194.08 | 194.24 | 61604.0 |
| 2016-01-13 06:55:00 | SPY | ETF | 194.2 | 194.21 | 194.05 | 194.11 | 61015.0 |
| 2016-01-13 07:00:00 | SPY | ETF | 194.13 | 194.14 | 194.04 | 194.08 | 17105.0 |
| 2016-01-13 07:05:00 | SPY | ETF | 194.05 | 194.17 | 194.05 | 194.17 | 1700.0 |
| 2016-01-13 07:10:00 | SPY | ETF | 194.2 | 194.31 | 194.14 | 194.3 | 58285.0 |
| 2016-01-13 07:15:00 | SPY | ETF | 194.31 | 194.33 | 194.27 | 194.3 | 62436.0 |
| 2016-01-13 07:20:00 | SPY | ETF | 194.29 | 194.29 | 194.2 | 194.27 | 59100.0 |
| 2016-01-13 07:25:00 | SPY | ETF | 194.3 | 194.41 | 194.28 | 194.29 | 43913.0 |
| 2016-01-13 07:30:00 | SPY | ETF | 194.31 | 194.33 | 194.24 | 194.27 | 56657.0 |
| 2016-01-13 07:35:00 | SPY | ETF | 194.28 | 194.32 | 194.18 | 194.22 | 117810.0 |
| 2016-01-13 07:40:00 | SPY | ETF | 194.2 | 194.2 | 194.04 | 194.07 | 27875.0 |
| 2016-01-13 07:45:00 | SPY | ETF | 194.09 | 194.16 | 194.08 | 194.15 | 24430.0 |
| 2016-01-13 07:50:00 | SPY | ETF | 194.14 | 194.24 | 193.96 | 193.96 | 32067.0 |
| 2016-01-13 07:55:00 | SPY | ETF | 193.99 | 194.1 | 193.99 | 194.05 | 109617.0 |
| 2016-01-13 08:00:00 | SPY | ETF | 195.44 | 195.44 | 193.91 | 193.99 | 166663.0 |
| 2016-01-13 08:05:00 | SPY | ETF | 194.485 | 194.485 | 193.8 | 194.01 | 253254.0 |
> showing 50 of 53,825 rows — these rows as CSV