PREVIEW / etf_5min / 2018-11-16
file: by_date/etf_5min/2018/2018-11-16.parquet size: 1.4 MB rows: 60,758
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-16 04:10:00 | SPY | ETF | 272.45 | 272.45 | 272.45 | 272.45 | 110.0 |
| 2018-11-16 04:15:00 | SPY | ETF | 272.3 | 272.44 | 272.3 | 272.37 | 5302.0 |
| 2018-11-16 04:20:00 | SPY | ETF | 272.32 | 272.46 | 272.32 | 272.4 | 2305.0 |
| 2018-11-16 04:25:00 | SPY | ETF | 272.28 | 272.32 | 272.28 | 272.32 | 3025.0 |
| 2018-11-16 04:30:00 | SPY | ETF | 272.34 | 272.34 | 272.34 | 272.34 | 300.0 |
| 2018-11-16 04:35:00 | SPY | ETF | 272.35 | 272.45 | 272.35 | 272.45 | 3055.0 |
| 2018-11-16 04:40:00 | SPY | ETF | 272.5 | 272.59 | 272.5 | 272.59 | 3665.0 |
| 2018-11-16 04:50:00 | SPY | ETF | 272.47 | 272.47 | 272.47 | 272.47 | 100.0 |
| 2018-11-16 04:55:00 | SPY | ETF | 272.49 | 272.5 | 272.49 | 272.5 | 3000.0 |
| 2018-11-16 05:00:00 | SPY | ETF | 272.41 | 272.44 | 272.35 | 272.36 | 1469.0 |
| 2018-11-16 05:05:00 | SPY | ETF | 272.35 | 272.35 | 272.35 | 272.35 | 225.0 |
| 2018-11-16 05:10:00 | SPY | ETF | 272.36 | 272.4 | 272.3 | 272.3 | 2838.0 |
| 2018-11-16 05:15:00 | SPY | ETF | 272.28 | 272.28 | 272.1 | 272.16 | 2719.0 |
| 2018-11-16 05:20:00 | SPY | ETF | 272.15 | 272.15 | 272.04 | 272.12 | 569.0 |
| 2018-11-16 05:25:00 | SPY | ETF | 272.16 | 272.19 | 272.14 | 272.14 | 5800.0 |
| 2018-11-16 05:30:00 | SPY | ETF | 272.12 | 272.2 | 272.12 | 272.2 | 3949.0 |
| 2018-11-16 05:35:00 | SPY | ETF | 272.14 | 272.17 | 272.09 | 272.09 | 1369.0 |
| 2018-11-16 05:40:00 | SPY | ETF | 272.02 | 272.2 | 272.02 | 272.2 | 4038.0 |
| 2018-11-16 05:45:00 | SPY | ETF | 272.08 | 272.08 | 272.04 | 272.06 | 838.0 |
| 2018-11-16 05:50:00 | SPY | ETF | 272.0 | 272.0 | 271.9 | 271.96 | 5556.0 |
| 2018-11-16 05:55:00 | SPY | ETF | 271.96 | 272.0 | 271.95 | 272.0 | 3298.0 |
| 2018-11-16 06:00:00 | SPY | ETF | 271.97 | 271.97 | 271.97 | 271.97 | 1000.0 |
| 2018-11-16 06:05:00 | SPY | ETF | 271.92 | 271.92 | 271.76 | 271.76 | 638.0 |
| 2018-11-16 06:10:00 | SPY | ETF | 271.88 | 272.0 | 271.88 | 271.99 | 13476.0 |
| 2018-11-16 06:15:00 | SPY | ETF | 271.92 | 271.95 | 271.54 | 271.6 | 13425.0 |
| 2018-11-16 06:20:00 | SPY | ETF | 271.77 | 271.77 | 271.75 | 271.75 | 2200.0 |
| 2018-11-16 06:25:00 | SPY | ETF | 271.77 | 271.82 | 271.66 | 271.66 | 4863.0 |
| 2018-11-16 06:30:00 | SPY | ETF | 271.66 | 271.8 | 271.64 | 271.8 | 2076.0 |
| 2018-11-16 06:35:00 | SPY | ETF | 271.8 | 271.86 | 271.8 | 271.83 | 21674.0 |
| 2018-11-16 06:40:00 | SPY | ETF | 271.82 | 271.99 | 271.7 | 271.96 | 13722.0 |
| 2018-11-16 06:45:00 | SPY | ETF | 271.96 | 272.08 | 271.96 | 272.08 | 1579.0 |
| 2018-11-16 06:50:00 | SPY | ETF | 272.01 | 272.06 | 271.99 | 272.01 | 15668.0 |
| 2018-11-16 06:55:00 | SPY | ETF | 271.95 | 271.95 | 271.91 | 271.93 | 5869.0 |
| 2018-11-16 07:00:00 | SPY | ETF | 272.0 | 272.09 | 271.85 | 271.86 | 8969.0 |
| 2018-11-16 07:05:00 | SPY | ETF | 271.8 | 271.84 | 271.7 | 271.84 | 3860.0 |
| 2018-11-16 07:10:00 | SPY | ETF | 271.75 | 271.95 | 271.75 | 271.83 | 14739.0 |
| 2018-11-16 07:15:00 | SPY | ETF | 271.8 | 271.86 | 271.56 | 271.7 | 18463.0 |
| 2018-11-16 07:20:00 | SPY | ETF | 271.7 | 271.7 | 271.3 | 271.46 | 72634.0 |
| 2018-11-16 07:25:00 | SPY | ETF | 271.41 | 271.63 | 271.39 | 271.63 | 26838.0 |
| 2018-11-16 07:30:00 | SPY | ETF | 271.57 | 271.57 | 271.22 | 271.28 | 51810.0 |
| 2018-11-16 07:35:00 | SPY | ETF | 271.31 | 271.33 | 271.22 | 271.25 | 24104.0 |
| 2018-11-16 07:40:00 | SPY | ETF | 271.22 | 271.36 | 271.13 | 271.27 | 26446.0 |
| 2018-11-16 07:45:00 | SPY | ETF | 271.4 | 271.44 | 271.34 | 271.36 | 23971.0 |
| 2018-11-16 07:50:00 | SPY | ETF | 271.39 | 271.5 | 271.34 | 271.43 | 35039.0 |
| 2018-11-16 07:55:00 | SPY | ETF | 271.49 | 271.76 | 271.49 | 271.68 | 42731.0 |
| 2018-11-16 08:00:00 | SPY | ETF | 271.8301 | 272.54 | 271.2 | 271.5299 | 147580.0 |
| 2018-11-16 08:05:00 | SPY | ETF | 271.52 | 271.65 | 271.43 | 271.49 | 24791.0 |
| 2018-11-16 08:10:00 | SPY | ETF | 271.51 | 271.56 | 271.27 | 271.4 | 45518.0 |
| 2018-11-16 08:15:00 | SPY | ETF | 271.4 | 271.51 | 271.26 | 271.33 | 30695.0 |
| 2018-11-16 08:20:00 | SPY | ETF | 271.29 | 271.42 | 271.24 | 271.42 | 18345.0 |
> showing 50 of 60,758 rows — these rows as CSV