PREVIEW / etf_1min / 2006-12-27
file: by_date/etf_1min/2006/2006-12-27.parquet size: 478 KB rows: 29,415
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:07:00 | SPY | ETF | 142.1 | 142.1 | 142.1 | 142.1 | 1600.0 |
| 2006-12-27 04:16: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:49:00 | SPY | ETF | 142.11 | 142.11 | 142.11 | 142.11 | 5000.0 |
| 2006-12-27 06:56:00 | SPY | ETF | 142.06 | 142.07 | 142.06 | 142.06 | 75000.0 |
| 2006-12-27 07:16:00 | SPY | ETF | 142.1 | 142.1 | 142.1 | 142.1 | 500.0 |
| 2006-12-27 07:21:00 | SPY | ETF | 142.12 | 142.13 | 142.12 | 142.13 | 12400.0 |
| 2006-12-27 07:22:00 | SPY | ETF | 142.13 | 142.13 | 142.12 | 142.12 | 7500.0 |
| 2006-12-27 07:48: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:58:00 | SPY | ETF | 142.01 | 142.01 | 142.01 | 142.01 | 400.0 |
| 2006-12-27 08:00:00 | SPY | ETF | 142.03 | 142.05 | 142.03 | 142.05 | 31000.0 |
| 2006-12-27 08:01:00 | SPY | ETF | 142.04 | 142.1 | 142.02 | 142.03 | 34800.0 |
| 2006-12-27 08:02:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 1400.0 |
| 2006-12-27 08:04:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 100.0 |
| 2006-12-27 08:06:00 | SPY | ETF | 142.07 | 142.07 | 142.07 | 142.07 | 9900.0 |
| 2006-12-27 08:07:00 | SPY | ETF | 142.07 | 142.07 | 142.04 | 142.04 | 2700.0 |
| 2006-12-27 08:08:00 | SPY | ETF | 142.08 | 142.08 | 142.08 | 142.08 | 10000.0 |
| 2006-12-27 08:09:00 | SPY | ETF | 142.04 | 142.04 | 142.04 | 142.04 | 100.0 |
| 2006-12-27 08:10:00 | SPY | ETF | 142.04 | 142.04 | 142.04 | 142.04 | 200.0 |
| 2006-12-27 08:12:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 200.0 |
| 2006-12-27 08:13:00 | SPY | ETF | 142.04 | 142.05 | 142.02 | 142.03 | 52000.0 |
| 2006-12-27 08:14:00 | SPY | ETF | 142.03 | 142.03 | 142.03 | 142.03 | 100.0 |
| 2006-12-27 08:15:00 | SPY | ETF | 142.02 | 142.02 | 142.02 | 142.02 | 600.0 |
| 2006-12-27 08:17:00 | SPY | ETF | 142.02 | 142.02 | 142.02 | 142.02 | 900.0 |
| 2006-12-27 08:19:00 | SPY | ETF | 142.02 | 142.02 | 142.02 | 142.02 | 3500.0 |
| 2006-12-27 08:20:00 | SPY | ETF | 142.0 | 142.0 | 142.0 | 142.0 | 2700.0 |
| 2006-12-27 08:21:00 | SPY | ETF | 141.99 | 141.99 | 141.99 | 141.99 | 4100.0 |
| 2006-12-27 08:22:00 | SPY | ETF | 141.98 | 141.98 | 141.97 | 141.97 | 8100.0 |
| 2006-12-27 08:23:00 | SPY | ETF | 141.97 | 141.98 | 141.97 | 141.98 | 42400.0 |
| 2006-12-27 08:24:00 | SPY | ETF | 141.99 | 141.99 | 141.99 | 141.99 | 500.0 |
| 2006-12-27 08:25:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 50000.0 |
| 2006-12-27 08:26:00 | SPY | ETF | 141.98 | 141.98 | 141.97 | 141.97 | 35000.0 |
| 2006-12-27 08:27:00 | SPY | ETF | 141.98 | 141.98 | 141.97 | 141.97 | 4100.0 |
| 2006-12-27 08:28:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 1000.0 |
| 2006-12-27 08:29:00 | SPY | ETF | 141.97 | 141.98 | 141.95 | 141.96 | 50200.0 |
| 2006-12-27 08:30:00 | SPY | ETF | 141.97 | 141.98 | 141.97 | 141.98 | 10500.0 |
| 2006-12-27 08:32:00 | SPY | ETF | 141.97 | 141.97 | 141.95 | 141.95 | 8700.0 |
| 2006-12-27 08:33:00 | SPY | ETF | 141.97 | 141.97 | 141.96 | 141.96 | 3100.0 |
| 2006-12-27 08:34:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 1000.0 |
| 2006-12-27 08:36:00 | SPY | ETF | 141.96 | 141.96 | 141.96 | 141.96 | 300.0 |
| 2006-12-27 08:39:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 400.0 |
| 2006-12-27 08:41:00 | SPY | ETF | 141.98 | 141.98 | 141.98 | 141.98 | 100.0 |
| 2006-12-27 08:42:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 500.0 |
| 2006-12-27 08:43:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 1000.0 |
| 2006-12-27 08:45:00 | SPY | ETF | 141.98 | 141.98 | 141.98 | 141.98 | 900.0 |
| 2006-12-27 08:47:00 | SPY | ETF | 141.99 | 141.99 | 141.98 | 141.98 | 2600.0 |
| 2006-12-27 08:48:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 500.0 |
| 2006-12-27 08:57:00 | SPY | ETF | 142.01 | 142.01 | 142.0 | 142.0 | 15100.0 |
| 2006-12-27 08:58:00 | SPY | ETF | 142.0 | 142.0 | 142.0 | 142.0 | 900.0 |
> showing 50 of 29,415 rows — these rows as CSV