PREVIEW / etf_1min / 2002-01-09
file: by_date/etf_1min/2002/2002-01-09.parquet size: 73 KB rows: 4,061
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-09 09:30:00 | SPY | ETF | 116.68 | 116.77 | 116.65 | 116.75 | 208600.0 |
| 2002-01-09 09:31:00 | SPY | ETF | 116.79 | 116.82 | 116.73 | 116.8 | 220700.0 |
| 2002-01-09 09:32:00 | SPY | ETF | 116.77 | 116.82 | 116.7 | 116.76 | 21900.0 |
| 2002-01-09 09:33:00 | SPY | ETF | 116.78 | 116.85 | 116.77 | 116.85 | 36100.0 |
| 2002-01-09 09:34:00 | SPY | ETF | 116.87 | 116.93 | 116.85 | 116.93 | 39100.0 |
| 2002-01-09 09:35:00 | SPY | ETF | 116.94 | 116.98 | 116.87 | 116.93 | 99200.0 |
| 2002-01-09 09:36:00 | SPY | ETF | 116.93 | 117.05 | 116.93 | 117.05 | 26900.0 |
| 2002-01-09 09:37:00 | SPY | ETF | 117.06 | 117.08 | 117.0 | 117.0 | 79600.0 |
| 2002-01-09 09:38:00 | SPY | ETF | 116.98 | 117.05 | 116.97 | 117.0 | 114600.0 |
| 2002-01-09 09:39:00 | SPY | ETF | 117.0 | 117.02 | 116.96 | 117.0 | 30500.0 |
| 2002-01-09 09:40:00 | SPY | ETF | 116.97 | 117.0 | 116.94 | 116.95 | 249100.0 |
| 2002-01-09 09:41:00 | SPY | ETF | 116.95 | 117.05 | 116.95 | 117.05 | 41800.0 |
| 2002-01-09 09:42:00 | SPY | ETF | 116.98 | 117.06 | 116.97 | 117.06 | 77600.0 |
| 2002-01-09 09:43:00 | SPY | ETF | 117.06 | 117.06 | 116.99 | 117.05 | 83600.0 |
| 2002-01-09 09:44:00 | SPY | ETF | 117.04 | 117.04 | 116.97 | 116.98 | 40500.0 |
| 2002-01-09 09:45:00 | SPY | ETF | 116.95 | 117.0 | 116.91 | 116.98 | 54500.0 |
| 2002-01-09 09:46:00 | SPY | ETF | 116.98 | 117.01 | 116.93 | 116.97 | 93900.0 |
| 2002-01-09 09:47:00 | SPY | ETF | 116.96 | 117.02 | 116.92 | 117.02 | 21900.0 |
| 2002-01-09 09:48:00 | SPY | ETF | 117.04 | 117.05 | 116.94 | 116.94 | 21000.0 |
| 2002-01-09 09:49:00 | SPY | ETF | 117.0 | 117.03 | 116.9 | 116.9 | 122200.0 |
| 2002-01-09 09:50:00 | SPY | ETF | 116.96 | 116.98 | 116.91 | 116.97 | 90700.0 |
| 2002-01-09 09:51:00 | SPY | ETF | 116.94 | 117.03 | 116.94 | 117.0 | 104100.0 |
| 2002-01-09 09:52:00 | SPY | ETF | 116.99 | 117.03 | 116.96 | 117.0 | 18500.0 |
| 2002-01-09 09:53:00 | SPY | ETF | 116.97 | 117.01 | 116.93 | 116.96 | 23100.0 |
| 2002-01-09 09:54:00 | SPY | ETF | 116.97 | 116.97 | 116.88 | 116.88 | 25100.0 |
| 2002-01-09 09:55:00 | SPY | ETF | 116.92 | 116.93 | 116.85 | 116.92 | 30100.0 |
| 2002-01-09 09:56:00 | SPY | ETF | 116.88 | 116.9 | 116.85 | 116.87 | 27100.0 |
| 2002-01-09 09:57:00 | SPY | ETF | 116.84 | 116.85 | 116.79 | 116.81 | 42200.0 |
| 2002-01-09 09:58:00 | SPY | ETF | 116.89 | 116.9 | 116.83 | 116.87 | 223700.0 |
| 2002-01-09 09:59:00 | SPY | ETF | 116.9 | 116.92 | 116.88 | 116.91 | 46400.0 |
| 2002-01-09 10:00:00 | SPY | ETF | 116.9 | 117.0 | 116.86 | 117.0 | 32200.0 |
| 2002-01-09 10:01:00 | SPY | ETF | 117.0 | 117.04 | 116.97 | 117.04 | 45600.0 |
| 2002-01-09 10:02:00 | SPY | ETF | 117.02 | 117.04 | 117.01 | 117.04 | 4400.0 |
| 2002-01-09 10:03:00 | SPY | ETF | 117.01 | 117.16 | 117.01 | 117.15 | 65300.0 |
| 2002-01-09 10:04:00 | SPY | ETF | 117.12 | 117.24 | 117.11 | 117.23 | 76200.0 |
| 2002-01-09 10:05:00 | SPY | ETF | 117.2 | 117.3 | 117.19 | 117.2 | 87800.0 |
| 2002-01-09 10:06:00 | SPY | ETF | 117.23 | 117.24 | 117.19 | 117.24 | 46500.0 |
| 2002-01-09 10:07:00 | SPY | ETF | 117.19 | 117.22 | 117.16 | 117.2 | 119900.0 |
| 2002-01-09 10:08:00 | SPY | ETF | 117.16 | 117.2 | 117.13 | 117.16 | 33600.0 |
| 2002-01-09 10:09:00 | SPY | ETF | 117.19 | 117.2 | 117.12 | 117.18 | 68200.0 |
| 2002-01-09 10:10:00 | SPY | ETF | 117.19 | 117.24 | 117.17 | 117.24 | 70800.0 |
| 2002-01-09 10:11:00 | SPY | ETF | 117.23 | 117.38 | 117.17 | 117.38 | 20000.0 |
| 2002-01-09 10:12:00 | SPY | ETF | 117.36 | 117.49 | 117.35 | 117.47 | 52800.0 |
| 2002-01-09 10:13:00 | SPY | ETF | 117.49 | 117.54 | 117.44 | 117.5 | 132200.0 |
| 2002-01-09 10:14:00 | SPY | ETF | 117.49 | 117.53 | 117.18 | 117.47 | 82500.0 |
| 2002-01-09 10:15:00 | SPY | ETF | 117.49 | 117.5 | 117.44 | 117.47 | 170500.0 |
| 2002-01-09 10:16:00 | SPY | ETF | 117.48 | 117.53 | 117.45 | 117.51 | 66200.0 |
| 2002-01-09 10:17:00 | SPY | ETF | 117.53 | 117.61 | 117.5 | 117.6 | 90900.0 |
| 2002-01-09 10:18:00 | SPY | ETF | 117.53 | 117.62 | 117.52 | 117.58 | 30200.0 |
| 2002-01-09 10:19:00 | SPY | ETF | 117.59 | 117.59 | 117.52 | 117.55 | 69600.0 |
> showing 50 of 4,061 rows — these rows as CSV