PREVIEW / etf_30min / 2004-01-14
file: by_date/etf_30min/2004/2004-01-14.parquet size: 34 KB rows: 1,154
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-01-14 08:00:00 | SPY | ETF | 112.65 | 112.69 | 112.63 | 112.69 | 8500.0 |
| 2004-01-14 08:30:00 | SPY | ETF | 112.69 | 112.82 | 112.69 | 112.8 | 8800.0 |
| 2004-01-14 09:00:00 | SPY | ETF | 112.72 | 112.72 | 112.72 | 112.72 | 100.0 |
| 2004-01-14 09:30:00 | SPY | ETF | 112.79 | 112.88 | 112.67 | 112.84 | 3283400.0 |
| 2004-01-14 10:00:00 | SPY | ETF | 112.81 | 113.03 | 112.74 | 112.9 | 2105700.0 |
| 2004-01-14 10:30:00 | SPY | ETF | 112.93 | 113.0 | 112.86 | 112.93 | 1294300.0 |
| 2004-01-14 11:00:00 | SPY | ETF | 112.94 | 113.17 | 112.92 | 113.1 | 3850100.0 |
| 2004-01-14 11:30:00 | SPY | ETF | 113.1 | 113.11 | 112.95 | 112.95 | 1209300.0 |
| 2004-01-14 12:00:00 | SPY | ETF | 112.96 | 113.0 | 112.8 | 112.82 | 1597900.0 |
| 2004-01-14 12:30:00 | SPY | ETF | 112.81 | 112.86 | 112.71 | 112.77 | 980800.0 |
| 2004-01-14 13:00:00 | SPY | ETF | 112.79 | 112.9 | 112.68 | 112.87 | 936200.0 |
| 2004-01-14 13:30:00 | SPY | ETF | 112.86 | 113.0 | 112.86 | 112.86 | 809700.0 |
| 2004-01-14 14:00:00 | SPY | ETF | 112.88 | 113.14 | 112.85 | 113.09 | 1971100.0 |
| 2004-01-14 14:30:00 | SPY | ETF | 113.1 | 113.21 | 113.05 | 113.19 | 1581600.0 |
| 2004-01-14 15:00:00 | SPY | ETF | 113.18 | 113.39 | 113.13 | 113.33 | 3045100.0 |
| 2004-01-14 15:30:00 | SPY | ETF | 113.33 | 113.42 | 113.21 | 113.31 | 2125800.0 |
| 2004-01-14 16:00:00 | SPY | ETF | 113.301 | 113.66 | 113.27 | 113.4 | 3595800.0 |
| 2004-01-14 16:30:00 | SPY | ETF | 113.4 | 113.44 | 112.94 | 113.1 | 1195800.0 |
| 2004-01-14 17:00:00 | SPY | ETF | 113.09 | 113.68 | 113.05 | 113.2 | 273900.0 |
| 2004-01-14 17:30:00 | SPY | ETF | 113.22 | 113.23 | 113.17 | 113.22 | 14600.0 |
| 2004-01-14 18:00:00 | SPY | ETF | 113.2 | 113.23 | 113.09 | 113.1 | 21000.0 |
| 2004-01-14 18:30:00 | SPY | ETF | 113.08 | 113.09 | 113.08 | 113.09 | 2500.0 |
| 2004-01-14 19:00:00 | SPY | ETF | 113.12 | 113.14 | 113.12 | 113.14 | 2400.0 |
| 2004-01-14 19:30:00 | SPY | ETF | 113.14 | 113.14 | 113.14 | 113.14 | 300.0 |
| 2004-01-14 08:00:00 | QQQ | ETF | 38.07 | 38.08 | 38.05 | 38.08 | 67900.0 |
| 2004-01-14 08:30:00 | QQQ | ETF | 38.07 | 38.12 | 38.07 | 38.11 | 67600.0 |
| 2004-01-14 09:00:00 | QQQ | ETF | 38.11 | 38.11 | 38.07 | 38.08 | 64700.0 |
| 2004-01-14 09:30:00 | QQQ | ETF | 38.083 | 38.123 | 37.929 | 38.01 | 11394200.0 |
| 2004-01-14 10:00:00 | QQQ | ETF | 38.031 | 38.14 | 37.969 | 38.04 | 5228900.0 |
| 2004-01-14 10:30:00 | QQQ | ETF | 38.04 | 38.1 | 37.97 | 38.027 | 3873600.0 |
| 2004-01-14 11:00:00 | QQQ | ETF | 38.03 | 38.18 | 38.0 | 38.12 | 5582400.0 |
| 2004-01-14 11:30:00 | QQQ | ETF | 38.12 | 38.13 | 38.02 | 38.02 | 2034600.0 |
| 2004-01-14 12:00:00 | QQQ | ETF | 38.02 | 38.05 | 37.87 | 37.9 | 2971900.0 |
| 2004-01-14 12:30:00 | QQQ | ETF | 37.92 | 37.93 | 37.85 | 37.9 | 3543300.0 |
| 2004-01-14 13:00:00 | QQQ | ETF | 37.91 | 37.97 | 37.84 | 37.93 | 2473500.0 |
| 2004-01-14 13:30:00 | QQQ | ETF | 37.94 | 38.02 | 37.93 | 37.98 | 2022000.0 |
| 2004-01-14 14:00:00 | QQQ | ETF | 37.98 | 38.1 | 37.91 | 38.08 | 4185400.0 |
| 2004-01-14 14:30:00 | QQQ | ETF | 38.08 | 38.13 | 38.05 | 38.1 | 2692200.0 |
| 2004-01-14 15:00:00 | QQQ | ETF | 38.099 | 38.221 | 38.08 | 38.18 | 4845000.0 |
| 2004-01-14 15:30:00 | QQQ | ETF | 38.18 | 38.19 | 38.09 | 38.101 | 4331800.0 |
| 2004-01-14 16:00:00 | QQQ | ETF | 38.101 | 38.25 | 37.9 | 38.0 | 5147100.0 |
| 2004-01-14 16:30:00 | QQQ | ETF | 38.0 | 38.043 | 37.7 | 37.75 | 4460800.0 |
| 2004-01-14 17:00:00 | QQQ | ETF | 37.74 | 37.85 | 37.73 | 37.84 | 1456500.0 |
| 2004-01-14 17:30:00 | QQQ | ETF | 37.84 | 37.84 | 37.77 | 37.78 | 739200.0 |
| 2004-01-14 18:00:00 | QQQ | ETF | 37.78 | 37.78 | 37.72 | 37.73 | 218400.0 |
| 2004-01-14 18:30:00 | QQQ | ETF | 37.73 | 37.77 | 37.72 | 37.77 | 20000.0 |
| 2004-01-14 19:00:00 | QQQ | ETF | 37.77 | 37.78 | 37.77 | 37.78 | 15100.0 |
| 2004-01-14 19:30:00 | QQQ | ETF | 37.78 | 37.78 | 37.75 | 37.75 | 17700.0 |
| 2004-01-14 09:00:00 | IWM | ETF | 58.085 | 58.135 | 58.085 | 58.135 | 800.0 |
| 2004-01-14 09:30:00 | IWM | ETF | 58.188 | 58.37 | 58.13 | 58.215 | 1289800.0 |
> showing 50 of 1,154 rows — these rows as CSV