PREVIEW / etf_1min / 2002-08-06
file: by_date/etf_1min/2002/2002-08-06.parquet size: 87 KB rows: 5,059
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-08-06 09:30:00 | SPY | ETF | 85.23 | 85.3 | 85.11 | 85.23 | 615400.0 |
| 2002-08-06 09:31:00 | SPY | ETF | 85.25 | 85.28 | 85.16 | 85.25 | 205000.0 |
| 2002-08-06 09:32:00 | SPY | ETF | 85.22 | 85.4 | 85.2 | 85.4 | 149600.0 |
| 2002-08-06 09:33:00 | SPY | ETF | 85.35 | 85.43 | 85.27 | 85.36 | 146700.0 |
| 2002-08-06 09:34:00 | SPY | ETF | 85.43 | 85.54 | 85.33 | 85.49 | 233300.0 |
| 2002-08-06 09:35:00 | SPY | ETF | 85.54 | 85.56 | 85.48 | 85.55 | 212300.0 |
| 2002-08-06 09:36:00 | SPY | ETF | 85.49 | 85.59 | 85.42 | 85.45 | 235600.0 |
| 2002-08-06 09:37:00 | SPY | ETF | 85.54 | 85.79 | 85.45 | 85.72 | 249200.0 |
| 2002-08-06 09:38:00 | SPY | ETF | 85.71 | 85.82 | 85.65 | 85.76 | 174700.0 |
| 2002-08-06 09:39:00 | SPY | ETF | 85.77 | 86.01 | 85.75 | 86.0 | 768600.0 |
| 2002-08-06 09:40:00 | SPY | ETF | 86.0 | 86.16 | 85.87 | 86.02 | 997800.0 |
| 2002-08-06 09:41:00 | SPY | ETF | 86.0 | 86.09 | 85.92 | 85.94 | 246500.0 |
| 2002-08-06 09:42:00 | SPY | ETF | 85.94 | 86.08 | 85.85 | 85.95 | 100300.0 |
| 2002-08-06 09:43:00 | SPY | ETF | 85.9 | 86.09 | 85.9 | 85.95 | 212900.0 |
| 2002-08-06 09:44:00 | SPY | ETF | 85.92 | 86.07 | 85.9 | 86.02 | 204900.0 |
| 2002-08-06 09:45:00 | SPY | ETF | 86.01 | 86.06 | 85.92 | 85.96 | 145200.0 |
| 2002-08-06 09:46:00 | SPY | ETF | 86.01 | 86.01 | 85.82 | 85.9 | 358200.0 |
| 2002-08-06 09:47:00 | SPY | ETF | 85.82 | 85.9 | 85.75 | 85.75 | 246100.0 |
| 2002-08-06 09:48:00 | SPY | ETF | 85.8 | 85.87 | 85.75 | 85.8 | 244100.0 |
| 2002-08-06 09:49:00 | SPY | ETF | 85.8 | 85.89 | 85.75 | 85.81 | 106000.0 |
| 2002-08-06 09:50:00 | SPY | ETF | 85.76 | 85.82 | 85.7 | 85.8 | 147900.0 |
| 2002-08-06 09:51:00 | SPY | ETF | 85.81 | 85.82 | 85.67 | 85.75 | 231400.0 |
| 2002-08-06 09:52:00 | SPY | ETF | 85.7 | 85.79 | 85.63 | 85.65 | 162300.0 |
| 2002-08-06 09:53:00 | SPY | ETF | 85.65 | 85.76 | 85.63 | 85.68 | 212400.0 |
| 2002-08-06 09:54:00 | SPY | ETF | 85.7 | 85.81 | 85.69 | 85.75 | 198200.0 |
| 2002-08-06 09:55:00 | SPY | ETF | 85.78 | 85.88 | 85.7 | 85.86 | 310300.0 |
| 2002-08-06 09:56:00 | SPY | ETF | 85.86 | 85.89 | 85.74 | 85.74 | 294100.0 |
| 2002-08-06 09:57:00 | SPY | ETF | 85.78 | 85.84 | 85.68 | 85.79 | 210300.0 |
| 2002-08-06 09:58:00 | SPY | ETF | 85.77 | 85.84 | 85.64 | 85.7 | 102100.0 |
| 2002-08-06 09:59:00 | SPY | ETF | 85.69 | 85.8 | 85.64 | 85.75 | 218600.0 |
| 2002-08-06 10:00:00 | SPY | ETF | 85.76 | 86.0 | 85.76 | 86.0 | 437300.0 |
| 2002-08-06 10:01:00 | SPY | ETF | 85.97 | 86.08 | 85.93 | 86.03 | 224400.0 |
| 2002-08-06 10:02:00 | SPY | ETF | 86.05 | 86.11 | 86.01 | 86.08 | 211400.0 |
| 2002-08-06 10:03:00 | SPY | ETF | 86.13 | 86.25 | 86.08 | 86.2 | 557500.0 |
| 2002-08-06 10:04:00 | SPY | ETF | 86.25 | 86.41 | 86.22 | 86.39 | 659500.0 |
| 2002-08-06 10:05:00 | SPY | ETF | 86.39 | 86.45 | 86.25 | 86.3 | 250400.0 |
| 2002-08-06 10:06:00 | SPY | ETF | 86.28 | 86.43 | 86.28 | 86.38 | 686200.0 |
| 2002-08-06 10:07:00 | SPY | ETF | 86.37 | 86.44 | 86.29 | 86.31 | 106700.0 |
| 2002-08-06 10:08:00 | SPY | ETF | 86.31 | 86.38 | 86.28 | 86.3 | 126900.0 |
| 2002-08-06 10:09:00 | SPY | ETF | 86.33 | 86.4 | 86.3 | 86.4 | 218000.0 |
| 2002-08-06 10:10:00 | SPY | ETF | 86.41 | 86.62 | 86.3 | 86.56 | 636300.0 |
| 2002-08-06 10:11:00 | SPY | ETF | 86.59 | 86.77 | 86.5 | 86.73 | 684700.0 |
| 2002-08-06 10:12:00 | SPY | ETF | 86.67 | 86.88 | 86.65 | 86.7 | 530200.0 |
| 2002-08-06 10:13:00 | SPY | ETF | 86.65 | 86.74 | 86.62 | 86.62 | 216000.0 |
| 2002-08-06 10:14:00 | SPY | ETF | 86.63 | 86.71 | 86.55 | 86.64 | 301500.0 |
| 2002-08-06 10:15:00 | SPY | ETF | 86.65 | 86.78 | 86.55 | 86.75 | 368900.0 |
| 2002-08-06 10:16:00 | SPY | ETF | 86.75 | 87.17 | 86.75 | 87.17 | 1428100.0 |
| 2002-08-06 10:17:00 | SPY | ETF | 87.17 | 87.22 | 86.95 | 87.15 | 536000.0 |
| 2002-08-06 10:18:00 | SPY | ETF | 87.11 | 87.2 | 87.0 | 87.1 | 290000.0 |
| 2002-08-06 10:19:00 | SPY | ETF | 87.11 | 87.32 | 87.09 | 87.24 | 560500.0 |
> showing 50 of 5,059 rows — these rows as CSV