PREVIEW / etf_30min / 2004-07-26
file: by_date/etf_30min/2004/2004-07-26.parquet size: 37 KB rows: 1,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-26 08:00:00 | SPY | ETF | 109.25 | 109.3 | 109.25 | 109.25 | 43000.0 |
| 2004-07-26 08:30:00 | SPY | ETF | 109.27 | 109.27 | 109.2 | 109.25 | 21000.0 |
| 2004-07-26 09:00:00 | SPY | ETF | 109.22 | 109.27 | 109.17 | 109.17 | 12400.0 |
| 2004-07-26 09:30:00 | SPY | ETF | 109.19 | 109.43 | 109.08 | 109.26 | 4092200.0 |
| 2004-07-26 10:00:00 | SPY | ETF | 109.26 | 109.39 | 108.85 | 109.12 | 4485600.0 |
| 2004-07-26 10:30:00 | SPY | ETF | 109.05 | 109.24 | 108.81 | 108.86 | 2676200.0 |
| 2004-07-26 11:00:00 | SPY | ETF | 108.86 | 108.93 | 108.32 | 108.53 | 5137100.0 |
| 2004-07-26 11:30:00 | SPY | ETF | 108.54 | 108.85 | 108.36 | 108.74 | 3623300.0 |
| 2004-07-26 12:00:00 | SPY | ETF | 108.73 | 108.92 | 108.61 | 108.67 | 2142200.0 |
| 2004-07-26 12:30:00 | SPY | ETF | 108.68 | 108.76 | 108.34 | 108.47 | 2544400.0 |
| 2004-07-26 13:00:00 | SPY | ETF | 108.48 | 108.85 | 108.36 | 108.76 | 2840600.0 |
| 2004-07-26 13:30:00 | SPY | ETF | 108.76 | 108.87 | 108.43 | 108.48 | 2717700.0 |
| 2004-07-26 14:00:00 | SPY | ETF | 108.49 | 108.78 | 108.28 | 108.7 | 3457900.0 |
| 2004-07-26 14:30:00 | SPY | ETF | 108.7 | 108.73 | 108.21 | 108.35 | 2643000.0 |
| 2004-07-26 15:00:00 | SPY | ETF | 108.35 | 108.65 | 108.24 | 108.57 | 3043200.0 |
| 2004-07-26 15:30:00 | SPY | ETF | 108.59 | 108.96 | 108.52 | 108.85 | 5526700.0 |
| 2004-07-26 16:00:00 | SPY | ETF | 108.85 | 108.85 | 108.68 | 108.77 | 1237300.0 |
| 2004-07-26 16:30:00 | SPY | ETF | 108.78 | 108.94 | 108.78 | 108.93 | 115100.0 |
| 2004-07-26 17:00:00 | SPY | ETF | 108.88 | 108.91 | 108.86 | 108.86 | 10500.0 |
| 2004-07-26 18:00:00 | SPY | ETF | 108.85 | 108.9 | 108.85 | 108.9 | 8300.0 |
| 2004-07-26 18:30:00 | SPY | ETF | 108.88 | 108.88 | 108.88 | 108.88 | 1600.0 |
| 2004-07-26 19:00:00 | SPY | ETF | 108.88 | 108.88 | 108.82 | 108.87 | 1500.0 |
| 2004-07-26 19:30:00 | SPY | ETF | 108.87 | 108.9 | 108.87 | 108.9 | 500.0 |
| 2004-07-26 08:00:00 | QQQ | ETF | 34.36 | 34.38 | 34.33 | 34.33 | 39200.0 |
| 2004-07-26 08:30:00 | QQQ | ETF | 34.33 | 34.35 | 34.28 | 34.3 | 106500.0 |
| 2004-07-26 09:00:00 | QQQ | ETF | 34.3 | 34.33 | 34.23 | 34.24 | 113100.0 |
| 2004-07-26 09:30:00 | QQQ | ETF | 34.24 | 34.41 | 34.2 | 34.32 | 12342000.0 |
| 2004-07-26 10:00:00 | QQQ | ETF | 34.32 | 34.41 | 34.07 | 34.17 | 9746500.0 |
| 2004-07-26 10:30:00 | QQQ | ETF | 34.18 | 34.32 | 34.07 | 34.09 | 6988000.0 |
| 2004-07-26 11:00:00 | QQQ | ETF | 34.09 | 34.13 | 33.825 | 33.91 | 15771800.0 |
| 2004-07-26 11:30:00 | QQQ | ETF | 33.91 | 34.02 | 33.78 | 33.98 | 9414600.0 |
| 2004-07-26 12:00:00 | QQQ | ETF | 33.99 | 34.08 | 33.9 | 33.94 | 6115200.0 |
| 2004-07-26 12:30:00 | QQQ | ETF | 33.95 | 33.98 | 33.808 | 33.86 | 6075500.0 |
| 2004-07-26 13:00:00 | QQQ | ETF | 33.86 | 34.01 | 33.77 | 33.969 | 6477300.0 |
| 2004-07-26 13:30:00 | QQQ | ETF | 33.97 | 34.02 | 33.849 | 33.864 | 5038900.0 |
| 2004-07-26 14:00:00 | QQQ | ETF | 33.86 | 34.01 | 33.77 | 33.972 | 7068300.0 |
| 2004-07-26 14:30:00 | QQQ | ETF | 33.98 | 33.99 | 33.78 | 33.83 | 5391400.0 |
| 2004-07-26 15:00:00 | QQQ | ETF | 33.83 | 33.943 | 33.8 | 33.92 | 6622500.0 |
| 2004-07-26 15:30:00 | QQQ | ETF | 33.92 | 34.08 | 33.89 | 34.06 | 11668900.0 |
| 2004-07-26 16:00:00 | QQQ | ETF | 34.06 | 34.08 | 34.02 | 34.06 | 3038200.0 |
| 2004-07-26 16:30:00 | QQQ | ETF | 34.066 | 34.13 | 34.06 | 34.093 | 599100.0 |
| 2004-07-26 17:00:00 | QQQ | ETF | 34.09 | 34.09 | 34.08 | 34.08 | 20800.0 |
| 2004-07-26 17:30:00 | QQQ | ETF | 34.08 | 34.09 | 34.06 | 34.08 | 19000.0 |
| 2004-07-26 18:00:00 | QQQ | ETF | 34.07 | 34.11 | 34.07 | 34.11 | 61300.0 |
| 2004-07-26 18:30:00 | QQQ | ETF | 34.11 | 34.12 | 34.11 | 34.12 | 4800.0 |
| 2004-07-26 19:00:00 | QQQ | ETF | 34.11 | 34.11 | 34.11 | 34.11 | 5800.0 |
| 2004-07-26 19:30:00 | QQQ | ETF | 34.11 | 34.11 | 34.07 | 34.07 | 1800.0 |
| 2004-07-26 09:00:00 | IWM | ETF | 53.89 | 53.935 | 53.89 | 53.935 | 5000.0 |
| 2004-07-26 09:30:00 | IWM | ETF | 53.94 | 54.12 | 53.855 | 53.965 | 1297800.0 |
| 2004-07-26 10:00:00 | IWM | ETF | 53.96 | 54.065 | 53.5 | 53.605 | 1091600.0 |
> showing 50 of 1,213 rows — these rows as CSV