PREVIEW / etf_30min / 2004-02-26
file: by_date/etf_30min/2004/2004-02-26.parquet size: 34 KB rows: 1,152
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-02-26 08:00:00 | SPY | ETF | 114.9 | 114.98 | 114.9 | 114.98 | 9800.0 |
| 2004-02-26 08:30:00 | SPY | ETF | 114.94 | 114.94 | 114.64 | 114.68 | 119800.0 |
| 2004-02-26 09:00:00 | SPY | ETF | 114.69 | 114.72 | 114.63 | 114.63 | 15100.0 |
| 2004-02-26 09:30:00 | SPY | ETF | 114.61 | 114.79 | 114.42 | 114.56 | 2693000.0 |
| 2004-02-26 10:00:00 | SPY | ETF | 114.55 | 114.69 | 114.34 | 114.6 | 3373700.0 |
| 2004-02-26 10:30:00 | SPY | ETF | 114.57 | 114.69 | 114.43 | 114.65 | 1418400.0 |
| 2004-02-26 11:00:00 | SPY | ETF | 114.62 | 115.01 | 114.62 | 114.84 | 2658400.0 |
| 2004-02-26 11:30:00 | SPY | ETF | 114.84 | 115.02 | 114.81 | 114.91 | 2022300.0 |
| 2004-02-26 12:00:00 | SPY | ETF | 114.93 | 115.03 | 114.86 | 114.98 | 1105900.0 |
| 2004-02-26 12:30:00 | SPY | ETF | 114.98 | 115.29 | 114.97 | 115.21 | 2655000.0 |
| 2004-02-26 13:00:00 | SPY | ETF | 115.23 | 115.23 | 115.0 | 115.05 | 1289500.0 |
| 2004-02-26 13:30:00 | SPY | ETF | 115.05 | 115.14 | 115.02 | 115.12 | 670700.0 |
| 2004-02-26 14:00:00 | SPY | ETF | 115.13 | 115.19 | 114.91 | 114.99 | 1637700.0 |
| 2004-02-26 14:30:00 | SPY | ETF | 115.0 | 115.09 | 114.88 | 115.04 | 1517900.0 |
| 2004-02-26 15:00:00 | SPY | ETF | 115.04 | 115.17 | 114.95 | 115.13 | 907800.0 |
| 2004-02-26 15:30:00 | SPY | ETF | 115.14 | 115.26 | 115.03 | 115.04 | 2158200.0 |
| 2004-02-26 16:00:00 | SPY | ETF | 115.02 | 115.11 | 114.9 | 114.94 | 1324400.0 |
| 2004-02-26 16:30:00 | SPY | ETF | 114.94 | 115.0 | 114.92 | 114.98 | 128400.0 |
| 2004-02-26 17:00:00 | SPY | ETF | 114.96 | 114.97 | 114.96 | 114.97 | 900.0 |
| 2004-02-26 17:30:00 | SPY | ETF | 114.99 | 114.99 | 114.97 | 114.97 | 300.0 |
| 2004-02-26 18:00:00 | SPY | ETF | 114.96 | 114.96 | 114.94 | 114.94 | 1600.0 |
| 2004-02-26 19:30:00 | SPY | ETF | 114.97 | 114.99 | 114.97 | 114.99 | 200.0 |
| 2004-02-26 08:00:00 | QQQ | ETF | 36.61 | 36.62 | 36.59 | 36.61 | 29300.0 |
| 2004-02-26 08:30:00 | QQQ | ETF | 36.61 | 36.62 | 36.49 | 36.51 | 129700.0 |
| 2004-02-26 09:00:00 | QQQ | ETF | 36.51 | 36.54 | 36.48 | 36.48 | 75800.0 |
| 2004-02-26 09:30:00 | QQQ | ETF | 36.47 | 36.54 | 36.34 | 36.44 | 9183900.0 |
| 2004-02-26 10:00:00 | QQQ | ETF | 36.441 | 36.522 | 36.305 | 36.47 | 7834400.0 |
| 2004-02-26 10:30:00 | QQQ | ETF | 36.47 | 36.53 | 36.4 | 36.497 | 5009300.0 |
| 2004-02-26 11:00:00 | QQQ | ETF | 36.49 | 36.65 | 36.49 | 36.585 | 6470100.0 |
| 2004-02-26 11:30:00 | QQQ | ETF | 36.583 | 36.71 | 36.57 | 36.65 | 5914100.0 |
| 2004-02-26 12:00:00 | QQQ | ETF | 36.65 | 36.7 | 36.6112 | 36.68 | 3560300.0 |
| 2004-02-26 12:30:00 | QQQ | ETF | 36.68 | 36.84 | 36.67 | 36.78 | 6700500.0 |
| 2004-02-26 13:00:00 | QQQ | ETF | 36.782 | 36.79 | 36.675 | 36.69 | 4200200.0 |
| 2004-02-26 13:30:00 | QQQ | ETF | 36.69 | 36.75 | 36.66 | 36.73 | 2189000.0 |
| 2004-02-26 14:00:00 | QQQ | ETF | 36.74 | 36.79 | 36.58 | 36.64 | 3597600.0 |
| 2004-02-26 14:30:00 | QQQ | ETF | 36.64 | 36.69 | 36.57 | 36.64 | 3234300.0 |
| 2004-02-26 15:00:00 | QQQ | ETF | 36.645 | 36.726 | 36.6 | 36.71 | 3188600.0 |
| 2004-02-26 15:30:00 | QQQ | ETF | 36.71 | 36.765 | 36.7 | 36.7 | 5112600.0 |
| 2004-02-26 16:00:00 | QQQ | ETF | 36.73 | 36.73 | 36.65 | 36.7 | 1513600.0 |
| 2004-02-26 16:30:00 | QQQ | ETF | 36.7 | 36.71 | 36.65 | 36.69 | 1225400.0 |
| 2004-02-26 17:00:00 | QQQ | ETF | 36.69 | 36.71 | 36.671 | 36.7 | 138500.0 |
| 2004-02-26 17:30:00 | QQQ | ETF | 36.7 | 36.73 | 36.7 | 36.72 | 43500.0 |
| 2004-02-26 18:00:00 | QQQ | ETF | 36.72 | 36.73 | 36.697 | 36.71 | 103200.0 |
| 2004-02-26 18:30:00 | QQQ | ETF | 36.71 | 36.71 | 36.71 | 36.71 | 800.0 |
| 2004-02-26 19:00:00 | QQQ | ETF | 36.7 | 36.73 | 36.7 | 36.73 | 28200.0 |
| 2004-02-26 19:30:00 | QQQ | ETF | 36.7 | 36.7 | 36.7 | 36.7 | 2500.0 |
| 2004-02-26 09:30:00 | IWM | ETF | 57.59 | 57.725 | 57.4 | 57.55 | 1108800.0 |
| 2004-02-26 10:00:00 | IWM | ETF | 57.55 | 57.725 | 57.429 | 57.685 | 774800.0 |
| 2004-02-26 10:30:00 | IWM | ETF | 57.72 | 57.795 | 57.61 | 57.755 | 316600.0 |
| 2004-02-26 11:00:00 | IWM | ETF | 57.795 | 58.01 | 57.79 | 57.945 | 1132000.0 |
> showing 50 of 1,152 rows — these rows as CSV