PREVIEW / etf_5min / 2019-02-04
file: by_date/etf_5min/2019/2019-02-04.parquet size: 1.4 MB rows: 62,382
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-02-04 04:00:00 | SPY | ETF | 269.9 | 269.9 | 269.89 | 269.89 | 5107.0 |
| 2019-02-04 04:10:00 | SPY | ETF | 270.02 | 270.02 | 270.02 | 270.02 | 200.0 |
| 2019-02-04 04:25:00 | SPY | ETF | 270.18 | 270.18 | 270.18 | 270.18 | 400.0 |
| 2019-02-04 04:30:00 | SPY | ETF | 270.23 | 270.23 | 270.14 | 270.14 | 600.0 |
| 2019-02-04 04:40:00 | SPY | ETF | 270.18 | 270.24 | 270.18 | 270.24 | 900.0 |
| 2019-02-04 04:45:00 | SPY | ETF | 270.25 | 270.27 | 270.25 | 270.27 | 900.0 |
| 2019-02-04 04:50:00 | SPY | ETF | 270.28 | 270.3 | 270.28 | 270.3 | 400.0 |
| 2019-02-04 04:55:00 | SPY | ETF | 270.3 | 270.3 | 270.3 | 270.3 | 100.0 |
| 2019-02-04 05:00:00 | SPY | ETF | 270.34 | 270.34 | 270.34 | 270.34 | 175.0 |
| 2019-02-04 05:05:00 | SPY | ETF | 270.37 | 270.37 | 270.37 | 270.37 | 250.0 |
| 2019-02-04 05:10:00 | SPY | ETF | 270.35 | 270.36 | 270.35 | 270.36 | 600.0 |
| 2019-02-04 05:15:00 | SPY | ETF | 270.29 | 270.3 | 270.29 | 270.3 | 4300.0 |
| 2019-02-04 05:20:00 | SPY | ETF | 270.25 | 270.25 | 270.2 | 270.2 | 2100.0 |
| 2019-02-04 05:25:00 | SPY | ETF | 270.2 | 270.2 | 270.2 | 270.2 | 300.0 |
| 2019-02-04 05:35:00 | SPY | ETF | 270.45 | 270.52 | 270.45 | 270.52 | 400.0 |
| 2019-02-04 05:40:00 | SPY | ETF | 270.5 | 270.5 | 270.44 | 270.5 | 3010.0 |
| 2019-02-04 05:50:00 | SPY | ETF | 270.39 | 270.39 | 270.39 | 270.39 | 431.0 |
| 2019-02-04 06:00:00 | SPY | ETF | 270.2 | 270.34 | 270.2 | 270.27 | 2070.0 |
| 2019-02-04 06:10:00 | SPY | ETF | 270.26 | 270.26 | 270.26 | 270.26 | 453.0 |
| 2019-02-04 06:15:00 | SPY | ETF | 270.15 | 270.22 | 270.15 | 270.22 | 500.0 |
| 2019-02-04 06:20:00 | SPY | ETF | 270.2 | 270.2 | 270.19 | 270.19 | 3169.0 |
| 2019-02-04 06:25:00 | SPY | ETF | 270.2 | 270.23 | 270.17 | 270.22 | 2245.0 |
| 2019-02-04 06:30:00 | SPY | ETF | 270.16 | 270.16 | 270.16 | 270.16 | 169.0 |
| 2019-02-04 06:35:00 | SPY | ETF | 270.15 | 270.15 | 270.13 | 270.15 | 1269.0 |
| 2019-02-04 06:40:00 | SPY | ETF | 270.18 | 270.18 | 270.18 | 270.18 | 800.0 |
| 2019-02-04 06:45:00 | SPY | ETF | 270.17 | 270.23 | 270.17 | 270.23 | 2600.0 |
| 2019-02-04 06:50:00 | SPY | ETF | 270.22 | 270.22 | 270.2 | 270.21 | 1669.0 |
| 2019-02-04 06:55:00 | SPY | ETF | 270.18 | 270.18 | 270.12 | 270.16 | 2400.0 |
| 2019-02-04 07:00:00 | SPY | ETF | 270.12 | 270.2 | 270.12 | 270.15 | 2217.0 |
| 2019-02-04 07:05:00 | SPY | ETF | 270.2 | 270.33 | 270.2 | 270.33 | 3657.0 |
| 2019-02-04 07:10:00 | SPY | ETF | 270.33 | 270.33 | 270.32 | 270.32 | 1541.0 |
| 2019-02-04 07:15:00 | SPY | ETF | 270.34 | 270.34 | 270.29 | 270.29 | 3700.0 |
| 2019-02-04 07:20:00 | SPY | ETF | 270.4 | 270.4 | 270.34 | 270.34 | 1459.0 |
| 2019-02-04 07:25:00 | SPY | ETF | 270.43 | 270.45 | 270.41 | 270.45 | 701.0 |
| 2019-02-04 07:30:00 | SPY | ETF | 270.4 | 270.45 | 270.36 | 270.39 | 15009.0 |
| 2019-02-04 07:35:00 | SPY | ETF | 270.38 | 270.4 | 270.38 | 270.4 | 2450.0 |
| 2019-02-04 07:40:00 | SPY | ETF | 270.37 | 270.37 | 270.28 | 270.28 | 5676.0 |
| 2019-02-04 07:45:00 | SPY | ETF | 270.28 | 270.35 | 270.28 | 270.3 | 8874.0 |
| 2019-02-04 07:50:00 | SPY | ETF | 270.32 | 270.32 | 270.28 | 270.3 | 7277.0 |
| 2019-02-04 07:55:00 | SPY | ETF | 270.32 | 270.39 | 270.31 | 270.37 | 5271.0 |
| 2019-02-04 08:00:00 | SPY | ETF | 270.39 | 270.4 | 269.92 | 270.25 | 17978.0 |
| 2019-02-04 08:05:00 | SPY | ETF | 270.25 | 270.25 | 270.12 | 270.12 | 10350.0 |
| 2019-02-04 08:10:00 | SPY | ETF | 270.1 | 270.12 | 270.05 | 270.1 | 8809.0 |
| 2019-02-04 08:15:00 | SPY | ETF | 270.09 | 270.09 | 270.04 | 270.05 | 5232.0 |
| 2019-02-04 08:20:00 | SPY | ETF | 270.09 | 270.1 | 270.06 | 270.1 | 9021.0 |
| 2019-02-04 08:25:00 | SPY | ETF | 270.1 | 270.13 | 270.09 | 270.09 | 2721.0 |
| 2019-02-04 08:30:00 | SPY | ETF | 270.03 | 270.07 | 269.99 | 270.0 | 14112.0 |
| 2019-02-04 08:35:00 | SPY | ETF | 269.98 | 269.99 | 269.9 | 269.95 | 18553.0 |
| 2019-02-04 08:40:00 | SPY | ETF | 269.96 | 269.98 | 269.93 | 269.96 | 3810.0 |
| 2019-02-04 08:45:00 | SPY | ETF | 269.93 | 269.95 | 269.86 | 269.92 | 13094.0 |
> showing 50 of 62,382 rows — these rows as CSV