PREVIEW / etf_5min / 2020-06-25
file: by_date/etf_5min/2020/2020-06-25.parquet size: 1.6 MB rows: 74,177
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-25 04:00:00 | SPY | ETF | 301.53 | 302.0 | 301.48 | 302.0 | 44323.0 |
| 2020-06-25 04:05:00 | SPY | ETF | 301.95 | 302.86 | 301.95 | 302.69 | 28265.0 |
| 2020-06-25 04:10:00 | SPY | ETF | 302.83 | 303.25 | 302.83 | 303.2 | 16514.0 |
| 2020-06-25 04:15:00 | SPY | ETF | 303.15 | 303.6 | 303.06 | 303.54 | 16310.0 |
| 2020-06-25 04:20:00 | SPY | ETF | 303.59 | 304.23 | 303.59 | 304.0 | 26183.0 |
| 2020-06-25 04:25:00 | SPY | ETF | 304.05 | 304.07 | 303.65 | 303.69 | 9550.0 |
| 2020-06-25 04:30:00 | SPY | ETF | 303.74 | 304.05 | 303.65 | 303.65 | 1949.0 |
| 2020-06-25 04:35:00 | SPY | ETF | 303.84 | 303.84 | 303.6 | 303.72 | 6700.0 |
| 2020-06-25 04:40:00 | SPY | ETF | 303.69 | 304.59 | 303.63 | 304.53 | 7373.0 |
| 2020-06-25 04:45:00 | SPY | ETF | 304.43 | 304.75 | 304.4 | 304.4 | 17053.0 |
| 2020-06-25 04:50:00 | SPY | ETF | 304.4 | 304.54 | 304.36 | 304.47 | 6076.0 |
| 2020-06-25 04:55:00 | SPY | ETF | 304.44 | 304.44 | 304.27 | 304.4 | 3277.0 |
| 2020-06-25 05:00:00 | SPY | ETF | 304.39 | 304.83 | 304.13 | 304.83 | 6535.0 |
| 2020-06-25 05:05:00 | SPY | ETF | 304.87 | 304.87 | 304.52 | 304.55 | 3559.0 |
| 2020-06-25 05:10:00 | SPY | ETF | 304.51 | 304.51 | 304.43 | 304.43 | 800.0 |
| 2020-06-25 05:15:00 | SPY | ETF | 304.52 | 304.65 | 304.52 | 304.56 | 7396.0 |
| 2020-06-25 05:20:00 | SPY | ETF | 304.53 | 304.72 | 304.53 | 304.62 | 1380.0 |
| 2020-06-25 05:25:00 | SPY | ETF | 304.7 | 305.01 | 304.7 | 305.01 | 5414.0 |
| 2020-06-25 05:30:00 | SPY | ETF | 305.19 | 305.3 | 305.02 | 305.15 | 9067.0 |
| 2020-06-25 05:35:00 | SPY | ETF | 305.2 | 305.33 | 305.1 | 305.15 | 7744.0 |
| 2020-06-25 05:40:00 | SPY | ETF | 304.9 | 304.96 | 303.86 | 304.04 | 23265.0 |
| 2020-06-25 05:45:00 | SPY | ETF | 304.04 | 304.29 | 303.84 | 304.25 | 10168.0 |
| 2020-06-25 05:50:00 | SPY | ETF | 304.36 | 304.37 | 304.19 | 304.31 | 33241.0 |
| 2020-06-25 05:55:00 | SPY | ETF | 304.3 | 304.3 | 304.08 | 304.08 | 6145.0 |
| 2020-06-25 06:00:00 | SPY | ETF | 304.2 | 304.49 | 304.18 | 304.49 | 1723.0 |
| 2020-06-25 06:05:00 | SPY | ETF | 304.35 | 304.35 | 304.01 | 304.15 | 52101.0 |
| 2020-06-25 06:10:00 | SPY | ETF | 304.02 | 304.04 | 303.91 | 303.95 | 22071.0 |
| 2020-06-25 06:15:00 | SPY | ETF | 303.85 | 304.1 | 303.8 | 303.8 | 39543.0 |
| 2020-06-25 06:20:00 | SPY | ETF | 303.88 | 304.24 | 303.88 | 304.18 | 767.0 |
| 2020-06-25 06:25:00 | SPY | ETF | 304.25 | 304.28 | 304.17 | 304.17 | 7085.0 |
| 2020-06-25 06:30:00 | SPY | ETF | 304.14 | 304.4 | 303.94 | 304.34 | 12718.0 |
| 2020-06-25 06:35:00 | SPY | ETF | 304.03 | 304.3 | 303.79 | 304.18 | 12843.0 |
| 2020-06-25 06:40:00 | SPY | ETF | 304.09 | 304.11 | 303.83 | 304.01 | 5089.0 |
| 2020-06-25 06:45:00 | SPY | ETF | 304.21 | 304.22 | 304.04 | 304.09 | 4870.0 |
| 2020-06-25 06:50:00 | SPY | ETF | 304.12 | 304.37 | 304.04 | 304.37 | 51174.0 |
| 2020-06-25 06:55:00 | SPY | ETF | 304.36 | 304.52 | 304.27 | 304.51 | 27824.0 |
| 2020-06-25 07:00:00 | SPY | ETF | 304.47 | 304.52 | 303.98 | 304.05 | 31410.0 |
| 2020-06-25 07:05:00 | SPY | ETF | 304.06 | 304.2 | 303.96 | 304.08 | 48808.0 |
| 2020-06-25 07:10:00 | SPY | ETF | 304.15 | 304.3 | 303.96 | 303.98 | 27306.0 |
| 2020-06-25 07:15:00 | SPY | ETF | 304.02 | 304.02 | 303.37 | 303.45 | 40489.0 |
| 2020-06-25 07:20:00 | SPY | ETF | 303.47 | 303.6 | 303.37 | 303.37 | 63186.0 |
| 2020-06-25 07:25:00 | SPY | ETF | 303.46 | 303.51 | 303.39 | 303.49 | 15793.0 |
| 2020-06-25 07:30:00 | SPY | ETF | 303.45 | 303.55 | 303.38 | 303.47 | 26696.0 |
| 2020-06-25 07:35:00 | SPY | ETF | 303.53 | 303.58 | 303.27 | 303.3 | 43356.0 |
| 2020-06-25 07:40:00 | SPY | ETF | 303.32 | 303.36 | 302.44 | 302.62 | 96614.0 |
| 2020-06-25 07:45:00 | SPY | ETF | 302.62 | 302.69 | 302.3 | 302.69 | 138506.0 |
| 2020-06-25 07:50:00 | SPY | ETF | 302.65 | 302.85 | 302.58 | 302.82 | 62976.0 |
| 2020-06-25 07:55:00 | SPY | ETF | 302.82 | 302.95 | 302.41 | 302.44 | 67218.0 |
| 2020-06-25 08:00:00 | SPY | ETF | 302.47 | 304.47 | 300.83 | 302.79 | 128951.0 |
| 2020-06-25 08:05:00 | SPY | ETF | 302.76 | 302.9 | 302.61 | 302.9 | 43132.0 |
> showing 50 of 74,177 rows — these rows as CSV