PREVIEW / etf_5min / 2006-11-17
file: by_date/etf_5min/2006/2006-11-17.parquet size: 241 KB rows: 11,861
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-17 07:10:00 | SPY | ETF | 140.25 | 140.25 | 140.25 | 140.25 | 300.0 |
| 2006-11-17 07:15:00 | SPY | ETF | 140.2 | 140.2 | 140.2 | 140.2 | 2500.0 |
| 2006-11-17 07:25:00 | SPY | ETF | 140.22 | 140.23 | 140.22 | 140.23 | 21500.0 |
| 2006-11-17 07:30:00 | SPY | ETF | 140.18 | 140.18 | 140.18 | 140.18 | 2500.0 |
| 2006-11-17 07:40:00 | SPY | ETF | 140.25 | 140.26 | 140.25 | 140.26 | 21800.0 |
| 2006-11-17 07:45:00 | SPY | ETF | 140.2 | 140.2 | 140.2 | 140.2 | 1500.0 |
| 2006-11-17 07:55:00 | SPY | ETF | 140.23 | 140.23 | 140.23 | 140.23 | 700.0 |
| 2006-11-17 08:00:00 | SPY | ETF | 140.25 | 140.26 | 140.2 | 140.23 | 3800.0 |
| 2006-11-17 08:05:00 | SPY | ETF | 140.24 | 140.24 | 140.21 | 140.21 | 4000.0 |
| 2006-11-17 08:10:00 | SPY | ETF | 140.21 | 140.23 | 140.2 | 140.2 | 14600.0 |
| 2006-11-17 08:15:00 | SPY | ETF | 140.18 | 140.2 | 140.17 | 140.2 | 20000.0 |
| 2006-11-17 08:20:00 | SPY | ETF | 140.2 | 140.23 | 140.2 | 140.23 | 18600.0 |
| 2006-11-17 08:25:00 | SPY | ETF | 140.2 | 140.24 | 140.2 | 140.24 | 7500.0 |
| 2006-11-17 08:30:00 | SPY | ETF | 140.22 | 140.22 | 140.04 | 140.07 | 173200.0 |
| 2006-11-17 08:35:00 | SPY | ETF | 140.06 | 140.06 | 139.99 | 140.0 | 147900.0 |
| 2006-11-17 08:40:00 | SPY | ETF | 140.01 | 140.03 | 139.97 | 140.0 | 125000.0 |
| 2006-11-17 08:45:00 | SPY | ETF | 139.99 | 140.02 | 139.93 | 140.0 | 176400.0 |
| 2006-11-17 08:50:00 | SPY | ETF | 139.99 | 139.99 | 139.96 | 139.98 | 70400.0 |
| 2006-11-17 08:55:00 | SPY | ETF | 140.0 | 140.0 | 139.98 | 140.0 | 2800.0 |
| 2006-11-17 09:00:00 | SPY | ETF | 140.05 | 140.05 | 140.02 | 140.03 | 24600.0 |
| 2006-11-17 09:05:00 | SPY | ETF | 140.03 | 140.04 | 140.01 | 140.02 | 53800.0 |
| 2006-11-17 09:10:00 | SPY | ETF | 140.02 | 140.02 | 139.95 | 139.95 | 57800.0 |
| 2006-11-17 09:15:00 | SPY | ETF | 139.95 | 139.96 | 139.91 | 139.92 | 69000.0 |
| 2006-11-17 09:20:00 | SPY | ETF | 139.92 | 139.93 | 139.89 | 139.89 | 151100.0 |
| 2006-11-17 09:25:00 | SPY | ETF | 139.89 | 139.94 | 139.88 | 139.94 | 50500.0 |
| 2006-11-17 09:30:00 | SPY | ETF | 139.93 | 139.97 | 139.8 | 139.8 | 1821600.0 |
| 2006-11-17 09:35:00 | SPY | ETF | 139.8 | 139.87 | 139.73 | 139.82 | 993700.0 |
| 2006-11-17 09:40:00 | SPY | ETF | 139.81 | 139.94 | 139.76 | 139.93 | 1678100.0 |
| 2006-11-17 09:45:00 | SPY | ETF | 139.93 | 139.96 | 139.85 | 139.87 | 975700.0 |
| 2006-11-17 09:50:00 | SPY | ETF | 139.88 | 139.99 | 139.86 | 139.95 | 633600.0 |
| 2006-11-17 09:55:00 | SPY | ETF | 139.95 | 140.06 | 139.95 | 140.03 | 895200.0 |
| 2006-11-17 10:00:00 | SPY | ETF | 140.03 | 140.04 | 139.95 | 140.02 | 1033200.0 |
| 2006-11-17 10:05:00 | SPY | ETF | 140.03 | 140.04 | 139.96 | 140.03 | 622200.0 |
| 2006-11-17 10:10:00 | SPY | ETF | 140.04 | 140.05 | 139.89 | 139.9 | 949400.0 |
| 2006-11-17 10:15:00 | SPY | ETF | 139.9 | 139.91 | 139.87 | 139.9099 | 833000.0 |
| 2006-11-17 10:20:00 | SPY | ETF | 139.91 | 139.97 | 139.89 | 139.95 | 1066400.0 |
| 2006-11-17 10:25:00 | SPY | ETF | 139.95 | 140.03 | 139.87 | 139.87 | 1000500.0 |
| 2006-11-17 10:30:00 | SPY | ETF | 139.87 | 139.89 | 139.82 | 139.8799 | 533800.0 |
| 2006-11-17 10:35:00 | SPY | ETF | 139.88 | 140.0 | 139.86 | 139.99 | 375700.0 |
| 2006-11-17 10:40:00 | SPY | ETF | 139.98 | 140.07 | 139.96 | 140.03 | 1636300.0 |
| 2006-11-17 10:45:00 | SPY | ETF | 140.04 | 140.13 | 140.03 | 140.08 | 658000.0 |
| 2006-11-17 10:50:00 | SPY | ETF | 140.08 | 140.12 | 139.99 | 140.0 | 347300.0 |
| 2006-11-17 10:55:00 | SPY | ETF | 140.01 | 140.05 | 139.92 | 139.97 | 1354300.0 |
| 2006-11-17 11:00:00 | SPY | ETF | 139.97 | 140.0 | 139.9 | 139.92 | 455500.0 |
| 2006-11-17 11:05:00 | SPY | ETF | 139.91 | 139.94 | 139.84 | 139.85 | 1164700.0 |
| 2006-11-17 11:10:00 | SPY | ETF | 139.85 | 139.97 | 139.83 | 139.95 | 247600.0 |
| 2006-11-17 11:15:00 | SPY | ETF | 139.95 | 140.0 | 139.94 | 139.99 | 507000.0 |
| 2006-11-17 11:20:00 | SPY | ETF | 139.99 | 140.02 | 139.97 | 139.99 | 232500.0 |
| 2006-11-17 11:25:00 | SPY | ETF | 139.99 | 140.09 | 139.98 | 140.04 | 665400.0 |
| 2006-11-17 11:30:00 | SPY | ETF | 140.02 | 140.04 | 139.92 | 139.96 | 236600.0 |
> showing 50 of 11,861 rows — these rows as CSV