PREVIEW / etf_1min / 2001-09-25
file: by_date/etf_1min/2001/2001-09-25.parquet size: 71 KB rows: 3,936
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-09-25 09:30:00 | SPY | ETF | 100.75 | 100.89 | 100.6 | 100.75 | 271200.0 |
| 2001-09-25 09:31:00 | SPY | ETF | 100.85 | 100.92 | 100.6 | 100.79 | 152300.0 |
| 2001-09-25 09:32:00 | SPY | ETF | 100.73 | 100.79 | 100.65 | 100.66 | 55700.0 |
| 2001-09-25 09:33:00 | SPY | ETF | 100.65 | 100.75 | 100.58 | 100.61 | 111000.0 |
| 2001-09-25 09:34:00 | SPY | ETF | 100.65 | 100.65 | 100.5 | 100.5 | 160000.0 |
| 2001-09-25 09:35:00 | SPY | ETF | 100.5 | 100.54 | 100.42 | 100.42 | 74200.0 |
| 2001-09-25 09:36:00 | SPY | ETF | 100.46 | 100.55 | 100.42 | 100.42 | 285400.0 |
| 2001-09-25 09:37:00 | SPY | ETF | 100.43 | 100.55 | 100.42 | 100.46 | 193600.0 |
| 2001-09-25 09:38:00 | SPY | ETF | 100.55 | 100.55 | 100.45 | 100.47 | 52900.0 |
| 2001-09-25 09:39:00 | SPY | ETF | 100.45 | 100.54 | 100.45 | 100.54 | 100800.0 |
| 2001-09-25 09:40:00 | SPY | ETF | 100.5 | 100.59 | 100.45 | 100.59 | 48300.0 |
| 2001-09-25 09:41:00 | SPY | ETF | 100.58 | 100.7 | 100.57 | 100.66 | 76200.0 |
| 2001-09-25 09:42:00 | SPY | ETF | 100.66 | 100.74 | 100.58 | 100.74 | 155300.0 |
| 2001-09-25 09:43:00 | SPY | ETF | 100.73 | 100.95 | 100.64 | 100.84 | 146000.0 |
| 2001-09-25 09:44:00 | SPY | ETF | 100.9 | 100.95 | 100.78 | 100.89 | 172300.0 |
| 2001-09-25 09:45:00 | SPY | ETF | 100.89 | 100.96 | 100.84 | 100.95 | 29500.0 |
| 2001-09-25 09:46:00 | SPY | ETF | 100.95 | 100.95 | 100.87 | 100.9 | 51000.0 |
| 2001-09-25 09:47:00 | SPY | ETF | 100.9 | 100.94 | 100.8 | 100.86 | 100900.0 |
| 2001-09-25 09:48:00 | SPY | ETF | 100.92 | 100.98 | 100.87 | 100.93 | 97700.0 |
| 2001-09-25 09:49:00 | SPY | ETF | 100.93 | 101.02 | 100.9 | 101.0 | 41300.0 |
| 2001-09-25 09:50:00 | SPY | ETF | 100.98 | 101.08 | 100.92 | 101.02 | 54700.0 |
| 2001-09-25 09:51:00 | SPY | ETF | 101.04 | 101.06 | 100.92 | 100.92 | 111100.0 |
| 2001-09-25 09:52:00 | SPY | ETF | 101.0 | 101.0 | 100.88 | 100.93 | 46100.0 |
| 2001-09-25 09:53:00 | SPY | ETF | 100.91 | 100.98 | 100.82 | 100.85 | 120000.0 |
| 2001-09-25 09:54:00 | SPY | ETF | 100.84 | 100.94 | 100.84 | 100.9 | 60700.0 |
| 2001-09-25 09:55:00 | SPY | ETF | 100.91 | 100.99 | 100.88 | 100.91 | 35400.0 |
| 2001-09-25 09:56:00 | SPY | ETF | 100.96 | 101.08 | 100.9 | 101.0 | 83700.0 |
| 2001-09-25 09:57:00 | SPY | ETF | 101.05 | 101.17 | 101.01 | 101.15 | 6700.0 |
| 2001-09-25 09:58:00 | SPY | ETF | 101.16 | 101.3 | 101.1 | 101.27 | 72500.0 |
| 2001-09-25 09:59:00 | SPY | ETF | 101.2 | 101.34 | 101.15 | 101.3 | 325100.0 |
| 2001-09-25 10:00:00 | SPY | ETF | 101.2 | 101.45 | 100.2 | 100.5 | 632100.0 |
| 2001-09-25 10:01:00 | SPY | ETF | 100.65 | 100.96 | 100.4 | 100.72 | 268600.0 |
| 2001-09-25 10:02:00 | SPY | ETF | 100.8 | 101.05 | 100.5 | 100.94 | 139300.0 |
| 2001-09-25 10:03:00 | SPY | ETF | 100.92 | 101.3 | 100.9 | 101.3 | 175600.0 |
| 2001-09-25 10:04:00 | SPY | ETF | 101.28 | 101.55 | 101.28 | 101.5 | 106400.0 |
| 2001-09-25 10:05:00 | SPY | ETF | 101.45 | 101.62 | 101.45 | 101.57 | 96600.0 |
| 2001-09-25 10:06:00 | SPY | ETF | 101.59 | 101.7 | 101.5 | 101.7 | 141600.0 |
| 2001-09-25 10:07:00 | SPY | ETF | 101.7 | 101.84 | 101.6 | 101.79 | 104500.0 |
| 2001-09-25 10:08:00 | SPY | ETF | 101.79 | 101.8 | 101.67 | 101.77 | 104100.0 |
| 2001-09-25 10:09:00 | SPY | ETF | 101.66 | 101.75 | 101.52 | 101.55 | 385300.0 |
| 2001-09-25 10:10:00 | SPY | ETF | 101.55 | 101.64 | 101.51 | 101.64 | 205300.0 |
| 2001-09-25 10:11:00 | SPY | ETF | 101.7 | 101.7 | 101.55 | 101.63 | 81100.0 |
| 2001-09-25 10:12:00 | SPY | ETF | 101.6 | 101.64 | 101.55 | 101.63 | 50800.0 |
| 2001-09-25 10:13:00 | SPY | ETF | 101.63 | 101.7 | 101.55 | 101.69 | 129400.0 |
| 2001-09-25 10:14:00 | SPY | ETF | 101.74 | 101.9 | 101.6 | 101.85 | 108600.0 |
| 2001-09-25 10:15:00 | SPY | ETF | 101.9 | 102.0 | 101.85 | 101.92 | 136700.0 |
| 2001-09-25 10:16:00 | SPY | ETF | 101.88 | 101.95 | 101.84 | 101.89 | 75500.0 |
| 2001-09-25 10:17:00 | SPY | ETF | 101.94 | 101.97 | 101.8 | 101.92 | 113200.0 |
| 2001-09-25 10:18:00 | SPY | ETF | 101.82 | 101.85 | 101.65 | 101.74 | 59300.0 |
| 2001-09-25 10:19:00 | SPY | ETF | 101.71 | 101.75 | 101.64 | 101.65 | 28100.0 |
> showing 50 of 3,936 rows — these rows as CSV