PREVIEW / etf_5min / 2020-05-04
file: by_date/etf_5min/2020/2020-05-04.parquet size: 1.7 MB rows: 74,960
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-04 04:00:00 | SPY | ETF | 280.56 | 281.05 | 280.37 | 281.01 | 21109.0 |
| 2020-05-04 04:05:00 | SPY | ETF | 281.06 | 281.12 | 280.79 | 280.83 | 9282.0 |
| 2020-05-04 04:10:00 | SPY | ETF | 280.82 | 280.82 | 280.39 | 280.45 | 10589.0 |
| 2020-05-04 04:15:00 | SPY | ETF | 280.39 | 280.39 | 280.0 | 280.01 | 27648.0 |
| 2020-05-04 04:20:00 | SPY | ETF | 279.92 | 280.25 | 279.92 | 280.06 | 8757.0 |
| 2020-05-04 04:25:00 | SPY | ETF | 280.05 | 280.29 | 279.95 | 280.18 | 6348.0 |
| 2020-05-04 04:30:00 | SPY | ETF | 280.07 | 280.09 | 279.79 | 279.79 | 2667.0 |
| 2020-05-04 04:35:00 | SPY | ETF | 279.77 | 279.85 | 279.71 | 279.77 | 2410.0 |
| 2020-05-04 04:40:00 | SPY | ETF | 279.81 | 280.15 | 279.8 | 279.86 | 9619.0 |
| 2020-05-04 04:45:00 | SPY | ETF | 279.86 | 280.2 | 279.86 | 280.15 | 3921.0 |
| 2020-05-04 04:50:00 | SPY | ETF | 280.02 | 280.08 | 279.86 | 279.86 | 8192.0 |
| 2020-05-04 04:55:00 | SPY | ETF | 279.92 | 279.92 | 279.77 | 279.8 | 4301.0 |
| 2020-05-04 05:00:00 | SPY | ETF | 279.69 | 279.69 | 279.28 | 279.28 | 9246.0 |
| 2020-05-04 05:05:00 | SPY | ETF | 279.25 | 279.45 | 279.24 | 279.25 | 7723.0 |
| 2020-05-04 05:10:00 | SPY | ETF | 279.3 | 279.34 | 279.02 | 279.02 | 17431.0 |
| 2020-05-04 05:15:00 | SPY | ETF | 279.05 | 279.11 | 278.9 | 278.9 | 11203.0 |
| 2020-05-04 05:20:00 | SPY | ETF | 279.0 | 279.14 | 278.79 | 278.79 | 3397.0 |
| 2020-05-04 05:25:00 | SPY | ETF | 278.72 | 278.9 | 278.69 | 278.75 | 4965.0 |
| 2020-05-04 05:30:00 | SPY | ETF | 278.79 | 278.96 | 278.78 | 278.93 | 11048.0 |
| 2020-05-04 05:35:00 | SPY | ETF | 278.84 | 279.05 | 278.79 | 278.97 | 7315.0 |
| 2020-05-04 05:40:00 | SPY | ETF | 279.0 | 279.48 | 279.0 | 279.48 | 7461.0 |
| 2020-05-04 05:45:00 | SPY | ETF | 279.49 | 279.7 | 279.47 | 279.67 | 7992.0 |
| 2020-05-04 05:50:00 | SPY | ETF | 279.7 | 279.79 | 279.7 | 279.75 | 34596.0 |
| 2020-05-04 05:55:00 | SPY | ETF | 279.73 | 279.89 | 279.65 | 279.89 | 15978.0 |
| 2020-05-04 06:00:00 | SPY | ETF | 279.94 | 279.94 | 279.61 | 279.61 | 3617.0 |
| 2020-05-04 06:05:00 | SPY | ETF | 279.67 | 279.82 | 279.67 | 279.78 | 11543.0 |
| 2020-05-04 06:10:00 | SPY | ETF | 279.8 | 280.04 | 279.8 | 280.04 | 8891.0 |
| 2020-05-04 06:15:00 | SPY | ETF | 280.1 | 280.45 | 280.02 | 280.45 | 37748.0 |
| 2020-05-04 06:20:00 | SPY | ETF | 280.49 | 280.51 | 280.25 | 280.25 | 72567.0 |
| 2020-05-04 06:25:00 | SPY | ETF | 280.25 | 280.25 | 280.07 | 280.07 | 30412.0 |
| 2020-05-04 06:30:00 | SPY | ETF | 280.18 | 280.28 | 280.18 | 280.26 | 3831.0 |
| 2020-05-04 06:35:00 | SPY | ETF | 280.14 | 280.2 | 280.05 | 280.19 | 12432.0 |
| 2020-05-04 06:40:00 | SPY | ETF | 280.11 | 280.32 | 280.11 | 280.32 | 8902.0 |
| 2020-05-04 06:45:00 | SPY | ETF | 280.25 | 280.3 | 280.1 | 280.2 | 18168.0 |
| 2020-05-04 06:50:00 | SPY | ETF | 280.0 | 280.0 | 279.78 | 279.82 | 7602.0 |
| 2020-05-04 06:55:00 | SPY | ETF | 279.84 | 279.99 | 279.79 | 279.99 | 7626.0 |
| 2020-05-04 07:00:00 | SPY | ETF | 280.03 | 280.03 | 279.78 | 279.85 | 27170.0 |
| 2020-05-04 07:05:00 | SPY | ETF | 279.77 | 280.0 | 279.69 | 279.69 | 18179.0 |
| 2020-05-04 07:10:00 | SPY | ETF | 279.73 | 279.84 | 279.69 | 279.82 | 21497.0 |
| 2020-05-04 07:15:00 | SPY | ETF | 279.8 | 280.04 | 279.74 | 280.04 | 16581.0 |
| 2020-05-04 07:20:00 | SPY | ETF | 280.0 | 280.1 | 279.82 | 279.85 | 19539.0 |
| 2020-05-04 07:25:00 | SPY | ETF | 279.87 | 280.25 | 279.87 | 280.13 | 16816.0 |
| 2020-05-04 07:30:00 | SPY | ETF | 280.06 | 280.3 | 280.06 | 280.3 | 26220.0 |
| 2020-05-04 07:35:00 | SPY | ETF | 280.29 | 280.6 | 280.29 | 280.59 | 63392.0 |
| 2020-05-04 07:40:00 | SPY | ETF | 280.59 | 280.6 | 280.27 | 280.27 | 26941.0 |
| 2020-05-04 07:45:00 | SPY | ETF | 280.23 | 280.47 | 280.23 | 280.39 | 41091.0 |
| 2020-05-04 07:50:00 | SPY | ETF | 280.39 | 280.83 | 280.2 | 280.83 | 76958.0 |
| 2020-05-04 07:55:00 | SPY | ETF | 280.78 | 280.85 | 280.35 | 280.36 | 68135.0 |
| 2020-05-04 08:00:00 | SPY | ETF | 280.31 | 281.55 | 279.7 | 280.19 | 101551.0 |
| 2020-05-04 08:05:00 | SPY | ETF | 280.14 | 280.28 | 280.0 | 280.28 | 40545.0 |
> showing 50 of 74,960 rows — these rows as CSV