PREVIEW / etf_5min / 2001-11-23
file: by_date/etf_5min/2001/2001-11-23.parquet size: 23 KB rows: 751
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-23 09:30:00 | SPY | ETF | 114.04 | 114.21 | 114.0 | 114.2 | 186300.0 |
| 2001-11-23 09:35:00 | SPY | ETF | 114.24 | 114.24 | 114.04 | 114.11 | 92000.0 |
| 2001-11-23 09:40:00 | SPY | ETF | 114.12 | 114.3 | 114.08 | 114.26 | 101300.0 |
| 2001-11-23 09:45:00 | SPY | ETF | 114.23 | 114.35 | 114.17 | 114.34 | 153700.0 |
| 2001-11-23 09:50:00 | SPY | ETF | 114.34 | 114.46 | 114.31 | 114.34 | 122200.0 |
| 2001-11-23 09:55:00 | SPY | ETF | 114.35 | 114.38 | 114.22 | 114.27 | 120200.0 |
| 2001-11-23 10:00:00 | SPY | ETF | 114.28 | 114.31 | 114.18 | 114.18 | 48200.0 |
| 2001-11-23 10:05:00 | SPY | ETF | 114.23 | 114.28 | 114.13 | 114.13 | 82100.0 |
| 2001-11-23 10:10:00 | SPY | ETF | 114.19 | 114.27 | 114.16 | 114.27 | 130500.0 |
| 2001-11-23 10:15:00 | SPY | ETF | 114.25 | 114.33 | 114.25 | 114.3 | 87200.0 |
| 2001-11-23 10:20:00 | SPY | ETF | 114.31 | 114.43 | 114.29 | 114.4 | 191900.0 |
| 2001-11-23 10:25:00 | SPY | ETF | 114.34 | 114.5 | 114.3 | 114.47 | 145500.0 |
| 2001-11-23 10:30:00 | SPY | ETF | 114.46 | 114.56 | 114.46 | 114.56 | 72700.0 |
| 2001-11-23 10:35:00 | SPY | ETF | 114.56 | 114.56 | 114.43 | 114.49 | 75300.0 |
| 2001-11-23 10:40:00 | SPY | ETF | 114.48 | 114.56 | 114.46 | 114.56 | 12600.0 |
| 2001-11-23 10:45:00 | SPY | ETF | 114.48 | 114.5 | 114.41 | 114.45 | 130700.0 |
| 2001-11-23 10:50:00 | SPY | ETF | 114.5 | 114.5 | 114.44 | 114.5 | 72800.0 |
| 2001-11-23 10:55:00 | SPY | ETF | 114.46 | 114.59 | 114.45 | 114.59 | 37100.0 |
| 2001-11-23 11:00:00 | SPY | ETF | 114.59 | 114.65 | 114.56 | 114.56 | 31200.0 |
| 2001-11-23 11:05:00 | SPY | ETF | 114.55 | 114.8 | 114.54 | 114.8 | 80000.0 |
| 2001-11-23 11:10:00 | SPY | ETF | 114.79 | 114.82 | 114.74 | 114.8 | 132800.0 |
| 2001-11-23 11:15:00 | SPY | ETF | 114.8 | 114.82 | 114.73 | 114.82 | 43500.0 |
| 2001-11-23 11:20:00 | SPY | ETF | 114.82 | 114.94 | 114.76 | 114.89 | 50000.0 |
| 2001-11-23 11:25:00 | SPY | ETF | 114.93 | 115.01 | 114.88 | 114.98 | 133600.0 |
| 2001-11-23 11:30:00 | SPY | ETF | 114.96 | 114.99 | 114.92 | 114.95 | 245700.0 |
| 2001-11-23 11:35:00 | SPY | ETF | 114.97 | 115.0 | 114.86 | 114.86 | 71600.0 |
| 2001-11-23 11:40:00 | SPY | ETF | 114.9 | 114.92 | 114.83 | 114.87 | 17700.0 |
| 2001-11-23 11:45:00 | SPY | ETF | 114.9 | 115.0 | 114.89 | 114.97 | 126000.0 |
| 2001-11-23 11:50:00 | SPY | ETF | 115.0 | 115.24 | 114.98 | 115.2 | 245400.0 |
| 2001-11-23 11:55:00 | SPY | ETF | 115.2 | 115.24 | 115.15 | 115.17 | 144500.0 |
| 2001-11-23 12:00:00 | SPY | ETF | 115.19 | 115.21 | 115.15 | 115.2 | 63600.0 |
| 2001-11-23 12:05:00 | SPY | ETF | 115.2 | 115.23 | 115.16 | 115.18 | 44000.0 |
| 2001-11-23 12:10:00 | SPY | ETF | 115.2 | 115.28 | 115.19 | 115.26 | 18100.0 |
| 2001-11-23 12:15:00 | SPY | ETF | 115.22 | 115.43 | 115.22 | 115.36 | 55200.0 |
| 2001-11-23 12:20:00 | SPY | ETF | 115.36 | 115.54 | 115.36 | 115.54 | 67900.0 |
| 2001-11-23 12:25:00 | SPY | ETF | 115.51 | 115.57 | 115.45 | 115.45 | 105300.0 |
| 2001-11-23 12:30:00 | SPY | ETF | 115.46 | 115.54 | 115.46 | 115.53 | 65400.0 |
| 2001-11-23 12:35:00 | SPY | ETF | 115.51 | 115.66 | 115.5 | 115.55 | 317600.0 |
| 2001-11-23 12:40:00 | SPY | ETF | 115.54 | 115.58 | 115.48 | 115.58 | 350200.0 |
| 2001-11-23 12:45:00 | SPY | ETF | 115.58 | 115.58 | 115.41 | 115.41 | 206600.0 |
| 2001-11-23 12:50:00 | SPY | ETF | 115.42 | 115.5 | 115.38 | 115.44 | 749400.0 |
| 2001-11-23 12:55:00 | SPY | ETF | 115.44 | 115.54 | 115.41 | 115.46 | 350800.0 |
| 2001-11-23 13:00:00 | SPY | ETF | 115.49 | 115.6 | 115.38 | 115.6 | 372200.0 |
| 2001-11-23 13:05:00 | SPY | ETF | 115.59 | 115.66 | 115.57 | 115.64 | 143900.0 |
| 2001-11-23 13:10:00 | SPY | ETF | 115.64 | 115.75 | 115.64 | 115.75 | 32800.0 |
| 2001-11-23 13:15:00 | SPY | ETF | 115.71 | 115.71 | 115.68 | 115.68 | 49800.0 |
| 2001-11-23 09:30:00 | QQQ | ETF | 38.76 | 38.85 | 38.72 | 38.75 | 1149800.0 |
| 2001-11-23 09:35:00 | QQQ | ETF | 38.74 | 38.78 | 38.57 | 38.6 | 509900.0 |
| 2001-11-23 09:40:00 | QQQ | ETF | 38.6 | 38.78 | 38.6 | 38.7 | 653300.0 |
| 2001-11-23 09:45:00 | QQQ | ETF | 38.71 | 38.83 | 38.64 | 38.75 | 752400.0 |
> showing 50 of 751 rows — these rows as CSV