PREVIEW / etf_5min / 2018-02-06
file: by_date/etf_5min/2018/2018-02-06.parquet size: 1.8 MB rows: 75,964
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-06 04:00:00 | SPY | ETF | 263.5 | 264.98 | 263.06 | 263.21 | 76944.0 |
| 2018-02-06 04:05:00 | SPY | ETF | 263.38 | 263.88 | 263.06 | 263.88 | 26492.0 |
| 2018-02-06 04:10:00 | SPY | ETF | 263.86 | 263.88 | 263.28 | 263.49 | 48729.0 |
| 2018-02-06 04:15:00 | SPY | ETF | 263.38 | 263.83 | 263.38 | 263.66 | 21935.0 |
| 2018-02-06 04:20:00 | SPY | ETF | 263.68 | 264.01 | 263.65 | 263.99 | 5924.0 |
| 2018-02-06 04:25:00 | SPY | ETF | 264.01 | 264.05 | 263.4 | 263.49 | 36194.0 |
| 2018-02-06 04:30:00 | SPY | ETF | 263.53 | 263.53 | 263.02 | 263.39 | 29639.0 |
| 2018-02-06 04:35:00 | SPY | ETF | 263.37 | 263.38 | 262.94 | 262.96 | 19900.0 |
| 2018-02-06 04:40:00 | SPY | ETF | 262.91 | 262.97 | 261.57 | 262.62 | 47622.0 |
| 2018-02-06 04:45:00 | SPY | ETF | 262.33 | 262.35 | 261.65 | 261.65 | 12852.0 |
| 2018-02-06 04:50:00 | SPY | ETF | 261.53 | 262.25 | 261.51 | 262.25 | 19664.0 |
| 2018-02-06 04:55:00 | SPY | ETF | 262.25 | 262.25 | 261.58 | 261.71 | 4461.0 |
| 2018-02-06 05:00:00 | SPY | ETF | 261.82 | 261.82 | 260.47 | 260.47 | 33604.0 |
| 2018-02-06 05:05:00 | SPY | ETF | 260.4 | 260.58 | 259.71 | 260.0 | 102189.0 |
| 2018-02-06 05:10:00 | SPY | ETF | 259.9 | 260.59 | 259.9 | 260.59 | 82595.0 |
| 2018-02-06 05:15:00 | SPY | ETF | 260.64 | 261.01 | 260.43 | 260.78 | 15484.0 |
| 2018-02-06 05:20:00 | SPY | ETF | 260.75 | 260.75 | 260.29 | 260.36 | 38172.0 |
| 2018-02-06 05:25:00 | SPY | ETF | 260.28 | 260.42 | 259.81 | 259.95 | 51790.0 |
| 2018-02-06 05:30:00 | SPY | ETF | 259.83 | 260.45 | 259.83 | 260.45 | 79212.0 |
| 2018-02-06 05:35:00 | SPY | ETF | 260.43 | 262.25 | 260.43 | 261.17 | 159700.0 |
| 2018-02-06 05:40:00 | SPY | ETF | 261.22 | 261.8 | 260.87 | 261.66 | 68711.0 |
| 2018-02-06 05:45:00 | SPY | ETF | 261.61 | 261.74 | 261.28 | 261.74 | 62703.0 |
| 2018-02-06 05:50:00 | SPY | ETF | 261.59 | 261.84 | 261.44 | 261.78 | 26430.0 |
| 2018-02-06 05:55:00 | SPY | ETF | 261.79 | 262.27 | 261.79 | 261.93 | 59345.0 |
| 2018-02-06 06:00:00 | SPY | ETF | 261.94 | 262.17 | 260.79 | 260.81 | 29132.0 |
| 2018-02-06 06:05:00 | SPY | ETF | 260.78 | 261.1 | 260.27 | 260.54 | 24456.0 |
| 2018-02-06 06:10:00 | SPY | ETF | 260.5 | 260.9 | 260.3 | 260.4 | 14196.0 |
| 2018-02-06 06:15:00 | SPY | ETF | 260.5 | 260.65 | 259.91 | 260.56 | 27071.0 |
| 2018-02-06 06:20:00 | SPY | ETF | 260.48 | 260.55 | 260.11 | 260.28 | 14919.0 |
| 2018-02-06 06:25:00 | SPY | ETF | 260.43 | 260.43 | 260.1 | 260.1 | 19278.0 |
| 2018-02-06 06:30:00 | SPY | ETF | 260.11 | 260.26 | 258.8 | 258.86 | 66962.0 |
| 2018-02-06 06:35:00 | SPY | ETF | 258.78 | 260.0 | 258.73 | 260.0 | 47194.0 |
| 2018-02-06 06:40:00 | SPY | ETF | 260.15 | 260.15 | 258.98 | 259.11 | 48490.0 |
| 2018-02-06 06:45:00 | SPY | ETF | 259.06 | 259.32 | 258.85 | 259.14 | 15069.0 |
| 2018-02-06 06:50:00 | SPY | ETF | 259.14 | 259.32 | 258.81 | 259.1 | 45142.0 |
| 2018-02-06 06:55:00 | SPY | ETF | 258.92 | 258.93 | 257.6 | 258.0 | 132615.0 |
| 2018-02-06 07:00:00 | SPY | ETF | 258.0 | 258.12 | 256.98 | 257.64 | 138759.0 |
| 2018-02-06 07:05:00 | SPY | ETF | 257.58 | 258.2 | 257.17 | 257.5 | 133119.0 |
| 2018-02-06 07:10:00 | SPY | ETF | 257.5 | 258.32 | 257.37 | 257.99 | 59608.0 |
| 2018-02-06 07:15:00 | SPY | ETF | 258.24 | 259.23 | 258.18 | 258.6 | 143594.0 |
| 2018-02-06 07:20:00 | SPY | ETF | 258.6 | 260.92 | 258.53 | 260.76 | 331470.0 |
| 2018-02-06 07:25:00 | SPY | ETF | 260.83 | 261.38 | 259.32 | 260.11 | 331616.0 |
| 2018-02-06 07:30:00 | SPY | ETF | 260.0 | 260.5 | 259.58 | 260.25 | 148410.0 |
| 2018-02-06 07:35:00 | SPY | ETF | 260.25 | 260.27 | 259.59 | 259.6 | 123778.0 |
| 2018-02-06 07:40:00 | SPY | ETF | 259.6 | 260.22 | 259.51 | 259.95 | 69792.0 |
| 2018-02-06 07:45:00 | SPY | ETF | 260.0 | 260.2 | 259.29 | 259.39 | 166189.0 |
| 2018-02-06 07:50:00 | SPY | ETF | 259.36 | 259.9 | 259.12 | 259.6 | 51453.0 |
| 2018-02-06 07:55:00 | SPY | ETF | 259.7 | 260.33 | 259.65 | 260.1 | 154302.0 |
| 2018-02-06 08:00:00 | SPY | ETF | 260.02 | 262.66 | 257.41 | 259.04 | 221065.0 |
| 2018-02-06 08:05:00 | SPY | ETF | 259.04 | 262.6 | 258.83 | 259.26 | 284965.0 |
> showing 50 of 75,964 rows — these rows as CSV