PREVIEW / etf_5min / 2018-11-28
file: by_date/etf_5min/2018/2018-11-28.parquet size: 1.5 MB rows: 64,654
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-28 04:05:00 | SPY | ETF | 268.84 | 268.95 | 268.84 | 268.95 | 250.0 |
| 2018-11-28 04:15:00 | SPY | ETF | 268.76 | 269.07 | 268.76 | 269.04 | 4955.0 |
| 2018-11-28 04:20:00 | SPY | ETF | 268.99 | 268.99 | 268.89 | 268.89 | 5500.0 |
| 2018-11-28 04:25:00 | SPY | ETF | 268.73 | 268.76 | 268.65 | 268.65 | 20180.0 |
| 2018-11-28 04:30:00 | SPY | ETF | 268.64 | 268.66 | 268.62 | 268.62 | 15100.0 |
| 2018-11-28 04:40:00 | SPY | ETF | 268.8 | 268.8 | 268.8 | 268.8 | 100.0 |
| 2018-11-28 04:50:00 | SPY | ETF | 268.97 | 268.99 | 268.97 | 268.99 | 1100.0 |
| 2018-11-28 04:55:00 | SPY | ETF | 268.99 | 268.99 | 268.87 | 268.87 | 3400.0 |
| 2018-11-28 05:05:00 | SPY | ETF | 268.77 | 268.77 | 268.77 | 268.77 | 1000.0 |
| 2018-11-28 05:10:00 | SPY | ETF | 268.94 | 268.94 | 268.87 | 268.87 | 1200.0 |
| 2018-11-28 05:15:00 | SPY | ETF | 268.87 | 268.87 | 268.87 | 268.87 | 200.0 |
| 2018-11-28 05:20:00 | SPY | ETF | 268.77 | 268.79 | 268.77 | 268.77 | 1500.0 |
| 2018-11-28 05:25:00 | SPY | ETF | 268.77 | 268.8 | 268.75 | 268.78 | 4700.0 |
| 2018-11-28 05:30:00 | SPY | ETF | 268.75 | 269.07 | 268.73 | 269.07 | 10300.0 |
| 2018-11-28 05:35:00 | SPY | ETF | 269.09 | 269.11 | 269.06 | 269.11 | 2500.0 |
| 2018-11-28 05:40:00 | SPY | ETF | 269.14 | 269.16 | 269.14 | 269.16 | 2450.0 |
| 2018-11-28 05:50:00 | SPY | ETF | 269.23 | 269.23 | 269.2 | 269.2 | 700.0 |
| 2018-11-28 05:55:00 | SPY | ETF | 269.24 | 269.24 | 269.24 | 269.24 | 100.0 |
| 2018-11-28 06:00:00 | SPY | ETF | 269.24 | 269.24 | 269.21 | 269.21 | 2660.0 |
| 2018-11-28 06:05:00 | SPY | ETF | 269.3 | 269.32 | 269.26 | 269.27 | 6800.0 |
| 2018-11-28 06:10:00 | SPY | ETF | 269.32 | 269.32 | 269.27 | 269.27 | 4920.0 |
| 2018-11-28 06:15:00 | SPY | ETF | 269.27 | 269.27 | 269.21 | 269.21 | 3190.0 |
| 2018-11-28 06:20:00 | SPY | ETF | 269.15 | 269.15 | 269.07 | 269.07 | 2595.0 |
| 2018-11-28 06:25:00 | SPY | ETF | 269.07 | 269.07 | 269.01 | 269.01 | 4400.0 |
| 2018-11-28 06:30:00 | SPY | ETF | 269.04 | 269.1 | 269.04 | 269.1 | 5200.0 |
| 2018-11-28 06:35:00 | SPY | ETF | 269.18 | 269.23 | 269.15 | 269.23 | 5103.0 |
| 2018-11-28 06:40:00 | SPY | ETF | 269.22 | 269.38 | 269.22 | 269.38 | 3897.0 |
| 2018-11-28 06:45:00 | SPY | ETF | 269.33 | 269.37 | 269.3 | 269.37 | 8950.0 |
| 2018-11-28 06:50:00 | SPY | ETF | 269.31 | 269.31 | 269.18 | 269.24 | 6890.0 |
| 2018-11-28 06:55:00 | SPY | ETF | 269.25 | 269.29 | 269.18 | 269.29 | 2200.0 |
| 2018-11-28 07:00:00 | SPY | ETF | 269.43 | 269.67 | 269.43 | 269.49 | 53806.0 |
| 2018-11-28 07:05:00 | SPY | ETF | 269.45 | 269.48 | 269.35 | 269.44 | 11980.0 |
| 2018-11-28 07:10:00 | SPY | ETF | 269.42 | 269.43 | 269.42 | 269.43 | 6975.0 |
| 2018-11-28 07:15:00 | SPY | ETF | 269.39 | 269.43 | 269.33 | 269.33 | 11942.0 |
| 2018-11-28 07:20:00 | SPY | ETF | 269.44 | 269.51 | 269.44 | 269.51 | 2491.0 |
| 2018-11-28 07:25:00 | SPY | ETF | 269.49 | 269.52 | 269.43 | 269.52 | 4353.0 |
| 2018-11-28 07:30:00 | SPY | ETF | 269.5 | 269.61 | 269.5 | 269.61 | 17133.0 |
| 2018-11-28 07:35:00 | SPY | ETF | 269.57 | 269.79 | 269.57 | 269.77 | 19351.0 |
| 2018-11-28 07:40:00 | SPY | ETF | 269.74 | 269.74 | 269.72 | 269.72 | 13625.0 |
| 2018-11-28 07:45:00 | SPY | ETF | 269.7 | 269.7 | 269.65 | 269.7 | 48590.0 |
| 2018-11-28 07:50:00 | SPY | ETF | 269.7 | 269.8 | 269.65 | 269.65 | 35511.0 |
| 2018-11-28 07:55:00 | SPY | ETF | 269.63 | 269.7 | 269.62 | 269.67 | 7686.0 |
| 2018-11-28 08:00:00 | SPY | ETF | 269.61 | 269.75 | 268.7 | 269.67 | 28462.0 |
| 2018-11-28 08:05:00 | SPY | ETF | 269.69 | 269.74 | 269.63 | 269.73 | 31589.0 |
| 2018-11-28 08:10:00 | SPY | ETF | 269.72 | 269.73 | 269.55 | 269.64 | 12798.0 |
| 2018-11-28 08:15:00 | SPY | ETF | 269.64 | 269.64 | 269.56 | 269.56 | 23155.0 |
| 2018-11-28 08:20:00 | SPY | ETF | 269.64 | 269.74 | 269.64 | 269.74 | 11686.0 |
| 2018-11-28 08:25:00 | SPY | ETF | 269.74 | 269.78 | 269.65 | 269.72 | 87513.0 |
| 2018-11-28 08:30:00 | SPY | ETF | 269.75 | 269.78 | 269.62 | 269.77 | 74864.0 |
| 2018-11-28 08:35:00 | SPY | ETF | 269.75 | 269.76 | 269.56 | 269.59 | 18124.0 |
> showing 50 of 64,654 rows — these rows as CSV