PREVIEW / etf_5min / 2019-10-02
file: by_date/etf_5min/2019/2019-10-02.parquet size: 1.6 MB rows: 66,609
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 |
|---|---|---|---|---|---|---|---|
| 2019-10-02 04:00:00 | SPY | ETF | 292.12 | 292.12 | 291.8 | 291.87 | 10440.0 |
| 2019-10-02 04:05:00 | SPY | ETF | 291.84 | 291.84 | 291.81 | 291.81 | 1814.0 |
| 2019-10-02 04:10:00 | SPY | ETF | 291.8 | 292.05 | 291.74 | 292.04 | 10466.0 |
| 2019-10-02 04:15:00 | SPY | ETF | 292.05 | 292.1 | 292.0 | 292.1 | 2500.0 |
| 2019-10-02 04:20:00 | SPY | ETF | 292.11 | 292.11 | 292.11 | 292.11 | 1100.0 |
| 2019-10-02 04:25:00 | SPY | ETF | 291.99 | 291.99 | 291.99 | 291.99 | 800.0 |
| 2019-10-02 04:30:00 | SPY | ETF | 291.84 | 291.84 | 291.84 | 291.84 | 253.0 |
| 2019-10-02 04:35:00 | SPY | ETF | 291.91 | 291.91 | 291.9 | 291.91 | 565.0 |
| 2019-10-02 04:40:00 | SPY | ETF | 291.81 | 291.81 | 291.5 | 291.5 | 2296.0 |
| 2019-10-02 04:45:00 | SPY | ETF | 291.47 | 291.54 | 291.42 | 291.46 | 7725.0 |
| 2019-10-02 04:50:00 | SPY | ETF | 291.42 | 291.59 | 291.39 | 291.59 | 1351.0 |
| 2019-10-02 04:55:00 | SPY | ETF | 291.65 | 291.66 | 291.55 | 291.62 | 10451.0 |
| 2019-10-02 05:00:00 | SPY | ETF | 291.6 | 291.65 | 291.42 | 291.42 | 11090.0 |
| 2019-10-02 05:05:00 | SPY | ETF | 291.53 | 291.69 | 291.53 | 291.6 | 2650.0 |
| 2019-10-02 05:10:00 | SPY | ETF | 291.6 | 291.65 | 291.6 | 291.6 | 2749.0 |
| 2019-10-02 05:15:00 | SPY | ETF | 291.63 | 291.77 | 291.63 | 291.75 | 3364.0 |
| 2019-10-02 05:20:00 | SPY | ETF | 291.78 | 291.78 | 291.3 | 291.3 | 14412.0 |
| 2019-10-02 05:25:00 | SPY | ETF | 291.25 | 291.29 | 291.13 | 291.17 | 6623.0 |
| 2019-10-02 05:30:00 | SPY | ETF | 291.21 | 291.22 | 290.96 | 291.22 | 9522.0 |
| 2019-10-02 05:35:00 | SPY | ETF | 291.16 | 291.16 | 291.01 | 291.01 | 21844.0 |
| 2019-10-02 05:40:00 | SPY | ETF | 291.14 | 291.2 | 290.9 | 290.96 | 11256.0 |
| 2019-10-02 05:45:00 | SPY | ETF | 290.96 | 291.06 | 290.92 | 290.99 | 13269.0 |
| 2019-10-02 05:50:00 | SPY | ETF | 290.96 | 291.16 | 290.92 | 291.13 | 3289.0 |
| 2019-10-02 05:55:00 | SPY | ETF | 291.15 | 291.22 | 291.12 | 291.22 | 8140.0 |
| 2019-10-02 06:00:00 | SPY | ETF | 291.26 | 291.36 | 291.25 | 291.25 | 6477.0 |
| 2019-10-02 06:05:00 | SPY | ETF | 291.27 | 291.27 | 291.19 | 291.25 | 7425.0 |
| 2019-10-02 06:10:00 | SPY | ETF | 291.23 | 291.23 | 291.01 | 291.01 | 3980.0 |
| 2019-10-02 06:15:00 | SPY | ETF | 291.09 | 291.12 | 290.97 | 291.12 | 2394.0 |
| 2019-10-02 06:20:00 | SPY | ETF | 291.0 | 291.08 | 291.0 | 291.05 | 4560.0 |
| 2019-10-02 06:25:00 | SPY | ETF | 291.08 | 291.16 | 291.02 | 291.16 | 1980.0 |
| 2019-10-02 06:30:00 | SPY | ETF | 291.23 | 291.27 | 291.17 | 291.27 | 7286.0 |
| 2019-10-02 06:35:00 | SPY | ETF | 291.32 | 291.32 | 291.2 | 291.23 | 13092.0 |
| 2019-10-02 06:40:00 | SPY | ETF | 291.2 | 291.2 | 291.1 | 291.12 | 12125.0 |
| 2019-10-02 06:45:00 | SPY | ETF | 291.12 | 291.26 | 291.1 | 291.23 | 8290.0 |
| 2019-10-02 06:50:00 | SPY | ETF | 291.23 | 291.32 | 291.2 | 291.32 | 7218.0 |
| 2019-10-02 06:55:00 | SPY | ETF | 291.34 | 291.35 | 291.05 | 291.08 | 28889.0 |
| 2019-10-02 07:00:00 | SPY | ETF | 291.08 | 291.29 | 291.08 | 291.21 | 20925.0 |
| 2019-10-02 07:05:00 | SPY | ETF | 291.22 | 291.35 | 291.21 | 291.32 | 52063.0 |
| 2019-10-02 07:10:00 | SPY | ETF | 291.42 | 291.42 | 291.32 | 291.35 | 6096.0 |
| 2019-10-02 07:15:00 | SPY | ETF | 291.37 | 291.37 | 291.25 | 291.27 | 26782.0 |
| 2019-10-02 07:20:00 | SPY | ETF | 291.25 | 291.36 | 291.25 | 291.31 | 5170.0 |
| 2019-10-02 07:25:00 | SPY | ETF | 291.38 | 291.54 | 291.36 | 291.53 | 17321.0 |
| 2019-10-02 07:30:00 | SPY | ETF | 291.54 | 291.59 | 291.5 | 291.51 | 22257.0 |
| 2019-10-02 07:35:00 | SPY | ETF | 291.51 | 291.65 | 291.51 | 291.64 | 25487.0 |
| 2019-10-02 07:40:00 | SPY | ETF | 291.66 | 291.66 | 291.52 | 291.57 | 38399.0 |
| 2019-10-02 07:45:00 | SPY | ETF | 291.47 | 291.57 | 291.47 | 291.57 | 6625.0 |
| 2019-10-02 07:50:00 | SPY | ETF | 291.59 | 291.8 | 291.59 | 291.75 | 12537.0 |
| 2019-10-02 07:55:00 | SPY | ETF | 291.75 | 291.8 | 291.6 | 291.71 | 19664.0 |
| 2019-10-02 08:00:00 | SPY | ETF | 291.73 | 293.9 | 291.12 | 293.9 | 48628.0 |
| 2019-10-02 08:05:00 | SPY | ETF | 291.61 | 291.7399 | 291.61 | 291.7399 | 48365.0 |
> showing 50 of 66,609 rows — these rows as CSV