PREVIEW / etf_5min / 2021-08-19
file: by_date/etf_5min/2021/2021-08-19.parquet size: 1.8 MB rows: 84,387
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-08-19 04:00:00 | SPY | ETF | 437.88 | 437.88 | 435.44 | 435.47 | 90374.0 |
| 2021-08-19 04:05:00 | SPY | ETF | 435.46 | 435.62 | 435.35 | 435.62 | 11423.0 |
| 2021-08-19 04:10:00 | SPY | ETF | 435.63 | 435.77 | 435.54 | 435.54 | 8904.0 |
| 2021-08-19 04:15:00 | SPY | ETF | 435.42 | 435.44 | 435.21 | 435.29 | 30700.0 |
| 2021-08-19 04:20:00 | SPY | ETF | 435.26 | 435.26 | 435.09 | 435.12 | 36639.0 |
| 2021-08-19 04:25:00 | SPY | ETF | 435.0 | 435.16 | 434.92 | 435.16 | 70456.0 |
| 2021-08-19 04:30:00 | SPY | ETF | 435.2 | 435.2 | 435.08 | 435.1 | 5516.0 |
| 2021-08-19 04:35:00 | SPY | ETF | 435.1 | 435.18 | 434.92 | 435.17 | 13212.0 |
| 2021-08-19 04:40:00 | SPY | ETF | 435.34 | 435.58 | 435.19 | 435.49 | 15821.0 |
| 2021-08-19 04:45:00 | SPY | ETF | 435.56 | 435.6 | 435.01 | 435.02 | 4810.0 |
| 2021-08-19 04:50:00 | SPY | ETF | 435.01 | 435.21 | 434.92 | 435.0 | 3761.0 |
| 2021-08-19 04:55:00 | SPY | ETF | 434.99 | 435.16 | 434.99 | 435.16 | 3666.0 |
| 2021-08-19 05:00:00 | SPY | ETF | 435.2 | 435.22 | 435.02 | 435.1 | 2001.0 |
| 2021-08-19 05:05:00 | SPY | ETF | 434.87 | 434.9 | 434.64 | 434.7 | 11223.0 |
| 2021-08-19 05:10:00 | SPY | ETF | 434.68 | 434.88 | 434.62 | 434.74 | 2600.0 |
| 2021-08-19 05:15:00 | SPY | ETF | 434.66 | 435.02 | 434.5 | 435.02 | 4560.0 |
| 2021-08-19 05:20:00 | SPY | ETF | 435.01 | 435.19 | 434.9 | 435.19 | 7138.0 |
| 2021-08-19 05:25:00 | SPY | ETF | 435.18 | 435.35 | 435.17 | 435.25 | 3250.0 |
| 2021-08-19 05:30:00 | SPY | ETF | 435.19 | 435.74 | 435.14 | 435.74 | 8695.0 |
| 2021-08-19 05:35:00 | SPY | ETF | 435.79 | 435.97 | 435.77 | 435.9 | 3083.0 |
| 2021-08-19 05:40:00 | SPY | ETF | 435.94 | 436.13 | 435.85 | 436.13 | 6282.0 |
| 2021-08-19 05:45:00 | SPY | ETF | 436.14 | 436.33 | 436.14 | 436.26 | 7463.0 |
| 2021-08-19 05:50:00 | SPY | ETF | 436.25 | 436.47 | 436.25 | 436.47 | 6049.0 |
| 2021-08-19 05:55:00 | SPY | ETF | 436.52 | 436.75 | 436.5 | 436.5 | 4254.0 |
| 2021-08-19 06:00:00 | SPY | ETF | 436.63 | 436.69 | 436.55 | 436.58 | 10527.0 |
| 2021-08-19 06:05:00 | SPY | ETF | 436.51 | 437.02 | 436.51 | 436.72 | 8420.0 |
| 2021-08-19 06:10:00 | SPY | ETF | 436.61 | 436.72 | 436.54 | 436.54 | 3504.0 |
| 2021-08-19 06:15:00 | SPY | ETF | 436.49 | 436.58 | 436.27 | 436.35 | 1598.0 |
| 2021-08-19 06:20:00 | SPY | ETF | 436.38 | 436.79 | 436.25 | 436.73 | 2860.0 |
| 2021-08-19 06:25:00 | SPY | ETF | 436.72 | 436.75 | 436.41 | 436.44 | 1500.0 |
| 2021-08-19 06:30:00 | SPY | ETF | 436.57 | 436.68 | 436.36 | 436.45 | 5739.0 |
| 2021-08-19 06:35:00 | SPY | ETF | 436.54 | 436.54 | 436.23 | 436.29 | 85096.0 |
| 2021-08-19 06:40:00 | SPY | ETF | 436.27 | 436.32 | 435.74 | 435.76 | 58776.0 |
| 2021-08-19 06:45:00 | SPY | ETF | 435.85 | 435.99 | 435.7 | 435.99 | 106575.0 |
| 2021-08-19 06:50:00 | SPY | ETF | 435.92 | 436.0 | 435.7 | 435.83 | 83082.0 |
| 2021-08-19 06:55:00 | SPY | ETF | 435.91 | 435.95 | 435.7 | 435.73 | 12041.0 |
| 2021-08-19 07:00:00 | SPY | ETF | 435.7 | 435.93 | 435.7 | 435.89 | 25665.0 |
| 2021-08-19 07:05:00 | SPY | ETF | 435.94 | 435.98 | 435.44 | 435.64 | 23642.0 |
| 2021-08-19 07:10:00 | SPY | ETF | 435.54 | 435.69 | 435.4 | 435.69 | 15957.0 |
| 2021-08-19 07:15:00 | SPY | ETF | 435.69 | 435.8 | 435.44 | 435.55 | 32310.0 |
| 2021-08-19 07:20:00 | SPY | ETF | 435.55 | 435.63 | 435.18 | 435.45 | 143232.0 |
| 2021-08-19 07:25:00 | SPY | ETF | 435.45 | 435.69 | 435.38 | 435.69 | 63769.0 |
| 2021-08-19 07:30:00 | SPY | ETF | 435.73 | 435.93 | 435.64 | 435.85 | 39233.0 |
| 2021-08-19 07:35:00 | SPY | ETF | 435.86 | 436.1 | 435.77 | 435.99 | 29755.0 |
| 2021-08-19 07:40:00 | SPY | ETF | 436.0 | 436.08 | 435.81 | 435.81 | 46667.0 |
| 2021-08-19 07:45:00 | SPY | ETF | 435.79 | 436.03 | 435.79 | 435.85 | 21900.0 |
| 2021-08-19 07:50:00 | SPY | ETF | 435.82 | 435.82 | 435.25 | 435.28 | 72040.0 |
| 2021-08-19 07:55:00 | SPY | ETF | 435.27 | 435.36 | 435.2 | 435.23 | 92551.0 |
| 2021-08-19 08:00:00 | SPY | ETF | 435.23 | 439.07 | 434.86 | 435.04 | 106771.0 |
| 2021-08-19 08:05:00 | SPY | ETF | 435.05 | 435.43 | 435.0 | 435.4 | 46397.0 |
> showing 50 of 84,387 rows — these rows as CSV