PREVIEW / etf_5min / 2021-09-22
file: by_date/etf_5min/2021/2021-09-22.parquet size: 1.8 MB rows: 81,800
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-09-22 04:00:00 | SPY | ETF | 434.02 | 435.13 | 433.02 | 435.04 | 7510.0 |
| 2021-09-22 04:05:00 | SPY | ETF | 435.22 | 435.47 | 435.22 | 435.42 | 3008.0 |
| 2021-09-22 04:10:00 | SPY | ETF | 435.45 | 435.57 | 435.41 | 435.57 | 1200.0 |
| 2021-09-22 04:15:00 | SPY | ETF | 435.58 | 435.61 | 435.45 | 435.45 | 2050.0 |
| 2021-09-22 04:20:00 | SPY | ETF | 435.62 | 435.62 | 435.55 | 435.6 | 700.0 |
| 2021-09-22 04:25:00 | SPY | ETF | 435.65 | 435.7 | 435.58 | 435.62 | 2300.0 |
| 2021-09-22 04:30:00 | SPY | ETF | 435.53 | 435.8 | 435.53 | 435.8 | 300.0 |
| 2021-09-22 04:35:00 | SPY | ETF | 435.66 | 435.8 | 435.57 | 435.8 | 4073.0 |
| 2021-09-22 04:40:00 | SPY | ETF | 435.83 | 435.91 | 435.63 | 435.91 | 6802.0 |
| 2021-09-22 04:45:00 | SPY | ETF | 435.99 | 436.12 | 435.99 | 436.1 | 10005.0 |
| 2021-09-22 04:50:00 | SPY | ETF | 436.11 | 436.11 | 436.08 | 436.08 | 475.0 |
| 2021-09-22 04:55:00 | SPY | ETF | 436.06 | 436.06 | 436.03 | 436.03 | 675.0 |
| 2021-09-22 05:00:00 | SPY | ETF | 436.03 | 436.03 | 436.03 | 436.03 | 500.0 |
| 2021-09-22 05:05:00 | SPY | ETF | 436.21 | 436.25 | 436.2 | 436.2 | 1100.0 |
| 2021-09-22 05:10:00 | SPY | ETF | 436.15 | 436.2 | 436.12 | 436.12 | 600.0 |
| 2021-09-22 05:15:00 | SPY | ETF | 436.11 | 436.11 | 435.96 | 435.96 | 1700.0 |
| 2021-09-22 05:20:00 | SPY | ETF | 436.0 | 436.0 | 436.0 | 436.0 | 407.0 |
| 2021-09-22 05:25:00 | SPY | ETF | 436.06 | 436.08 | 435.98 | 435.98 | 4367.0 |
| 2021-09-22 05:30:00 | SPY | ETF | 435.91 | 435.91 | 435.7 | 435.71 | 6719.0 |
| 2021-09-22 05:35:00 | SPY | ETF | 435.55 | 435.69 | 435.51 | 435.65 | 6650.0 |
| 2021-09-22 05:40:00 | SPY | ETF | 435.68 | 435.71 | 435.58 | 435.68 | 7525.0 |
| 2021-09-22 05:45:00 | SPY | ETF | 435.62 | 435.63 | 435.59 | 435.61 | 1700.0 |
| 2021-09-22 05:50:00 | SPY | ETF | 435.74 | 436.0 | 435.74 | 436.0 | 2150.0 |
| 2021-09-22 05:55:00 | SPY | ETF | 436.0 | 436.01 | 435.93 | 435.96 | 7274.0 |
| 2021-09-22 06:00:00 | SPY | ETF | 435.97 | 436.24 | 435.97 | 436.21 | 17003.0 |
| 2021-09-22 06:05:00 | SPY | ETF | 436.19 | 436.27 | 436.19 | 436.24 | 13111.0 |
| 2021-09-22 06:10:00 | SPY | ETF | 436.17 | 436.19 | 436.17 | 436.19 | 425.0 |
| 2021-09-22 06:15:00 | SPY | ETF | 436.28 | 436.39 | 436.28 | 436.37 | 33782.0 |
| 2021-09-22 06:20:00 | SPY | ETF | 436.39 | 436.4 | 436.31 | 436.35 | 15875.0 |
| 2021-09-22 06:25:00 | SPY | ETF | 436.21 | 436.21 | 436.11 | 436.11 | 2428.0 |
| 2021-09-22 06:30:00 | SPY | ETF | 436.18 | 436.18 | 436.01 | 436.01 | 2874.0 |
| 2021-09-22 06:35:00 | SPY | ETF | 436.02 | 436.25 | 436.02 | 436.24 | 3653.0 |
| 2021-09-22 06:40:00 | SPY | ETF | 436.3 | 436.56 | 436.18 | 436.18 | 43237.0 |
| 2021-09-22 06:45:00 | SPY | ETF | 436.26 | 436.26 | 436.01 | 436.02 | 37779.0 |
| 2021-09-22 06:50:00 | SPY | ETF | 436.15 | 436.15 | 436.06 | 436.06 | 971.0 |
| 2021-09-22 06:55:00 | SPY | ETF | 436.08 | 436.12 | 435.97 | 435.98 | 7351.0 |
| 2021-09-22 07:00:00 | SPY | ETF | 435.99 | 436.01 | 435.76 | 435.9 | 16015.0 |
| 2021-09-22 07:05:00 | SPY | ETF | 435.9 | 436.01 | 435.89 | 435.89 | 5787.0 |
| 2021-09-22 07:10:00 | SPY | ETF | 435.89 | 435.98 | 435.86 | 435.9 | 13797.0 |
| 2021-09-22 07:15:00 | SPY | ETF | 435.92 | 435.92 | 435.7 | 435.74 | 13027.0 |
| 2021-09-22 07:20:00 | SPY | ETF | 435.72 | 435.9 | 435.67 | 435.88 | 20840.0 |
| 2021-09-22 07:25:00 | SPY | ETF | 435.9 | 435.94 | 435.85 | 435.92 | 5051.0 |
| 2021-09-22 07:30:00 | SPY | ETF | 435.91 | 436.13 | 435.89 | 436.01 | 13524.0 |
| 2021-09-22 07:35:00 | SPY | ETF | 436.1 | 436.11 | 436.0 | 436.0 | 12018.0 |
| 2021-09-22 07:40:00 | SPY | ETF | 436.02 | 436.03 | 435.98 | 436.0 | 5675.0 |
| 2021-09-22 07:45:00 | SPY | ETF | 435.98 | 436.04 | 435.98 | 436.0 | 30447.0 |
| 2021-09-22 07:50:00 | SPY | ETF | 435.99 | 436.05 | 435.92 | 436.01 | 3605.0 |
| 2021-09-22 07:55:00 | SPY | ETF | 435.99 | 436.0 | 435.88 | 435.98 | 28861.0 |
| 2021-09-22 08:00:00 | SPY | ETF | 435.9199 | 436.5096 | 434.31 | 436.07 | 37084.0 |
| 2021-09-22 08:05:00 | SPY | ETF | 436.05 | 436.06 | 433.915 | 436.06 | 13717.0 |
> showing 50 of 81,800 rows — these rows as CSV