PREVIEW / etf_5min / 2006-10-31
file: by_date/etf_5min/2006/2006-10-31.parquet size: 246 KB rows: 11,744
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-10-31 04:15:00 | SPY | ETF | 137.9 | 137.9 | 137.9 | 137.9 | 600.0 |
| 2006-10-31 04:20:00 | SPY | ETF | 137.98 | 138.0 | 137.98 | 138.0 | 300.0 |
| 2006-10-31 05:15:00 | SPY | ETF | 138.12 | 138.12 | 138.12 | 138.12 | 3000.0 |
| 2006-10-31 06:15:00 | SPY | ETF | 138.08 | 138.08 | 138.08 | 138.08 | 15000.0 |
| 2006-10-31 06:25:00 | SPY | ETF | 138.04 | 138.04 | 138.04 | 138.04 | 75000.0 |
| 2006-10-31 07:05:00 | SPY | ETF | 138.04 | 138.07 | 138.04 | 138.07 | 53300.0 |
| 2006-10-31 07:15:00 | SPY | ETF | 137.97 | 137.97 | 137.93 | 137.94 | 19300.0 |
| 2006-10-31 07:25:00 | SPY | ETF | 137.93 | 137.99 | 137.93 | 137.99 | 82600.0 |
| 2006-10-31 07:30:00 | SPY | ETF | 137.99 | 138.04 | 137.95 | 137.95 | 115100.0 |
| 2006-10-31 07:35:00 | SPY | ETF | 137.95 | 137.95 | 137.94 | 137.94 | 15000.0 |
| 2006-10-31 07:40:00 | SPY | ETF | 138.0 | 138.01 | 138.0 | 138.01 | 1600.0 |
| 2006-10-31 07:45:00 | SPY | ETF | 138.0 | 138.0 | 138.0 | 138.0 | 500.0 |
| 2006-10-31 07:50:00 | SPY | ETF | 138.06 | 138.07 | 138.06 | 138.07 | 28500.0 |
| 2006-10-31 07:55:00 | SPY | ETF | 138.09 | 138.09 | 138.09 | 138.09 | 200.0 |
| 2006-10-31 08:00:00 | SPY | ETF | 138.04 | 138.11 | 137.93 | 138.06 | 1051600.0 |
| 2006-10-31 08:05:00 | SPY | ETF | 138.07 | 138.07 | 138.04 | 138.07 | 41400.0 |
| 2006-10-31 08:10:00 | SPY | ETF | 138.06 | 138.06 | 138.04 | 138.04 | 5000.0 |
| 2006-10-31 08:15:00 | SPY | ETF | 138.04 | 138.09 | 138.04 | 138.09 | 10800.0 |
| 2006-10-31 08:20:00 | SPY | ETF | 138.09 | 138.13 | 138.09 | 138.13 | 637500.0 |
| 2006-10-31 08:25:00 | SPY | ETF | 138.15 | 138.15 | 138.11 | 138.14 | 307100.0 |
| 2006-10-31 08:30:00 | SPY | ETF | 138.14 | 138.14 | 138.07 | 138.09 | 45700.0 |
| 2006-10-31 08:35:00 | SPY | ETF | 138.1 | 138.12 | 138.08 | 138.09 | 144200.0 |
| 2006-10-31 08:40:00 | SPY | ETF | 138.07 | 138.11 | 138.07 | 138.07 | 5300.0 |
| 2006-10-31 08:45:00 | SPY | ETF | 138.09 | 138.1 | 138.07 | 138.09 | 31500.0 |
| 2006-10-31 08:50:00 | SPY | ETF | 138.09 | 138.1 | 138.08 | 138.09 | 27000.0 |
| 2006-10-31 08:55:00 | SPY | ETF | 138.11 | 138.11 | 138.09 | 138.11 | 14300.0 |
| 2006-10-31 09:00:00 | SPY | ETF | 138.08 | 138.1 | 138.08 | 138.1 | 1800.0 |
| 2006-10-31 09:05:00 | SPY | ETF | 138.1 | 138.1 | 138.07 | 138.08 | 2000.0 |
| 2006-10-31 09:10:00 | SPY | ETF | 138.07 | 138.07 | 138.03 | 138.03 | 6800.0 |
| 2006-10-31 09:15:00 | SPY | ETF | 138.02 | 138.11 | 138.02 | 138.1 | 26200.0 |
| 2006-10-31 09:20:00 | SPY | ETF | 138.11 | 138.11 | 138.07 | 138.1 | 15900.0 |
| 2006-10-31 09:25:00 | SPY | ETF | 138.1 | 138.12 | 138.07 | 138.08 | 78900.0 |
| 2006-10-31 09:30:00 | SPY | ETF | 138.07 | 138.26 | 138.05 | 138.22 | 1089100.0 |
| 2006-10-31 09:35:00 | SPY | ETF | 138.21 | 138.23 | 138.07 | 138.12 | 943100.0 |
| 2006-10-31 09:40:00 | SPY | ETF | 138.12 | 138.15 | 138.0 | 138.06 | 1245300.0 |
| 2006-10-31 09:45:00 | SPY | ETF | 138.06 | 138.09 | 137.95 | 137.96 | 743400.0 |
| 2006-10-31 09:50:00 | SPY | ETF | 137.97 | 138.03 | 137.95 | 137.97 | 1092800.0 |
| 2006-10-31 09:55:00 | SPY | ETF | 137.97 | 138.01 | 137.84 | 137.96 | 1165800.0 |
| 2006-10-31 10:00:00 | SPY | ETF | 137.95 | 137.98 | 137.8 | 137.89 | 1309200.0 |
| 2006-10-31 10:05:00 | SPY | ETF | 137.89 | 137.92 | 137.73 | 137.73 | 894500.0 |
| 2006-10-31 10:10:00 | SPY | ETF | 137.74 | 137.82 | 137.69 | 137.81 | 554500.0 |
| 2006-10-31 10:15:00 | SPY | ETF | 137.78 | 137.82 | 137.62 | 137.66 | 979600.0 |
| 2006-10-31 10:20:00 | SPY | ETF | 137.66 | 137.71 | 137.59 | 137.71 | 866200.0 |
| 2006-10-31 10:25:00 | SPY | ETF | 137.72 | 137.74 | 137.59 | 137.74 | 717100.0 |
| 2006-10-31 10:30:00 | SPY | ETF | 137.74 | 137.84 | 137.73 | 137.795 | 865700.0 |
| 2006-10-31 10:35:00 | SPY | ETF | 137.79 | 137.84 | 137.76 | 137.78 | 319700.0 |
| 2006-10-31 10:40:00 | SPY | ETF | 137.7901 | 137.97 | 137.78 | 137.95 | 984400.0 |
| 2006-10-31 10:45:00 | SPY | ETF | 137.94 | 137.95 | 137.83 | 137.89 | 313600.0 |
| 2006-10-31 10:50:00 | SPY | ETF | 137.89 | 138.05 | 137.87 | 138.02 | 1097500.0 |
| 2006-10-31 10:55:00 | SPY | ETF | 138.02 | 138.08 | 137.98 | 138.06 | 502800.0 |
> showing 50 of 11,744 rows — these rows as CSV