PREVIEW / etf_5min / 2001-09-24
file: by_date/etf_5min/2001/2001-09-24.parquet size: 38 KB rows: 1,596
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-24 09:30:00 | SPY | ETF | 99.72 | 99.83 | 99.45 | 99.72 | 1112300.0 |
| 2001-09-24 09:35:00 | SPY | ETF | 99.8 | 99.85 | 99.5 | 99.6 | 562600.0 |
| 2001-09-24 09:40:00 | SPY | ETF | 99.67 | 100.06 | 99.5 | 100.0 | 937800.0 |
| 2001-09-24 09:45:00 | SPY | ETF | 100.0 | 100.04 | 99.65 | 99.8 | 666700.0 |
| 2001-09-24 09:50:00 | SPY | ETF | 99.81 | 99.9 | 99.45 | 99.62 | 283900.0 |
| 2001-09-24 09:55:00 | SPY | ETF | 99.51 | 99.59 | 99.25 | 99.4 | 326100.0 |
| 2001-09-24 10:00:00 | SPY | ETF | 99.3 | 99.45 | 99.06 | 99.39 | 469300.0 |
| 2001-09-24 10:05:00 | SPY | ETF | 99.39 | 99.6 | 99.12 | 99.52 | 637800.0 |
| 2001-09-24 10:10:00 | SPY | ETF | 99.52 | 99.6 | 99.25 | 99.32 | 340700.0 |
| 2001-09-24 10:15:00 | SPY | ETF | 99.3 | 99.48 | 99.15 | 99.4 | 230500.0 |
| 2001-09-24 10:20:00 | SPY | ETF | 99.51 | 99.75 | 99.4 | 99.67 | 434000.0 |
| 2001-09-24 10:25:00 | SPY | ETF | 99.67 | 99.8 | 99.6 | 99.6 | 382200.0 |
| 2001-09-24 10:30:00 | SPY | ETF | 99.59 | 99.75 | 99.49 | 99.74 | 152000.0 |
| 2001-09-24 10:35:00 | SPY | ETF | 99.7 | 99.78 | 99.29 | 99.35 | 360500.0 |
| 2001-09-24 10:40:00 | SPY | ETF | 99.43 | 99.89 | 99.32 | 99.78 | 378500.0 |
| 2001-09-24 10:45:00 | SPY | ETF | 99.82 | 99.96 | 99.73 | 99.76 | 435100.0 |
| 2001-09-24 10:50:00 | SPY | ETF | 99.75 | 99.92 | 99.72 | 99.78 | 638000.0 |
| 2001-09-24 10:55:00 | SPY | ETF | 99.82 | 99.9 | 99.73 | 99.8 | 281000.0 |
| 2001-09-24 11:00:00 | SPY | ETF | 99.88 | 100.12 | 99.82 | 100.09 | 593800.0 |
| 2001-09-24 11:05:00 | SPY | ETF | 100.09 | 100.09 | 99.84 | 99.95 | 373800.0 |
| 2001-09-24 11:10:00 | SPY | ETF | 99.92 | 100.2 | 99.91 | 100.05 | 750700.0 |
| 2001-09-24 11:15:00 | SPY | ETF | 100.09 | 100.32 | 100.05 | 100.27 | 483200.0 |
| 2001-09-24 11:20:00 | SPY | ETF | 100.28 | 100.4 | 100.19 | 100.38 | 348300.0 |
| 2001-09-24 11:25:00 | SPY | ETF | 100.34 | 100.4 | 100.15 | 100.16 | 158900.0 |
| 2001-09-24 11:30:00 | SPY | ETF | 100.16 | 100.35 | 100.15 | 100.2 | 455800.0 |
| 2001-09-24 11:35:00 | SPY | ETF | 100.19 | 100.26 | 100.13 | 100.17 | 316900.0 |
| 2001-09-24 11:40:00 | SPY | ETF | 100.17 | 100.22 | 100.0 | 100.07 | 214500.0 |
| 2001-09-24 11:45:00 | SPY | ETF | 100.02 | 100.4 | 100.02 | 100.4 | 268300.0 |
| 2001-09-24 11:50:00 | SPY | ETF | 100.4 | 100.6 | 100.38 | 100.43 | 321200.0 |
| 2001-09-24 11:55:00 | SPY | ETF | 100.4 | 100.6 | 100.4 | 100.51 | 521700.0 |
| 2001-09-24 12:00:00 | SPY | ETF | 100.47 | 100.66 | 100.41 | 100.51 | 124800.0 |
| 2001-09-24 12:05:00 | SPY | ETF | 100.51 | 100.52 | 100.36 | 100.37 | 157100.0 |
| 2001-09-24 12:10:00 | SPY | ETF | 100.44 | 100.5 | 100.34 | 100.5 | 108400.0 |
| 2001-09-24 12:15:00 | SPY | ETF | 100.47 | 100.62 | 100.41 | 100.49 | 80600.0 |
| 2001-09-24 12:20:00 | SPY | ETF | 100.43 | 100.5 | 100.37 | 100.5 | 125800.0 |
| 2001-09-24 12:25:00 | SPY | ETF | 100.48 | 100.59 | 100.45 | 100.54 | 219800.0 |
| 2001-09-24 12:30:00 | SPY | ETF | 100.52 | 100.66 | 100.47 | 100.63 | 185400.0 |
| 2001-09-24 12:35:00 | SPY | ETF | 100.59 | 100.65 | 100.53 | 100.6 | 84800.0 |
| 2001-09-24 12:40:00 | SPY | ETF | 100.63 | 100.74 | 100.53 | 100.74 | 99700.0 |
| 2001-09-24 12:45:00 | SPY | ETF | 100.7 | 100.77 | 100.64 | 100.73 | 117400.0 |
| 2001-09-24 12:50:00 | SPY | ETF | 100.7 | 100.81 | 100.7 | 100.75 | 112700.0 |
| 2001-09-24 12:55:00 | SPY | ETF | 100.74 | 100.82 | 100.72 | 100.82 | 419800.0 |
| 2001-09-24 13:00:00 | SPY | ETF | 100.76 | 100.82 | 100.75 | 100.77 | 259200.0 |
| 2001-09-24 13:05:00 | SPY | ETF | 100.76 | 100.8 | 100.66 | 100.7 | 98400.0 |
| 2001-09-24 13:10:00 | SPY | ETF | 100.7 | 100.74 | 100.55 | 100.58 | 170800.0 |
| 2001-09-24 13:15:00 | SPY | ETF | 100.65 | 100.67 | 100.46 | 100.5 | 187700.0 |
| 2001-09-24 13:20:00 | SPY | ETF | 100.5 | 100.57 | 100.41 | 100.42 | 129000.0 |
| 2001-09-24 13:25:00 | SPY | ETF | 100.45 | 100.54 | 100.35 | 100.5 | 180600.0 |
| 2001-09-24 13:30:00 | SPY | ETF | 100.5 | 100.58 | 100.4 | 100.45 | 110500.0 |
| 2001-09-24 13:35:00 | SPY | ETF | 100.43 | 100.53 | 100.4 | 100.5 | 98900.0 |
> showing 50 of 1,596 rows — these rows as CSV