PREVIEW / etf_1min / 2004-05-07
file: by_date/etf_1min/2004/2004-05-07.parquet size: 213 KB rows: 12,950
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 |
|---|---|---|---|---|---|---|---|
| 2004-05-07 08:02:00 | SPY | ETF | 111.61 | 111.61 | 111.55 | 111.57 | 15900.0 |
| 2004-05-07 08:03:00 | SPY | ETF | 111.61 | 111.61 | 111.61 | 111.61 | 15000.0 |
| 2004-05-07 08:04:00 | SPY | ETF | 111.61 | 111.61 | 111.61 | 111.61 | 5000.0 |
| 2004-05-07 08:05:00 | SPY | ETF | 111.6 | 111.6 | 111.6 | 111.6 | 100.0 |
| 2004-05-07 08:06:00 | SPY | ETF | 111.57 | 111.64 | 111.57 | 111.6 | 700.0 |
| 2004-05-07 08:08:00 | SPY | ETF | 111.66 | 111.66 | 111.63 | 111.63 | 1800.0 |
| 2004-05-07 08:12:00 | SPY | ETF | 111.66 | 111.69 | 111.65 | 111.65 | 7000.0 |
| 2004-05-07 08:14:00 | SPY | ETF | 111.62 | 111.64 | 111.62 | 111.64 | 6000.0 |
| 2004-05-07 08:16:00 | SPY | ETF | 111.62 | 111.62 | 111.61 | 111.62 | 11300.0 |
| 2004-05-07 08:17:00 | SPY | ETF | 111.62 | 111.62 | 111.62 | 111.62 | 7100.0 |
| 2004-05-07 08:18:00 | SPY | ETF | 111.55 | 111.55 | 111.55 | 111.55 | 5100.0 |
| 2004-05-07 08:19:00 | SPY | ETF | 111.64 | 111.64 | 111.64 | 111.64 | 3400.0 |
| 2004-05-07 08:23:00 | SPY | ETF | 111.67 | 111.79 | 111.67 | 111.79 | 2400.0 |
| 2004-05-07 08:24:00 | SPY | ETF | 111.75 | 111.75 | 111.75 | 111.75 | 800.0 |
| 2004-05-07 08:26:00 | SPY | ETF | 111.7 | 111.76 | 111.7 | 111.76 | 2400.0 |
| 2004-05-07 08:27:00 | SPY | ETF | 111.76 | 111.76 | 111.72 | 111.72 | 3100.0 |
| 2004-05-07 08:28:00 | SPY | ETF | 111.7 | 111.73 | 111.7 | 111.73 | 1800.0 |
| 2004-05-07 08:29:00 | SPY | ETF | 111.8 | 111.8 | 111.79 | 111.79 | 800.0 |
| 2004-05-07 08:30:00 | SPY | ETF | 111.97 | 112.02 | 111.09 | 111.25 | 78200.0 |
| 2004-05-07 08:31:00 | SPY | ETF | 111.32 | 111.44 | 111.26 | 111.39 | 428900.0 |
| 2004-05-07 08:32:00 | SPY | ETF | 111.37 | 111.47 | 111.37 | 111.41 | 67100.0 |
| 2004-05-07 08:33:00 | SPY | ETF | 111.41 | 111.67 | 111.4 | 111.58 | 85500.0 |
| 2004-05-07 08:34:00 | SPY | ETF | 111.64 | 111.67 | 111.57 | 111.67 | 52500.0 |
| 2004-05-07 08:35:00 | SPY | ETF | 111.66 | 111.71 | 111.56 | 111.56 | 72800.0 |
| 2004-05-07 08:36:00 | SPY | ETF | 111.56 | 111.58 | 111.5 | 111.52 | 33500.0 |
| 2004-05-07 08:37:00 | SPY | ETF | 111.46 | 111.5 | 111.41 | 111.43 | 24800.0 |
| 2004-05-07 08:38:00 | SPY | ETF | 111.44 | 111.47 | 111.28 | 111.28 | 55100.0 |
| 2004-05-07 08:39:00 | SPY | ETF | 111.26 | 111.31 | 111.17 | 111.29 | 28400.0 |
| 2004-05-07 08:40:00 | SPY | ETF | 111.31 | 111.34 | 111.27 | 111.34 | 17700.0 |
| 2004-05-07 08:41:00 | SPY | ETF | 111.33 | 111.35 | 111.18 | 111.19 | 31200.0 |
| 2004-05-07 08:42:00 | SPY | ETF | 111.2 | 111.28 | 111.19 | 111.25 | 22400.0 |
| 2004-05-07 08:43:00 | SPY | ETF | 111.36 | 111.39 | 111.33 | 111.36 | 2600.0 |
| 2004-05-07 08:44:00 | SPY | ETF | 111.35 | 111.44 | 111.32 | 111.32 | 4000.0 |
| 2004-05-07 08:45:00 | SPY | ETF | 111.28 | 111.28 | 111.2 | 111.28 | 12800.0 |
| 2004-05-07 08:46:00 | SPY | ETF | 111.25 | 111.25 | 111.2 | 111.21 | 47600.0 |
| 2004-05-07 08:47:00 | SPY | ETF | 111.2 | 111.2 | 111.17 | 111.18 | 26500.0 |
| 2004-05-07 08:48:00 | SPY | ETF | 111.2 | 111.21 | 111.16 | 111.18 | 10600.0 |
| 2004-05-07 08:49:00 | SPY | ETF | 111.15 | 111.22 | 111.15 | 111.22 | 600.0 |
| 2004-05-07 08:50:00 | SPY | ETF | 111.25 | 111.3 | 111.25 | 111.27 | 6500.0 |
| 2004-05-07 08:51:00 | SPY | ETF | 111.25 | 111.25 | 111.2 | 111.2 | 2600.0 |
| 2004-05-07 08:52:00 | SPY | ETF | 111.24 | 111.24 | 111.24 | 111.24 | 100.0 |
| 2004-05-07 08:53:00 | SPY | ETF | 111.24 | 111.25 | 111.2 | 111.2 | 13200.0 |
| 2004-05-07 08:54:00 | SPY | ETF | 111.2 | 111.2 | 111.1 | 111.1 | 7500.0 |
| 2004-05-07 08:55:00 | SPY | ETF | 111.12 | 111.19 | 111.1 | 111.1 | 6800.0 |
| 2004-05-07 08:56:00 | SPY | ETF | 111.1 | 111.1 | 111.03 | 111.07 | 51500.0 |
| 2004-05-07 08:57:00 | SPY | ETF | 111.08 | 111.09 | 111.07 | 111.07 | 7000.0 |
| 2004-05-07 08:58:00 | SPY | ETF | 111.07 | 111.12 | 111.0 | 111.0 | 29900.0 |
| 2004-05-07 08:59:00 | SPY | ETF | 110.99 | 111.03 | 110.96 | 111.03 | 25700.0 |
| 2004-05-07 09:00:00 | SPY | ETF | 111.03 | 111.09 | 111.03 | 111.08 | 32100.0 |
| 2004-05-07 09:01:00 | SPY | ETF | 111.08 | 111.12 | 111.08 | 111.12 | 33400.0 |
> showing 50 of 12,950 rows — these rows as CSV