PREVIEW / etf_5min / 2006-12-27
file: by_date/etf_5min/2006/2006-12-27.parquet size: 241 KB rows: 11,800
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-12-27 04:05:00 | SPY | ETF | 142.1 | 142.1 | 142.1 | 142.1 | 1600.0 |
| 2006-12-27 04:15:00 | SPY | ETF | 142.09 | 142.09 | 142.09 | 142.09 | 100.0 |
| 2006-12-27 06:15:00 | SPY | ETF | 142.17 | 142.17 | 142.17 | 142.17 | 5000.0 |
| 2006-12-27 06:45:00 | SPY | ETF | 142.11 | 142.11 | 142.11 | 142.11 | 5000.0 |
| 2006-12-27 06:55:00 | SPY | ETF | 142.06 | 142.07 | 142.06 | 142.06 | 75000.0 |
| 2006-12-27 07:15:00 | SPY | ETF | 142.1 | 142.1 | 142.1 | 142.1 | 500.0 |
| 2006-12-27 07:20:00 | SPY | ETF | 142.12 | 142.13 | 142.12 | 142.12 | 19900.0 |
| 2006-12-27 07:45:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 100.0 |
| 2006-12-27 07:50:00 | SPY | ETF | 142.06 | 142.06 | 142.06 | 142.06 | 200.0 |
| 2006-12-27 07:55:00 | SPY | ETF | 142.01 | 142.01 | 142.01 | 142.01 | 400.0 |
| 2006-12-27 08:00:00 | SPY | ETF | 142.03 | 142.1 | 142.02 | 142.05 | 67300.0 |
| 2006-12-27 08:05:00 | SPY | ETF | 142.07 | 142.08 | 142.04 | 142.04 | 22700.0 |
| 2006-12-27 08:10:00 | SPY | ETF | 142.04 | 142.05 | 142.02 | 142.03 | 52500.0 |
| 2006-12-27 08:15:00 | SPY | ETF | 142.02 | 142.02 | 142.02 | 142.02 | 5000.0 |
| 2006-12-27 08:20:00 | SPY | ETF | 142.0 | 142.0 | 141.97 | 141.99 | 57800.0 |
| 2006-12-27 08:25:00 | SPY | ETF | 141.97 | 141.98 | 141.95 | 141.96 | 140300.0 |
| 2006-12-27 08:30:00 | SPY | ETF | 141.97 | 141.98 | 141.95 | 141.97 | 23300.0 |
| 2006-12-27 08:35:00 | SPY | ETF | 141.96 | 141.97 | 141.96 | 141.97 | 700.0 |
| 2006-12-27 08:40:00 | SPY | ETF | 141.98 | 141.98 | 141.97 | 141.97 | 1600.0 |
| 2006-12-27 08:45:00 | SPY | ETF | 141.98 | 141.99 | 141.97 | 141.97 | 4000.0 |
| 2006-12-27 08:55:00 | SPY | ETF | 142.01 | 142.01 | 142.0 | 142.0 | 16000.0 |
| 2006-12-27 09:00:00 | SPY | ETF | 142.02 | 142.02 | 142.0 | 142.0 | 42100.0 |
| 2006-12-27 09:05:00 | SPY | ETF | 142.0 | 142.0 | 141.98 | 141.99 | 40900.0 |
| 2006-12-27 09:10:00 | SPY | ETF | 141.99 | 142.0 | 141.97 | 141.97 | 10100.0 |
| 2006-12-27 09:15:00 | SPY | ETF | 141.95 | 141.96 | 141.9 | 141.91 | 23100.0 |
| 2006-12-27 09:20:00 | SPY | ETF | 141.91 | 141.91 | 141.88 | 141.89 | 25200.0 |
| 2006-12-27 09:25:00 | SPY | ETF | 141.89 | 141.91 | 141.85 | 141.86 | 47900.0 |
| 2006-12-27 09:30:00 | SPY | ETF | 141.87 | 142.11 | 141.83 | 142.1 | 1000200.0 |
| 2006-12-27 09:35:00 | SPY | ETF | 142.1 | 142.16 | 142.02 | 142.08 | 837800.0 |
| 2006-12-27 09:40:00 | SPY | ETF | 142.09 | 142.28 | 142.08 | 142.25 | 1298300.0 |
| 2006-12-27 09:45:00 | SPY | ETF | 142.25 | 142.27 | 142.17 | 142.25 | 1024800.0 |
| 2006-12-27 09:50:00 | SPY | ETF | 142.24 | 142.34 | 142.24 | 142.27 | 1690100.0 |
| 2006-12-27 09:55:00 | SPY | ETF | 142.28 | 142.29 | 142.09 | 142.13 | 699200.0 |
| 2006-12-27 10:00:00 | SPY | ETF | 142.13 | 142.25 | 142.1 | 142.16 | 1414000.0 |
| 2006-12-27 10:05:00 | SPY | ETF | 142.16 | 142.2 | 142.12 | 142.17 | 707000.0 |
| 2006-12-27 10:10:00 | SPY | ETF | 142.19 | 142.19 | 142.08 | 142.08 | 749100.0 |
| 2006-12-27 10:15:00 | SPY | ETF | 142.09 | 142.11 | 142.0 | 142.01 | 816400.0 |
| 2006-12-27 10:20:00 | SPY | ETF | 142.0 | 142.05 | 141.99 | 142.0 | 479800.0 |
| 2006-12-27 10:25:00 | SPY | ETF | 142.0 | 142.17 | 142.0 | 142.16 | 1678000.0 |
| 2006-12-27 10:30:00 | SPY | ETF | 142.16 | 142.19 | 142.02 | 142.03 | 339600.0 |
| 2006-12-27 10:35:00 | SPY | ETF | 142.03 | 142.04 | 141.97 | 142.01 | 1002200.0 |
| 2006-12-27 10:40:00 | SPY | ETF | 142.01 | 142.14 | 141.99 | 142.13 | 583700.0 |
| 2006-12-27 10:45:00 | SPY | ETF | 142.14 | 142.16 | 142.05 | 142.11 | 340800.0 |
| 2006-12-27 10:50:00 | SPY | ETF | 142.13 | 142.15 | 142.1 | 142.14 | 203000.0 |
| 2006-12-27 10:55:00 | SPY | ETF | 142.13 | 142.2 | 142.11 | 142.17 | 473500.0 |
| 2006-12-27 11:00:00 | SPY | ETF | 142.17 | 142.26 | 142.16 | 142.24 | 708600.0 |
| 2006-12-27 11:05:00 | SPY | ETF | 142.24 | 142.27 | 142.22 | 142.26 | 367400.0 |
| 2006-12-27 11:10:00 | SPY | ETF | 142.28 | 142.29 | 142.15 | 142.17 | 447600.0 |
| 2006-12-27 11:15:00 | SPY | ETF | 142.17 | 142.25 | 142.15 | 142.23 | 134400.0 |
| 2006-12-27 11:20:00 | SPY | ETF | 142.23 | 142.26 | 142.2 | 142.2 | 261100.0 |
> showing 50 of 11,800 rows — these rows as CSV