PREVIEW / etf_5min / 2001-09-19
file: by_date/etf_5min/2001/2001-09-19.parquet size: 44 KB rows: 1,664
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-19 09:30:00 | SPY | ETF | 104.1 | 104.4 | 104.09 | 104.25 | 668900.0 |
| 2001-09-19 09:35:00 | SPY | ETF | 104.26 | 104.45 | 104.05 | 104.35 | 512100.0 |
| 2001-09-19 09:40:00 | SPY | ETF | 104.29 | 104.35 | 104.0 | 104.02 | 477200.0 |
| 2001-09-19 09:45:00 | SPY | ETF | 104.06 | 104.21 | 103.8 | 103.91 | 290400.0 |
| 2001-09-19 09:50:00 | SPY | ETF | 103.9 | 104.1 | 103.8 | 103.95 | 496500.0 |
| 2001-09-19 09:55:00 | SPY | ETF | 103.98 | 104.3 | 103.9 | 104.19 | 142800.0 |
| 2001-09-19 10:00:00 | SPY | ETF | 104.19 | 104.4 | 104.15 | 104.34 | 145800.0 |
| 2001-09-19 10:05:00 | SPY | ETF | 104.39 | 104.5 | 104.21 | 104.21 | 264700.0 |
| 2001-09-19 10:10:00 | SPY | ETF | 104.3 | 104.38 | 104.2 | 104.3 | 100700.0 |
| 2001-09-19 10:15:00 | SPY | ETF | 104.33 | 104.33 | 103.93 | 103.95 | 400600.0 |
| 2001-09-19 10:20:00 | SPY | ETF | 103.9 | 103.93 | 103.7 | 103.87 | 317000.0 |
| 2001-09-19 10:25:00 | SPY | ETF | 103.88 | 103.95 | 103.51 | 103.59 | 177600.0 |
| 2001-09-19 10:30:00 | SPY | ETF | 103.56 | 103.6 | 103.25 | 103.49 | 242700.0 |
| 2001-09-19 10:35:00 | SPY | ETF | 103.49 | 103.56 | 103.36 | 103.5 | 254000.0 |
| 2001-09-19 10:40:00 | SPY | ETF | 103.49 | 103.54 | 103.1 | 103.18 | 433800.0 |
| 2001-09-19 10:45:00 | SPY | ETF | 103.19 | 103.26 | 103.01 | 103.05 | 399200.0 |
| 2001-09-19 10:50:00 | SPY | ETF | 103.09 | 103.12 | 102.78 | 102.87 | 264100.0 |
| 2001-09-19 10:55:00 | SPY | ETF | 102.87 | 102.93 | 102.65 | 102.9 | 341000.0 |
| 2001-09-19 11:00:00 | SPY | ETF | 102.87 | 102.93 | 102.54 | 102.55 | 451300.0 |
| 2001-09-19 11:05:00 | SPY | ETF | 102.55 | 102.56 | 102.3 | 102.5 | 480800.0 |
| 2001-09-19 11:10:00 | SPY | ETF | 102.48 | 102.48 | 101.88 | 102.02 | 341500.0 |
| 2001-09-19 11:15:00 | SPY | ETF | 102.0 | 102.18 | 101.67 | 101.82 | 491000.0 |
| 2001-09-19 11:20:00 | SPY | ETF | 101.9 | 102.03 | 101.77 | 102.03 | 240000.0 |
| 2001-09-19 11:25:00 | SPY | ETF | 101.98 | 102.24 | 101.95 | 102.05 | 764600.0 |
| 2001-09-19 11:30:00 | SPY | ETF | 102.05 | 102.2 | 101.93 | 102.08 | 524800.0 |
| 2001-09-19 11:35:00 | SPY | ETF | 102.1 | 102.15 | 101.83 | 101.93 | 234400.0 |
| 2001-09-19 11:40:00 | SPY | ETF | 101.85 | 102.2 | 101.85 | 102.15 | 714300.0 |
| 2001-09-19 11:45:00 | SPY | ETF | 102.16 | 102.28 | 102.05 | 102.14 | 316800.0 |
| 2001-09-19 11:50:00 | SPY | ETF | 102.1 | 102.2 | 101.88 | 101.95 | 218500.0 |
| 2001-09-19 11:55:00 | SPY | ETF | 101.95 | 101.95 | 101.23 | 101.3 | 1367300.0 |
| 2001-09-19 12:00:00 | SPY | ETF | 101.32 | 101.32 | 100.8 | 101.1 | 503600.0 |
| 2001-09-19 12:05:00 | SPY | ETF | 101.11 | 101.45 | 101.0 | 101.37 | 327100.0 |
| 2001-09-19 12:10:00 | SPY | ETF | 101.38 | 101.55 | 101.28 | 101.46 | 402000.0 |
| 2001-09-19 12:15:00 | SPY | ETF | 101.5 | 101.79 | 101.3 | 101.79 | 186000.0 |
| 2001-09-19 12:20:00 | SPY | ETF | 101.69 | 101.85 | 101.45 | 101.45 | 612800.0 |
| 2001-09-19 12:25:00 | SPY | ETF | 101.5 | 101.6 | 101.3 | 101.41 | 160100.0 |
| 2001-09-19 12:30:00 | SPY | ETF | 101.43 | 101.6 | 101.4 | 101.43 | 45100.0 |
| 2001-09-19 12:35:00 | SPY | ETF | 101.49 | 101.52 | 101.3 | 101.41 | 43700.0 |
| 2001-09-19 12:40:00 | SPY | ETF | 101.33 | 101.4 | 101.16 | 101.35 | 227600.0 |
| 2001-09-19 12:45:00 | SPY | ETF | 101.32 | 101.35 | 101.14 | 101.15 | 208500.0 |
| 2001-09-19 12:50:00 | SPY | ETF | 101.17 | 101.36 | 101.05 | 101.33 | 197200.0 |
| 2001-09-19 12:55:00 | SPY | ETF | 101.34 | 101.65 | 101.31 | 101.56 | 282500.0 |
| 2001-09-19 13:00:00 | SPY | ETF | 101.62 | 101.66 | 101.46 | 101.46 | 195800.0 |
| 2001-09-19 13:05:00 | SPY | ETF | 101.46 | 101.64 | 101.44 | 101.49 | 153500.0 |
| 2001-09-19 13:10:00 | SPY | ETF | 101.52 | 101.76 | 101.46 | 101.6 | 274800.0 |
| 2001-09-19 13:15:00 | SPY | ETF | 101.6 | 101.69 | 101.44 | 101.5 | 273600.0 |
| 2001-09-19 13:20:00 | SPY | ETF | 101.46 | 101.6 | 101.0 | 101.0 | 178500.0 |
| 2001-09-19 13:25:00 | SPY | ETF | 101.01 | 101.33 | 101.0 | 101.23 | 277200.0 |
| 2001-09-19 13:30:00 | SPY | ETF | 101.26 | 101.26 | 100.85 | 100.93 | 256100.0 |
| 2001-09-19 13:35:00 | SPY | ETF | 100.9 | 101.07 | 100.6 | 100.61 | 443900.0 |
> showing 50 of 1,664 rows — these rows as CSV