PREVIEW / etf_5min / 2020-09-02
file: by_date/etf_5min/2020/2020-09-02.parquet size: 1.7 MB rows: 77,675
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-09-02 04:00:00 | SPY | ETF | 354.51 | 354.62 | 354.44 | 354.52 | 6317.0 |
| 2020-09-02 04:05:00 | SPY | ETF | 354.5 | 354.72 | 354.5 | 354.51 | 3415.0 |
| 2020-09-02 04:10:00 | SPY | ETF | 354.55 | 354.55 | 354.55 | 354.55 | 1045.0 |
| 2020-09-02 04:15:00 | SPY | ETF | 354.58 | 354.67 | 354.58 | 354.67 | 2790.0 |
| 2020-09-02 04:20:00 | SPY | ETF | 354.75 | 354.86 | 354.75 | 354.82 | 2985.0 |
| 2020-09-02 04:25:00 | SPY | ETF | 354.75 | 354.79 | 354.75 | 354.79 | 490.0 |
| 2020-09-02 04:30:00 | SPY | ETF | 354.9 | 354.9 | 354.9 | 354.9 | 100.0 |
| 2020-09-02 04:35:00 | SPY | ETF | 354.92 | 354.92 | 354.88 | 354.88 | 2714.0 |
| 2020-09-02 04:40:00 | SPY | ETF | 354.85 | 355.18 | 354.85 | 355.1 | 4430.0 |
| 2020-09-02 04:45:00 | SPY | ETF | 355.09 | 355.26 | 354.89 | 355.04 | 4553.0 |
| 2020-09-02 04:50:00 | SPY | ETF | 355.06 | 355.17 | 355.06 | 355.17 | 3420.0 |
| 2020-09-02 04:55:00 | SPY | ETF | 355.16 | 355.16 | 355.02 | 355.1 | 1009.0 |
| 2020-09-02 05:00:00 | SPY | ETF | 355.23 | 355.29 | 355.21 | 355.21 | 1731.0 |
| 2020-09-02 05:05:00 | SPY | ETF | 355.05 | 355.15 | 355.05 | 355.15 | 1450.0 |
| 2020-09-02 05:10:00 | SPY | ETF | 355.17 | 355.27 | 355.14 | 355.16 | 7286.0 |
| 2020-09-02 05:15:00 | SPY | ETF | 355.19 | 355.34 | 355.19 | 355.34 | 719.0 |
| 2020-09-02 05:20:00 | SPY | ETF | 355.37 | 355.37 | 355.27 | 355.27 | 722.0 |
| 2020-09-02 05:25:00 | SPY | ETF | 355.34 | 355.41 | 355.32 | 355.32 | 850.0 |
| 2020-09-02 05:30:00 | SPY | ETF | 355.37 | 355.37 | 355.15 | 355.22 | 4825.0 |
| 2020-09-02 05:35:00 | SPY | ETF | 355.21 | 355.21 | 355.13 | 355.14 | 3160.0 |
| 2020-09-02 05:45:00 | SPY | ETF | 355.03 | 355.09 | 355.03 | 355.09 | 345.0 |
| 2020-09-02 05:50:00 | SPY | ETF | 355.15 | 355.21 | 355.15 | 355.21 | 960.0 |
| 2020-09-02 05:55:00 | SPY | ETF | 355.39 | 355.53 | 355.39 | 355.5 | 3241.0 |
| 2020-09-02 06:00:00 | SPY | ETF | 355.47 | 355.62 | 355.46 | 355.54 | 5467.0 |
| 2020-09-02 06:05:00 | SPY | ETF | 355.47 | 355.47 | 355.4 | 355.4 | 2014.0 |
| 2020-09-02 06:10:00 | SPY | ETF | 355.36 | 355.38 | 355.21 | 355.21 | 3001.0 |
| 2020-09-02 06:15:00 | SPY | ETF | 355.21 | 355.26 | 355.21 | 355.25 | 21205.0 |
| 2020-09-02 06:20:00 | SPY | ETF | 355.2 | 355.22 | 355.16 | 355.2 | 2096.0 |
| 2020-09-02 06:25:00 | SPY | ETF | 355.16 | 355.17 | 355.09 | 355.1 | 2050.0 |
| 2020-09-02 06:30:00 | SPY | ETF | 355.03 | 355.11 | 355.01 | 355.11 | 2527.0 |
| 2020-09-02 06:35:00 | SPY | ETF | 355.14 | 355.14 | 355.12 | 355.13 | 10601.0 |
| 2020-09-02 06:40:00 | SPY | ETF | 355.14 | 355.22 | 355.14 | 355.19 | 15892.0 |
| 2020-09-02 06:45:00 | SPY | ETF | 355.25 | 355.27 | 355.1 | 355.12 | 40502.0 |
| 2020-09-02 06:50:00 | SPY | ETF | 355.08 | 355.14 | 355.02 | 355.02 | 2925.0 |
| 2020-09-02 06:55:00 | SPY | ETF | 355.01 | 355.14 | 355.01 | 355.1 | 5753.0 |
| 2020-09-02 07:00:00 | SPY | ETF | 355.0 | 355.07 | 354.93 | 354.94 | 18219.0 |
| 2020-09-02 07:05:00 | SPY | ETF | 355.06 | 355.12 | 355.02 | 355.03 | 4820.0 |
| 2020-09-02 07:10:00 | SPY | ETF | 354.98 | 355.04 | 354.87 | 354.9 | 12394.0 |
| 2020-09-02 07:15:00 | SPY | ETF | 354.95 | 355.02 | 354.94 | 354.95 | 3239.0 |
| 2020-09-02 07:20:00 | SPY | ETF | 354.87 | 355.02 | 354.87 | 355.02 | 5015.0 |
| 2020-09-02 07:25:00 | SPY | ETF | 355.01 | 355.04 | 354.92 | 354.92 | 10422.0 |
| 2020-09-02 07:30:00 | SPY | ETF | 354.99 | 355.1 | 354.99 | 355.09 | 17511.0 |
| 2020-09-02 07:35:00 | SPY | ETF | 355.06 | 355.06 | 354.93 | 354.99 | 13345.0 |
| 2020-09-02 07:40:00 | SPY | ETF | 355.02 | 355.11 | 354.99 | 355.07 | 10374.0 |
| 2020-09-02 07:45:00 | SPY | ETF | 355.07 | 355.07 | 354.92 | 355.0 | 18034.0 |
| 2020-09-02 07:50:00 | SPY | ETF | 354.95 | 354.97 | 354.87 | 354.9 | 33412.0 |
| 2020-09-02 07:55:00 | SPY | ETF | 354.9 | 354.9 | 354.69 | 354.69 | 20915.0 |
| 2020-09-02 08:00:00 | SPY | ETF | 354.68 | 355.4104 | 353.6 | 354.84 | 28524.0 |
| 2020-09-02 08:05:00 | SPY | ETF | 354.85 | 354.86 | 354.72 | 354.75 | 29771.0 |
| 2020-09-02 08:10:00 | SPY | ETF | 354.76 | 354.87 | 354.76 | 354.83 | 6298.0 |
> showing 50 of 77,675 rows — these rows as CSV