PREVIEW / etf_1min / 2001-03-20
file: by_date/etf_1min/2001/2001-03-20.parquet size: 63 KB rows: 3,241
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-03-20 09:31:00 | SPY | ETF | 117.9 | 117.9 | 117.9 | 117.9 | 331700.0 |
| 2001-03-20 09:32:00 | SPY | ETF | 117.7 | 117.9 | 117.7 | 117.7 | 63500.0 |
| 2001-03-20 09:33:00 | SPY | ETF | 117.7 | 117.7 | 117.51 | 117.69 | 12000.0 |
| 2001-03-20 09:34:00 | SPY | ETF | 117.65 | 117.68 | 117.5 | 117.64 | 21500.0 |
| 2001-03-20 09:35:00 | SPY | ETF | 117.65 | 117.65 | 117.51 | 117.64 | 17600.0 |
| 2001-03-20 09:36:00 | SPY | ETF | 117.54 | 117.63 | 117.5 | 117.5 | 4100.0 |
| 2001-03-20 09:37:00 | SPY | ETF | 117.55 | 117.58 | 117.4 | 117.55 | 38600.0 |
| 2001-03-20 09:38:00 | SPY | ETF | 117.45 | 117.5 | 117.35 | 117.5 | 38700.0 |
| 2001-03-20 09:39:00 | SPY | ETF | 117.53 | 117.75 | 117.4 | 117.63 | 38400.0 |
| 2001-03-20 09:40:00 | SPY | ETF | 117.55 | 117.64 | 117.48 | 117.55 | 26300.0 |
| 2001-03-20 09:41:00 | SPY | ETF | 117.54 | 117.6 | 117.5 | 117.6 | 7800.0 |
| 2001-03-20 09:42:00 | SPY | ETF | 117.6 | 117.6 | 117.39 | 117.54 | 36800.0 |
| 2001-03-20 09:43:00 | SPY | ETF | 117.54 | 117.54 | 117.36 | 117.36 | 14900.0 |
| 2001-03-20 09:44:00 | SPY | ETF | 117.46 | 117.48 | 117.33 | 117.48 | 16100.0 |
| 2001-03-20 09:45:00 | SPY | ETF | 117.34 | 117.5 | 117.34 | 117.5 | 21700.0 |
| 2001-03-20 09:46:00 | SPY | ETF | 117.45 | 117.45 | 117.23 | 117.23 | 6700.0 |
| 2001-03-20 09:47:00 | SPY | ETF | 117.26 | 117.31 | 117.26 | 117.28 | 28800.0 |
| 2001-03-20 09:48:00 | SPY | ETF | 117.28 | 117.33 | 117.25 | 117.26 | 29600.0 |
| 2001-03-20 09:49:00 | SPY | ETF | 117.33 | 117.34 | 117.2 | 117.33 | 16700.0 |
| 2001-03-20 09:50:00 | SPY | ETF | 117.22 | 117.34 | 117.22 | 117.34 | 14200.0 |
| 2001-03-20 09:51:00 | SPY | ETF | 117.27 | 117.34 | 117.25 | 117.25 | 22000.0 |
| 2001-03-20 09:52:00 | SPY | ETF | 117.26 | 117.29 | 117.12 | 117.12 | 26000.0 |
| 2001-03-20 09:53:00 | SPY | ETF | 117.2 | 117.2 | 117.15 | 117.15 | 110100.0 |
| 2001-03-20 09:54:00 | SPY | ETF | 117.11 | 117.17 | 117.03 | 117.17 | 9100.0 |
| 2001-03-20 09:55:00 | SPY | ETF | 117.15 | 117.26 | 117.1 | 117.17 | 13700.0 |
| 2001-03-20 09:56:00 | SPY | ETF | 117.29 | 117.34 | 117.17 | 117.3 | 21700.0 |
| 2001-03-20 09:57:00 | SPY | ETF | 117.31 | 117.32 | 117.17 | 117.29 | 9400.0 |
| 2001-03-20 09:58:00 | SPY | ETF | 117.3 | 117.36 | 117.18 | 117.18 | 30200.0 |
| 2001-03-20 09:59:00 | SPY | ETF | 117.3 | 117.3 | 117.11 | 117.15 | 40900.0 |
| 2001-03-20 10:00:00 | SPY | ETF | 117.12 | 117.2 | 117.01 | 117.11 | 24300.0 |
| 2001-03-20 10:01:00 | SPY | ETF | 117.0 | 117.1 | 117.0 | 117.1 | 16600.0 |
| 2001-03-20 10:02:00 | SPY | ETF | 117.22 | 117.3 | 117.22 | 117.3 | 1800.0 |
| 2001-03-20 10:03:00 | SPY | ETF | 117.18 | 117.32 | 117.18 | 117.25 | 12500.0 |
| 2001-03-20 10:04:00 | SPY | ETF | 117.33 | 117.36 | 117.25 | 117.25 | 1600.0 |
| 2001-03-20 10:05:00 | SPY | ETF | 117.24 | 117.36 | 117.24 | 117.36 | 2400.0 |
| 2001-03-20 10:06:00 | SPY | ETF | 117.39 | 117.47 | 117.32 | 117.47 | 63000.0 |
| 2001-03-20 10:07:00 | SPY | ETF | 117.48 | 117.51 | 117.35 | 117.51 | 205100.0 |
| 2001-03-20 10:08:00 | SPY | ETF | 117.5 | 117.6 | 117.35 | 117.45 | 14600.0 |
| 2001-03-20 10:09:00 | SPY | ETF | 117.45 | 117.57 | 117.45 | 117.57 | 28300.0 |
| 2001-03-20 10:10:00 | SPY | ETF | 117.5 | 117.64 | 117.5 | 117.56 | 27000.0 |
| 2001-03-20 10:11:00 | SPY | ETF | 117.56 | 117.64 | 117.51 | 117.6 | 10500.0 |
| 2001-03-20 10:12:00 | SPY | ETF | 117.52 | 117.65 | 117.51 | 117.52 | 10200.0 |
| 2001-03-20 10:13:00 | SPY | ETF | 117.58 | 117.64 | 117.51 | 117.51 | 34000.0 |
| 2001-03-20 10:14:00 | SPY | ETF | 117.64 | 117.74 | 117.64 | 117.74 | 4900.0 |
| 2001-03-20 10:15:00 | SPY | ETF | 117.74 | 117.84 | 117.66 | 117.66 | 35500.0 |
| 2001-03-20 10:16:00 | SPY | ETF | 117.85 | 117.87 | 117.68 | 117.85 | 16000.0 |
| 2001-03-20 10:17:00 | SPY | ETF | 117.92 | 117.96 | 117.78 | 117.81 | 3700.0 |
| 2001-03-20 10:18:00 | SPY | ETF | 117.8 | 117.88 | 117.75 | 117.88 | 33500.0 |
| 2001-03-20 10:20:00 | SPY | ETF | 117.75 | 117.78 | 117.6 | 117.74 | 33800.0 |
| 2001-03-20 10:21:00 | SPY | ETF | 117.66 | 117.84 | 117.66 | 117.84 | 9400.0 |
> showing 50 of 3,241 rows — these rows as CSV