PREVIEW / etf_1min / 2002-07-31
file: by_date/etf_1min/2002/2002-07-31.parquet size: 89 KB rows: 5,011
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-07-31 09:30:00 | SPY | ETF | 90.49 | 90.55 | 90.26 | 90.3 | 411000.0 |
| 2002-07-31 09:31:00 | SPY | ETF | 90.3 | 90.55 | 90.25 | 90.5 | 56600.0 |
| 2002-07-31 09:32:00 | SPY | ETF | 90.44 | 90.5 | 90.22 | 90.26 | 161500.0 |
| 2002-07-31 09:33:00 | SPY | ETF | 90.23 | 90.31 | 90.15 | 90.2 | 107600.0 |
| 2002-07-31 09:34:00 | SPY | ETF | 90.15 | 90.24 | 90.03 | 90.2 | 121500.0 |
| 2002-07-31 09:35:00 | SPY | ETF | 90.07 | 90.25 | 90.07 | 90.19 | 164100.0 |
| 2002-07-31 09:36:00 | SPY | ETF | 90.15 | 90.37 | 90.1 | 90.26 | 162800.0 |
| 2002-07-31 09:37:00 | SPY | ETF | 90.27 | 90.35 | 90.12 | 90.2 | 178300.0 |
| 2002-07-31 09:38:00 | SPY | ETF | 90.15 | 90.3 | 90.11 | 90.17 | 94600.0 |
| 2002-07-31 09:39:00 | SPY | ETF | 90.19 | 90.46 | 90.12 | 90.38 | 152100.0 |
| 2002-07-31 09:40:00 | SPY | ETF | 90.4 | 90.52 | 90.33 | 90.45 | 141000.0 |
| 2002-07-31 09:41:00 | SPY | ETF | 90.5 | 90.55 | 90.28 | 90.32 | 178500.0 |
| 2002-07-31 09:42:00 | SPY | ETF | 90.32 | 90.42 | 90.2 | 90.33 | 148700.0 |
| 2002-07-31 09:43:00 | SPY | ETF | 90.33 | 90.4 | 90.27 | 90.29 | 122700.0 |
| 2002-07-31 09:44:00 | SPY | ETF | 90.27 | 90.58 | 90.2 | 90.58 | 150300.0 |
| 2002-07-31 09:45:00 | SPY | ETF | 90.57 | 90.69 | 90.4 | 90.6 | 221800.0 |
| 2002-07-31 09:46:00 | SPY | ETF | 90.6 | 90.69 | 90.55 | 90.61 | 120400.0 |
| 2002-07-31 09:47:00 | SPY | ETF | 90.64 | 90.77 | 90.55 | 90.72 | 333700.0 |
| 2002-07-31 09:48:00 | SPY | ETF | 90.73 | 90.85 | 90.66 | 90.72 | 105800.0 |
| 2002-07-31 09:49:00 | SPY | ETF | 90.71 | 90.85 | 90.62 | 90.66 | 152300.0 |
| 2002-07-31 09:50:00 | SPY | ETF | 90.62 | 90.8 | 90.55 | 90.65 | 242700.0 |
| 2002-07-31 09:51:00 | SPY | ETF | 90.67 | 90.78 | 90.62 | 90.78 | 77500.0 |
| 2002-07-31 09:52:00 | SPY | ETF | 90.7 | 90.78 | 90.62 | 90.7 | 90000.0 |
| 2002-07-31 09:53:00 | SPY | ETF | 90.7 | 90.75 | 90.56 | 90.6 | 92600.0 |
| 2002-07-31 09:54:00 | SPY | ETF | 90.6 | 90.69 | 90.5 | 90.56 | 45700.0 |
| 2002-07-31 09:55:00 | SPY | ETF | 90.53 | 90.7 | 90.45 | 90.62 | 89500.0 |
| 2002-07-31 09:56:00 | SPY | ETF | 90.56 | 90.6 | 90.43 | 90.43 | 69700.0 |
| 2002-07-31 09:57:00 | SPY | ETF | 90.43 | 90.5 | 90.35 | 90.39 | 101100.0 |
| 2002-07-31 09:58:00 | SPY | ETF | 90.36 | 90.56 | 90.3 | 90.38 | 159100.0 |
| 2002-07-31 09:59:00 | SPY | ETF | 90.41 | 90.47 | 90.27 | 90.31 | 61900.0 |
| 2002-07-31 10:00:00 | SPY | ETF | 90.3 | 90.36 | 89.84 | 90.0 | 442200.0 |
| 2002-07-31 10:01:00 | SPY | ETF | 89.94 | 90.14 | 89.85 | 90.03 | 293000.0 |
| 2002-07-31 10:02:00 | SPY | ETF | 90.01 | 90.15 | 89.9 | 90.0 | 235500.0 |
| 2002-07-31 10:03:00 | SPY | ETF | 89.95 | 90.1 | 89.91 | 90.09 | 448400.0 |
| 2002-07-31 10:04:00 | SPY | ETF | 90.1 | 90.24 | 90.0 | 90.02 | 138200.0 |
| 2002-07-31 10:05:00 | SPY | ETF | 90.02 | 90.1 | 89.85 | 89.85 | 140100.0 |
| 2002-07-31 10:06:00 | SPY | ETF | 89.95 | 90.02 | 89.84 | 89.84 | 144000.0 |
| 2002-07-31 10:07:00 | SPY | ETF | 89.94 | 90.1 | 89.83 | 89.83 | 143800.0 |
| 2002-07-31 10:08:00 | SPY | ETF | 89.93 | 90.0 | 89.84 | 89.9 | 191800.0 |
| 2002-07-31 10:09:00 | SPY | ETF | 89.9 | 89.96 | 89.83 | 89.87 | 41700.0 |
| 2002-07-31 10:10:00 | SPY | ETF | 89.84 | 89.91 | 89.7 | 89.8 | 150100.0 |
| 2002-07-31 10:11:00 | SPY | ETF | 89.76 | 89.8 | 89.6 | 89.68 | 396900.0 |
| 2002-07-31 10:12:00 | SPY | ETF | 89.68 | 89.83 | 89.62 | 89.78 | 147600.0 |
| 2002-07-31 10:13:00 | SPY | ETF | 89.76 | 89.84 | 89.68 | 89.83 | 176500.0 |
| 2002-07-31 10:14:00 | SPY | ETF | 89.83 | 89.86 | 89.76 | 89.8 | 202100.0 |
| 2002-07-31 10:15:00 | SPY | ETF | 89.82 | 89.91 | 89.76 | 89.9 | 153000.0 |
| 2002-07-31 10:16:00 | SPY | ETF | 89.91 | 90.01 | 89.85 | 90.0 | 121900.0 |
| 2002-07-31 10:17:00 | SPY | ETF | 90.0 | 90.06 | 89.9 | 90.0 | 98700.0 |
| 2002-07-31 10:18:00 | SPY | ETF | 89.91 | 90.01 | 89.82 | 89.84 | 76100.0 |
| 2002-07-31 10:19:00 | SPY | ETF | 89.84 | 89.9 | 89.72 | 89.74 | 151100.0 |
> showing 50 of 5,011 rows — these rows as CSV