PREVIEW / etf_5min / 2021-07-09
file: by_date/etf_5min/2021/2021-07-09.parquet size: 1.7 MB rows: 78,779
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-09 04:00:00 | SPY | ETF | 431.3 | 431.63 | 431.3 | 431.55 | 3660.0 |
| 2021-07-09 04:05:00 | SPY | ETF | 431.66 | 431.82 | 431.66 | 431.79 | 5291.0 |
| 2021-07-09 04:10:00 | SPY | ETF | 431.86 | 432.14 | 431.86 | 432.1 | 15600.0 |
| 2021-07-09 04:15:00 | SPY | ETF | 432.0 | 432.0 | 431.86 | 431.88 | 1600.0 |
| 2021-07-09 04:20:00 | SPY | ETF | 431.9 | 431.99 | 431.9 | 431.99 | 500.0 |
| 2021-07-09 04:25:00 | SPY | ETF | 431.93 | 432.0 | 431.76 | 431.83 | 6300.0 |
| 2021-07-09 04:30:00 | SPY | ETF | 431.91 | 431.97 | 431.91 | 431.97 | 600.0 |
| 2021-07-09 04:35:00 | SPY | ETF | 432.06 | 432.1 | 432.06 | 432.1 | 1770.0 |
| 2021-07-09 04:40:00 | SPY | ETF | 432.14 | 432.14 | 432.13 | 432.13 | 200.0 |
| 2021-07-09 04:45:00 | SPY | ETF | 432.16 | 432.17 | 432.16 | 432.17 | 300.0 |
| 2021-07-09 04:55:00 | SPY | ETF | 432.1 | 432.1 | 432.0 | 432.06 | 12300.0 |
| 2021-07-09 05:00:00 | SPY | ETF | 432.13 | 432.32 | 432.13 | 432.3 | 3600.0 |
| 2021-07-09 05:05:00 | SPY | ETF | 432.35 | 432.35 | 432.25 | 432.26 | 1600.0 |
| 2021-07-09 05:10:00 | SPY | ETF | 432.18 | 432.18 | 432.14 | 432.14 | 300.0 |
| 2021-07-09 05:15:00 | SPY | ETF | 432.4 | 432.56 | 432.4 | 432.43 | 4063.0 |
| 2021-07-09 05:20:00 | SPY | ETF | 432.54 | 432.54 | 432.48 | 432.53 | 1600.0 |
| 2021-07-09 05:25:00 | SPY | ETF | 432.49 | 432.49 | 432.44 | 432.44 | 300.0 |
| 2021-07-09 05:30:00 | SPY | ETF | 432.47 | 432.59 | 432.36 | 432.36 | 9186.0 |
| 2021-07-09 05:35:00 | SPY | ETF | 432.4 | 432.4 | 432.1 | 432.1 | 5000.0 |
| 2021-07-09 05:40:00 | SPY | ETF | 432.29 | 432.31 | 432.1 | 432.13 | 3200.0 |
| 2021-07-09 05:45:00 | SPY | ETF | 432.05 | 432.11 | 431.95 | 431.95 | 4323.0 |
| 2021-07-09 05:50:00 | SPY | ETF | 431.95 | 432.08 | 431.88 | 432.08 | 2799.0 |
| 2021-07-09 05:55:00 | SPY | ETF | 431.9 | 431.9 | 431.9 | 431.9 | 100.0 |
| 2021-07-09 06:00:00 | SPY | ETF | 431.84 | 431.87 | 431.7 | 431.75 | 3888.0 |
| 2021-07-09 06:05:00 | SPY | ETF | 431.72 | 431.72 | 431.46 | 431.57 | 3200.0 |
| 2021-07-09 06:10:00 | SPY | ETF | 431.6 | 431.6 | 431.48 | 431.49 | 5300.0 |
| 2021-07-09 06:15:00 | SPY | ETF | 431.77 | 431.99 | 431.56 | 431.99 | 1500.0 |
| 2021-07-09 06:20:00 | SPY | ETF | 431.9 | 431.98 | 431.86 | 431.98 | 6255.0 |
| 2021-07-09 06:25:00 | SPY | ETF | 432.06 | 432.06 | 431.89 | 431.91 | 9602.0 |
| 2021-07-09 06:30:00 | SPY | ETF | 431.89 | 432.14 | 431.88 | 432.11 | 8405.0 |
| 2021-07-09 06:35:00 | SPY | ETF | 432.08 | 432.25 | 432.08 | 432.12 | 16868.0 |
| 2021-07-09 06:40:00 | SPY | ETF | 432.22 | 432.24 | 432.1 | 432.16 | 4156.0 |
| 2021-07-09 06:45:00 | SPY | ETF | 432.11 | 432.25 | 432.11 | 432.25 | 5638.0 |
| 2021-07-09 06:50:00 | SPY | ETF | 432.26 | 432.28 | 432.23 | 432.23 | 27600.0 |
| 2021-07-09 06:55:00 | SPY | ETF | 432.15 | 432.19 | 432.1 | 432.15 | 6619.0 |
| 2021-07-09 07:00:00 | SPY | ETF | 432.16 | 432.46 | 432.15 | 432.4 | 14012.0 |
| 2021-07-09 07:05:00 | SPY | ETF | 432.36 | 432.37 | 432.2 | 432.29 | 4536.0 |
| 2021-07-09 07:10:00 | SPY | ETF | 432.31 | 432.43 | 432.31 | 432.4 | 16255.0 |
| 2021-07-09 07:15:00 | SPY | ETF | 432.4 | 432.64 | 432.4 | 432.61 | 13036.0 |
| 2021-07-09 07:20:00 | SPY | ETF | 432.53 | 432.55 | 432.44 | 432.54 | 8972.0 |
| 2021-07-09 07:25:00 | SPY | ETF | 432.57 | 432.6 | 432.39 | 432.39 | 7336.0 |
| 2021-07-09 07:30:00 | SPY | ETF | 432.32 | 432.84 | 432.16 | 432.7 | 37298.0 |
| 2021-07-09 07:35:00 | SPY | ETF | 432.7 | 432.7 | 432.54 | 432.61 | 5989.0 |
| 2021-07-09 07:40:00 | SPY | ETF | 432.6 | 433.0 | 432.49 | 433.0 | 33791.0 |
| 2021-07-09 07:45:00 | SPY | ETF | 432.98 | 433.06 | 432.84 | 432.9 | 8972.0 |
| 2021-07-09 07:50:00 | SPY | ETF | 432.9 | 432.95 | 432.88 | 432.89 | 23286.0 |
| 2021-07-09 07:55:00 | SPY | ETF | 432.88 | 432.95 | 432.88 | 432.9 | 9287.0 |
| 2021-07-09 08:00:00 | SPY | ETF | 432.5701 | 433.0301 | 431.0 | 432.94 | 79852.0 |
| 2021-07-09 08:05:00 | SPY | ETF | 432.95 | 432.95 | 432.82 | 432.86 | 19451.0 |
| 2021-07-09 08:10:00 | SPY | ETF | 432.83 | 432.96 | 432.83 | 432.95 | 17902.0 |
> showing 50 of 78,779 rows — these rows as CSV