PREVIEW / etf_5min / 2020-06-29
file: by_date/etf_5min/2020/2020-06-29.parquet size: 1.5 MB rows: 73,908
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-06-29 04:00:00 | SPY | ETF | 301.22 | 301.24 | 300.86 | 300.86 | 34896.0 |
| 2020-06-29 04:05:00 | SPY | ETF | 300.99 | 301.02 | 300.72 | 300.78 | 12611.0 |
| 2020-06-29 04:10:00 | SPY | ETF | 301.0 | 301.0 | 300.4 | 300.43 | 2890.0 |
| 2020-06-29 04:15:00 | SPY | ETF | 300.41 | 300.54 | 300.36 | 300.36 | 939.0 |
| 2020-06-29 04:20:00 | SPY | ETF | 300.34 | 300.61 | 300.34 | 300.6 | 2972.0 |
| 2020-06-29 04:25:00 | SPY | ETF | 300.69 | 300.75 | 300.4 | 300.4 | 1774.0 |
| 2020-06-29 04:30:00 | SPY | ETF | 300.8 | 300.8 | 300.74 | 300.76 | 1887.0 |
| 2020-06-29 04:35:00 | SPY | ETF | 300.7 | 300.9 | 300.66 | 300.76 | 3127.0 |
| 2020-06-29 04:40:00 | SPY | ETF | 300.71 | 301.14 | 300.69 | 300.99 | 4183.0 |
| 2020-06-29 04:45:00 | SPY | ETF | 301.09 | 301.24 | 301.01 | 301.13 | 5142.0 |
| 2020-06-29 04:50:00 | SPY | ETF | 301.27 | 301.27 | 301.27 | 301.27 | 107.0 |
| 2020-06-29 04:55:00 | SPY | ETF | 301.3 | 301.37 | 301.2 | 301.37 | 1819.0 |
| 2020-06-29 05:00:00 | SPY | ETF | 301.29 | 301.34 | 301.19 | 301.25 | 1202.0 |
| 2020-06-29 05:05:00 | SPY | ETF | 301.34 | 301.34 | 300.9 | 301.03 | 1524.0 |
| 2020-06-29 05:10:00 | SPY | ETF | 301.04 | 301.35 | 301.04 | 301.21 | 2519.0 |
| 2020-06-29 05:15:00 | SPY | ETF | 301.24 | 301.37 | 301.24 | 301.24 | 2579.0 |
| 2020-06-29 05:20:00 | SPY | ETF | 301.31 | 301.41 | 301.31 | 301.36 | 3392.0 |
| 2020-06-29 05:25:00 | SPY | ETF | 301.41 | 301.41 | 301.37 | 301.37 | 600.0 |
| 2020-06-29 05:30:00 | SPY | ETF | 301.04 | 301.56 | 301.02 | 301.53 | 8153.0 |
| 2020-06-29 05:35:00 | SPY | ETF | 301.47 | 301.61 | 301.47 | 301.61 | 4064.0 |
| 2020-06-29 05:40:00 | SPY | ETF | 301.65 | 301.89 | 301.65 | 301.89 | 2197.0 |
| 2020-06-29 05:45:00 | SPY | ETF | 301.72 | 301.75 | 301.69 | 301.7 | 2255.0 |
| 2020-06-29 05:55:00 | SPY | ETF | 301.67 | 301.7 | 301.62 | 301.7 | 1380.0 |
| 2020-06-29 06:00:00 | SPY | ETF | 301.69 | 301.87 | 301.13 | 301.24 | 35544.0 |
| 2020-06-29 06:05:00 | SPY | ETF | 301.4 | 301.49 | 301.4 | 301.4 | 2406.0 |
| 2020-06-29 06:10:00 | SPY | ETF | 301.51 | 301.54 | 301.25 | 301.25 | 2284.0 |
| 2020-06-29 06:15:00 | SPY | ETF | 301.12 | 301.26 | 301.1 | 301.26 | 2836.0 |
| 2020-06-29 06:20:00 | SPY | ETF | 301.34 | 301.4 | 301.34 | 301.37 | 5253.0 |
| 2020-06-29 06:25:00 | SPY | ETF | 301.27 | 301.32 | 301.27 | 301.3 | 15237.0 |
| 2020-06-29 06:30:00 | SPY | ETF | 301.3 | 301.38 | 301.19 | 301.26 | 88058.0 |
| 2020-06-29 06:35:00 | SPY | ETF | 301.14 | 301.24 | 300.7 | 300.85 | 13536.0 |
| 2020-06-29 06:40:00 | SPY | ETF | 300.92 | 300.98 | 300.91 | 300.98 | 2124.0 |
| 2020-06-29 06:45:00 | SPY | ETF | 300.99 | 301.47 | 300.99 | 301.46 | 8986.0 |
| 2020-06-29 06:50:00 | SPY | ETF | 301.47 | 301.51 | 301.43 | 301.43 | 25644.0 |
| 2020-06-29 06:55:00 | SPY | ETF | 301.51 | 301.53 | 301.48 | 301.5 | 10400.0 |
| 2020-06-29 07:00:00 | SPY | ETF | 301.51 | 301.57 | 301.25 | 301.28 | 44960.0 |
| 2020-06-29 07:05:00 | SPY | ETF | 301.22 | 301.35 | 301.19 | 301.3 | 22429.0 |
| 2020-06-29 07:10:00 | SPY | ETF | 301.33 | 301.45 | 301.28 | 301.37 | 65430.0 |
| 2020-06-29 07:15:00 | SPY | ETF | 301.34 | 301.4 | 301.24 | 301.37 | 34302.0 |
| 2020-06-29 07:20:00 | SPY | ETF | 301.33 | 301.61 | 301.33 | 301.61 | 43796.0 |
| 2020-06-29 07:25:00 | SPY | ETF | 301.61 | 301.83 | 301.6 | 301.77 | 76344.0 |
| 2020-06-29 07:30:00 | SPY | ETF | 301.84 | 301.84 | 301.62 | 301.71 | 47756.0 |
| 2020-06-29 07:35:00 | SPY | ETF | 301.7 | 301.74 | 301.5 | 301.56 | 63382.0 |
| 2020-06-29 07:40:00 | SPY | ETF | 301.55 | 301.72 | 301.55 | 301.64 | 31041.0 |
| 2020-06-29 07:45:00 | SPY | ETF | 301.7 | 301.75 | 301.53 | 301.67 | 30924.0 |
| 2020-06-29 07:50:00 | SPY | ETF | 301.6 | 302.55 | 301.59 | 302.46 | 91205.0 |
| 2020-06-29 07:55:00 | SPY | ETF | 302.42 | 302.7 | 302.38 | 302.44 | 91045.0 |
| 2020-06-29 08:00:00 | SPY | ETF | 302.5 | 302.65 | 300.01 | 302.42 | 170668.0 |
| 2020-06-29 08:05:00 | SPY | ETF | 302.37 | 302.47 | 302.16 | 302.33 | 66466.0 |
| 2020-06-29 08:10:00 | SPY | ETF | 302.35 | 302.51 | 302.31 | 302.4 | 128075.0 |
> showing 50 of 73,908 rows — these rows as CSV