PREVIEW / etf_1min / 2001-10-17
file: by_date/etf_1min/2001/2001-10-17.parquet size: 77 KB rows: 3,711
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-10-17 09:30:00 | SPY | ETF | 111.07 | 111.15 | 111.0 | 111.0 | 378300.0 |
| 2001-10-17 09:31:00 | SPY | ETF | 111.0 | 111.15 | 110.92 | 110.98 | 81900.0 |
| 2001-10-17 09:32:00 | SPY | ETF | 110.92 | 111.03 | 110.9 | 111.0 | 60400.0 |
| 2001-10-17 09:33:00 | SPY | ETF | 110.99 | 111.1 | 110.95 | 111.0 | 152400.0 |
| 2001-10-17 09:34:00 | SPY | ETF | 111.0 | 111.05 | 110.89 | 111.0 | 136000.0 |
| 2001-10-17 09:35:00 | SPY | ETF | 110.95 | 111.03 | 110.88 | 110.95 | 168000.0 |
| 2001-10-17 09:36:00 | SPY | ETF | 110.93 | 111.0 | 110.9 | 110.93 | 66800.0 |
| 2001-10-17 09:37:00 | SPY | ETF | 111.0 | 111.04 | 110.9 | 110.94 | 169400.0 |
| 2001-10-17 09:38:00 | SPY | ETF | 110.92 | 110.98 | 110.8 | 110.88 | 25700.0 |
| 2001-10-17 09:39:00 | SPY | ETF | 110.86 | 110.96 | 110.82 | 110.9 | 41200.0 |
| 2001-10-17 09:40:00 | SPY | ETF | 110.95 | 111.1 | 110.9 | 111.1 | 33800.0 |
| 2001-10-17 09:41:00 | SPY | ETF | 111.1 | 111.14 | 111.06 | 111.1 | 25600.0 |
| 2001-10-17 09:42:00 | SPY | ETF | 111.1 | 111.14 | 110.9 | 110.9 | 30600.0 |
| 2001-10-17 09:43:00 | SPY | ETF | 110.9 | 110.92 | 110.8 | 110.8 | 95400.0 |
| 2001-10-17 09:44:00 | SPY | ETF | 110.77 | 110.88 | 110.76 | 110.88 | 62800.0 |
| 2001-10-17 09:45:00 | SPY | ETF | 110.88 | 110.98 | 110.85 | 110.85 | 17000.0 |
| 2001-10-17 09:46:00 | SPY | ETF | 110.86 | 110.91 | 110.75 | 110.75 | 69800.0 |
| 2001-10-17 09:47:00 | SPY | ETF | 110.83 | 110.85 | 110.69 | 110.73 | 46900.0 |
| 2001-10-17 09:48:00 | SPY | ETF | 110.76 | 110.83 | 110.71 | 110.74 | 35200.0 |
| 2001-10-17 09:49:00 | SPY | ETF | 110.79 | 110.79 | 110.64 | 110.7 | 37500.0 |
| 2001-10-17 09:50:00 | SPY | ETF | 110.7 | 110.83 | 110.67 | 110.78 | 169400.0 |
| 2001-10-17 09:51:00 | SPY | ETF | 110.85 | 110.88 | 110.8 | 110.83 | 15300.0 |
| 2001-10-17 09:52:00 | SPY | ETF | 110.9 | 110.98 | 110.81 | 110.81 | 65300.0 |
| 2001-10-17 09:53:00 | SPY | ETF | 110.81 | 110.91 | 110.75 | 110.75 | 20300.0 |
| 2001-10-17 09:54:00 | SPY | ETF | 110.74 | 110.91 | 110.74 | 110.85 | 81700.0 |
| 2001-10-17 09:55:00 | SPY | ETF | 110.87 | 110.92 | 110.82 | 110.9 | 245100.0 |
| 2001-10-17 09:56:00 | SPY | ETF | 110.98 | 110.99 | 110.77 | 110.82 | 84300.0 |
| 2001-10-17 09:57:00 | SPY | ETF | 110.81 | 110.85 | 110.75 | 110.78 | 35200.0 |
| 2001-10-17 09:58:00 | SPY | ETF | 110.84 | 110.87 | 110.77 | 110.85 | 69300.0 |
| 2001-10-17 09:59:00 | SPY | ETF | 110.8 | 110.86 | 110.72 | 110.81 | 38300.0 |
| 2001-10-17 10:00:00 | SPY | ETF | 110.74 | 110.84 | 110.56 | 110.73 | 99100.0 |
| 2001-10-17 10:01:00 | SPY | ETF | 110.67 | 110.77 | 110.55 | 110.57 | 229900.0 |
| 2001-10-17 10:02:00 | SPY | ETF | 110.56 | 110.62 | 110.49 | 110.6 | 53800.0 |
| 2001-10-17 10:03:00 | SPY | ETF | 110.6 | 110.6 | 110.51 | 110.51 | 61500.0 |
| 2001-10-17 10:04:00 | SPY | ETF | 110.55 | 110.6 | 110.33 | 110.38 | 84700.0 |
| 2001-10-17 10:05:00 | SPY | ETF | 110.38 | 110.5 | 110.22 | 110.3 | 40600.0 |
| 2001-10-17 10:06:00 | SPY | ETF | 110.29 | 110.29 | 110.17 | 110.2 | 186000.0 |
| 2001-10-17 10:07:00 | SPY | ETF | 110.21 | 110.27 | 110.1 | 110.1 | 191400.0 |
| 2001-10-17 10:08:00 | SPY | ETF | 110.1 | 110.21 | 110.07 | 110.15 | 132900.0 |
| 2001-10-17 10:09:00 | SPY | ETF | 110.15 | 110.15 | 109.9 | 109.96 | 130000.0 |
| 2001-10-17 10:10:00 | SPY | ETF | 109.92 | 110.05 | 109.75 | 109.85 | 308400.0 |
| 2001-10-17 10:11:00 | SPY | ETF | 109.83 | 109.92 | 109.74 | 109.75 | 240000.0 |
| 2001-10-17 10:12:00 | SPY | ETF | 109.75 | 109.79 | 109.35 | 109.4 | 182700.0 |
| 2001-10-17 10:13:00 | SPY | ETF | 109.4 | 109.55 | 109.3 | 109.45 | 267200.0 |
| 2001-10-17 10:14:00 | SPY | ETF | 109.44 | 109.55 | 109.35 | 109.51 | 269100.0 |
| 2001-10-17 10:15:00 | SPY | ETF | 109.55 | 109.58 | 109.35 | 109.53 | 300600.0 |
| 2001-10-17 10:16:00 | SPY | ETF | 109.54 | 109.56 | 109.4 | 109.55 | 186800.0 |
| 2001-10-17 10:17:00 | SPY | ETF | 109.62 | 109.64 | 109.45 | 109.62 | 89700.0 |
| 2001-10-17 10:18:00 | SPY | ETF | 109.63 | 109.7 | 109.55 | 109.68 | 41000.0 |
| 2001-10-17 10:19:00 | SPY | ETF | 109.64 | 109.75 | 109.62 | 109.74 | 88100.0 |
> showing 50 of 3,711 rows — these rows as CSV