PREVIEW / etf_5min / 2018-02-15
file: by_date/etf_5min/2018/2018-02-15.parquet size: 1.5 MB rows: 63,330
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-02-15 04:00:00 | SPY | ETF | 271.18 | 271.47 | 271.18 | 271.21 | 7860.0 |
| 2018-02-15 04:05:00 | SPY | ETF | 271.23 | 271.28 | 271.23 | 271.28 | 657.0 |
| 2018-02-15 04:10:00 | SPY | ETF | 271.25 | 271.31 | 271.25 | 271.31 | 5240.0 |
| 2018-02-15 04:15:00 | SPY | ETF | 271.3 | 271.32 | 271.3 | 271.3 | 2900.0 |
| 2018-02-15 04:20:00 | SPY | ETF | 271.25 | 271.6 | 271.25 | 271.59 | 5132.0 |
| 2018-02-15 04:25:00 | SPY | ETF | 271.59 | 271.68 | 271.59 | 271.63 | 8100.0 |
| 2018-02-15 04:30:00 | SPY | ETF | 271.67 | 271.73 | 271.66 | 271.72 | 2760.0 |
| 2018-02-15 04:35:00 | SPY | ETF | 271.7 | 271.79 | 271.7 | 271.72 | 2650.0 |
| 2018-02-15 04:40:00 | SPY | ETF | 271.79 | 271.79 | 271.67 | 271.72 | 3650.0 |
| 2018-02-15 04:45:00 | SPY | ETF | 271.66 | 271.68 | 271.66 | 271.68 | 1450.0 |
| 2018-02-15 04:50:00 | SPY | ETF | 271.76 | 271.77 | 271.72 | 271.77 | 4500.0 |
| 2018-02-15 04:55:00 | SPY | ETF | 271.73 | 271.74 | 271.68 | 271.74 | 8901.0 |
| 2018-02-15 05:00:00 | SPY | ETF | 271.7 | 271.72 | 271.65 | 271.65 | 1815.0 |
| 2018-02-15 05:05:00 | SPY | ETF | 271.67 | 271.67 | 271.65 | 271.65 | 6205.0 |
| 2018-02-15 05:10:00 | SPY | ETF | 271.62 | 271.72 | 271.62 | 271.72 | 2669.0 |
| 2018-02-15 05:15:00 | SPY | ETF | 271.75 | 271.75 | 271.75 | 271.75 | 400.0 |
| 2018-02-15 05:20:00 | SPY | ETF | 271.7 | 271.75 | 271.67 | 271.69 | 2432.0 |
| 2018-02-15 05:25:00 | SPY | ETF | 271.72 | 271.74 | 271.69 | 271.69 | 900.0 |
| 2018-02-15 05:35:00 | SPY | ETF | 271.55 | 271.55 | 271.53 | 271.53 | 1683.0 |
| 2018-02-15 05:45:00 | SPY | ETF | 271.54 | 271.59 | 271.45 | 271.59 | 1025.0 |
| 2018-02-15 05:50:00 | SPY | ETF | 271.54 | 271.54 | 271.4 | 271.4 | 3500.0 |
| 2018-02-15 06:00:00 | SPY | ETF | 271.41 | 271.46 | 271.35 | 271.35 | 9699.0 |
| 2018-02-15 06:05:00 | SPY | ETF | 271.32 | 271.32 | 271.12 | 271.15 | 10612.0 |
| 2018-02-15 06:10:00 | SPY | ETF | 271.15 | 271.29 | 271.15 | 271.29 | 1700.0 |
| 2018-02-15 06:15:00 | SPY | ETF | 271.27 | 271.27 | 270.94 | 270.94 | 2229.0 |
| 2018-02-15 06:20:00 | SPY | ETF | 270.82 | 271.04 | 270.82 | 271.0 | 7619.0 |
| 2018-02-15 06:25:00 | SPY | ETF | 271.0 | 271.07 | 270.96 | 271.05 | 19427.0 |
| 2018-02-15 06:30:00 | SPY | ETF | 271.0 | 271.0 | 270.97 | 271.0 | 1500.0 |
| 2018-02-15 06:35:00 | SPY | ETF | 270.96 | 270.98 | 270.82 | 270.84 | 14917.0 |
| 2018-02-15 06:40:00 | SPY | ETF | 270.85 | 270.98 | 270.84 | 270.98 | 3747.0 |
| 2018-02-15 06:45:00 | SPY | ETF | 271.01 | 271.01 | 270.69 | 270.82 | 13329.0 |
| 2018-02-15 06:50:00 | SPY | ETF | 270.81 | 270.96 | 270.8 | 270.96 | 5819.0 |
| 2018-02-15 06:55:00 | SPY | ETF | 270.96 | 270.96 | 270.84 | 270.92 | 8373.0 |
| 2018-02-15 07:00:00 | SPY | ETF | 270.92 | 271.1 | 270.89 | 271.1 | 24279.0 |
| 2018-02-15 07:05:00 | SPY | ETF | 271.1 | 271.18 | 271.09 | 271.12 | 11930.0 |
| 2018-02-15 07:10:00 | SPY | ETF | 271.11 | 271.19 | 271.11 | 271.16 | 7626.0 |
| 2018-02-15 07:15:00 | SPY | ETF | 271.15 | 271.19 | 271.12 | 271.16 | 11848.0 |
| 2018-02-15 07:20:00 | SPY | ETF | 271.12 | 271.13 | 270.96 | 270.96 | 13219.0 |
| 2018-02-15 07:25:00 | SPY | ETF | 270.96 | 271.0 | 270.89 | 270.95 | 35242.0 |
| 2018-02-15 07:30:00 | SPY | ETF | 270.95 | 270.95 | 270.7 | 270.72 | 24313.0 |
| 2018-02-15 07:35:00 | SPY | ETF | 270.72 | 270.79 | 270.68 | 270.7 | 37970.0 |
| 2018-02-15 07:40:00 | SPY | ETF | 270.7 | 270.8 | 270.62 | 270.62 | 17507.0 |
| 2018-02-15 07:45:00 | SPY | ETF | 270.67 | 270.67 | 270.45 | 270.55 | 16220.0 |
| 2018-02-15 07:50:00 | SPY | ETF | 270.56 | 270.58 | 270.47 | 270.58 | 19215.0 |
| 2018-02-15 07:55:00 | SPY | ETF | 270.58 | 270.65 | 270.5 | 270.65 | 40303.0 |
| 2018-02-15 08:00:00 | SPY | ETF | 270.63 | 271.43 | 270.44 | 270.65 | 167106.0 |
| 2018-02-15 08:05:00 | SPY | ETF | 270.67 | 270.67 | 270.58 | 270.59 | 32575.0 |
| 2018-02-15 08:10:00 | SPY | ETF | 270.62 | 270.65 | 270.54 | 270.65 | 18993.0 |
| 2018-02-15 08:15:00 | SPY | ETF | 270.67 | 270.81 | 270.67 | 270.81 | 23109.0 |
| 2018-02-15 08:20:00 | SPY | ETF | 270.8 | 270.82 | 270.71 | 270.71 | 133146.0 |
> showing 50 of 63,330 rows — these rows as CSV