PREVIEW / etf_5min / 2021-11-05
file: by_date/etf_5min/2021/2021-11-05.parquet size: 1.8 MB rows: 87,374
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-11-05 04:00:00 | SPY | ETF | 466.6 | 466.77 | 466.6 | 466.75 | 681.0 |
| 2021-11-05 04:05:00 | SPY | ETF | 466.82 | 466.85 | 466.74 | 466.84 | 1280.0 |
| 2021-11-05 04:10:00 | SPY | ETF | 466.87 | 467.0 | 466.87 | 467.0 | 600.0 |
| 2021-11-05 04:15:00 | SPY | ETF | 467.02 | 467.1 | 467.02 | 467.09 | 1080.0 |
| 2021-11-05 04:25:00 | SPY | ETF | 467.14 | 467.14 | 466.97 | 467.04 | 1148.0 |
| 2021-11-05 04:30:00 | SPY | ETF | 466.92 | 466.92 | 466.92 | 466.92 | 447.0 |
| 2021-11-05 04:35:00 | SPY | ETF | 467.02 | 467.02 | 466.99 | 466.99 | 648.0 |
| 2021-11-05 04:45:00 | SPY | ETF | 467.0 | 467.0 | 466.93 | 466.99 | 821.0 |
| 2021-11-05 04:50:00 | SPY | ETF | 466.98 | 466.98 | 466.98 | 466.98 | 250.0 |
| 2021-11-05 04:55:00 | SPY | ETF | 467.0 | 467.0 | 467.0 | 467.0 | 499.0 |
| 2021-11-05 05:05:00 | SPY | ETF | 467.16 | 467.17 | 467.1 | 467.17 | 1540.0 |
| 2021-11-05 05:10:00 | SPY | ETF | 467.14 | 467.14 | 467.13 | 467.14 | 641.0 |
| 2021-11-05 05:15:00 | SPY | ETF | 467.21 | 467.22 | 467.16 | 467.16 | 500.0 |
| 2021-11-05 05:25:00 | SPY | ETF | 467.19 | 467.35 | 467.19 | 467.31 | 1673.0 |
| 2021-11-05 05:30:00 | SPY | ETF | 467.35 | 467.4 | 467.35 | 467.4 | 516.0 |
| 2021-11-05 05:40:00 | SPY | ETF | 467.48 | 467.48 | 467.4 | 467.42 | 5099.0 |
| 2021-11-05 05:45:00 | SPY | ETF | 467.63 | 467.67 | 467.6 | 467.67 | 889.0 |
| 2021-11-05 05:50:00 | SPY | ETF | 467.66 | 467.7 | 467.66 | 467.7 | 2900.0 |
| 2021-11-05 05:55:00 | SPY | ETF | 467.68 | 467.84 | 467.68 | 467.84 | 1243.0 |
| 2021-11-05 06:00:00 | SPY | ETF | 467.87 | 467.87 | 467.78 | 467.84 | 3967.0 |
| 2021-11-05 06:05:00 | SPY | ETF | 467.78 | 467.8 | 467.75 | 467.8 | 1299.0 |
| 2021-11-05 06:15:00 | SPY | ETF | 467.82 | 467.82 | 467.82 | 467.82 | 100.0 |
| 2021-11-05 06:20:00 | SPY | ETF | 467.9 | 468.01 | 467.9 | 467.95 | 8937.0 |
| 2021-11-05 06:25:00 | SPY | ETF | 467.97 | 467.97 | 467.9 | 467.9 | 2449.0 |
| 2021-11-05 06:30:00 | SPY | ETF | 467.83 | 467.83 | 467.82 | 467.82 | 555.0 |
| 2021-11-05 06:35:00 | SPY | ETF | 467.91 | 467.91 | 467.91 | 467.91 | 300.0 |
| 2021-11-05 06:40:00 | SPY | ETF | 467.89 | 467.89 | 467.82 | 467.82 | 1047.0 |
| 2021-11-05 06:50:00 | SPY | ETF | 467.89 | 468.04 | 467.89 | 467.95 | 6699.0 |
| 2021-11-05 06:55:00 | SPY | ETF | 467.95 | 468.03 | 467.95 | 468.01 | 4365.0 |
| 2021-11-05 07:00:00 | SPY | ETF | 468.03 | 468.11 | 467.96 | 468.0 | 7147.0 |
| 2021-11-05 07:05:00 | SPY | ETF | 468.03 | 468.08 | 468.02 | 468.07 | 8398.0 |
| 2021-11-05 07:10:00 | SPY | ETF | 468.12 | 468.26 | 467.9 | 467.91 | 14997.0 |
| 2021-11-05 07:15:00 | SPY | ETF | 467.91 | 467.93 | 467.84 | 467.92 | 4404.0 |
| 2021-11-05 07:20:00 | SPY | ETF | 467.88 | 467.9 | 467.73 | 467.73 | 3284.0 |
| 2021-11-05 07:25:00 | SPY | ETF | 467.77 | 467.83 | 467.56 | 467.56 | 8827.0 |
| 2021-11-05 07:30:00 | SPY | ETF | 467.63 | 467.84 | 467.59 | 467.81 | 10734.0 |
| 2021-11-05 07:35:00 | SPY | ETF | 467.83 | 467.9 | 467.83 | 467.89 | 4772.0 |
| 2021-11-05 07:40:00 | SPY | ETF | 467.9 | 467.94 | 467.86 | 467.93 | 5840.0 |
| 2021-11-05 07:45:00 | SPY | ETF | 467.94 | 467.95 | 467.9 | 467.91 | 5832.0 |
| 2021-11-05 07:50:00 | SPY | ETF | 467.9 | 467.9 | 467.83 | 467.89 | 3512.0 |
| 2021-11-05 07:55:00 | SPY | ETF | 467.89 | 467.96 | 467.86 | 467.94 | 2309.0 |
| 2021-11-05 08:00:00 | SPY | ETF | 468.0399 | 468.11 | 466.5 | 467.87 | 42945.0 |
| 2021-11-05 08:05:00 | SPY | ETF | 467.88 | 467.96 | 467.85 | 467.869 | 42664.0 |
| 2021-11-05 08:10:00 | SPY | ETF | 467.87 | 467.97 | 466.7 | 467.95 | 23380.0 |
| 2021-11-05 08:15:00 | SPY | ETF | 467.93 | 468.02 | 467.89 | 468.0 | 17272.0 |
| 2021-11-05 08:20:00 | SPY | ETF | 467.999 | 468.059 | 467.97 | 468.059 | 23888.0 |
| 2021-11-05 08:25:00 | SPY | ETF | 468.02 | 468.08 | 467.99 | 468.03 | 55813.0 |
| 2021-11-05 08:30:00 | SPY | ETF | 468.04 | 468.62 | 467.83 | 468.59 | 203313.0 |
| 2021-11-05 08:35:00 | SPY | ETF | 468.61 | 469.2 | 468.579 | 468.59 | 257916.0 |
| 2021-11-05 08:40:00 | SPY | ETF | 468.58 | 468.8 | 468.54 | 468.71 | 36319.0 |
> showing 50 of 87,374 rows — these rows as CSV