PREVIEW / etf_5min / 2005-10-11
file: by_date/etf_5min/2005/2005-10-11.parquet size: 139 KB rows: 7,158
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-11 06:00:00 | SPY | ETF | 119.11 | 119.11 | 119.11 | 119.11 | 1700.0 |
| 2005-10-11 07:00:00 | SPY | ETF | 119.04 | 119.04 | 119.04 | 119.04 | 1000.0 |
| 2005-10-11 07:05:00 | SPY | ETF | 119.06 | 119.06 | 119.05 | 119.06 | 6400.0 |
| 2005-10-11 07:25:00 | SPY | ETF | 119.03 | 119.06 | 119.03 | 119.06 | 4600.0 |
| 2005-10-11 07:30:00 | SPY | ETF | 119.05 | 119.1 | 119.05 | 119.1 | 4700.0 |
| 2005-10-11 07:35:00 | SPY | ETF | 119.12 | 119.12 | 119.09 | 119.1 | 21400.0 |
| 2005-10-11 07:40:00 | SPY | ETF | 119.05 | 119.05 | 119.05 | 119.05 | 1500.0 |
| 2005-10-11 08:00:00 | SPY | ETF | 119.04 | 119.12 | 119.02 | 119.05 | 291400.0 |
| 2005-10-11 08:05:00 | SPY | ETF | 119.02 | 119.04 | 119.02 | 119.04 | 7200.0 |
| 2005-10-11 08:10:00 | SPY | ETF | 119.03 | 119.1 | 118.8 | 119.03 | 51500.0 |
| 2005-10-11 08:15:00 | SPY | ETF | 119.05 | 119.06 | 119.03 | 119.04 | 7500.0 |
| 2005-10-11 08:20:00 | SPY | ETF | 119.04 | 119.05 | 119.04 | 119.05 | 600.0 |
| 2005-10-11 08:25:00 | SPY | ETF | 119.04 | 119.08 | 118.6 | 119.08 | 85400.0 |
| 2005-10-11 08:30:00 | SPY | ETF | 119.07 | 119.11 | 119.07 | 119.09 | 181600.0 |
| 2005-10-11 08:35:00 | SPY | ETF | 119.09 | 119.12 | 119.07 | 119.1 | 152900.0 |
| 2005-10-11 08:40:00 | SPY | ETF | 119.1 | 119.1 | 119.08 | 119.08 | 213100.0 |
| 2005-10-11 08:45:00 | SPY | ETF | 119.09 | 119.09 | 118.7 | 119.06 | 106600.0 |
| 2005-10-11 08:50:00 | SPY | ETF | 119.06 | 119.09 | 119.06 | 119.08 | 41500.0 |
| 2005-10-11 08:55:00 | SPY | ETF | 119.08 | 119.08 | 119.07 | 119.07 | 29900.0 |
| 2005-10-11 09:00:00 | SPY | ETF | 119.06 | 119.08 | 119.03 | 119.03 | 34900.0 |
| 2005-10-11 09:05:00 | SPY | ETF | 119.03 | 119.05 | 118.98 | 118.98 | 119700.0 |
| 2005-10-11 09:10:00 | SPY | ETF | 118.99 | 119.12 | 118.97 | 118.99 | 380600.0 |
| 2005-10-11 09:15:00 | SPY | ETF | 118.96 | 118.99 | 118.96 | 118.99 | 311900.0 |
| 2005-10-11 09:20:00 | SPY | ETF | 119.0 | 119.01 | 118.99 | 119.01 | 113100.0 |
| 2005-10-11 09:25:00 | SPY | ETF | 119.01 | 119.02 | 119.01 | 119.01 | 103500.0 |
| 2005-10-11 09:30:00 | SPY | ETF | 118.99 | 119.27 | 118.95 | 119.24 | 2454700.0 |
| 2005-10-11 09:35:00 | SPY | ETF | 119.25 | 119.35 | 119.18 | 119.24 | 2217800.0 |
| 2005-10-11 09:40:00 | SPY | ETF | 119.25 | 119.3 | 119.2 | 119.23 | 901600.0 |
| 2005-10-11 09:45:00 | SPY | ETF | 119.25 | 119.39 | 119.24 | 119.33 | 616300.0 |
| 2005-10-11 09:50:00 | SPY | ETF | 119.35 | 119.35 | 119.22 | 119.26 | 480200.0 |
| 2005-10-11 09:55:00 | SPY | ETF | 119.26 | 119.3 | 119.18 | 119.22 | 386300.0 |
| 2005-10-11 10:00:00 | SPY | ETF | 119.26 | 119.26 | 118.95 | 119.05 | 1764300.0 |
| 2005-10-11 10:05:00 | SPY | ETF | 119.05 | 119.18 | 118.98 | 119.1 | 859900.0 |
| 2005-10-11 10:10:00 | SPY | ETF | 119.11 | 119.14 | 119.01 | 119.05 | 627200.0 |
| 2005-10-11 10:15:00 | SPY | ETF | 119.05 | 119.09 | 118.96 | 119.08 | 432000.0 |
| 2005-10-11 10:20:00 | SPY | ETF | 119.08 | 119.16 | 119.04 | 119.14 | 637900.0 |
| 2005-10-11 10:25:00 | SPY | ETF | 119.16 | 119.39 | 119.14 | 119.31 | 2187800.0 |
| 2005-10-11 10:30:00 | SPY | ETF | 119.33 | 119.37 | 119.24 | 119.26 | 875100.0 |
| 2005-10-11 10:35:00 | SPY | ETF | 119.25 | 119.32 | 119.07 | 119.1 | 826500.0 |
| 2005-10-11 10:40:00 | SPY | ETF | 119.1 | 119.14 | 119.0 | 119.06 | 627500.0 |
| 2005-10-11 10:45:00 | SPY | ETF | 119.06 | 119.14 | 119.03 | 119.14 | 293600.0 |
| 2005-10-11 10:50:00 | SPY | ETF | 119.14 | 119.14 | 118.79 | 118.84 | 1059000.0 |
| 2005-10-11 10:55:00 | SPY | ETF | 118.84 | 118.99 | 118.83 | 118.94 | 808300.0 |
| 2005-10-11 11:00:00 | SPY | ETF | 118.92 | 118.92 | 118.79 | 118.87 | 459900.0 |
| 2005-10-11 11:05:00 | SPY | ETF | 118.88 | 119.01 | 118.8 | 118.94 | 579400.0 |
| 2005-10-11 11:10:00 | SPY | ETF | 118.94 | 118.97 | 118.79 | 118.79 | 1103100.0 |
| 2005-10-11 11:15:00 | SPY | ETF | 118.79 | 118.98 | 118.76 | 118.94 | 789600.0 |
| 2005-10-11 11:20:00 | SPY | ETF | 118.93 | 118.97 | 118.9 | 118.93 | 117700.0 |
| 2005-10-11 11:25:00 | SPY | ETF | 118.92 | 118.94 | 118.82 | 118.84 | 219800.0 |
| 2005-10-11 11:30:00 | SPY | ETF | 118.83 | 118.87 | 118.7 | 118.72 | 1333400.0 |
> showing 50 of 7,158 rows — these rows as CSV