PREVIEW / etf_5min / 2019-09-13
file: by_date/etf_5min/2019/2019-09-13.parquet size: 1.4 MB rows: 61,019
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-09-13 04:00:00 | SPY | ETF | 302.01 | 302.12 | 302.01 | 302.12 | 2361.0 |
| 2019-09-13 04:05:00 | SPY | ETF | 302.12 | 302.12 | 302.12 | 302.12 | 115.0 |
| 2019-09-13 04:10:00 | SPY | ETF | 302.14 | 302.15 | 302.14 | 302.15 | 2571.0 |
| 2019-09-13 04:15:00 | SPY | ETF | 302.14 | 302.17 | 302.14 | 302.14 | 1280.0 |
| 2019-09-13 04:20:00 | SPY | ETF | 302.13 | 302.14 | 302.12 | 302.12 | 1620.0 |
| 2019-09-13 04:25:00 | SPY | ETF | 301.98 | 301.98 | 301.98 | 301.98 | 201.0 |
| 2019-09-13 04:35:00 | SPY | ETF | 302.18 | 302.27 | 302.16 | 302.16 | 994.0 |
| 2019-09-13 04:40:00 | SPY | ETF | 302.02 | 302.02 | 302.02 | 302.02 | 300.0 |
| 2019-09-13 04:45:00 | SPY | ETF | 301.99 | 301.99 | 301.99 | 301.99 | 250.0 |
| 2019-09-13 04:55:00 | SPY | ETF | 301.94 | 301.94 | 301.94 | 301.94 | 100.0 |
| 2019-09-13 05:05:00 | SPY | ETF | 302.07 | 302.09 | 302.07 | 302.09 | 2500.0 |
| 2019-09-13 05:25:00 | SPY | ETF | 302.08 | 302.16 | 302.08 | 302.16 | 600.0 |
| 2019-09-13 05:30:00 | SPY | ETF | 302.18 | 302.18 | 302.18 | 302.18 | 500.0 |
| 2019-09-13 05:35:00 | SPY | ETF | 302.14 | 302.16 | 302.12 | 302.12 | 900.0 |
| 2019-09-13 05:40:00 | SPY | ETF | 302.21 | 302.21 | 302.2 | 302.2 | 1500.0 |
| 2019-09-13 05:45:00 | SPY | ETF | 302.22 | 302.3 | 302.22 | 302.22 | 4400.0 |
| 2019-09-13 05:50:00 | SPY | ETF | 302.23 | 302.3 | 302.23 | 302.29 | 1400.0 |
| 2019-09-13 05:55:00 | SPY | ETF | 302.34 | 302.34 | 302.34 | 302.34 | 1100.0 |
| 2019-09-13 06:00:00 | SPY | ETF | 302.27 | 302.32 | 302.27 | 302.32 | 6300.0 |
| 2019-09-13 06:05:00 | SPY | ETF | 302.36 | 302.41 | 302.34 | 302.37 | 3130.0 |
| 2019-09-13 06:10:00 | SPY | ETF | 302.39 | 302.42 | 302.39 | 302.42 | 2005.0 |
| 2019-09-13 06:15:00 | SPY | ETF | 302.39 | 302.39 | 302.39 | 302.39 | 100.0 |
| 2019-09-13 06:20:00 | SPY | ETF | 302.44 | 302.44 | 302.4 | 302.41 | 1471.0 |
| 2019-09-13 06:40:00 | SPY | ETF | 302.4 | 302.46 | 302.38 | 302.38 | 11090.0 |
| 2019-09-13 06:45:00 | SPY | ETF | 302.37 | 302.49 | 302.37 | 302.46 | 6466.0 |
| 2019-09-13 06:50:00 | SPY | ETF | 302.5 | 302.51 | 302.44 | 302.48 | 11154.0 |
| 2019-09-13 06:55:00 | SPY | ETF | 302.51 | 302.56 | 302.51 | 302.56 | 408.0 |
| 2019-09-13 07:00:00 | SPY | ETF | 302.59 | 302.68 | 302.57 | 302.59 | 11425.0 |
| 2019-09-13 07:05:00 | SPY | ETF | 302.61 | 302.61 | 302.54 | 302.54 | 24855.0 |
| 2019-09-13 07:10:00 | SPY | ETF | 302.54 | 302.54 | 302.52 | 302.52 | 3404.0 |
| 2019-09-13 07:15:00 | SPY | ETF | 302.5 | 302.54 | 302.44 | 302.44 | 10714.0 |
| 2019-09-13 07:20:00 | SPY | ETF | 302.45 | 302.45 | 302.45 | 302.45 | 3000.0 |
| 2019-09-13 07:25:00 | SPY | ETF | 302.44 | 302.48 | 302.44 | 302.48 | 3450.0 |
| 2019-09-13 07:30:00 | SPY | ETF | 302.48 | 302.48 | 302.45 | 302.48 | 2762.0 |
| 2019-09-13 07:35:00 | SPY | ETF | 302.48 | 302.48 | 302.4 | 302.44 | 35116.0 |
| 2019-09-13 07:40:00 | SPY | ETF | 302.42 | 302.45 | 302.38 | 302.38 | 67188.0 |
| 2019-09-13 07:45:00 | SPY | ETF | 302.4 | 302.43 | 302.38 | 302.38 | 1814.0 |
| 2019-09-13 07:50:00 | SPY | ETF | 302.37 | 302.37 | 302.36 | 302.36 | 3114.0 |
| 2019-09-13 07:55:00 | SPY | ETF | 302.32 | 302.35 | 302.26 | 302.33 | 8756.0 |
| 2019-09-13 08:00:00 | SPY | ETF | 302.33 | 302.62 | 302.24 | 302.44 | 47951.0 |
| 2019-09-13 08:05:00 | SPY | ETF | 302.45 | 302.45 | 302.35 | 302.39 | 8408.0 |
| 2019-09-13 08:10:00 | SPY | ETF | 302.4 | 302.43 | 302.33 | 302.35 | 2791.0 |
| 2019-09-13 08:15:00 | SPY | ETF | 302.35 | 302.35 | 302.3 | 302.32 | 2648.0 |
| 2019-09-13 08:20:00 | SPY | ETF | 302.31 | 302.31 | 302.26 | 302.27 | 2035.0 |
| 2019-09-13 08:25:00 | SPY | ETF | 302.23 | 302.3 | 302.21 | 302.3 | 11369.0 |
| 2019-09-13 08:30:00 | SPY | ETF | 302.3 | 302.44 | 302.21 | 302.21 | 34553.0 |
| 2019-09-13 08:35:00 | SPY | ETF | 302.23 | 302.23 | 302.1 | 302.1 | 39083.0 |
| 2019-09-13 08:40:00 | SPY | ETF | 302.08 | 302.16 | 302.04 | 302.13 | 17682.0 |
| 2019-09-13 08:45:00 | SPY | ETF | 302.13 | 302.2 | 302.1 | 302.2 | 7415.0 |
| 2019-09-13 08:50:00 | SPY | ETF | 302.2 | 302.2 | 302.1 | 302.15 | 21016.0 |
> showing 50 of 61,019 rows — these rows as CSV