PREVIEW / etf_30min / 2004-08-09
file: by_date/etf_30min/2004/2004-08-09.parquet size: 34 KB rows: 1,165
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-08-09 08:00:00 | SPY | ETF | 107.16 | 107.19 | 106.99 | 107.06 | 157200.0 |
| 2004-08-09 08:30:00 | SPY | ETF | 107.05 | 107.14 | 107.01 | 107.14 | 81800.0 |
| 2004-08-09 09:00:00 | SPY | ETF | 107.1 | 107.13 | 106.97 | 106.98 | 177200.0 |
| 2004-08-09 09:30:00 | SPY | ETF | 107.02 | 107.29 | 106.98 | 107.07 | 6248200.0 |
| 2004-08-09 10:00:00 | SPY | ETF | 107.11 | 107.3 | 106.87 | 107.1 | 4675600.0 |
| 2004-08-09 10:30:00 | SPY | ETF | 107.13 | 107.37 | 107.08 | 107.37 | 3126200.0 |
| 2004-08-09 11:00:00 | SPY | ETF | 107.36 | 107.38 | 107.17 | 107.34 | 2126800.0 |
| 2004-08-09 11:30:00 | SPY | ETF | 107.32 | 107.37 | 107.19 | 107.2 | 1494900.0 |
| 2004-08-09 12:00:00 | SPY | ETF | 107.2 | 107.25 | 107.04 | 107.16 | 2733100.0 |
| 2004-08-09 12:30:00 | SPY | ETF | 107.19 | 107.2 | 107.06 | 107.1 | 1498500.0 |
| 2004-08-09 13:00:00 | SPY | ETF | 107.12 | 107.27 | 107.09 | 107.21 | 1262800.0 |
| 2004-08-09 13:30:00 | SPY | ETF | 107.2 | 107.27 | 107.11 | 107.17 | 1086700.0 |
| 2004-08-09 14:00:00 | SPY | ETF | 107.18 | 107.47 | 107.07 | 107.45 | 3118800.0 |
| 2004-08-09 14:30:00 | SPY | ETF | 107.45 | 107.48 | 107.2 | 107.28 | 2117100.0 |
| 2004-08-09 15:00:00 | SPY | ETF | 107.27 | 107.39 | 107.18 | 107.28 | 1679700.0 |
| 2004-08-09 15:30:00 | SPY | ETF | 107.28 | 107.32 | 106.99 | 107.01 | 2665700.0 |
| 2004-08-09 16:00:00 | SPY | ETF | 107.01 | 107.04 | 106.924 | 107.0 | 1150700.0 |
| 2004-08-09 16:30:00 | SPY | ETF | 107.01 | 107.03 | 106.94 | 106.97 | 326700.0 |
| 2004-08-09 17:00:00 | SPY | ETF | 107.01 | 107.04 | 106.97 | 107.04 | 3200.0 |
| 2004-08-09 17:30:00 | SPY | ETF | 107.04 | 107.04 | 107.0 | 107.0 | 1600.0 |
| 2004-08-09 18:00:00 | SPY | ETF | 107.05 | 107.12 | 107.05 | 107.12 | 900.0 |
| 2004-08-09 08:00:00 | QQQ | ETF | 32.83 | 32.88 | 32.82 | 32.85 | 103800.0 |
| 2004-08-09 08:30:00 | QQQ | ETF | 32.85 | 32.87 | 32.83 | 32.87 | 37300.0 |
| 2004-08-09 09:00:00 | QQQ | ETF | 32.86 | 32.87 | 32.81 | 32.81 | 288600.0 |
| 2004-08-09 09:30:00 | QQQ | ETF | 32.81 | 32.94 | 32.78 | 32.78 | 11478600.0 |
| 2004-08-09 10:00:00 | QQQ | ETF | 32.785 | 32.929 | 32.67 | 32.84 | 11181500.0 |
| 2004-08-09 10:30:00 | QQQ | ETF | 32.839 | 32.93 | 32.77 | 32.93 | 7685100.0 |
| 2004-08-09 11:00:00 | QQQ | ETF | 32.93 | 32.93 | 32.85 | 32.93 | 4578800.0 |
| 2004-08-09 11:30:00 | QQQ | ETF | 32.93 | 32.938 | 32.82 | 32.86 | 3152600.0 |
| 2004-08-09 12:00:00 | QQQ | ETF | 32.86 | 32.87 | 32.77 | 32.83 | 5615000.0 |
| 2004-08-09 12:30:00 | QQQ | ETF | 32.837 | 32.85 | 32.77 | 32.8 | 3332400.0 |
| 2004-08-09 13:00:00 | QQQ | ETF | 32.8 | 32.88 | 32.78 | 32.836 | 3381900.0 |
| 2004-08-09 13:30:00 | QQQ | ETF | 32.84 | 32.92 | 32.82 | 32.874 | 2942300.0 |
| 2004-08-09 14:00:00 | QQQ | ETF | 32.874 | 32.94 | 32.79 | 32.94 | 3921400.0 |
| 2004-08-09 14:30:00 | QQQ | ETF | 32.93 | 32.96 | 32.86 | 32.911 | 4976700.0 |
| 2004-08-09 15:00:00 | QQQ | ETF | 32.91 | 32.93 | 32.84 | 32.895 | 4267200.0 |
| 2004-08-09 15:30:00 | QQQ | ETF | 32.891 | 32.92 | 32.75 | 32.8 | 6745200.0 |
| 2004-08-09 16:00:00 | QQQ | ETF | 32.79 | 32.85 | 32.78 | 32.81 | 1502900.0 |
| 2004-08-09 16:30:00 | QQQ | ETF | 32.816 | 32.83 | 32.801 | 32.82 | 309800.0 |
| 2004-08-09 17:00:00 | QQQ | ETF | 32.821 | 32.85 | 32.82 | 32.85 | 334400.0 |
| 2004-08-09 17:30:00 | QQQ | ETF | 32.858 | 32.86 | 32.82 | 32.849 | 696200.0 |
| 2004-08-09 18:00:00 | QQQ | ETF | 32.848 | 32.86 | 32.848 | 32.85 | 31900.0 |
| 2004-08-09 18:30:00 | QQQ | ETF | 32.85 | 32.86 | 32.83 | 32.84 | 2600.0 |
| 2004-08-09 19:00:00 | QQQ | ETF | 32.84 | 32.84 | 32.84 | 32.84 | 600.0 |
| 2004-08-09 19:30:00 | QQQ | ETF | 32.84 | 32.84 | 32.84 | 32.84 | 300.0 |
| 2004-08-09 08:30:00 | IWM | ETF | 51.985 | 51.985 | 51.985 | 51.985 | 200.0 |
| 2004-08-09 09:00:00 | IWM | ETF | 51.995 | 51.995 | 51.995 | 51.995 | 2000.0 |
| 2004-08-09 09:30:00 | IWM | ETF | 51.95 | 52.055 | 51.885 | 51.94 | 1782000.0 |
| 2004-08-09 10:00:00 | IWM | ETF | 51.945 | 51.97 | 51.665 | 51.91 | 1539000.0 |
| 2004-08-09 10:30:00 | IWM | ETF | 51.91 | 52.12 | 51.815 | 51.98 | 824800.0 |
> showing 50 of 1,165 rows — these rows as CSV