PREVIEW / etf_1min / 2001-11-09
file: by_date/etf_1min/2001/2001-11-09.parquet size: 60 KB rows: 3,442
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-11-09 09:30:00 | SPY | ETF | 112.25 | 112.29 | 112.17 | 112.29 | 188200.0 |
| 2001-11-09 09:31:00 | SPY | ETF | 112.29 | 112.33 | 112.2 | 112.2 | 55900.0 |
| 2001-11-09 09:32:00 | SPY | ETF | 112.2 | 112.23 | 112.09 | 112.09 | 30400.0 |
| 2001-11-09 09:33:00 | SPY | ETF | 112.08 | 112.16 | 112.05 | 112.15 | 57900.0 |
| 2001-11-09 09:34:00 | SPY | ETF | 112.11 | 112.18 | 112.1 | 112.1 | 28400.0 |
| 2001-11-09 09:35:00 | SPY | ETF | 112.1 | 112.14 | 112.02 | 112.12 | 117100.0 |
| 2001-11-09 09:36:00 | SPY | ETF | 112.11 | 112.28 | 112.06 | 112.21 | 121700.0 |
| 2001-11-09 09:37:00 | SPY | ETF | 112.19 | 112.28 | 112.12 | 112.23 | 363500.0 |
| 2001-11-09 09:38:00 | SPY | ETF | 112.23 | 112.25 | 112.15 | 112.19 | 80400.0 |
| 2001-11-09 09:39:00 | SPY | ETF | 112.15 | 112.25 | 112.13 | 112.22 | 21300.0 |
| 2001-11-09 09:40:00 | SPY | ETF | 112.22 | 112.25 | 112.1 | 112.13 | 36500.0 |
| 2001-11-09 09:41:00 | SPY | ETF | 112.1 | 112.16 | 112.1 | 112.16 | 126900.0 |
| 2001-11-09 09:42:00 | SPY | ETF | 112.16 | 112.16 | 112.01 | 112.02 | 24600.0 |
| 2001-11-09 09:43:00 | SPY | ETF | 112.02 | 112.1 | 112.0 | 112.04 | 15800.0 |
| 2001-11-09 09:44:00 | SPY | ETF | 112.08 | 112.1 | 111.96 | 111.96 | 31900.0 |
| 2001-11-09 09:45:00 | SPY | ETF | 111.95 | 112.02 | 111.94 | 112.01 | 69800.0 |
| 2001-11-09 09:46:00 | SPY | ETF | 112.01 | 112.05 | 111.96 | 112.0 | 67900.0 |
| 2001-11-09 09:47:00 | SPY | ETF | 112.01 | 112.21 | 111.96 | 112.21 | 45700.0 |
| 2001-11-09 09:48:00 | SPY | ETF | 112.09 | 112.28 | 112.09 | 112.15 | 88200.0 |
| 2001-11-09 09:49:00 | SPY | ETF | 112.15 | 112.44 | 112.15 | 112.27 | 131000.0 |
| 2001-11-09 09:50:00 | SPY | ETF | 112.44 | 112.5 | 112.34 | 112.35 | 186600.0 |
| 2001-11-09 09:51:00 | SPY | ETF | 112.45 | 112.54 | 112.38 | 112.54 | 685700.0 |
| 2001-11-09 09:52:00 | SPY | ETF | 112.53 | 112.59 | 112.42 | 112.42 | 48900.0 |
| 2001-11-09 09:53:00 | SPY | ETF | 112.52 | 112.52 | 112.24 | 112.24 | 45300.0 |
| 2001-11-09 09:54:00 | SPY | ETF | 112.25 | 112.42 | 112.14 | 112.32 | 100600.0 |
| 2001-11-09 09:55:00 | SPY | ETF | 112.25 | 112.28 | 111.96 | 111.98 | 69800.0 |
| 2001-11-09 09:56:00 | SPY | ETF | 112.05 | 112.25 | 111.77 | 111.83 | 64200.0 |
| 2001-11-09 09:57:00 | SPY | ETF | 111.9 | 112.02 | 111.75 | 111.8 | 27900.0 |
| 2001-11-09 09:58:00 | SPY | ETF | 111.75 | 111.92 | 111.74 | 111.91 | 201500.0 |
| 2001-11-09 09:59:00 | SPY | ETF | 111.91 | 111.95 | 111.8 | 111.92 | 63100.0 |
| 2001-11-09 10:00:00 | SPY | ETF | 111.88 | 111.92 | 111.71 | 111.75 | 102400.0 |
| 2001-11-09 10:01:00 | SPY | ETF | 111.67 | 111.75 | 111.64 | 111.73 | 50000.0 |
| 2001-11-09 10:02:00 | SPY | ETF | 111.66 | 111.82 | 111.66 | 111.76 | 29300.0 |
| 2001-11-09 10:03:00 | SPY | ETF | 111.8 | 111.82 | 111.71 | 111.8 | 39200.0 |
| 2001-11-09 10:04:00 | SPY | ETF | 111.74 | 111.85 | 111.52 | 111.58 | 168200.0 |
| 2001-11-09 10:05:00 | SPY | ETF | 111.56 | 111.6 | 111.44 | 111.5 | 174200.0 |
| 2001-11-09 10:06:00 | SPY | ETF | 111.56 | 111.6 | 111.5 | 111.57 | 118300.0 |
| 2001-11-09 10:07:00 | SPY | ETF | 111.59 | 111.68 | 111.54 | 111.6 | 46600.0 |
| 2001-11-09 10:08:00 | SPY | ETF | 111.67 | 111.75 | 111.61 | 111.7 | 82700.0 |
| 2001-11-09 10:09:00 | SPY | ETF | 111.68 | 111.78 | 111.64 | 111.74 | 50500.0 |
| 2001-11-09 10:10:00 | SPY | ETF | 111.82 | 111.85 | 111.75 | 111.77 | 30500.0 |
| 2001-11-09 10:11:00 | SPY | ETF | 111.77 | 111.81 | 111.7 | 111.81 | 12300.0 |
| 2001-11-09 10:12:00 | SPY | ETF | 111.8 | 111.8 | 111.64 | 111.64 | 11900.0 |
| 2001-11-09 10:13:00 | SPY | ETF | 111.65 | 111.73 | 111.6 | 111.67 | 32100.0 |
| 2001-11-09 10:14:00 | SPY | ETF | 111.63 | 111.73 | 111.63 | 111.7 | 9400.0 |
| 2001-11-09 10:15:00 | SPY | ETF | 111.7 | 111.76 | 111.7 | 111.76 | 30400.0 |
| 2001-11-09 10:16:00 | SPY | ETF | 111.78 | 111.89 | 111.75 | 111.89 | 64900.0 |
| 2001-11-09 10:17:00 | SPY | ETF | 111.88 | 111.95 | 111.85 | 111.87 | 32600.0 |
| 2001-11-09 10:18:00 | SPY | ETF | 111.84 | 111.91 | 111.82 | 111.9 | 41400.0 |
| 2001-11-09 10:19:00 | SPY | ETF | 111.94 | 112.0 | 111.9 | 111.92 | 60800.0 |
> showing 50 of 3,442 rows — these rows as CSV