PREVIEW / etf_5min / 2004-01-02
file: by_date/etf_5min/2004/2004-01-02.parquet size: 93 KB rows: 4,861
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-02 08:00:00 | SPY | ETF | 111.85 | 111.85 | 111.8 | 111.8 | 4500.0 |
| 2004-01-02 08:05:00 | SPY | ETF | 111.85 | 111.85 | 111.83 | 111.83 | 1300.0 |
| 2004-01-02 08:10:00 | SPY | ETF | 111.86 | 111.86 | 111.86 | 111.86 | 200.0 |
| 2004-01-02 08:15:00 | SPY | ETF | 111.86 | 111.86 | 111.85 | 111.85 | 500.0 |
| 2004-01-02 08:20:00 | SPY | ETF | 111.87 | 111.87 | 111.83 | 111.83 | 5000.0 |
| 2004-01-02 08:25:00 | SPY | ETF | 111.83 | 111.83 | 111.82 | 111.82 | 300.0 |
| 2004-01-02 08:30:00 | SPY | ETF | 111.82 | 111.83 | 111.78 | 111.8 | 11000.0 |
| 2004-01-02 08:35:00 | SPY | ETF | 111.83 | 111.83 | 111.83 | 111.83 | 1500.0 |
| 2004-01-02 08:40:00 | SPY | ETF | 111.83 | 111.83 | 111.83 | 111.83 | 3500.0 |
| 2004-01-02 08:45:00 | SPY | ETF | 111.82 | 111.83 | 111.81 | 111.83 | 3700.0 |
| 2004-01-02 08:50:00 | SPY | ETF | 111.83 | 111.88 | 111.83 | 111.88 | 3000.0 |
| 2004-01-02 08:55:00 | SPY | ETF | 111.9 | 111.9 | 111.89 | 111.9 | 2800.0 |
| 2004-01-02 09:00:00 | SPY | ETF | 111.9 | 111.9 | 111.88 | 111.88 | 4500.0 |
| 2004-01-02 09:05:00 | SPY | ETF | 111.89 | 111.89 | 111.89 | 111.89 | 1000.0 |
| 2004-01-02 09:10:00 | SPY | ETF | 111.91 | 111.91 | 111.86 | 111.91 | 45800.0 |
| 2004-01-02 09:15:00 | SPY | ETF | 111.88 | 111.92 | 111.88 | 111.92 | 1600.0 |
| 2004-01-02 09:20:00 | SPY | ETF | 111.9 | 111.93 | 111.9 | 111.93 | 4600.0 |
| 2004-01-02 09:25:00 | SPY | ETF | 111.89 | 111.9 | 111.75 | 111.75 | 33000.0 |
| 2004-01-02 09:30:00 | SPY | ETF | 111.73 | 111.94 | 111.61 | 111.87 | 2820500.0 |
| 2004-01-02 09:35:00 | SPY | ETF | 111.88 | 111.98 | 111.84 | 111.89 | 1851400.0 |
| 2004-01-02 09:40:00 | SPY | ETF | 111.88 | 111.95 | 111.83 | 111.83 | 681100.0 |
| 2004-01-02 09:45:00 | SPY | ETF | 111.83 | 111.85 | 111.73 | 111.82 | 492500.0 |
| 2004-01-02 09:50:00 | SPY | ETF | 111.83 | 111.86 | 111.72 | 111.76 | 325200.0 |
| 2004-01-02 09:55:00 | SPY | ETF | 111.76 | 111.82 | 111.74 | 111.76 | 204000.0 |
| 2004-01-02 10:00:00 | SPY | ETF | 111.76 | 112.19 | 111.7 | 112.15 | 1719600.0 |
| 2004-01-02 10:05:00 | SPY | ETF | 112.13 | 112.14 | 111.96 | 112.07 | 2454700.0 |
| 2004-01-02 10:10:00 | SPY | ETF | 112.06 | 112.12 | 111.97 | 112.01 | 386500.0 |
| 2004-01-02 10:15:00 | SPY | ETF | 112.02 | 112.18 | 111.99 | 112.15 | 330100.0 |
| 2004-01-02 10:20:00 | SPY | ETF | 112.14 | 112.16 | 111.98 | 112.02 | 272100.0 |
| 2004-01-02 10:25:00 | SPY | ETF | 112.04 | 112.11 | 111.94 | 111.96 | 316900.0 |
| 2004-01-02 10:30:00 | SPY | ETF | 111.96 | 112.04 | 111.93 | 112.03 | 329100.0 |
| 2004-01-02 10:35:00 | SPY | ETF | 112.05 | 112.06 | 111.9 | 112.02 | 308200.0 |
| 2004-01-02 10:40:00 | SPY | ETF | 112.0 | 112.13 | 111.94 | 111.98 | 309400.0 |
| 2004-01-02 10:45:00 | SPY | ETF | 112.0 | 112.14 | 111.98 | 112.11 | 156400.0 |
| 2004-01-02 10:50:00 | SPY | ETF | 112.1 | 112.15 | 112.04 | 112.1 | 218900.0 |
| 2004-01-02 10:55:00 | SPY | ETF | 112.08 | 112.19 | 112.06 | 112.11 | 560300.0 |
| 2004-01-02 11:00:00 | SPY | ETF | 112.12 | 112.16 | 112.08 | 112.09 | 410800.0 |
| 2004-01-02 11:05:00 | SPY | ETF | 112.1 | 112.18 | 112.05 | 112.12 | 127900.0 |
| 2004-01-02 11:10:00 | SPY | ETF | 112.1 | 112.14 | 112.0 | 112.04 | 114900.0 |
| 2004-01-02 11:15:00 | SPY | ETF | 112.05 | 112.06 | 111.87 | 111.95 | 290800.0 |
| 2004-01-02 11:20:00 | SPY | ETF | 111.89 | 111.99 | 111.89 | 111.92 | 289400.0 |
| 2004-01-02 11:25:00 | SPY | ETF | 111.94 | 111.97 | 111.87 | 111.9 | 132600.0 |
| 2004-01-02 11:30:00 | SPY | ETF | 111.89 | 112.07 | 111.88 | 112.04 | 232500.0 |
| 2004-01-02 11:35:00 | SPY | ETF | 112.03 | 112.07 | 111.95 | 112.07 | 136300.0 |
| 2004-01-02 11:40:00 | SPY | ETF | 112.07 | 112.11 | 111.98 | 112.0 | 260600.0 |
| 2004-01-02 11:45:00 | SPY | ETF | 111.98 | 112.05 | 111.91 | 111.95 | 126700.0 |
| 2004-01-02 11:50:00 | SPY | ETF | 111.95 | 112.03 | 111.93 | 111.98 | 121400.0 |
| 2004-01-02 11:55:00 | SPY | ETF | 111.95 | 112.03 | 111.9 | 111.9 | 326100.0 |
| 2004-01-02 12:00:00 | SPY | ETF | 111.9 | 111.99 | 111.9 | 111.96 | 1095000.0 |
| 2004-01-02 12:05:00 | SPY | ETF | 111.94 | 111.99 | 111.82 | 111.96 | 696600.0 |
> showing 50 of 4,861 rows — these rows as CSV