PREVIEW / etf_5min / 2001-09-26
file: by_date/etf_5min/2001/2001-09-26.parquet size: 34 KB rows: 1,382
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-26 09:30:00 | SPY | ETF | 102.35 | 102.4 | 102.15 | 102.26 | 838700.0 |
| 2001-09-26 09:35:00 | SPY | ETF | 102.24 | 102.31 | 101.97 | 102.0 | 478700.0 |
| 2001-09-26 09:40:00 | SPY | ETF | 102.01 | 102.18 | 101.75 | 101.83 | 380900.0 |
| 2001-09-26 09:45:00 | SPY | ETF | 101.8 | 101.92 | 101.51 | 101.55 | 839700.0 |
| 2001-09-26 09:50:00 | SPY | ETF | 101.55 | 101.77 | 101.25 | 101.4 | 549200.0 |
| 2001-09-26 09:55:00 | SPY | ETF | 101.38 | 101.56 | 101.3 | 101.51 | 542600.0 |
| 2001-09-26 10:00:00 | SPY | ETF | 101.51 | 101.57 | 101.28 | 101.4 | 287400.0 |
| 2001-09-26 10:05:00 | SPY | ETF | 101.35 | 101.8 | 101.31 | 101.6 | 230200.0 |
| 2001-09-26 10:10:00 | SPY | ETF | 101.52 | 101.8 | 101.52 | 101.6 | 229400.0 |
| 2001-09-26 10:15:00 | SPY | ETF | 101.61 | 101.78 | 101.5 | 101.74 | 101500.0 |
| 2001-09-26 10:20:00 | SPY | ETF | 101.71 | 101.78 | 101.25 | 101.35 | 142500.0 |
| 2001-09-26 10:25:00 | SPY | ETF | 101.36 | 101.49 | 101.27 | 101.49 | 336100.0 |
| 2001-09-26 10:30:00 | SPY | ETF | 101.45 | 101.53 | 101.28 | 101.49 | 261500.0 |
| 2001-09-26 10:35:00 | SPY | ETF | 101.5 | 101.54 | 101.34 | 101.38 | 189100.0 |
| 2001-09-26 10:40:00 | SPY | ETF | 101.35 | 101.41 | 101.22 | 101.22 | 197600.0 |
| 2001-09-26 10:45:00 | SPY | ETF | 101.22 | 101.37 | 101.15 | 101.37 | 234200.0 |
| 2001-09-26 10:50:00 | SPY | ETF | 101.35 | 101.53 | 101.3 | 101.53 | 59900.0 |
| 2001-09-26 10:55:00 | SPY | ETF | 101.53 | 101.65 | 101.41 | 101.56 | 208100.0 |
| 2001-09-26 11:00:00 | SPY | ETF | 101.6 | 101.61 | 101.41 | 101.44 | 191200.0 |
| 2001-09-26 11:05:00 | SPY | ETF | 101.41 | 101.58 | 101.4 | 101.48 | 225300.0 |
| 2001-09-26 11:10:00 | SPY | ETF | 101.5 | 101.66 | 101.48 | 101.48 | 43400.0 |
| 2001-09-26 11:15:00 | SPY | ETF | 101.47 | 101.53 | 101.28 | 101.31 | 39500.0 |
| 2001-09-26 11:20:00 | SPY | ETF | 101.3 | 101.32 | 100.91 | 101.01 | 272100.0 |
| 2001-09-26 11:25:00 | SPY | ETF | 100.92 | 101.12 | 100.9 | 100.9 | 325700.0 |
| 2001-09-26 11:30:00 | SPY | ETF | 100.9 | 101.15 | 100.88 | 101.04 | 238600.0 |
| 2001-09-26 11:35:00 | SPY | ETF | 101.06 | 101.13 | 101.02 | 101.13 | 268400.0 |
| 2001-09-26 11:40:00 | SPY | ETF | 101.12 | 101.15 | 100.93 | 100.93 | 106600.0 |
| 2001-09-26 11:45:00 | SPY | ETF | 100.99 | 101.0 | 100.8 | 100.86 | 264200.0 |
| 2001-09-26 11:50:00 | SPY | ETF | 100.87 | 101.0 | 100.7 | 100.8 | 199600.0 |
| 2001-09-26 11:55:00 | SPY | ETF | 100.71 | 100.82 | 100.65 | 100.76 | 221000.0 |
| 2001-09-26 12:00:00 | SPY | ETF | 100.8 | 100.94 | 100.75 | 100.85 | 312100.0 |
| 2001-09-26 12:05:00 | SPY | ETF | 100.8 | 100.89 | 100.75 | 100.79 | 100400.0 |
| 2001-09-26 12:10:00 | SPY | ETF | 100.81 | 100.95 | 100.8 | 100.95 | 108500.0 |
| 2001-09-26 12:15:00 | SPY | ETF | 100.9 | 101.05 | 100.86 | 100.94 | 81700.0 |
| 2001-09-26 12:20:00 | SPY | ETF | 100.99 | 101.02 | 100.78 | 100.81 | 72700.0 |
| 2001-09-26 12:25:00 | SPY | ETF | 100.85 | 101.04 | 100.77 | 100.97 | 72500.0 |
| 2001-09-26 12:30:00 | SPY | ETF | 101.0 | 101.07 | 100.9 | 101.07 | 175400.0 |
| 2001-09-26 12:35:00 | SPY | ETF | 101.0 | 101.1 | 100.95 | 101.04 | 145500.0 |
| 2001-09-26 12:40:00 | SPY | ETF | 101.05 | 101.08 | 100.92 | 100.95 | 134900.0 |
| 2001-09-26 12:45:00 | SPY | ETF | 100.91 | 100.92 | 100.75 | 100.75 | 73600.0 |
| 2001-09-26 12:50:00 | SPY | ETF | 100.84 | 100.9 | 100.77 | 100.9 | 70100.0 |
| 2001-09-26 12:55:00 | SPY | ETF | 100.85 | 100.9 | 100.75 | 100.81 | 55600.0 |
| 2001-09-26 13:00:00 | SPY | ETF | 100.75 | 100.81 | 100.58 | 100.66 | 66700.0 |
| 2001-09-26 13:05:00 | SPY | ETF | 100.67 | 100.69 | 100.5 | 100.57 | 140500.0 |
| 2001-09-26 13:10:00 | SPY | ETF | 100.56 | 100.65 | 100.49 | 100.54 | 247100.0 |
| 2001-09-26 13:15:00 | SPY | ETF | 100.55 | 100.7 | 100.5 | 100.68 | 194000.0 |
| 2001-09-26 13:20:00 | SPY | ETF | 100.67 | 100.73 | 100.65 | 100.67 | 401700.0 |
| 2001-09-26 13:25:00 | SPY | ETF | 100.65 | 100.82 | 100.65 | 100.76 | 321400.0 |
| 2001-09-26 13:30:00 | SPY | ETF | 100.78 | 100.8 | 100.66 | 100.66 | 65000.0 |
| 2001-09-26 13:35:00 | SPY | ETF | 100.72 | 100.84 | 100.65 | 100.65 | 107800.0 |
> showing 50 of 1,382 rows — these rows as CSV