PREVIEW / etf_1min / 2001-08-02
file: by_date/etf_1min/2001/2001-08-02.parquet size: 50 KB rows: 2,811
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-08-02 09:30:00 | SPY | ETF | 123.23 | 123.25 | 122.1 | 123.14 | 67000.0 |
| 2001-08-02 09:31:00 | SPY | ETF | 123.07 | 123.19 | 122.1 | 123.0 | 61100.0 |
| 2001-08-02 09:32:00 | SPY | ETF | 123.12 | 123.16 | 122.93 | 122.98 | 81300.0 |
| 2001-08-02 09:33:00 | SPY | ETF | 123.05 | 123.05 | 122.92 | 123.0 | 36300.0 |
| 2001-08-02 09:34:00 | SPY | ETF | 123.0 | 123.0 | 122.88 | 122.94 | 16500.0 |
| 2001-08-02 09:35:00 | SPY | ETF | 122.93 | 123.0 | 122.9 | 123.0 | 62100.0 |
| 2001-08-02 09:36:00 | SPY | ETF | 122.98 | 123.1 | 122.95 | 123.01 | 115000.0 |
| 2001-08-02 09:37:00 | SPY | ETF | 123.02 | 123.07 | 123.02 | 123.04 | 12500.0 |
| 2001-08-02 09:38:00 | SPY | ETF | 123.04 | 123.05 | 122.99 | 123.0 | 29200.0 |
| 2001-08-02 09:39:00 | SPY | ETF | 123.02 | 123.04 | 122.99 | 122.99 | 95500.0 |
| 2001-08-02 09:40:00 | SPY | ETF | 122.95 | 123.0 | 122.88 | 122.88 | 35200.0 |
| 2001-08-02 09:41:00 | SPY | ETF | 122.88 | 122.94 | 122.85 | 122.93 | 48800.0 |
| 2001-08-02 09:42:00 | SPY | ETF | 122.98 | 122.98 | 122.9 | 122.91 | 10900.0 |
| 2001-08-02 09:43:00 | SPY | ETF | 122.83 | 122.94 | 122.83 | 122.9 | 36300.0 |
| 2001-08-02 09:44:00 | SPY | ETF | 122.9 | 123.05 | 122.9 | 123.02 | 302400.0 |
| 2001-08-02 09:45:00 | SPY | ETF | 123.04 | 123.08 | 123.03 | 123.05 | 20600.0 |
| 2001-08-02 09:46:00 | SPY | ETF | 123.05 | 123.08 | 123.02 | 123.02 | 80600.0 |
| 2001-08-02 09:47:00 | SPY | ETF | 123.07 | 123.07 | 123.0 | 123.04 | 66300.0 |
| 2001-08-02 09:48:00 | SPY | ETF | 123.03 | 123.05 | 123.02 | 123.03 | 7700.0 |
| 2001-08-02 09:49:00 | SPY | ETF | 123.03 | 123.04 | 123.0 | 123.01 | 6600.0 |
| 2001-08-02 09:50:00 | SPY | ETF | 123.0 | 123.09 | 123.0 | 123.04 | 161400.0 |
| 2001-08-02 09:51:00 | SPY | ETF | 123.07 | 123.07 | 122.98 | 122.98 | 13600.0 |
| 2001-08-02 09:52:00 | SPY | ETF | 122.95 | 122.97 | 122.87 | 122.87 | 105900.0 |
| 2001-08-02 09:53:00 | SPY | ETF | 122.9 | 123.0 | 122.9 | 123.0 | 13500.0 |
| 2001-08-02 09:54:00 | SPY | ETF | 122.98 | 122.98 | 122.86 | 122.86 | 71200.0 |
| 2001-08-02 09:55:00 | SPY | ETF | 122.88 | 122.88 | 122.85 | 122.88 | 7500.0 |
| 2001-08-02 09:56:00 | SPY | ETF | 122.89 | 122.9 | 122.87 | 122.89 | 18700.0 |
| 2001-08-02 09:57:00 | SPY | ETF | 122.88 | 122.88 | 122.77 | 122.77 | 17500.0 |
| 2001-08-02 09:58:00 | SPY | ETF | 122.76 | 122.79 | 122.71 | 122.74 | 48200.0 |
| 2001-08-02 09:59:00 | SPY | ETF | 122.71 | 122.84 | 122.71 | 122.81 | 48400.0 |
| 2001-08-02 10:00:00 | SPY | ETF | 122.82 | 122.85 | 122.79 | 122.85 | 17900.0 |
| 2001-08-02 10:01:00 | SPY | ETF | 122.9 | 122.92 | 122.8 | 122.8 | 23200.0 |
| 2001-08-02 10:02:00 | SPY | ETF | 122.81 | 122.91 | 122.8 | 122.91 | 26800.0 |
| 2001-08-02 10:03:00 | SPY | ETF | 122.9 | 122.9 | 122.8 | 122.84 | 12000.0 |
| 2001-08-02 10:04:00 | SPY | ETF | 122.77 | 122.8 | 122.61 | 122.61 | 33000.0 |
| 2001-08-02 10:05:00 | SPY | ETF | 122.65 | 122.65 | 122.57 | 122.57 | 8700.0 |
| 2001-08-02 10:06:00 | SPY | ETF | 122.55 | 122.62 | 122.53 | 122.62 | 7500.0 |
| 2001-08-02 10:07:00 | SPY | ETF | 122.58 | 122.63 | 122.53 | 122.53 | 12800.0 |
| 2001-08-02 10:08:00 | SPY | ETF | 122.55 | 122.55 | 122.44 | 122.49 | 17000.0 |
| 2001-08-02 10:09:00 | SPY | ETF | 122.47 | 122.52 | 122.45 | 122.49 | 38600.0 |
| 2001-08-02 10:10:00 | SPY | ETF | 122.49 | 122.5 | 122.43 | 122.45 | 35500.0 |
| 2001-08-02 10:11:00 | SPY | ETF | 122.44 | 122.48 | 122.4 | 122.4 | 96800.0 |
| 2001-08-02 10:12:00 | SPY | ETF | 122.43 | 122.46 | 122.32 | 122.34 | 58200.0 |
| 2001-08-02 10:13:00 | SPY | ETF | 122.37 | 122.43 | 122.35 | 122.41 | 9900.0 |
| 2001-08-02 10:14:00 | SPY | ETF | 122.46 | 122.46 | 122.34 | 122.37 | 16300.0 |
| 2001-08-02 10:15:00 | SPY | ETF | 122.36 | 122.44 | 122.36 | 122.44 | 7500.0 |
| 2001-08-02 10:16:00 | SPY | ETF | 122.44 | 122.47 | 122.4 | 122.42 | 22500.0 |
| 2001-08-02 10:17:00 | SPY | ETF | 122.37 | 122.46 | 122.25 | 122.25 | 19700.0 |
| 2001-08-02 10:18:00 | SPY | ETF | 122.25 | 122.27 | 122.17 | 122.17 | 26800.0 |
| 2001-08-02 10:19:00 | SPY | ETF | 122.18 | 122.28 | 122.18 | 122.28 | 38500.0 |
> showing 50 of 2,811 rows — these rows as CSV