PREVIEW / etf_5min / 2005-12-02
file: by_date/etf_5min/2005/2005-12-02.parquet size: 151 KB rows: 8,383
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-02 07:00:00 | SPY | ETF | 126.78 | 126.78 | 126.78 | 126.78 | 1000.0 |
| 2005-12-02 07:05:00 | SPY | ETF | 126.82 | 126.82 | 126.82 | 126.82 | 500.0 |
| 2005-12-02 07:10:00 | SPY | ETF | 126.84 | 126.84 | 126.84 | 126.84 | 500.0 |
| 2005-12-02 07:20:00 | SPY | ETF | 126.86 | 126.88 | 126.86 | 126.88 | 2000.0 |
| 2005-12-02 07:35:00 | SPY | ETF | 126.85 | 126.85 | 126.84 | 126.84 | 17500.0 |
| 2005-12-02 07:40:00 | SPY | ETF | 126.84 | 126.84 | 126.84 | 126.84 | 15000.0 |
| 2005-12-02 07:50:00 | SPY | ETF | 126.76 | 126.8 | 126.76 | 126.8 | 4100.0 |
| 2005-12-02 07:55:00 | SPY | ETF | 126.77 | 126.81 | 126.77 | 126.78 | 10500.0 |
| 2005-12-02 08:00:00 | SPY | ETF | 126.77 | 126.85 | 126.77 | 126.78 | 21200.0 |
| 2005-12-02 08:05:00 | SPY | ETF | 126.8 | 126.8 | 126.8 | 126.8 | 100.0 |
| 2005-12-02 08:10:00 | SPY | ETF | 126.79 | 126.85 | 126.79 | 126.85 | 42300.0 |
| 2005-12-02 08:15:00 | SPY | ETF | 126.85 | 126.85 | 126.8 | 126.8 | 9800.0 |
| 2005-12-02 08:20:00 | SPY | ETF | 126.79 | 126.83 | 126.75 | 126.83 | 69100.0 |
| 2005-12-02 08:25:00 | SPY | ETF | 126.84 | 126.93 | 126.82 | 126.82 | 16800.0 |
| 2005-12-02 08:30:00 | SPY | ETF | 126.93 | 127.02 | 126.81 | 126.9 | 702800.0 |
| 2005-12-02 08:35:00 | SPY | ETF | 126.92 | 126.99 | 126.87 | 126.98 | 62600.0 |
| 2005-12-02 08:40:00 | SPY | ETF | 126.99 | 127.02 | 126.97 | 126.99 | 94000.0 |
| 2005-12-02 08:45:00 | SPY | ETF | 126.98 | 126.98 | 126.94 | 126.97 | 14100.0 |
| 2005-12-02 08:50:00 | SPY | ETF | 126.98 | 127.0 | 126.95 | 127.0 | 326600.0 |
| 2005-12-02 08:55:00 | SPY | ETF | 126.92 | 126.93 | 126.89 | 126.91 | 8800.0 |
| 2005-12-02 09:00:00 | SPY | ETF | 126.91 | 126.93 | 126.82 | 126.82 | 131200.0 |
| 2005-12-02 09:05:00 | SPY | ETF | 126.82 | 126.95 | 126.81 | 126.82 | 1068800.0 |
| 2005-12-02 09:10:00 | SPY | ETF | 126.82 | 126.86 | 126.8 | 126.83 | 135400.0 |
| 2005-12-02 09:15:00 | SPY | ETF | 126.83 | 126.84 | 126.78 | 126.84 | 89000.0 |
| 2005-12-02 09:20:00 | SPY | ETF | 126.81 | 126.83 | 126.8 | 126.82 | 18900.0 |
| 2005-12-02 09:25:00 | SPY | ETF | 126.81 | 126.82 | 126.77 | 126.77 | 3500.0 |
| 2005-12-02 09:30:00 | SPY | ETF | 126.77 | 126.78 | 126.66 | 126.67 | 938500.0 |
| 2005-12-02 09:35:00 | SPY | ETF | 126.68 | 126.78 | 126.65 | 126.71 | 573600.0 |
| 2005-12-02 09:40:00 | SPY | ETF | 126.7 | 126.73 | 126.61 | 126.63 | 779400.0 |
| 2005-12-02 09:45:00 | SPY | ETF | 126.64 | 126.76 | 126.62 | 126.69 | 809400.0 |
| 2005-12-02 09:50:00 | SPY | ETF | 126.68 | 126.76 | 126.63 | 126.7 | 1065700.0 |
| 2005-12-02 09:55:00 | SPY | ETF | 126.6912 | 126.74 | 126.61 | 126.66 | 1463200.0 |
| 2005-12-02 10:00:00 | SPY | ETF | 126.67 | 126.8 | 126.65 | 126.78 | 755900.0 |
| 2005-12-02 10:05:00 | SPY | ETF | 126.78 | 126.92 | 126.74 | 126.86 | 979300.0 |
| 2005-12-02 10:10:00 | SPY | ETF | 126.87 | 126.92 | 126.82 | 126.9 | 431500.0 |
| 2005-12-02 10:15:00 | SPY | ETF | 126.89 | 126.95 | 126.86 | 126.91 | 442100.0 |
| 2005-12-02 10:20:00 | SPY | ETF | 126.89 | 127.0 | 126.87 | 126.96 | 541700.0 |
| 2005-12-02 10:25:00 | SPY | ETF | 126.96 | 127.06 | 126.95 | 127.04 | 1006800.0 |
| 2005-12-02 10:30:00 | SPY | ETF | 127.04 | 127.08 | 127.01 | 127.02 | 1078800.0 |
| 2005-12-02 10:35:00 | SPY | ETF | 127.03 | 127.05 | 126.89 | 126.92 | 664300.0 |
| 2005-12-02 10:40:00 | SPY | ETF | 126.92 | 126.96 | 126.9 | 126.92 | 357900.0 |
| 2005-12-02 10:45:00 | SPY | ETF | 126.92 | 126.99 | 126.79 | 126.8 | 673200.0 |
| 2005-12-02 10:50:00 | SPY | ETF | 126.81 | 126.84 | 126.73 | 126.8 | 1518400.0 |
| 2005-12-02 10:55:00 | SPY | ETF | 126.78 | 126.84 | 126.68 | 126.74 | 711000.0 |
| 2005-12-02 11:00:00 | SPY | ETF | 126.74 | 126.78 | 126.65 | 126.75 | 241200.0 |
| 2005-12-02 11:05:00 | SPY | ETF | 126.75 | 126.78 | 126.72 | 126.74 | 288100.0 |
| 2005-12-02 11:10:00 | SPY | ETF | 126.73 | 126.78 | 126.66 | 126.76 | 656000.0 |
| 2005-12-02 11:15:00 | SPY | ETF | 126.76 | 126.89 | 126.73 | 126.87 | 820600.0 |
| 2005-12-02 11:20:00 | SPY | ETF | 126.87 | 126.9 | 126.81 | 126.87 | 384100.0 |
| 2005-12-02 11:25:00 | SPY | ETF | 126.85 | 126.93 | 126.85 | 126.88 | 553500.0 |
> showing 50 of 8,383 rows — these rows as CSV