PREVIEW / etf_1min / 2001-09-20
file: by_date/etf_1min/2001/2001-09-20.parquet size: 72 KB rows: 3,916
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-09-20 09:30:00 | SPY | ETF | 100.4 | 100.44 | 100.2 | 100.4 | 312500.0 |
| 2001-09-20 09:31:00 | SPY | ETF | 100.2 | 100.62 | 100.2 | 100.54 | 88200.0 |
| 2001-09-20 09:32:00 | SPY | ETF | 100.55 | 100.55 | 100.2 | 100.43 | 191300.0 |
| 2001-09-20 09:33:00 | SPY | ETF | 100.43 | 100.44 | 100.2 | 100.2 | 143300.0 |
| 2001-09-20 09:34:00 | SPY | ETF | 100.25 | 100.3 | 100.05 | 100.15 | 92000.0 |
| 2001-09-20 09:35:00 | SPY | ETF | 100.08 | 100.11 | 99.95 | 100.07 | 61100.0 |
| 2001-09-20 09:36:00 | SPY | ETF | 100.0 | 100.3 | 100.0 | 100.25 | 93700.0 |
| 2001-09-20 09:37:00 | SPY | ETF | 100.25 | 100.35 | 100.1 | 100.35 | 150800.0 |
| 2001-09-20 09:38:00 | SPY | ETF | 100.35 | 100.49 | 100.23 | 100.44 | 155600.0 |
| 2001-09-20 09:39:00 | SPY | ETF | 100.4 | 100.55 | 100.4 | 100.55 | 212900.0 |
| 2001-09-20 09:40:00 | SPY | ETF | 100.55 | 100.6 | 100.4 | 100.52 | 238900.0 |
| 2001-09-20 09:41:00 | SPY | ETF | 100.53 | 100.56 | 100.4 | 100.45 | 206200.0 |
| 2001-09-20 09:42:00 | SPY | ETF | 100.4 | 100.65 | 100.4 | 100.65 | 80800.0 |
| 2001-09-20 09:43:00 | SPY | ETF | 100.55 | 100.93 | 100.5 | 100.9 | 293400.0 |
| 2001-09-20 09:44:00 | SPY | ETF | 100.89 | 100.95 | 100.75 | 100.81 | 90000.0 |
| 2001-09-20 09:45:00 | SPY | ETF | 100.75 | 100.81 | 100.6 | 100.65 | 210800.0 |
| 2001-09-20 09:46:00 | SPY | ETF | 100.74 | 100.9 | 100.65 | 100.72 | 323700.0 |
| 2001-09-20 09:47:00 | SPY | ETF | 100.65 | 100.75 | 100.5 | 100.55 | 181200.0 |
| 2001-09-20 09:48:00 | SPY | ETF | 100.52 | 100.59 | 100.4 | 100.55 | 100600.0 |
| 2001-09-20 09:49:00 | SPY | ETF | 100.5 | 100.59 | 100.4 | 100.49 | 141900.0 |
| 2001-09-20 09:50:00 | SPY | ETF | 100.4 | 100.59 | 100.36 | 100.54 | 78400.0 |
| 2001-09-20 09:51:00 | SPY | ETF | 100.54 | 100.55 | 100.2 | 100.39 | 77300.0 |
| 2001-09-20 09:52:00 | SPY | ETF | 100.34 | 100.45 | 100.25 | 100.3 | 90700.0 |
| 2001-09-20 09:53:00 | SPY | ETF | 100.27 | 100.35 | 100.25 | 100.35 | 161300.0 |
| 2001-09-20 09:54:00 | SPY | ETF | 100.36 | 100.65 | 100.35 | 100.6 | 105400.0 |
| 2001-09-20 09:55:00 | SPY | ETF | 100.6 | 100.7 | 100.35 | 100.7 | 175000.0 |
| 2001-09-20 09:56:00 | SPY | ETF | 100.65 | 100.74 | 100.55 | 100.7 | 141900.0 |
| 2001-09-20 09:57:00 | SPY | ETF | 100.58 | 100.7 | 100.51 | 100.55 | 36700.0 |
| 2001-09-20 09:58:00 | SPY | ETF | 100.55 | 100.59 | 100.49 | 100.55 | 86500.0 |
| 2001-09-20 09:59:00 | SPY | ETF | 100.52 | 100.85 | 100.52 | 100.85 | 166600.0 |
| 2001-09-20 10:00:00 | SPY | ETF | 100.68 | 101.04 | 100.58 | 100.9 | 131400.0 |
| 2001-09-20 10:01:00 | SPY | ETF | 100.85 | 100.9 | 100.7 | 100.8 | 140600.0 |
| 2001-09-20 10:02:00 | SPY | ETF | 100.79 | 100.85 | 100.65 | 100.85 | 135600.0 |
| 2001-09-20 10:03:00 | SPY | ETF | 100.88 | 101.06 | 100.8 | 101.06 | 79800.0 |
| 2001-09-20 10:04:00 | SPY | ETF | 101.0 | 101.17 | 100.75 | 100.99 | 421900.0 |
| 2001-09-20 10:05:00 | SPY | ETF | 101.15 | 101.15 | 100.8 | 100.8 | 62700.0 |
| 2001-09-20 10:06:00 | SPY | ETF | 100.83 | 101.1 | 100.6 | 100.74 | 144800.0 |
| 2001-09-20 10:07:00 | SPY | ETF | 100.65 | 100.74 | 100.5 | 100.56 | 188500.0 |
| 2001-09-20 10:08:00 | SPY | ETF | 100.57 | 100.64 | 100.51 | 100.6 | 231500.0 |
| 2001-09-20 10:09:00 | SPY | ETF | 100.65 | 100.7 | 100.5 | 100.55 | 278500.0 |
| 2001-09-20 10:10:00 | SPY | ETF | 100.5 | 100.6 | 100.4 | 100.6 | 167400.0 |
| 2001-09-20 10:11:00 | SPY | ETF | 100.5 | 100.59 | 100.4 | 100.4 | 12900.0 |
| 2001-09-20 10:12:00 | SPY | ETF | 100.42 | 100.5 | 100.4 | 100.41 | 235100.0 |
| 2001-09-20 10:13:00 | SPY | ETF | 100.41 | 100.5 | 100.3 | 100.35 | 120500.0 |
| 2001-09-20 10:14:00 | SPY | ETF | 100.29 | 100.35 | 100.15 | 100.15 | 229700.0 |
| 2001-09-20 10:15:00 | SPY | ETF | 100.18 | 100.27 | 100.1 | 100.15 | 136300.0 |
| 2001-09-20 10:16:00 | SPY | ETF | 100.23 | 100.23 | 100.07 | 100.18 | 152100.0 |
| 2001-09-20 10:17:00 | SPY | ETF | 100.1 | 100.25 | 100.05 | 100.19 | 68900.0 |
| 2001-09-20 10:18:00 | SPY | ETF | 100.19 | 100.31 | 100.15 | 100.18 | 233200.0 |
| 2001-09-20 10:19:00 | SPY | ETF | 100.21 | 100.25 | 100.05 | 100.2 | 249800.0 |
> showing 50 of 3,916 rows — these rows as CSV