PREVIEW / etf_5min / 2020-02-06
file: by_date/etf_5min/2020/2020-02-06.parquet size: 1.5 MB rows: 67,730
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 |
|---|---|---|---|---|---|---|---|
| 2020-02-06 04:00:00 | SPY | ETF | 334.48 | 334.51 | 334.39 | 334.46 | 9381.0 |
| 2020-02-06 04:05:00 | SPY | ETF | 334.48 | 334.64 | 334.48 | 334.64 | 2558.0 |
| 2020-02-06 04:10:00 | SPY | ETF | 334.6 | 334.62 | 334.56 | 334.62 | 546.0 |
| 2020-02-06 04:15:00 | SPY | ETF | 334.36 | 334.37 | 334.3 | 334.3 | 4385.0 |
| 2020-02-06 04:20:00 | SPY | ETF | 334.25 | 334.28 | 333.86 | 333.88 | 1502.0 |
| 2020-02-06 04:25:00 | SPY | ETF | 333.8 | 333.85 | 333.78 | 333.8 | 3078.0 |
| 2020-02-06 04:35:00 | SPY | ETF | 334.07 | 334.07 | 333.88 | 333.88 | 912.0 |
| 2020-02-06 04:40:00 | SPY | ETF | 333.83 | 333.9 | 333.83 | 333.88 | 2275.0 |
| 2020-02-06 04:45:00 | SPY | ETF | 333.89 | 333.89 | 333.83 | 333.85 | 380.0 |
| 2020-02-06 04:50:00 | SPY | ETF | 334.04 | 334.04 | 334.0 | 334.0 | 1100.0 |
| 2020-02-06 04:55:00 | SPY | ETF | 333.9 | 333.91 | 333.9 | 333.91 | 1650.0 |
| 2020-02-06 05:05:00 | SPY | ETF | 333.8 | 333.8 | 333.73 | 333.73 | 2104.0 |
| 2020-02-06 05:10:00 | SPY | ETF | 333.8 | 333.8 | 333.74 | 333.74 | 370.0 |
| 2020-02-06 05:15:00 | SPY | ETF | 333.89 | 333.93 | 333.89 | 333.93 | 745.0 |
| 2020-02-06 05:20:00 | SPY | ETF | 333.9 | 333.9 | 333.9 | 333.9 | 100.0 |
| 2020-02-06 05:35:00 | SPY | ETF | 333.91 | 333.95 | 333.86 | 333.95 | 1981.0 |
| 2020-02-06 05:40:00 | SPY | ETF | 333.86 | 333.86 | 333.86 | 333.86 | 350.0 |
| 2020-02-06 05:45:00 | SPY | ETF | 333.8 | 333.8 | 333.8 | 333.8 | 515.0 |
| 2020-02-06 05:50:00 | SPY | ETF | 333.73 | 333.73 | 333.73 | 333.73 | 130.0 |
| 2020-02-06 05:55:00 | SPY | ETF | 333.73 | 333.73 | 333.64 | 333.64 | 285.0 |
| 2020-02-06 06:00:00 | SPY | ETF | 333.68 | 333.68 | 333.68 | 333.68 | 100.0 |
| 2020-02-06 06:05:00 | SPY | ETF | 333.79 | 333.83 | 333.79 | 333.83 | 505.0 |
| 2020-02-06 06:10:00 | SPY | ETF | 333.91 | 333.91 | 333.83 | 333.83 | 446.0 |
| 2020-02-06 06:20:00 | SPY | ETF | 333.71 | 333.78 | 333.71 | 333.76 | 950.0 |
| 2020-02-06 06:25:00 | SPY | ETF | 333.9 | 333.94 | 333.9 | 333.91 | 505.0 |
| 2020-02-06 06:30:00 | SPY | ETF | 333.91 | 334.2 | 333.9 | 334.2 | 5533.0 |
| 2020-02-06 06:35:00 | SPY | ETF | 334.1 | 334.24 | 334.1 | 334.24 | 3641.0 |
| 2020-02-06 06:40:00 | SPY | ETF | 334.2 | 334.25 | 334.17 | 334.25 | 2272.0 |
| 2020-02-06 06:45:00 | SPY | ETF | 334.26 | 334.26 | 334.18 | 334.18 | 2800.0 |
| 2020-02-06 06:50:00 | SPY | ETF | 334.16 | 334.18 | 334.15 | 334.18 | 468.0 |
| 2020-02-06 06:55:00 | SPY | ETF | 334.22 | 334.5 | 334.22 | 334.5 | 7162.0 |
| 2020-02-06 07:00:00 | SPY | ETF | 334.43 | 334.51 | 334.3 | 334.37 | 15252.0 |
| 2020-02-06 07:05:00 | SPY | ETF | 334.37 | 334.49 | 334.37 | 334.38 | 57591.0 |
| 2020-02-06 07:10:00 | SPY | ETF | 334.39 | 334.5 | 334.38 | 334.42 | 18188.0 |
| 2020-02-06 07:15:00 | SPY | ETF | 334.35 | 334.37 | 334.24 | 334.29 | 3864.0 |
| 2020-02-06 07:20:00 | SPY | ETF | 334.35 | 334.35 | 334.31 | 334.33 | 2375.0 |
| 2020-02-06 07:25:00 | SPY | ETF | 334.31 | 334.31 | 334.18 | 334.18 | 10638.0 |
| 2020-02-06 07:30:00 | SPY | ETF | 334.18 | 334.22 | 334.16 | 334.22 | 33774.0 |
| 2020-02-06 07:35:00 | SPY | ETF | 334.22 | 334.25 | 334.2 | 334.25 | 9231.0 |
| 2020-02-06 07:40:00 | SPY | ETF | 334.25 | 334.28 | 334.16 | 334.22 | 6127.0 |
| 2020-02-06 07:45:00 | SPY | ETF | 334.24 | 334.28 | 334.16 | 334.16 | 3670.0 |
| 2020-02-06 07:50:00 | SPY | ETF | 334.16 | 334.16 | 333.96 | 333.99 | 14204.0 |
| 2020-02-06 07:55:00 | SPY | ETF | 333.97 | 334.0 | 333.91 | 334.0 | 76893.0 |
| 2020-02-06 08:00:00 | SPY | ETF | 334.15 | 335.15 | 333.81 | 333.87 | 52736.0 |
| 2020-02-06 08:05:00 | SPY | ETF | 333.879 | 333.94 | 332.86 | 333.94 | 17272.0 |
| 2020-02-06 08:10:00 | SPY | ETF | 333.95 | 333.96 | 333.84 | 333.85 | 11694.0 |
| 2020-02-06 08:15:00 | SPY | ETF | 333.87 | 334.08 | 333.87 | 334.03 | 15581.0 |
| 2020-02-06 08:20:00 | SPY | ETF | 334.07 | 334.13 | 334.0201 | 334.07 | 12329.0 |
| 2020-02-06 08:25:00 | SPY | ETF | 334.11 | 334.2 | 334.05 | 334.11 | 46054.0 |
| 2020-02-06 08:30:00 | SPY | ETF | 334.22 | 334.36 | 334.17 | 334.21 | 101079.0 |
> showing 50 of 67,730 rows — these rows as CSV