PREVIEW / etf_1min / 2001-07-31
file: by_date/etf_1min/2001/2001-07-31.parquet size: 56 KB rows: 3,021
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-07-31 09:30:00 | SPY | ETF | 121.0 | 121.0 | 120.88 | 121.0 | 87600.0 |
| 2001-07-31 09:31:00 | SPY | ETF | 120.99 | 121.02 | 120.88 | 121.0 | 8300.0 |
| 2001-07-31 09:32:00 | SPY | ETF | 121.03 | 121.15 | 121.03 | 121.06 | 13200.0 |
| 2001-07-31 09:33:00 | SPY | ETF | 121.09 | 121.1 | 120.97 | 121.0 | 118600.0 |
| 2001-07-31 09:34:00 | SPY | ETF | 121.05 | 121.05 | 120.97 | 121.01 | 18400.0 |
| 2001-07-31 09:35:00 | SPY | ETF | 121.0 | 121.05 | 120.97 | 121.04 | 62000.0 |
| 2001-07-31 09:36:00 | SPY | ETF | 121.08 | 121.08 | 120.94 | 120.96 | 22800.0 |
| 2001-07-31 09:37:00 | SPY | ETF | 120.98 | 121.05 | 120.96 | 121.01 | 28800.0 |
| 2001-07-31 09:38:00 | SPY | ETF | 121.03 | 121.07 | 120.94 | 120.97 | 32100.0 |
| 2001-07-31 09:39:00 | SPY | ETF | 120.96 | 121.04 | 120.96 | 121.04 | 11000.0 |
| 2001-07-31 09:40:00 | SPY | ETF | 120.95 | 121.11 | 120.95 | 121.1 | 17200.0 |
| 2001-07-31 09:41:00 | SPY | ETF | 121.05 | 121.08 | 121.05 | 121.05 | 2400.0 |
| 2001-07-31 09:42:00 | SPY | ETF | 121.03 | 121.04 | 120.97 | 121.03 | 52600.0 |
| 2001-07-31 09:43:00 | SPY | ETF | 121.03 | 121.09 | 121.01 | 121.02 | 13200.0 |
| 2001-07-31 09:44:00 | SPY | ETF | 121.0 | 121.05 | 120.97 | 120.97 | 22000.0 |
| 2001-07-31 09:45:00 | SPY | ETF | 120.93 | 120.96 | 120.88 | 120.93 | 51100.0 |
| 2001-07-31 09:46:00 | SPY | ETF | 120.9 | 120.99 | 120.9 | 120.92 | 17200.0 |
| 2001-07-31 09:47:00 | SPY | ETF | 120.96 | 120.96 | 120.88 | 120.91 | 12400.0 |
| 2001-07-31 09:48:00 | SPY | ETF | 120.96 | 120.99 | 120.95 | 120.96 | 28500.0 |
| 2001-07-31 09:49:00 | SPY | ETF | 120.98 | 121.05 | 120.92 | 121.04 | 21000.0 |
| 2001-07-31 09:50:00 | SPY | ETF | 121.05 | 121.07 | 120.98 | 120.98 | 14100.0 |
| 2001-07-31 09:51:00 | SPY | ETF | 121.03 | 121.07 | 121.03 | 121.07 | 5100.0 |
| 2001-07-31 09:52:00 | SPY | ETF | 121.07 | 121.08 | 121.0 | 121.03 | 14200.0 |
| 2001-07-31 09:53:00 | SPY | ETF | 121.03 | 121.03 | 121.02 | 121.02 | 2300.0 |
| 2001-07-31 09:54:00 | SPY | ETF | 121.02 | 121.1 | 121.02 | 121.09 | 3400.0 |
| 2001-07-31 09:55:00 | SPY | ETF | 121.1 | 121.1 | 121.03 | 121.05 | 5100.0 |
| 2001-07-31 09:56:00 | SPY | ETF | 121.06 | 121.06 | 120.99 | 120.99 | 8700.0 |
| 2001-07-31 09:57:00 | SPY | ETF | 121.02 | 121.08 | 121.02 | 121.08 | 1000.0 |
| 2001-07-31 09:58:00 | SPY | ETF | 121.09 | 121.15 | 121.03 | 121.14 | 12400.0 |
| 2001-07-31 09:59:00 | SPY | ETF | 121.15 | 121.25 | 121.15 | 121.25 | 56900.0 |
| 2001-07-31 10:00:00 | SPY | ETF | 121.21 | 121.24 | 120.92 | 120.94 | 59300.0 |
| 2001-07-31 10:01:00 | SPY | ETF | 120.95 | 121.04 | 120.87 | 120.92 | 122700.0 |
| 2001-07-31 10:02:00 | SPY | ETF | 120.93 | 121.0 | 120.86 | 120.98 | 28400.0 |
| 2001-07-31 10:03:00 | SPY | ETF | 120.97 | 121.02 | 120.9 | 120.9 | 230200.0 |
| 2001-07-31 10:04:00 | SPY | ETF | 120.9 | 120.96 | 120.9 | 120.95 | 13600.0 |
| 2001-07-31 10:05:00 | SPY | ETF | 120.92 | 121.01 | 120.92 | 120.98 | 73800.0 |
| 2001-07-31 10:06:00 | SPY | ETF | 120.96 | 120.98 | 120.93 | 120.98 | 52400.0 |
| 2001-07-31 10:07:00 | SPY | ETF | 120.99 | 121.04 | 120.99 | 121.03 | 10300.0 |
| 2001-07-31 10:08:00 | SPY | ETF | 121.04 | 121.06 | 121.04 | 121.06 | 2000.0 |
| 2001-07-31 10:09:00 | SPY | ETF | 121.15 | 121.24 | 121.11 | 121.24 | 4600.0 |
| 2001-07-31 10:10:00 | SPY | ETF | 121.25 | 121.39 | 121.25 | 121.39 | 13200.0 |
| 2001-07-31 10:11:00 | SPY | ETF | 121.39 | 121.49 | 121.38 | 121.48 | 49300.0 |
| 2001-07-31 10:12:00 | SPY | ETF | 121.48 | 121.48 | 121.41 | 121.48 | 42200.0 |
| 2001-07-31 10:13:00 | SPY | ETF | 121.51 | 121.55 | 121.47 | 121.5 | 43300.0 |
| 2001-07-31 10:14:00 | SPY | ETF | 121.49 | 121.49 | 121.41 | 121.47 | 263500.0 |
| 2001-07-31 10:15:00 | SPY | ETF | 121.47 | 121.55 | 121.47 | 121.55 | 22100.0 |
| 2001-07-31 10:16:00 | SPY | ETF | 121.51 | 121.7 | 121.51 | 121.7 | 16400.0 |
| 2001-07-31 10:17:00 | SPY | ETF | 121.61 | 121.71 | 121.57 | 121.71 | 22300.0 |
| 2001-07-31 10:18:00 | SPY | ETF | 121.75 | 121.83 | 121.7 | 121.75 | 81300.0 |
| 2001-07-31 10:19:00 | SPY | ETF | 121.78 | 121.84 | 121.75 | 121.81 | 28300.0 |
> showing 50 of 3,021 rows — these rows as CSV