PREVIEW / etf_5min / 2018-10-22
file: by_date/etf_5min/2018/2018-10-22.parquet size: 1.4 MB rows: 60,100
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-10-22 04:00:00 | SPY | ETF | 276.76 | 276.91 | 276.76 | 276.8 | 12606.0 |
| 2018-10-22 04:05:00 | SPY | ETF | 276.76 | 276.76 | 276.58 | 276.64 | 15889.0 |
| 2018-10-22 04:10:00 | SPY | ETF | 276.62 | 276.75 | 276.62 | 276.75 | 11540.0 |
| 2018-10-22 04:15:00 | SPY | ETF | 276.73 | 276.73 | 276.55 | 276.57 | 6369.0 |
| 2018-10-22 04:20:00 | SPY | ETF | 276.51 | 276.51 | 276.35 | 276.41 | 5560.0 |
| 2018-10-22 04:25:00 | SPY | ETF | 276.41 | 276.41 | 276.35 | 276.35 | 4400.0 |
| 2018-10-22 04:30:00 | SPY | ETF | 276.49 | 276.5 | 276.49 | 276.49 | 10200.0 |
| 2018-10-22 04:35:00 | SPY | ETF | 276.5 | 276.61 | 276.5 | 276.59 | 10230.0 |
| 2018-10-22 04:40:00 | SPY | ETF | 276.58 | 276.58 | 276.45 | 276.46 | 3260.0 |
| 2018-10-22 04:45:00 | SPY | ETF | 276.4 | 276.4 | 276.27 | 276.27 | 4765.0 |
| 2018-10-22 04:50:00 | SPY | ETF | 276.35 | 276.45 | 276.34 | 276.44 | 3850.0 |
| 2018-10-22 04:55:00 | SPY | ETF | 276.42 | 276.44 | 276.35 | 276.41 | 3100.0 |
| 2018-10-22 05:00:00 | SPY | ETF | 276.45 | 276.54 | 276.45 | 276.54 | 4100.0 |
| 2018-10-22 05:05:00 | SPY | ETF | 276.55 | 276.61 | 276.55 | 276.55 | 3300.0 |
| 2018-10-22 05:10:00 | SPY | ETF | 276.52 | 276.75 | 276.52 | 276.75 | 6234.0 |
| 2018-10-22 05:15:00 | SPY | ETF | 276.75 | 276.76 | 276.69 | 276.74 | 10700.0 |
| 2018-10-22 05:20:00 | SPY | ETF | 276.75 | 276.77 | 276.7 | 276.7 | 4650.0 |
| 2018-10-22 05:25:00 | SPY | ETF | 276.7 | 276.7 | 276.6 | 276.6 | 15270.0 |
| 2018-10-22 05:30:00 | SPY | ETF | 276.6 | 276.65 | 276.59 | 276.65 | 5700.0 |
| 2018-10-22 05:35:00 | SPY | ETF | 276.64 | 276.65 | 276.6 | 276.65 | 6840.0 |
| 2018-10-22 05:40:00 | SPY | ETF | 276.63 | 276.63 | 276.55 | 276.57 | 3210.0 |
| 2018-10-22 05:45:00 | SPY | ETF | 276.6 | 276.6 | 276.45 | 276.45 | 6775.0 |
| 2018-10-22 05:50:00 | SPY | ETF | 276.4 | 276.47 | 276.4 | 276.43 | 2506.0 |
| 2018-10-22 05:55:00 | SPY | ETF | 276.4 | 276.4 | 276.25 | 276.3 | 7617.0 |
| 2018-10-22 06:00:00 | SPY | ETF | 276.3 | 276.38 | 276.26 | 276.35 | 7450.0 |
| 2018-10-22 06:05:00 | SPY | ETF | 276.4 | 276.4 | 276.19 | 276.19 | 11685.0 |
| 2018-10-22 06:10:00 | SPY | ETF | 276.16 | 276.5 | 276.16 | 276.48 | 21100.0 |
| 2018-10-22 06:15:00 | SPY | ETF | 276.48 | 276.6 | 276.48 | 276.6 | 9600.0 |
| 2018-10-22 06:20:00 | SPY | ETF | 276.58 | 276.62 | 276.55 | 276.57 | 2400.0 |
| 2018-10-22 06:25:00 | SPY | ETF | 276.59 | 276.85 | 276.59 | 276.85 | 16615.0 |
| 2018-10-22 06:30:00 | SPY | ETF | 276.81 | 276.84 | 276.7 | 276.7 | 19000.0 |
| 2018-10-22 06:35:00 | SPY | ETF | 276.7 | 276.75 | 276.7 | 276.74 | 1300.0 |
| 2018-10-22 06:40:00 | SPY | ETF | 276.75 | 276.8 | 276.65 | 276.65 | 8495.0 |
| 2018-10-22 06:45:00 | SPY | ETF | 276.66 | 276.78 | 276.6 | 276.7 | 18245.0 |
| 2018-10-22 06:50:00 | SPY | ETF | 276.68 | 276.86 | 276.68 | 276.86 | 10200.0 |
| 2018-10-22 06:55:00 | SPY | ETF | 276.86 | 277.01 | 276.86 | 276.97 | 33860.0 |
| 2018-10-22 07:00:00 | SPY | ETF | 276.93 | 276.93 | 276.86 | 276.9 | 9298.0 |
| 2018-10-22 07:05:00 | SPY | ETF | 276.88 | 277.04 | 276.86 | 277.04 | 14405.0 |
| 2018-10-22 07:10:00 | SPY | ETF | 277.04 | 277.05 | 276.93 | 277.05 | 45306.0 |
| 2018-10-22 07:15:00 | SPY | ETF | 277.04 | 277.04 | 276.97 | 277.02 | 23894.0 |
| 2018-10-22 07:20:00 | SPY | ETF | 277.02 | 277.14 | 276.99 | 276.99 | 61501.0 |
| 2018-10-22 07:25:00 | SPY | ETF | 277.01 | 277.07 | 276.99 | 277.07 | 36510.0 |
| 2018-10-22 07:30:00 | SPY | ETF | 277.06 | 277.18 | 277.06 | 277.13 | 10680.0 |
| 2018-10-22 07:35:00 | SPY | ETF | 277.1 | 277.16 | 277.08 | 277.12 | 12040.0 |
| 2018-10-22 07:40:00 | SPY | ETF | 277.19 | 277.38 | 277.19 | 277.34 | 50010.0 |
| 2018-10-22 07:45:00 | SPY | ETF | 277.36 | 277.44 | 277.35 | 277.38 | 34126.0 |
| 2018-10-22 07:50:00 | SPY | ETF | 277.38 | 277.47 | 277.38 | 277.45 | 12735.0 |
| 2018-10-22 07:55:00 | SPY | ETF | 277.4 | 277.42 | 277.18 | 277.18 | 36026.0 |
| 2018-10-22 08:00:00 | SPY | ETF | 277.21 | 277.47 | 276.25 | 277.15 | 93231.0 |
| 2018-10-22 08:05:00 | SPY | ETF | 277.15 | 277.22 | 276.76 | 277.15 | 38087.0 |
> showing 50 of 60,100 rows — these rows as CSV