PREVIEW / etf_5min / 2018-03-28
file: by_date/etf_5min/2018/2018-03-28.parquet size: 1.4 MB rows: 60,094
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-03-28 04:00:00 | SPY | ETF | 259.61 | 259.97 | 259.61 | 259.96 | 44875.0 |
| 2018-03-28 04:05:00 | SPY | ETF | 259.82 | 259.88 | 259.32 | 259.71 | 11610.0 |
| 2018-03-28 04:10:00 | SPY | ETF | 259.78 | 260.06 | 259.53 | 260.02 | 11723.0 |
| 2018-03-28 04:15:00 | SPY | ETF | 260.1 | 260.4 | 260.1 | 260.4 | 23455.0 |
| 2018-03-28 04:20:00 | SPY | ETF | 260.36 | 260.41 | 260.18 | 260.18 | 18850.0 |
| 2018-03-28 04:25:00 | SPY | ETF | 260.34 | 260.53 | 260.32 | 260.38 | 6670.0 |
| 2018-03-28 04:30:00 | SPY | ETF | 260.46 | 260.47 | 260.41 | 260.47 | 1725.0 |
| 2018-03-28 04:35:00 | SPY | ETF | 260.16 | 260.16 | 259.93 | 259.93 | 1215.0 |
| 2018-03-28 04:40:00 | SPY | ETF | 259.72 | 259.77 | 259.71 | 259.77 | 21171.0 |
| 2018-03-28 04:45:00 | SPY | ETF | 259.79 | 259.84 | 259.74 | 259.83 | 2641.0 |
| 2018-03-28 04:50:00 | SPY | ETF | 259.94 | 260.22 | 259.94 | 260.22 | 4100.0 |
| 2018-03-28 04:55:00 | SPY | ETF | 260.04 | 260.04 | 259.81 | 259.81 | 3000.0 |
| 2018-03-28 05:00:00 | SPY | ETF | 259.82 | 259.85 | 259.81 | 259.82 | 6727.0 |
| 2018-03-28 05:05:00 | SPY | ETF | 260.02 | 260.03 | 260.0 | 260.0 | 3100.0 |
| 2018-03-28 05:10:00 | SPY | ETF | 259.91 | 259.99 | 259.91 | 259.99 | 1200.0 |
| 2018-03-28 05:15:00 | SPY | ETF | 259.86 | 259.86 | 259.74 | 259.74 | 1509.0 |
| 2018-03-28 05:20:00 | SPY | ETF | 259.63 | 260.04 | 259.49 | 260.04 | 2643.0 |
| 2018-03-28 05:25:00 | SPY | ETF | 259.98 | 260.1 | 259.91 | 260.02 | 1920.0 |
| 2018-03-28 05:30:00 | SPY | ETF | 260.04 | 260.24 | 260.04 | 260.17 | 2618.0 |
| 2018-03-28 05:35:00 | SPY | ETF | 260.21 | 260.21 | 259.96 | 260.0 | 2100.0 |
| 2018-03-28 05:40:00 | SPY | ETF | 260.0 | 260.07 | 259.89 | 260.07 | 1174.0 |
| 2018-03-28 05:45:00 | SPY | ETF | 260.36 | 260.36 | 260.19 | 260.19 | 1700.0 |
| 2018-03-28 05:50:00 | SPY | ETF | 260.1 | 260.27 | 260.1 | 260.24 | 2847.0 |
| 2018-03-28 05:55:00 | SPY | ETF | 260.07 | 260.07 | 260.07 | 260.07 | 200.0 |
| 2018-03-28 06:00:00 | SPY | ETF | 260.22 | 260.33 | 260.21 | 260.33 | 1010.0 |
| 2018-03-28 06:05:00 | SPY | ETF | 260.4 | 260.46 | 260.19 | 260.19 | 8255.0 |
| 2018-03-28 06:10:00 | SPY | ETF | 260.08 | 260.14 | 260.07 | 260.14 | 1708.0 |
| 2018-03-28 06:15:00 | SPY | ETF | 260.46 | 260.46 | 260.26 | 260.27 | 900.0 |
| 2018-03-28 06:20:00 | SPY | ETF | 260.43 | 260.61 | 260.43 | 260.61 | 4909.0 |
| 2018-03-28 06:25:00 | SPY | ETF | 260.56 | 260.71 | 260.56 | 260.61 | 3605.0 |
| 2018-03-28 06:30:00 | SPY | ETF | 260.63 | 260.63 | 260.62 | 260.62 | 320.0 |
| 2018-03-28 06:35:00 | SPY | ETF | 260.68 | 260.72 | 260.59 | 260.59 | 6320.0 |
| 2018-03-28 06:40:00 | SPY | ETF | 260.53 | 260.68 | 260.48 | 260.68 | 835.0 |
| 2018-03-28 06:45:00 | SPY | ETF | 260.71 | 260.85 | 260.71 | 260.85 | 27000.0 |
| 2018-03-28 06:50:00 | SPY | ETF | 260.81 | 261.05 | 260.81 | 261.05 | 59069.0 |
| 2018-03-28 06:55:00 | SPY | ETF | 260.95 | 261.05 | 260.95 | 260.97 | 8550.0 |
| 2018-03-28 07:00:00 | SPY | ETF | 261.03 | 261.28 | 260.97 | 261.2 | 39363.0 |
| 2018-03-28 07:05:00 | SPY | ETF | 261.18 | 261.28 | 261.16 | 261.2 | 45853.0 |
| 2018-03-28 07:10:00 | SPY | ETF | 261.17 | 261.31 | 261.14 | 261.28 | 20409.0 |
| 2018-03-28 07:15:00 | SPY | ETF | 261.33 | 261.39 | 261.25 | 261.39 | 52601.0 |
| 2018-03-28 07:20:00 | SPY | ETF | 261.33 | 261.46 | 261.2 | 261.39 | 59059.0 |
| 2018-03-28 07:25:00 | SPY | ETF | 261.47 | 261.71 | 261.47 | 261.63 | 63534.0 |
| 2018-03-28 07:30:00 | SPY | ETF | 261.63 | 261.68 | 261.53 | 261.58 | 54435.0 |
| 2018-03-28 07:35:00 | SPY | ETF | 261.55 | 261.58 | 261.55 | 261.57 | 23785.0 |
| 2018-03-28 07:40:00 | SPY | ETF | 261.54 | 261.59 | 261.41 | 261.44 | 23493.0 |
| 2018-03-28 07:45:00 | SPY | ETF | 261.41 | 261.43 | 261.13 | 261.13 | 16011.0 |
| 2018-03-28 07:50:00 | SPY | ETF | 261.16 | 261.42 | 261.13 | 261.24 | 26530.0 |
| 2018-03-28 07:55:00 | SPY | ETF | 261.23 | 261.27 | 261.14 | 261.23 | 15935.0 |
| 2018-03-28 08:00:00 | SPY | ETF | 261.35 | 261.74 | 259.12 | 261.68 | 60259.0 |
| 2018-03-28 08:05:00 | SPY | ETF | 261.65 | 261.72 | 261.61 | 261.65 | 25898.0 |
> showing 50 of 60,094 rows — these rows as CSV