PREVIEW / etf_1min / 2004-01-22
file: by_date/etf_1min/2004/2004-01-22.parquet size: 179 KB rows: 12,212
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-01-22 08:00:00 | SPY | ETF | 114.95 | 114.95 | 114.95 | 114.95 | 100.0 |
| 2004-01-22 08:06:00 | SPY | ETF | 114.98 | 114.98 | 114.98 | 114.98 | 200.0 |
| 2004-01-22 08:07:00 | SPY | ETF | 114.98 | 114.98 | 114.98 | 114.98 | 900.0 |
| 2004-01-22 08:12:00 | SPY | ETF | 114.95 | 114.95 | 114.95 | 114.95 | 100.0 |
| 2004-01-22 08:13:00 | SPY | ETF | 114.95 | 114.95 | 114.95 | 114.95 | 500.0 |
| 2004-01-22 08:14:00 | SPY | ETF | 114.94 | 114.96 | 114.94 | 114.96 | 1600.0 |
| 2004-01-22 08:22:00 | SPY | ETF | 114.99 | 114.99 | 114.99 | 114.99 | 500.0 |
| 2004-01-22 08:24:00 | SPY | ETF | 114.95 | 114.95 | 114.94 | 114.94 | 9600.0 |
| 2004-01-22 08:29:00 | SPY | ETF | 114.93 | 114.93 | 114.93 | 114.93 | 1000.0 |
| 2004-01-22 08:30:00 | SPY | ETF | 114.99 | 115.0 | 114.95 | 114.95 | 800.0 |
| 2004-01-22 08:32:00 | SPY | ETF | 115.0 | 115.0 | 115.0 | 115.0 | 1000.0 |
| 2004-01-22 08:36:00 | SPY | ETF | 115.02 | 115.02 | 115.02 | 115.02 | 100.0 |
| 2004-01-22 08:37:00 | SPY | ETF | 115.02 | 115.02 | 115.02 | 115.02 | 1800.0 |
| 2004-01-22 08:38:00 | SPY | ETF | 115.02 | 115.02 | 115.02 | 115.02 | 100.0 |
| 2004-01-22 08:39:00 | SPY | ETF | 115.03 | 115.03 | 115.03 | 115.03 | 500.0 |
| 2004-01-22 08:45:00 | SPY | ETF | 115.03 | 115.03 | 115.03 | 115.03 | 1000.0 |
| 2004-01-22 08:47:00 | SPY | ETF | 115.03 | 115.04 | 115.03 | 115.04 | 1100.0 |
| 2004-01-22 08:48:00 | SPY | ETF | 115.04 | 115.04 | 115.04 | 115.04 | 900.0 |
| 2004-01-22 08:50:00 | SPY | ETF | 115.07 | 115.07 | 115.07 | 115.07 | 100.0 |
| 2004-01-22 08:51:00 | SPY | ETF | 115.07 | 115.07 | 115.07 | 115.07 | 900.0 |
| 2004-01-22 08:52:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 200.0 |
| 2004-01-22 08:54:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 200.0 |
| 2004-01-22 08:56:00 | SPY | ETF | 115.12 | 115.12 | 115.12 | 115.12 | 100.0 |
| 2004-01-22 08:57:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 200.0 |
| 2004-01-22 09:01:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 200.0 |
| 2004-01-22 09:05:00 | SPY | ETF | 115.1 | 115.14 | 115.09 | 115.14 | 4200.0 |
| 2004-01-22 09:08:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 300.0 |
| 2004-01-22 09:10:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 700.0 |
| 2004-01-22 09:13:00 | SPY | ETF | 115.11 | 115.11 | 115.11 | 115.11 | 100.0 |
| 2004-01-22 09:14:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 2000.0 |
| 2004-01-22 09:15:00 | SPY | ETF | 115.1 | 115.1 | 115.1 | 115.1 | 1000.0 |
| 2004-01-22 09:17:00 | SPY | ETF | 115.09 | 115.09 | 115.09 | 115.09 | 100.0 |
| 2004-01-22 09:27:00 | SPY | ETF | 115.16 | 115.16 | 115.16 | 115.16 | 1500.0 |
| 2004-01-22 09:28:00 | SPY | ETF | 115.15 | 115.15 | 115.15 | 115.15 | 500.0 |
| 2004-01-22 09:30:00 | SPY | ETF | 115.14 | 115.18 | 115.08 | 115.11 | 502300.0 |
| 2004-01-22 09:31:00 | SPY | ETF | 115.11 | 115.18 | 115.11 | 115.14 | 100800.0 |
| 2004-01-22 09:32:00 | SPY | ETF | 115.14 | 115.18 | 115.1 | 115.13 | 171700.0 |
| 2004-01-22 09:33:00 | SPY | ETF | 115.14 | 115.2 | 115.1 | 115.16 | 105800.0 |
| 2004-01-22 09:34:00 | SPY | ETF | 115.15 | 115.2 | 115.12 | 115.17 | 972800.0 |
| 2004-01-22 09:35:00 | SPY | ETF | 115.17 | 115.22 | 115.16 | 115.22 | 179100.0 |
| 2004-01-22 09:36:00 | SPY | ETF | 115.16 | 115.27 | 115.15 | 115.24 | 205400.0 |
| 2004-01-22 09:37:00 | SPY | ETF | 115.23 | 115.27 | 115.21 | 115.23 | 305400.0 |
| 2004-01-22 09:38:00 | SPY | ETF | 115.24 | 115.26 | 115.2 | 115.22 | 30500.0 |
| 2004-01-22 09:39:00 | SPY | ETF | 115.22 | 115.29 | 115.21 | 115.28 | 118300.0 |
| 2004-01-22 09:40:00 | SPY | ETF | 115.29 | 115.3 | 115.25 | 115.26 | 275300.0 |
| 2004-01-22 09:41:00 | SPY | ETF | 115.25 | 115.28 | 115.23 | 115.24 | 54300.0 |
| 2004-01-22 09:42:00 | SPY | ETF | 115.24 | 115.26 | 115.19 | 115.21 | 73200.0 |
| 2004-01-22 09:43:00 | SPY | ETF | 115.21 | 115.25 | 115.2 | 115.21 | 38600.0 |
| 2004-01-22 09:44:00 | SPY | ETF | 115.22 | 115.23 | 115.15 | 115.21 | 67100.0 |
| 2004-01-22 09:45:00 | SPY | ETF | 115.22 | 115.23 | 115.17 | 115.2 | 87400.0 |
> showing 50 of 12,212 rows — these rows as CSV