PREVIEW / etf_30min / 2004-07-09
file: by_date/etf_30min/2004/2004-07-09.parquet size: 33 KB rows: 1,139
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-09 08:00:00 | SPY | ETF | 111.78 | 111.8 | 111.72 | 111.8 | 9800.0 |
| 2004-07-09 08:30:00 | SPY | ETF | 111.8 | 111.8 | 111.72 | 111.78 | 10400.0 |
| 2004-07-09 09:00:00 | SPY | ETF | 111.78 | 111.8 | 111.68 | 111.68 | 22900.0 |
| 2004-07-09 09:30:00 | SPY | ETF | 111.71 | 111.94 | 111.65 | 111.72 | 5358400.0 |
| 2004-07-09 10:00:00 | SPY | ETF | 111.72 | 111.87 | 111.58 | 111.69 | 3503700.0 |
| 2004-07-09 10:30:00 | SPY | ETF | 111.71 | 111.76 | 111.48 | 111.54 | 2620900.0 |
| 2004-07-09 11:00:00 | SPY | ETF | 111.54 | 111.78 | 111.53 | 111.78 | 1448200.0 |
| 2004-07-09 11:30:00 | SPY | ETF | 111.78 | 111.82 | 111.48 | 111.68 | 1578100.0 |
| 2004-07-09 12:00:00 | SPY | ETF | 111.67 | 111.69 | 111.47 | 111.49 | 2645700.0 |
| 2004-07-09 12:30:00 | SPY | ETF | 111.5 | 111.66 | 111.39 | 111.59 | 1350600.0 |
| 2004-07-09 13:00:00 | SPY | ETF | 111.59 | 111.73 | 111.54 | 111.64 | 632900.0 |
| 2004-07-09 13:30:00 | SPY | ETF | 111.65 | 111.7 | 111.51 | 111.64 | 482000.0 |
| 2004-07-09 14:00:00 | SPY | ETF | 111.64 | 111.68 | 111.45 | 111.65 | 851000.0 |
| 2004-07-09 14:30:00 | SPY | ETF | 111.64 | 111.65 | 111.46 | 111.51 | 867600.0 |
| 2004-07-09 15:00:00 | SPY | ETF | 111.5 | 111.75 | 111.38 | 111.64 | 1553500.0 |
| 2004-07-09 15:30:00 | SPY | ETF | 111.64 | 111.76 | 111.54 | 111.64 | 2042300.0 |
| 2004-07-09 16:00:00 | SPY | ETF | 111.61 | 111.83 | 111.55 | 111.77 | 924200.0 |
| 2004-07-09 16:30:00 | SPY | ETF | 111.77 | 111.84 | 111.73 | 111.8 | 34800.0 |
| 2004-07-09 17:00:00 | SPY | ETF | 111.8 | 111.8 | 111.8 | 111.8 | 9000.0 |
| 2004-07-09 17:30:00 | SPY | ETF | 111.82 | 111.82 | 111.71 | 111.71 | 55800.0 |
| 2004-07-09 18:30:00 | SPY | ETF | 111.75 | 111.78 | 111.75 | 111.78 | 700.0 |
| 2004-07-09 19:30:00 | SPY | ETF | 111.65 | 111.65 | 111.62 | 111.62 | 1000.0 |
| 2004-07-09 08:00:00 | QQQ | ETF | 35.84 | 35.88 | 35.83 | 35.86 | 33400.0 |
| 2004-07-09 08:30:00 | QQQ | ETF | 35.85 | 35.9 | 35.83 | 35.89 | 283400.0 |
| 2004-07-09 09:00:00 | QQQ | ETF | 35.88 | 35.91 | 35.85 | 35.85 | 130500.0 |
| 2004-07-09 09:30:00 | QQQ | ETF | 35.84 | 36.0 | 35.82 | 35.88 | 17432000.0 |
| 2004-07-09 10:00:00 | QQQ | ETF | 35.88 | 36.037 | 35.84 | 35.88 | 9863400.0 |
| 2004-07-09 10:30:00 | QQQ | ETF | 35.85 | 35.9 | 35.75 | 35.778 | 8807000.0 |
| 2004-07-09 11:00:00 | QQQ | ETF | 35.778 | 35.883 | 35.75 | 35.882 | 3970100.0 |
| 2004-07-09 11:30:00 | QQQ | ETF | 35.882 | 35.91 | 35.73 | 35.79 | 5431100.0 |
| 2004-07-09 12:00:00 | QQQ | ETF | 35.79 | 35.802 | 35.69 | 35.71 | 4348600.0 |
| 2004-07-09 12:30:00 | QQQ | ETF | 35.71 | 35.81 | 35.67 | 35.762 | 4861900.0 |
| 2004-07-09 13:00:00 | QQQ | ETF | 35.76 | 35.8 | 35.72 | 35.77 | 2307500.0 |
| 2004-07-09 13:30:00 | QQQ | ETF | 35.77 | 35.79 | 35.7 | 35.77 | 2639000.0 |
| 2004-07-09 14:00:00 | QQQ | ETF | 35.78 | 35.78 | 35.63 | 35.762 | 3746800.0 |
| 2004-07-09 14:30:00 | QQQ | ETF | 35.76 | 35.77 | 35.66 | 35.7 | 2653600.0 |
| 2004-07-09 15:00:00 | QQQ | ETF | 35.693 | 35.89 | 35.63 | 35.809 | 6867900.0 |
| 2004-07-09 15:30:00 | QQQ | ETF | 35.809 | 35.86 | 35.71 | 35.79 | 8470700.0 |
| 2004-07-09 16:00:00 | QQQ | ETF | 35.79 | 35.82 | 35.74 | 35.78 | 1895700.0 |
| 2004-07-09 16:30:00 | QQQ | ETF | 35.77 | 35.79 | 35.76 | 35.79 | 40800.0 |
| 2004-07-09 17:00:00 | QQQ | ETF | 35.761 | 35.79 | 35.761 | 35.79 | 7600.0 |
| 2004-07-09 17:30:00 | QQQ | ETF | 35.79 | 35.79 | 35.77 | 35.77 | 20000.0 |
| 2004-07-09 18:00:00 | QQQ | ETF | 35.77 | 35.8 | 35.76 | 35.761 | 12400.0 |
| 2004-07-09 18:30:00 | QQQ | ETF | 35.77 | 35.8 | 35.77 | 35.8 | 2900.0 |
| 2004-07-09 19:00:00 | QQQ | ETF | 35.78 | 35.78 | 35.77 | 35.77 | 2100.0 |
| 2004-07-09 19:30:00 | QQQ | ETF | 35.77 | 35.77 | 35.76 | 35.76 | 800.0 |
| 2004-07-09 08:00:00 | IWM | ETF | 56.1 | 56.1 | 56.1 | 56.1 | 1000.0 |
| 2004-07-09 08:30:00 | IWM | ETF | 56.17 | 56.17 | 56.1 | 56.14 | 2600.0 |
| 2004-07-09 09:00:00 | IWM | ETF | 56.15 | 56.15 | 56.15 | 56.15 | 400.0 |
| 2004-07-09 09:30:00 | IWM | ETF | 56.15 | 56.355 | 56.025 | 56.125 | 2226400.0 |
> showing 50 of 1,139 rows — these rows as CSV