PREVIEW / etf_1min / 2001-01-31
file: by_date/etf_1min/2001/2001-01-31.parquet size: 56 KB rows: 3,101
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-01-31 09:30:00 | SPY | ETF | 137.4 | 137.4 | 137.4 | 137.4 | 318100.0 |
| 2001-01-31 09:31:00 | SPY | ETF | 137.4 | 137.65 | 137.4 | 137.63 | 214900.0 |
| 2001-01-31 09:32:00 | SPY | ETF | 137.4 | 137.65 | 137.4 | 137.5 | 102100.0 |
| 2001-01-31 09:33:00 | SPY | ETF | 137.55 | 137.75 | 137.4 | 137.59 | 3800.0 |
| 2001-01-31 09:34:00 | SPY | ETF | 137.75 | 137.75 | 137.7 | 137.75 | 1800.0 |
| 2001-01-31 09:35:00 | SPY | ETF | 137.7 | 137.85 | 137.66 | 137.79 | 12800.0 |
| 2001-01-31 09:36:00 | SPY | ETF | 137.67 | 137.76 | 137.6 | 137.6 | 13600.0 |
| 2001-01-31 09:37:00 | SPY | ETF | 137.7 | 137.7 | 137.65 | 137.65 | 100100.0 |
| 2001-01-31 09:38:00 | SPY | ETF | 137.56 | 137.72 | 137.56 | 137.71 | 6400.0 |
| 2001-01-31 09:39:00 | SPY | ETF | 137.6 | 137.68 | 137.55 | 137.66 | 112500.0 |
| 2001-01-31 09:40:00 | SPY | ETF | 137.68 | 137.78 | 137.6 | 137.66 | 7900.0 |
| 2001-01-31 09:41:00 | SPY | ETF | 137.76 | 137.86 | 137.62 | 137.86 | 12900.0 |
| 2001-01-31 09:42:00 | SPY | ETF | 137.86 | 137.88 | 137.82 | 137.82 | 12900.0 |
| 2001-01-31 09:43:00 | SPY | ETF | 137.82 | 137.84 | 137.64 | 137.75 | 4300.0 |
| 2001-01-31 09:44:00 | SPY | ETF | 137.75 | 137.77 | 137.64 | 137.69 | 101500.0 |
| 2001-01-31 09:45:00 | SPY | ETF | 137.61 | 137.8 | 137.61 | 137.8 | 4300.0 |
| 2001-01-31 09:46:00 | SPY | ETF | 137.75 | 137.83 | 137.7 | 137.71 | 1900.0 |
| 2001-01-31 09:47:00 | SPY | ETF | 137.78 | 137.78 | 137.66 | 137.75 | 4200.0 |
| 2001-01-31 09:48:00 | SPY | ETF | 137.79 | 137.8 | 137.65 | 137.79 | 9800.0 |
| 2001-01-31 09:49:00 | SPY | ETF | 137.8 | 137.8 | 137.62 | 137.62 | 25300.0 |
| 2001-01-31 09:50:00 | SPY | ETF | 137.62 | 137.75 | 137.62 | 137.75 | 1400.0 |
| 2001-01-31 09:51:00 | SPY | ETF | 137.75 | 137.76 | 137.68 | 137.75 | 1500.0 |
| 2001-01-31 09:52:00 | SPY | ETF | 137.79 | 137.84 | 137.79 | 137.84 | 15100.0 |
| 2001-01-31 09:53:00 | SPY | ETF | 137.82 | 137.85 | 137.69 | 137.75 | 6000.0 |
| 2001-01-31 09:54:00 | SPY | ETF | 137.82 | 137.85 | 137.82 | 137.85 | 2000.0 |
| 2001-01-31 09:55:00 | SPY | ETF | 137.8 | 137.8 | 137.64 | 137.7 | 219400.0 |
| 2001-01-31 09:56:00 | SPY | ETF | 137.65 | 137.65 | 137.61 | 137.61 | 25200.0 |
| 2001-01-31 09:57:00 | SPY | ETF | 137.61 | 137.73 | 137.61 | 137.73 | 1700.0 |
| 2001-01-31 09:58:00 | SPY | ETF | 137.63 | 137.63 | 137.63 | 137.63 | 800.0 |
| 2001-01-31 09:59:00 | SPY | ETF | 137.75 | 137.79 | 137.66 | 137.78 | 1200.0 |
| 2001-01-31 10:00:00 | SPY | ETF | 137.79 | 137.84 | 137.71 | 137.8 | 15500.0 |
| 2001-01-31 10:01:00 | SPY | ETF | 137.7 | 137.89 | 137.7 | 137.89 | 18200.0 |
| 2001-01-31 10:02:00 | SPY | ETF | 137.89 | 137.9 | 137.84 | 137.84 | 12400.0 |
| 2001-01-31 10:03:00 | SPY | ETF | 137.8 | 137.94 | 137.79 | 137.79 | 11600.0 |
| 2001-01-31 10:04:00 | SPY | ETF | 137.81 | 137.92 | 137.75 | 137.75 | 9400.0 |
| 2001-01-31 10:05:00 | SPY | ETF | 137.86 | 137.86 | 137.81 | 137.81 | 4900.0 |
| 2001-01-31 10:06:00 | SPY | ETF | 137.91 | 137.92 | 137.8 | 137.8 | 7800.0 |
| 2001-01-31 10:07:00 | SPY | ETF | 137.84 | 137.84 | 137.84 | 137.84 | 300.0 |
| 2001-01-31 10:08:00 | SPY | ETF | 137.85 | 137.86 | 137.83 | 137.85 | 37800.0 |
| 2001-01-31 10:09:00 | SPY | ETF | 137.86 | 137.86 | 137.76 | 137.76 | 2900.0 |
| 2001-01-31 10:10:00 | SPY | ETF | 137.85 | 137.86 | 137.76 | 137.76 | 3900.0 |
| 2001-01-31 10:11:00 | SPY | ETF | 137.75 | 137.79 | 137.63 | 137.63 | 8300.0 |
| 2001-01-31 10:12:00 | SPY | ETF | 137.78 | 137.78 | 137.64 | 137.73 | 22300.0 |
| 2001-01-31 10:13:00 | SPY | ETF | 137.72 | 137.77 | 137.72 | 137.77 | 4300.0 |
| 2001-01-31 10:14:00 | SPY | ETF | 137.73 | 137.77 | 137.61 | 137.61 | 6000.0 |
| 2001-01-31 10:15:00 | SPY | ETF | 137.7 | 137.76 | 137.65 | 137.76 | 17100.0 |
| 2001-01-31 10:16:00 | SPY | ETF | 137.63 | 137.75 | 137.63 | 137.72 | 3000.0 |
| 2001-01-31 10:17:00 | SPY | ETF | 137.76 | 137.76 | 137.63 | 137.63 | 16700.0 |
| 2001-01-31 10:18:00 | SPY | ETF | 137.62 | 137.69 | 137.62 | 137.69 | 4600.0 |
| 2001-01-31 10:19:00 | SPY | ETF | 137.68 | 137.68 | 137.62 | 137.62 | 5700.0 |
> showing 50 of 3,101 rows — these rows as CSV