PREVIEW / etf_30min / 2004-05-26
file: by_date/etf_30min/2004/2004-05-26.parquet size: 34 KB rows: 1,166
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-05-26 08:00:00 | SPY | ETF | 111.76 | 111.76 | 111.7 | 111.76 | 13700.0 |
| 2004-05-26 08:30:00 | SPY | ETF | 111.76 | 111.78 | 111.61 | 111.67 | 58100.0 |
| 2004-05-26 09:00:00 | SPY | ETF | 111.69 | 111.72 | 111.68 | 111.68 | 46600.0 |
| 2004-05-26 09:30:00 | SPY | ETF | 111.66 | 111.95 | 111.62 | 111.84 | 4772000.0 |
| 2004-05-26 10:00:00 | SPY | ETF | 111.85 | 111.85 | 111.57 | 111.67 | 2966500.0 |
| 2004-05-26 10:30:00 | SPY | ETF | 111.68 | 111.97 | 111.51 | 111.87 | 4171100.0 |
| 2004-05-26 11:00:00 | SPY | ETF | 111.88 | 111.95 | 111.73 | 111.76 | 1361700.0 |
| 2004-05-26 11:30:00 | SPY | ETF | 111.76 | 112.03 | 111.64 | 111.95 | 2633100.0 |
| 2004-05-26 12:00:00 | SPY | ETF | 111.95 | 112.09 | 111.84 | 112.0 | 1489700.0 |
| 2004-05-26 12:30:00 | SPY | ETF | 112.0 | 112.1 | 111.94 | 111.97 | 1170000.0 |
| 2004-05-26 13:00:00 | SPY | ETF | 111.97 | 112.06 | 111.85 | 111.99 | 750600.0 |
| 2004-05-26 13:30:00 | SPY | ETF | 111.99 | 112.22 | 111.89 | 111.98 | 2587900.0 |
| 2004-05-26 14:00:00 | SPY | ETF | 111.98 | 112.08 | 111.78 | 112.01 | 2613500.0 |
| 2004-05-26 14:30:00 | SPY | ETF | 112.01 | 112.29 | 111.98 | 112.07 | 2866200.0 |
| 2004-05-26 15:00:00 | SPY | ETF | 112.09 | 112.21 | 111.771 | 111.771 | 2345300.0 |
| 2004-05-26 15:30:00 | SPY | ETF | 111.8 | 112.17 | 111.78 | 112.09 | 2383500.0 |
| 2004-05-26 16:00:00 | SPY | ETF | 112.09 | 112.24 | 111.8 | 111.8 | 1178300.0 |
| 2004-05-26 16:30:00 | SPY | ETF | 112.2 | 112.22 | 112.16 | 112.16 | 82000.0 |
| 2004-05-26 17:00:00 | SPY | ETF | 112.19 | 112.25 | 112.19 | 112.25 | 20600.0 |
| 2004-05-26 17:30:00 | SPY | ETF | 112.22 | 112.22 | 112.2 | 112.2 | 2700.0 |
| 2004-05-26 18:00:00 | SPY | ETF | 112.22 | 112.22 | 112.16 | 112.2 | 3000.0 |
| 2004-05-26 08:00:00 | QQQ | ETF | 35.89 | 35.9 | 35.88 | 35.9 | 31500.0 |
| 2004-05-26 08:30:00 | QQQ | ETF | 35.89 | 35.89 | 35.83 | 35.86 | 106500.0 |
| 2004-05-26 09:00:00 | QQQ | ETF | 35.87 | 35.89 | 35.84 | 35.87 | 288000.0 |
| 2004-05-26 09:30:00 | QQQ | ETF | 35.86 | 36.03 | 35.84 | 35.98 | 13795600.0 |
| 2004-05-26 10:00:00 | QQQ | ETF | 35.984 | 36.0 | 35.85 | 35.91 | 7931000.0 |
| 2004-05-26 10:30:00 | QQQ | ETF | 35.9 | 36.05 | 35.81 | 36.03 | 10131200.0 |
| 2004-05-26 11:00:00 | QQQ | ETF | 36.03 | 36.05 | 35.93 | 35.95 | 4033800.0 |
| 2004-05-26 11:30:00 | QQQ | ETF | 35.95 | 36.11 | 35.91 | 36.07 | 5102300.0 |
| 2004-05-26 12:00:00 | QQQ | ETF | 36.05 | 36.14 | 36.0 | 36.117 | 4531600.0 |
| 2004-05-26 12:30:00 | QQQ | ETF | 36.114 | 36.15 | 36.05 | 36.07 | 4313900.0 |
| 2004-05-26 13:00:00 | QQQ | ETF | 36.072 | 36.09 | 35.99 | 36.05 | 2560800.0 |
| 2004-05-26 13:30:00 | QQQ | ETF | 36.05 | 36.14 | 36.03 | 36.061 | 4322600.0 |
| 2004-05-26 14:00:00 | QQQ | ETF | 36.05 | 36.11 | 35.96 | 36.06 | 5389300.0 |
| 2004-05-26 14:30:00 | QQQ | ETF | 36.054 | 36.19 | 36.05 | 36.11 | 7333100.0 |
| 2004-05-26 15:00:00 | QQQ | ETF | 36.113 | 36.15 | 35.96 | 35.96 | 6594500.0 |
| 2004-05-26 15:30:00 | QQQ | ETF | 35.98 | 36.146 | 35.95 | 36.146 | 10645300.0 |
| 2004-05-26 16:00:00 | QQQ | ETF | 36.13 | 36.24 | 36.11 | 36.18 | 2353700.0 |
| 2004-05-26 16:30:00 | QQQ | ETF | 36.18 | 36.21 | 36.15 | 36.18 | 167700.0 |
| 2004-05-26 17:00:00 | QQQ | ETF | 36.179 | 36.23 | 36.179 | 36.19 | 112500.0 |
| 2004-05-26 17:30:00 | QQQ | ETF | 36.2 | 36.23 | 36.2 | 36.21 | 21500.0 |
| 2004-05-26 18:00:00 | QQQ | ETF | 36.21 | 36.23 | 36.19 | 36.19 | 20000.0 |
| 2004-05-26 18:30:00 | QQQ | ETF | 36.19 | 36.2 | 36.19 | 36.2 | 11900.0 |
| 2004-05-26 19:00:00 | QQQ | ETF | 36.21 | 36.22 | 36.2 | 36.22 | 2300.0 |
| 2004-05-26 19:30:00 | QQQ | ETF | 36.22 | 36.23 | 36.2 | 36.23 | 5600.0 |
| 2004-05-26 08:00:00 | IWM | ETF | 56.19 | 56.19 | 56.19 | 56.19 | 200.0 |
| 2004-05-26 09:00:00 | IWM | ETF | 56.21 | 56.225 | 56.21 | 56.225 | 2600.0 |
| 2004-05-26 09:30:00 | IWM | ETF | 56.22 | 56.515 | 56.17 | 56.445 | 1231200.0 |
| 2004-05-26 10:00:00 | IWM | ETF | 56.45 | 56.45 | 56.22 | 56.245 | 787800.0 |
| 2004-05-26 10:30:00 | IWM | ETF | 56.25 | 56.37 | 56.03 | 56.37 | 1328800.0 |
> showing 50 of 1,166 rows — these rows as CSV