PREVIEW / etf_5min / 2004-07-02
file: by_date/etf_5min/2004/2004-07-02.parquet size: 78 KB rows: 4,213
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-07-02 08:00:00 | SPY | ETF | 112.97 | 112.97 | 112.97 | 112.97 | 900.0 |
| 2004-07-02 08:05:00 | SPY | ETF | 113.0 | 113.0 | 112.93 | 112.93 | 9300.0 |
| 2004-07-02 08:10:00 | SPY | ETF | 112.95 | 112.95 | 112.95 | 112.95 | 900.0 |
| 2004-07-02 08:20:00 | SPY | ETF | 113.0 | 113.06 | 113.0 | 113.06 | 20900.0 |
| 2004-07-02 08:25:00 | SPY | ETF | 113.05 | 113.05 | 112.84 | 112.84 | 35800.0 |
| 2004-07-02 08:30:00 | SPY | ETF | 112.85 | 112.88 | 112.62 | 112.88 | 129100.0 |
| 2004-07-02 08:35:00 | SPY | ETF | 112.89 | 113.02 | 112.82 | 112.82 | 48700.0 |
| 2004-07-02 08:40:00 | SPY | ETF | 112.82 | 112.88 | 112.82 | 112.88 | 18900.0 |
| 2004-07-02 08:45:00 | SPY | ETF | 112.82 | 112.92 | 112.81 | 112.89 | 53300.0 |
| 2004-07-02 08:50:00 | SPY | ETF | 112.88 | 113.03 | 112.88 | 113.03 | 13000.0 |
| 2004-07-02 08:55:00 | SPY | ETF | 113.03 | 113.03 | 112.96 | 113.0 | 15500.0 |
| 2004-07-02 09:00:00 | SPY | ETF | 112.96 | 112.96 | 112.96 | 112.96 | 2500.0 |
| 2004-07-02 09:05:00 | SPY | ETF | 112.97 | 112.98 | 112.96 | 112.98 | 28800.0 |
| 2004-07-02 09:10:00 | SPY | ETF | 112.97 | 112.99 | 112.95 | 112.95 | 3900.0 |
| 2004-07-02 09:15:00 | SPY | ETF | 112.97 | 112.98 | 112.95 | 112.96 | 26400.0 |
| 2004-07-02 09:20:00 | SPY | ETF | 112.97 | 113.0 | 112.97 | 112.99 | 12100.0 |
| 2004-07-02 09:25:00 | SPY | ETF | 112.99 | 113.16 | 112.99 | 113.1 | 16800.0 |
| 2004-07-02 09:30:00 | SPY | ETF | 113.16 | 113.21 | 113.01 | 113.03 | 1776200.0 |
| 2004-07-02 09:35:00 | SPY | ETF | 113.04 | 113.07 | 112.95 | 113.0 | 1167900.0 |
| 2004-07-02 09:40:00 | SPY | ETF | 113.0 | 113.02 | 112.8 | 112.88 | 686800.0 |
| 2004-07-02 09:45:00 | SPY | ETF | 112.89 | 112.96 | 112.61 | 112.66 | 973500.0 |
| 2004-07-02 09:50:00 | SPY | ETF | 112.66 | 112.76 | 112.62 | 112.68 | 981500.0 |
| 2004-07-02 09:55:00 | SPY | ETF | 112.67 | 112.84 | 112.66 | 112.8 | 364200.0 |
| 2004-07-02 10:00:00 | SPY | ETF | 112.82 | 112.84 | 112.6 | 112.79 | 1124200.0 |
| 2004-07-02 10:05:00 | SPY | ETF | 112.8 | 112.91 | 112.74 | 112.87 | 354900.0 |
| 2004-07-02 10:10:00 | SPY | ETF | 112.92 | 113.14 | 112.85 | 113.04 | 702300.0 |
| 2004-07-02 10:15:00 | SPY | ETF | 113.05 | 113.06 | 112.95 | 112.98 | 570800.0 |
| 2004-07-02 10:20:00 | SPY | ETF | 112.99 | 112.99 | 112.84 | 112.94 | 242400.0 |
| 2004-07-02 10:25:00 | SPY | ETF | 112.94 | 113.21 | 112.93 | 113.2 | 816700.0 |
| 2004-07-02 10:30:00 | SPY | ETF | 113.2 | 113.27 | 113.09 | 113.2 | 1502400.0 |
| 2004-07-02 10:35:00 | SPY | ETF | 113.21 | 113.24 | 113.14 | 113.18 | 1043700.0 |
| 2004-07-02 10:40:00 | SPY | ETF | 113.18 | 113.29 | 113.1 | 113.18 | 608400.0 |
| 2004-07-02 10:45:00 | SPY | ETF | 113.18 | 113.2 | 113.12 | 113.14 | 529000.0 |
| 2004-07-02 10:50:00 | SPY | ETF | 113.15 | 113.19 | 113.09 | 113.13 | 285900.0 |
| 2004-07-02 10:55:00 | SPY | ETF | 113.13 | 113.13 | 113.04 | 113.11 | 222700.0 |
| 2004-07-02 11:00:00 | SPY | ETF | 113.1 | 113.14 | 113.07 | 113.09 | 325300.0 |
| 2004-07-02 11:05:00 | SPY | ETF | 113.1 | 113.12 | 113.03 | 113.06 | 197700.0 |
| 2004-07-02 11:10:00 | SPY | ETF | 113.06 | 113.15 | 113.05 | 113.08 | 172000.0 |
| 2004-07-02 11:15:00 | SPY | ETF | 113.08 | 113.08 | 112.94 | 112.97 | 379800.0 |
| 2004-07-02 11:20:00 | SPY | ETF | 112.97 | 113.02 | 112.94 | 112.99 | 152800.0 |
| 2004-07-02 11:25:00 | SPY | ETF | 112.99 | 113.06 | 112.98 | 113.0 | 462400.0 |
| 2004-07-02 11:30:00 | SPY | ETF | 113.0 | 113.02 | 112.86 | 112.94 | 927100.0 |
| 2004-07-02 11:35:00 | SPY | ETF | 112.93 | 113.08 | 112.93 | 113.02 | 846400.0 |
| 2004-07-02 11:40:00 | SPY | ETF | 113.02 | 113.04 | 112.97 | 113.01 | 158100.0 |
| 2004-07-02 11:45:00 | SPY | ETF | 113.0 | 113.05 | 112.93 | 112.97 | 112300.0 |
| 2004-07-02 11:50:00 | SPY | ETF | 112.98 | 113.02 | 112.95 | 113.02 | 349100.0 |
| 2004-07-02 11:55:00 | SPY | ETF | 113.02 | 113.08 | 112.97 | 112.97 | 142800.0 |
| 2004-07-02 12:00:00 | SPY | ETF | 112.98 | 113.04 | 112.96 | 113.02 | 107700.0 |
| 2004-07-02 12:05:00 | SPY | ETF | 113.02 | 113.17 | 112.92 | 112.99 | 383900.0 |
| 2004-07-02 12:10:00 | SPY | ETF | 112.99 | 112.99 | 112.9 | 112.92 | 168500.0 |
> showing 50 of 4,213 rows — these rows as CSV