PREVIEW / etf_5min / 2003-07-02
file: by_date/etf_5min/2003/2003-07-02.parquet size: 56 KB rows: 2,623
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-02 08:00:00 | SPY | ETF | 98.88 | 98.88 | 98.88 | 98.88 | 100.0 |
| 2003-07-02 08:05:00 | SPY | ETF | 98.87 | 98.88 | 98.85 | 98.88 | 1600.0 |
| 2003-07-02 08:20:00 | SPY | ETF | 98.88 | 98.95 | 98.88 | 98.95 | 1700.0 |
| 2003-07-02 08:30:00 | SPY | ETF | 98.95 | 98.95 | 98.95 | 98.95 | 800.0 |
| 2003-07-02 08:35:00 | SPY | ETF | 98.92 | 98.93 | 98.92 | 98.93 | 600.0 |
| 2003-07-02 08:40:00 | SPY | ETF | 98.91 | 98.91 | 98.81 | 98.81 | 2500.0 |
| 2003-07-02 08:45:00 | SPY | ETF | 98.83 | 98.83 | 98.73 | 98.73 | 29300.0 |
| 2003-07-02 08:50:00 | SPY | ETF | 98.7 | 98.73 | 98.69 | 98.69 | 25500.0 |
| 2003-07-02 08:55:00 | SPY | ETF | 98.72 | 98.75 | 98.72 | 98.75 | 3700.0 |
| 2003-07-02 09:00:00 | SPY | ETF | 98.7 | 98.73 | 98.7 | 98.7 | 11500.0 |
| 2003-07-02 09:05:00 | SPY | ETF | 98.69 | 98.7 | 98.69 | 98.7 | 1300.0 |
| 2003-07-02 09:10:00 | SPY | ETF | 98.75 | 98.75 | 98.71 | 98.71 | 1100.0 |
| 2003-07-02 09:15:00 | SPY | ETF | 98.7 | 98.73 | 98.7 | 98.73 | 4000.0 |
| 2003-07-02 09:25:00 | SPY | ETF | 98.77 | 98.79 | 98.77 | 98.79 | 6800.0 |
| 2003-07-02 09:30:00 | SPY | ETF | 98.77 | 98.9 | 98.57 | 98.72 | 1171100.0 |
| 2003-07-02 09:35:00 | SPY | ETF | 98.72 | 98.93 | 98.61 | 98.93 | 890800.0 |
| 2003-07-02 09:40:00 | SPY | ETF | 98.943 | 99.05 | 98.81 | 98.95 | 920300.0 |
| 2003-07-02 09:45:00 | SPY | ETF | 98.94 | 98.97 | 98.84 | 98.88 | 441800.0 |
| 2003-07-02 09:50:00 | SPY | ETF | 98.88 | 98.96 | 98.83 | 98.91 | 264600.0 |
| 2003-07-02 09:55:00 | SPY | ETF | 98.92 | 99.2 | 98.88 | 99.19 | 1760100.0 |
| 2003-07-02 10:00:00 | SPY | ETF | 99.17 | 99.28 | 99.02 | 99.05 | 1339900.0 |
| 2003-07-02 10:05:00 | SPY | ETF | 99.05 | 99.13 | 99.01 | 99.051 | 842200.0 |
| 2003-07-02 10:10:00 | SPY | ETF | 99.06 | 99.06 | 98.85 | 98.89 | 915000.0 |
| 2003-07-02 10:15:00 | SPY | ETF | 98.902 | 99.0 | 98.86 | 98.91 | 414600.0 |
| 2003-07-02 10:20:00 | SPY | ETF | 98.93 | 98.93 | 98.75 | 98.873 | 370200.0 |
| 2003-07-02 10:25:00 | SPY | ETF | 98.87 | 98.9 | 98.74 | 98.831 | 374600.0 |
| 2003-07-02 10:30:00 | SPY | ETF | 98.84 | 98.97 | 98.8 | 98.95 | 145900.0 |
| 2003-07-02 10:35:00 | SPY | ETF | 98.97 | 99.09 | 98.94 | 99.07 | 452800.0 |
| 2003-07-02 10:40:00 | SPY | ETF | 99.07 | 99.15 | 99.03 | 99.12 | 250300.0 |
| 2003-07-02 10:45:00 | SPY | ETF | 99.14 | 99.199 | 99.0 | 99.1 | 258700.0 |
| 2003-07-02 10:50:00 | SPY | ETF | 99.09 | 99.15 | 99.03 | 99.07 | 210400.0 |
| 2003-07-02 10:55:00 | SPY | ETF | 99.08 | 99.12 | 99.02 | 99.1 | 213700.0 |
| 2003-07-02 11:00:00 | SPY | ETF | 99.09 | 99.21 | 98.86 | 98.98 | 351300.0 |
| 2003-07-02 11:05:00 | SPY | ETF | 98.98 | 99.03 | 98.88 | 98.957 | 243900.0 |
| 2003-07-02 11:10:00 | SPY | ETF | 98.97 | 98.98 | 98.83 | 98.89 | 427400.0 |
| 2003-07-02 11:15:00 | SPY | ETF | 98.88 | 98.94 | 98.84 | 98.85 | 144300.0 |
| 2003-07-02 11:20:00 | SPY | ETF | 98.87 | 98.97 | 98.76 | 98.933 | 178400.0 |
| 2003-07-02 11:25:00 | SPY | ETF | 98.937 | 99.06 | 98.9 | 99.05 | 307700.0 |
| 2003-07-02 11:30:00 | SPY | ETF | 99.06 | 99.13 | 99.03 | 99.09 | 196300.0 |
| 2003-07-02 11:35:00 | SPY | ETF | 99.09 | 99.09 | 98.95 | 98.97 | 184300.0 |
| 2003-07-02 11:40:00 | SPY | ETF | 98.97 | 99.06 | 98.91 | 99.02 | 176300.0 |
| 2003-07-02 11:45:00 | SPY | ETF | 99.02 | 99.07 | 98.95 | 98.96 | 112100.0 |
| 2003-07-02 11:50:00 | SPY | ETF | 98.98 | 99.04 | 98.9 | 99.01 | 163200.0 |
| 2003-07-02 11:55:00 | SPY | ETF | 99.01 | 99.15 | 98.93 | 99.13 | 115000.0 |
| 2003-07-02 12:00:00 | SPY | ETF | 99.15 | 99.2 | 99.1 | 99.157 | 183300.0 |
| 2003-07-02 12:05:00 | SPY | ETF | 99.158 | 99.253 | 99.13 | 99.24 | 394900.0 |
| 2003-07-02 12:10:00 | SPY | ETF | 99.23 | 99.29 | 99.14 | 99.16 | 491200.0 |
| 2003-07-02 12:15:00 | SPY | ETF | 99.17 | 99.28 | 99.11 | 99.17 | 320300.0 |
| 2003-07-02 12:20:00 | SPY | ETF | 99.17 | 99.19 | 99.08 | 99.13 | 250900.0 |
| 2003-07-02 12:25:00 | SPY | ETF | 99.13 | 99.21 | 99.1 | 99.2 | 158800.0 |
> showing 50 of 2,623 rows — these rows as CSV