PREVIEW / etf_1min / 2004-12-10
file: by_date/etf_1min/2004/2004-12-10.parquet size: 194 KB rows: 13,672
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-10 08:01:00 | SPY | ETF | 118.97 | 118.97 | 118.97 | 118.97 | 100.0 |
| 2004-12-10 08:04:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 1100.0 |
| 2004-12-10 08:05:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 500.0 |
| 2004-12-10 08:13:00 | SPY | ETF | 119.0 | 119.0 | 118.99 | 118.99 | 200.0 |
| 2004-12-10 08:15:00 | SPY | ETF | 119.01 | 119.02 | 119.01 | 119.02 | 59400.0 |
| 2004-12-10 08:20:00 | SPY | ETF | 118.98 | 118.98 | 118.97 | 118.97 | 10800.0 |
| 2004-12-10 08:23:00 | SPY | ETF | 119.02 | 119.02 | 119.02 | 119.02 | 2000.0 |
| 2004-12-10 08:25:00 | SPY | ETF | 118.99 | 118.99 | 118.99 | 118.99 | 600.0 |
| 2004-12-10 08:27:00 | SPY | ETF | 118.99 | 118.99 | 118.99 | 118.99 | 2500.0 |
| 2004-12-10 08:28:00 | SPY | ETF | 118.95 | 118.95 | 118.95 | 118.95 | 800.0 |
| 2004-12-10 08:29:00 | SPY | ETF | 118.97 | 118.97 | 118.95 | 118.95 | 2900.0 |
| 2004-12-10 08:30:00 | SPY | ETF | 118.95 | 118.95 | 118.92 | 118.94 | 3800.0 |
| 2004-12-10 08:31:00 | SPY | ETF | 118.95 | 118.96 | 118.95 | 118.96 | 5400.0 |
| 2004-12-10 08:32:00 | SPY | ETF | 118.98 | 119.0 | 118.98 | 119.0 | 13000.0 |
| 2004-12-10 08:33:00 | SPY | ETF | 119.0 | 119.0 | 118.99 | 118.99 | 900.0 |
| 2004-12-10 08:34:00 | SPY | ETF | 118.99 | 118.99 | 118.94 | 118.95 | 8000.0 |
| 2004-12-10 08:35:00 | SPY | ETF | 118.98 | 118.98 | 118.98 | 118.98 | 5000.0 |
| 2004-12-10 08:36:00 | SPY | ETF | 118.95 | 118.95 | 118.95 | 118.95 | 1000.0 |
| 2004-12-10 08:37:00 | SPY | ETF | 118.96 | 118.96 | 118.96 | 118.96 | 500.0 |
| 2004-12-10 08:39:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 2800.0 |
| 2004-12-10 08:40:00 | SPY | ETF | 119.0 | 119.0 | 118.99 | 118.99 | 41100.0 |
| 2004-12-10 08:41:00 | SPY | ETF | 118.97 | 119.0 | 118.97 | 119.0 | 3200.0 |
| 2004-12-10 08:42:00 | SPY | ETF | 118.92 | 118.92 | 118.88 | 118.88 | 3600.0 |
| 2004-12-10 08:43:00 | SPY | ETF | 118.88 | 118.93 | 118.88 | 118.93 | 21100.0 |
| 2004-12-10 08:47:00 | SPY | ETF | 118.92 | 118.92 | 118.92 | 118.92 | 500.0 |
| 2004-12-10 08:49:00 | SPY | ETF | 118.92 | 118.92 | 118.89 | 118.89 | 900.0 |
| 2004-12-10 08:50:00 | SPY | ETF | 118.86 | 118.86 | 118.86 | 118.86 | 100.0 |
| 2004-12-10 08:51:00 | SPY | ETF | 118.9 | 118.9 | 118.9 | 118.9 | 2400.0 |
| 2004-12-10 08:52:00 | SPY | ETF | 118.88 | 118.95 | 118.87 | 118.87 | 2600.0 |
| 2004-12-10 08:53:00 | SPY | ETF | 118.92 | 118.92 | 118.92 | 118.92 | 1600.0 |
| 2004-12-10 08:54:00 | SPY | ETF | 118.91 | 118.91 | 118.91 | 118.91 | 100.0 |
| 2004-12-10 09:01:00 | SPY | ETF | 118.91 | 118.91 | 118.91 | 118.91 | 400.0 |
| 2004-12-10 09:08:00 | SPY | ETF | 118.93 | 118.93 | 118.93 | 118.93 | 200.0 |
| 2004-12-10 09:11:00 | SPY | ETF | 118.93 | 118.93 | 118.93 | 118.93 | 8200.0 |
| 2004-12-10 09:12:00 | SPY | ETF | 118.93 | 118.93 | 118.93 | 118.93 | 16800.0 |
| 2004-12-10 09:13:00 | SPY | ETF | 118.92 | 118.93 | 118.92 | 118.93 | 6600.0 |
| 2004-12-10 09:15:00 | SPY | ETF | 118.93 | 118.94 | 118.93 | 118.94 | 35500.0 |
| 2004-12-10 09:16:00 | SPY | ETF | 118.94 | 118.94 | 118.94 | 118.94 | 400.0 |
| 2004-12-10 09:17:00 | SPY | ETF | 118.94 | 118.94 | 118.94 | 118.94 | 500.0 |
| 2004-12-10 09:18:00 | SPY | ETF | 118.93 | 118.93 | 118.91 | 118.91 | 500.0 |
| 2004-12-10 09:19:00 | SPY | ETF | 118.91 | 118.92 | 118.91 | 118.92 | 200.0 |
| 2004-12-10 09:21:00 | SPY | ETF | 118.91 | 118.92 | 118.91 | 118.92 | 1000.0 |
| 2004-12-10 09:22:00 | SPY | ETF | 118.91 | 118.91 | 118.91 | 118.91 | 800.0 |
| 2004-12-10 09:23:00 | SPY | ETF | 118.94 | 118.94 | 118.94 | 118.94 | 4100.0 |
| 2004-12-10 09:25:00 | SPY | ETF | 118.94 | 118.94 | 118.94 | 118.94 | 900.0 |
| 2004-12-10 09:28:00 | SPY | ETF | 118.93 | 118.94 | 118.93 | 118.93 | 1300.0 |
| 2004-12-10 09:29:00 | SPY | ETF | 118.96 | 118.96 | 118.89 | 118.89 | 8600.0 |
| 2004-12-10 09:30:00 | SPY | ETF | 118.91 | 118.93 | 118.85 | 118.87 | 209300.0 |
| 2004-12-10 09:31:00 | SPY | ETF | 118.87 | 118.97 | 118.85 | 118.94 | 233400.0 |
| 2004-12-10 09:32:00 | SPY | ETF | 118.94 | 119.02 | 118.93 | 118.99 | 135000.0 |
> showing 50 of 13,672 rows — these rows as CSV