PREVIEW / etf_1min / 2001-02-27
file: by_date/etf_1min/2001/2001-02-27.parquet size: 57 KB rows: 2,806
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-27 09:31:00 | SPY | ETF | 126.8 | 126.95 | 126.75 | 126.95 | 240200.0 |
| 2001-02-27 09:32:00 | SPY | ETF | 126.89 | 126.94 | 126.79 | 126.94 | 208600.0 |
| 2001-02-27 09:33:00 | SPY | ETF | 126.99 | 127.05 | 126.85 | 127.05 | 9600.0 |
| 2001-02-27 09:34:00 | SPY | ETF | 126.91 | 127.05 | 126.91 | 127.0 | 21000.0 |
| 2001-02-27 09:35:00 | SPY | ETF | 127.1 | 127.1 | 126.9 | 126.9 | 49700.0 |
| 2001-02-27 09:36:00 | SPY | ETF | 127.06 | 127.06 | 126.82 | 126.82 | 3700.0 |
| 2001-02-27 09:37:00 | SPY | ETF | 126.88 | 126.88 | 126.82 | 126.82 | 22100.0 |
| 2001-02-27 09:38:00 | SPY | ETF | 126.82 | 127.0 | 126.82 | 126.91 | 18100.0 |
| 2001-02-27 09:39:00 | SPY | ETF | 126.96 | 127.05 | 126.95 | 126.95 | 10100.0 |
| 2001-02-27 09:40:00 | SPY | ETF | 126.9 | 126.99 | 126.78 | 126.78 | 6100.0 |
| 2001-02-27 09:41:00 | SPY | ETF | 126.95 | 126.95 | 126.8 | 126.84 | 102700.0 |
| 2001-02-27 09:42:00 | SPY | ETF | 126.95 | 126.98 | 126.85 | 126.98 | 101600.0 |
| 2001-02-27 09:43:00 | SPY | ETF | 126.86 | 127.05 | 126.85 | 127.04 | 132600.0 |
| 2001-02-27 09:44:00 | SPY | ETF | 126.99 | 127.0 | 126.8 | 126.8 | 30200.0 |
| 2001-02-27 09:45:00 | SPY | ETF | 126.93 | 126.95 | 126.85 | 126.95 | 3300.0 |
| 2001-02-27 09:46:00 | SPY | ETF | 126.9 | 126.9 | 126.76 | 126.8 | 15800.0 |
| 2001-02-27 09:47:00 | SPY | ETF | 126.76 | 126.95 | 126.75 | 126.75 | 16500.0 |
| 2001-02-27 09:48:00 | SPY | ETF | 126.78 | 127.0 | 126.78 | 127.0 | 7900.0 |
| 2001-02-27 09:49:00 | SPY | ETF | 127.0 | 127.05 | 126.85 | 126.85 | 113000.0 |
| 2001-02-27 09:50:00 | SPY | ETF | 126.9 | 126.9 | 126.83 | 126.9 | 3800.0 |
| 2001-02-27 09:51:00 | SPY | ETF | 126.94 | 126.95 | 126.85 | 126.9 | 102200.0 |
| 2001-02-27 09:52:00 | SPY | ETF | 127.0 | 127.09 | 127.0 | 127.05 | 4400.0 |
| 2001-02-27 09:53:00 | SPY | ETF | 126.98 | 126.98 | 126.9 | 126.9 | 1300.0 |
| 2001-02-27 09:54:00 | SPY | ETF | 126.92 | 126.99 | 126.92 | 126.99 | 7700.0 |
| 2001-02-27 09:55:00 | SPY | ETF | 126.89 | 126.99 | 126.81 | 126.99 | 11300.0 |
| 2001-02-27 09:56:00 | SPY | ETF | 126.85 | 126.85 | 126.85 | 126.85 | 50000.0 |
| 2001-02-27 09:57:00 | SPY | ETF | 127.0 | 127.14 | 126.9 | 127.14 | 79000.0 |
| 2001-02-27 09:58:00 | SPY | ETF | 127.0 | 127.2 | 127.0 | 127.2 | 9800.0 |
| 2001-02-27 09:59:00 | SPY | ETF | 127.25 | 127.25 | 127.05 | 127.17 | 32500.0 |
| 2001-02-27 10:00:00 | SPY | ETF | 127.05 | 127.56 | 127.05 | 127.45 | 171400.0 |
| 2001-02-27 10:01:00 | SPY | ETF | 127.3 | 127.6 | 127.3 | 127.6 | 138200.0 |
| 2001-02-27 10:02:00 | SPY | ETF | 127.6 | 127.6 | 127.42 | 127.55 | 41300.0 |
| 2001-02-27 10:03:00 | SPY | ETF | 127.57 | 127.57 | 127.3 | 127.3 | 43300.0 |
| 2001-02-27 10:04:00 | SPY | ETF | 127.25 | 127.38 | 126.91 | 126.91 | 149600.0 |
| 2001-02-27 10:05:00 | SPY | ETF | 127.0 | 127.4 | 126.7 | 126.73 | 56200.0 |
| 2001-02-27 10:06:00 | SPY | ETF | 126.72 | 126.72 | 126.44 | 126.5 | 31400.0 |
| 2001-02-27 10:07:00 | SPY | ETF | 126.5 | 126.7 | 126.35 | 126.35 | 170700.0 |
| 2001-02-27 10:08:00 | SPY | ETF | 126.3 | 126.55 | 126.25 | 126.44 | 104000.0 |
| 2001-02-27 10:09:00 | SPY | ETF | 126.3 | 126.44 | 126.2 | 126.25 | 29500.0 |
| 2001-02-27 10:10:00 | SPY | ETF | 126.25 | 126.25 | 126.0 | 126.1 | 31000.0 |
| 2001-02-27 10:11:00 | SPY | ETF | 126.0 | 126.3 | 126.0 | 126.29 | 24600.0 |
| 2001-02-27 10:12:00 | SPY | ETF | 126.3 | 126.45 | 126.25 | 126.34 | 41100.0 |
| 2001-02-27 10:13:00 | SPY | ETF | 126.39 | 126.46 | 126.39 | 126.46 | 32100.0 |
| 2001-02-27 10:14:00 | SPY | ETF | 126.47 | 126.55 | 126.35 | 126.48 | 42500.0 |
| 2001-02-27 10:15:00 | SPY | ETF | 126.48 | 126.55 | 126.33 | 126.55 | 63600.0 |
| 2001-02-27 10:16:00 | SPY | ETF | 126.48 | 126.57 | 126.4 | 126.4 | 12300.0 |
| 2001-02-27 10:17:00 | SPY | ETF | 126.33 | 126.48 | 126.33 | 126.33 | 9300.0 |
| 2001-02-27 10:18:00 | SPY | ETF | 126.42 | 126.55 | 126.32 | 126.55 | 14200.0 |
| 2001-02-27 10:19:00 | SPY | ETF | 126.55 | 126.58 | 126.43 | 126.57 | 3000.0 |
| 2001-02-27 10:20:00 | SPY | ETF | 126.5 | 126.5 | 126.32 | 126.32 | 4200.0 |
> showing 50 of 2,806 rows — these rows as CSV