PREVIEW / etf_5min / 2020-05-26
file: by_date/etf_5min/2020/2020-05-26.parquet size: 1.6 MB rows: 77,848
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-05-26 04:00:00 | SPY | ETF | 300.51 | 301.0 | 300.51 | 300.97 | 63786.0 |
| 2020-05-26 04:05:00 | SPY | ETF | 301.0 | 301.06 | 300.88 | 300.98 | 16240.0 |
| 2020-05-26 04:10:00 | SPY | ETF | 301.1 | 301.17 | 301.06 | 301.13 | 13970.0 |
| 2020-05-26 04:15:00 | SPY | ETF | 301.11 | 301.2 | 301.11 | 301.15 | 3643.0 |
| 2020-05-26 04:20:00 | SPY | ETF | 301.13 | 301.25 | 301.1 | 301.17 | 14809.0 |
| 2020-05-26 04:25:00 | SPY | ETF | 301.19 | 301.2 | 301.07 | 301.15 | 2907.0 |
| 2020-05-26 04:30:00 | SPY | ETF | 301.14 | 301.14 | 300.91 | 300.95 | 8913.0 |
| 2020-05-26 04:35:00 | SPY | ETF | 300.95 | 301.03 | 300.89 | 300.89 | 2537.0 |
| 2020-05-26 04:40:00 | SPY | ETF | 300.98 | 301.08 | 300.84 | 300.98 | 7880.0 |
| 2020-05-26 04:45:00 | SPY | ETF | 301.03 | 301.1 | 301.02 | 301.05 | 4156.0 |
| 2020-05-26 04:50:00 | SPY | ETF | 301.05 | 301.2 | 301.05 | 301.2 | 2355.0 |
| 2020-05-26 04:55:00 | SPY | ETF | 301.23 | 301.48 | 301.22 | 301.4 | 4002.0 |
| 2020-05-26 05:00:00 | SPY | ETF | 301.4 | 301.52 | 301.34 | 301.45 | 7138.0 |
| 2020-05-26 05:05:00 | SPY | ETF | 301.47 | 301.61 | 301.47 | 301.6 | 3564.0 |
| 2020-05-26 05:10:00 | SPY | ETF | 301.58 | 301.79 | 301.58 | 301.77 | 9657.0 |
| 2020-05-26 05:15:00 | SPY | ETF | 301.7 | 301.78 | 301.7 | 301.75 | 6993.0 |
| 2020-05-26 05:20:00 | SPY | ETF | 301.75 | 301.79 | 301.63 | 301.67 | 19219.0 |
| 2020-05-26 05:25:00 | SPY | ETF | 301.6 | 301.77 | 301.59 | 301.77 | 2454.0 |
| 2020-05-26 05:30:00 | SPY | ETF | 301.7 | 301.7 | 301.55 | 301.61 | 2578.0 |
| 2020-05-26 05:35:00 | SPY | ETF | 301.65 | 301.65 | 301.47 | 301.5 | 6858.0 |
| 2020-05-26 05:40:00 | SPY | ETF | 301.47 | 301.51 | 301.27 | 301.34 | 6082.0 |
| 2020-05-26 05:45:00 | SPY | ETF | 301.38 | 301.38 | 301.33 | 301.38 | 11223.0 |
| 2020-05-26 05:50:00 | SPY | ETF | 301.32 | 301.34 | 301.29 | 301.33 | 1526.0 |
| 2020-05-26 05:55:00 | SPY | ETF | 301.35 | 301.35 | 301.24 | 301.3 | 10456.0 |
| 2020-05-26 06:00:00 | SPY | ETF | 301.33 | 301.33 | 301.19 | 301.25 | 10579.0 |
| 2020-05-26 06:05:00 | SPY | ETF | 301.15 | 301.15 | 301.02 | 301.02 | 4296.0 |
| 2020-05-26 06:10:00 | SPY | ETF | 301.08 | 301.08 | 301.0 | 301.06 | 4762.0 |
| 2020-05-26 06:15:00 | SPY | ETF | 301.0 | 301.31 | 301.0 | 301.21 | 11785.0 |
| 2020-05-26 06:20:00 | SPY | ETF | 301.21 | 301.32 | 301.17 | 301.31 | 12680.0 |
| 2020-05-26 06:25:00 | SPY | ETF | 301.3 | 301.31 | 301.2 | 301.24 | 28384.0 |
| 2020-05-26 06:30:00 | SPY | ETF | 301.39 | 301.55 | 301.39 | 301.47 | 13021.0 |
| 2020-05-26 06:35:00 | SPY | ETF | 301.4 | 301.4 | 301.19 | 301.3 | 46674.0 |
| 2020-05-26 06:40:00 | SPY | ETF | 301.27 | 301.51 | 301.2 | 301.44 | 22902.0 |
| 2020-05-26 06:45:00 | SPY | ETF | 301.49 | 301.54 | 301.37 | 301.37 | 3260.0 |
| 2020-05-26 06:50:00 | SPY | ETF | 301.41 | 301.41 | 301.13 | 301.15 | 9011.0 |
| 2020-05-26 06:55:00 | SPY | ETF | 301.11 | 301.27 | 301.06 | 301.15 | 28695.0 |
| 2020-05-26 07:00:00 | SPY | ETF | 301.11 | 301.12 | 300.88 | 300.92 | 73823.0 |
| 2020-05-26 07:05:00 | SPY | ETF | 300.92 | 301.07 | 300.86 | 301.07 | 51163.0 |
| 2020-05-26 07:10:00 | SPY | ETF | 301.07 | 301.24 | 301.04 | 301.04 | 26628.0 |
| 2020-05-26 07:15:00 | SPY | ETF | 301.0 | 301.16 | 300.91 | 301.15 | 33213.0 |
| 2020-05-26 07:20:00 | SPY | ETF | 301.14 | 301.15 | 301.0 | 301.05 | 17849.0 |
| 2020-05-26 07:25:00 | SPY | ETF | 301.04 | 301.06 | 300.96 | 300.97 | 19396.0 |
| 2020-05-26 07:30:00 | SPY | ETF | 301.0 | 301.0 | 300.78 | 300.79 | 31600.0 |
| 2020-05-26 07:35:00 | SPY | ETF | 300.8 | 300.85 | 300.76 | 300.76 | 19224.0 |
| 2020-05-26 07:40:00 | SPY | ETF | 300.78 | 300.99 | 300.75 | 300.94 | 37436.0 |
| 2020-05-26 07:45:00 | SPY | ETF | 300.95 | 301.04 | 300.9 | 300.97 | 55096.0 |
| 2020-05-26 07:50:00 | SPY | ETF | 300.99 | 301.36 | 300.99 | 301.34 | 98453.0 |
| 2020-05-26 07:55:00 | SPY | ETF | 301.29 | 301.29 | 301.01 | 301.03 | 83785.0 |
| 2020-05-26 08:00:00 | SPY | ETF | 301.03 | 301.68 | 300.11 | 300.87 | 124659.0 |
| 2020-05-26 08:05:00 | SPY | ETF | 300.94 | 300.96 | 300.71 | 300.84 | 39797.0 |
> showing 50 of 77,848 rows — these rows as CSV