PREVIEW / etf_5min / 2020-09-28
file: by_date/etf_5min/2020/2020-09-28.parquet size: 1.6 MB rows: 72,577
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-28 04:00:00 | SPY | ETF | 331.17 | 331.2 | 330.87 | 330.97 | 9941.0 |
| 2020-09-28 04:05:00 | SPY | ETF | 331.12 | 331.56 | 331.12 | 331.56 | 11083.0 |
| 2020-09-28 04:10:00 | SPY | ETF | 331.66 | 331.7 | 331.48 | 331.5 | 2455.0 |
| 2020-09-28 04:15:00 | SPY | ETF | 331.55 | 331.58 | 331.5 | 331.5 | 1025.0 |
| 2020-09-28 04:20:00 | SPY | ETF | 331.58 | 331.58 | 331.5 | 331.5 | 6059.0 |
| 2020-09-28 04:25:00 | SPY | ETF | 331.6 | 331.62 | 331.6 | 331.6 | 6484.0 |
| 2020-09-28 04:30:00 | SPY | ETF | 331.47 | 331.74 | 331.47 | 331.74 | 390.0 |
| 2020-09-28 04:35:00 | SPY | ETF | 331.67 | 331.67 | 331.57 | 331.57 | 564.0 |
| 2020-09-28 04:40:00 | SPY | ETF | 331.63 | 331.63 | 331.63 | 331.63 | 418.0 |
| 2020-09-28 04:45:00 | SPY | ETF | 331.41 | 331.41 | 331.36 | 331.36 | 1400.0 |
| 2020-09-28 04:50:00 | SPY | ETF | 331.27 | 331.27 | 331.27 | 331.27 | 150.0 |
| 2020-09-28 04:55:00 | SPY | ETF | 331.26 | 331.33 | 331.18 | 331.19 | 6310.0 |
| 2020-09-28 05:00:00 | SPY | ETF | 331.2 | 331.4 | 331.2 | 331.25 | 7365.0 |
| 2020-09-28 05:05:00 | SPY | ETF | 331.42 | 331.42 | 331.38 | 331.38 | 466.0 |
| 2020-09-28 05:15:00 | SPY | ETF | 331.38 | 331.38 | 331.38 | 331.38 | 300.0 |
| 2020-09-28 05:20:00 | SPY | ETF | 331.45 | 331.45 | 331.35 | 331.39 | 1620.0 |
| 2020-09-28 05:25:00 | SPY | ETF | 331.34 | 331.4 | 331.34 | 331.4 | 6499.0 |
| 2020-09-28 05:30:00 | SPY | ETF | 331.49 | 331.6 | 331.48 | 331.6 | 896.0 |
| 2020-09-28 05:35:00 | SPY | ETF | 331.48 | 331.48 | 331.48 | 331.48 | 206.0 |
| 2020-09-28 05:40:00 | SPY | ETF | 331.68 | 331.68 | 331.52 | 331.52 | 15310.0 |
| 2020-09-28 05:45:00 | SPY | ETF | 331.52 | 331.69 | 331.46 | 331.69 | 3101.0 |
| 2020-09-28 05:50:00 | SPY | ETF | 331.71 | 331.72 | 331.71 | 331.72 | 1411.0 |
| 2020-09-28 05:55:00 | SPY | ETF | 331.67 | 331.67 | 331.67 | 331.67 | 304.0 |
| 2020-09-28 06:00:00 | SPY | ETF | 331.95 | 332.4 | 331.95 | 332.4 | 4400.0 |
| 2020-09-28 06:05:00 | SPY | ETF | 332.49 | 332.68 | 332.49 | 332.64 | 5684.0 |
| 2020-09-28 06:10:00 | SPY | ETF | 332.78 | 332.86 | 332.77 | 332.79 | 4196.0 |
| 2020-09-28 06:15:00 | SPY | ETF | 332.8 | 333.19 | 332.8 | 333.18 | 4246.0 |
| 2020-09-28 06:20:00 | SPY | ETF | 333.0 | 333.04 | 332.99 | 333.0 | 2225.0 |
| 2020-09-28 06:25:00 | SPY | ETF | 333.08 | 333.09 | 332.96 | 332.96 | 2030.0 |
| 2020-09-28 06:30:00 | SPY | ETF | 333.13 | 333.14 | 333.09 | 333.09 | 10528.0 |
| 2020-09-28 06:35:00 | SPY | ETF | 333.07 | 333.07 | 332.97 | 332.98 | 3827.0 |
| 2020-09-28 06:40:00 | SPY | ETF | 333.22 | 333.22 | 332.93 | 332.93 | 1846.0 |
| 2020-09-28 06:45:00 | SPY | ETF | 332.92 | 332.97 | 332.85 | 332.92 | 4725.0 |
| 2020-09-28 06:50:00 | SPY | ETF | 333.1 | 333.2 | 333.1 | 333.2 | 785.0 |
| 2020-09-28 06:55:00 | SPY | ETF | 333.16 | 333.19 | 333.0 | 333.01 | 1955.0 |
| 2020-09-28 07:00:00 | SPY | ETF | 332.95 | 333.01 | 332.79 | 332.81 | 42301.0 |
| 2020-09-28 07:05:00 | SPY | ETF | 332.85 | 332.93 | 332.73 | 332.73 | 15019.0 |
| 2020-09-28 07:10:00 | SPY | ETF | 332.75 | 332.85 | 332.73 | 332.85 | 6612.0 |
| 2020-09-28 07:15:00 | SPY | ETF | 332.82 | 332.93 | 332.61 | 332.64 | 41476.0 |
| 2020-09-28 07:20:00 | SPY | ETF | 332.71 | 332.83 | 332.695 | 332.83 | 24307.0 |
| 2020-09-28 07:25:00 | SPY | ETF | 332.77 | 332.9 | 332.68 | 332.68 | 24392.0 |
| 2020-09-28 07:30:00 | SPY | ETF | 332.69 | 332.95 | 332.69 | 332.95 | 15563.0 |
| 2020-09-28 07:35:00 | SPY | ETF | 332.96 | 332.99 | 332.9 | 332.91 | 32466.0 |
| 2020-09-28 07:40:00 | SPY | ETF | 332.89 | 332.99 | 332.87 | 332.98 | 27232.0 |
| 2020-09-28 07:45:00 | SPY | ETF | 332.88 | 332.88 | 332.79 | 332.85 | 6739.0 |
| 2020-09-28 07:50:00 | SPY | ETF | 332.88 | 332.88 | 332.73 | 332.73 | 19172.0 |
| 2020-09-28 07:55:00 | SPY | ETF | 332.71 | 333.17 | 332.71 | 333.08 | 13897.0 |
| 2020-09-28 08:00:00 | SPY | ETF | 332.8301 | 333.1196 | 329.85 | 333.02 | 64997.0 |
| 2020-09-28 08:05:00 | SPY | ETF | 333.04 | 333.59 | 333.04 | 333.3 | 44083.0 |
| 2020-09-28 08:10:00 | SPY | ETF | 333.24 | 333.32 | 333.22 | 333.32 | 27786.0 |
> showing 50 of 72,577 rows — these rows as CSV