PREVIEW / etf_30min / 2004-02-03
file: by_date/etf_30min/2004/2004-02-03.parquet size: 34 KB rows: 1,191
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-02-03 08:00:00 | SPY | ETF | 113.79 | 113.92 | 113.79 | 113.92 | 12600.0 |
| 2004-02-03 08:30:00 | SPY | ETF | 113.88 | 113.88 | 113.78 | 113.78 | 2000.0 |
| 2004-02-03 09:00:00 | SPY | ETF | 113.78 | 113.79 | 113.68 | 113.75 | 94400.0 |
| 2004-02-03 09:30:00 | SPY | ETF | 113.74 | 113.95 | 113.44 | 113.83 | 4057700.0 |
| 2004-02-03 10:00:00 | SPY | ETF | 113.84 | 114.02 | 113.77 | 113.94 | 3154700.0 |
| 2004-02-03 10:30:00 | SPY | ETF | 113.93 | 113.95 | 113.5 | 113.9 | 1576600.0 |
| 2004-02-03 11:00:00 | SPY | ETF | 113.91 | 114.0 | 113.76 | 113.94 | 1060900.0 |
| 2004-02-03 11:30:00 | SPY | ETF | 113.94 | 113.96 | 113.64 | 113.73 | 1597000.0 |
| 2004-02-03 12:00:00 | SPY | ETF | 113.72 | 114.1 | 113.68 | 113.98 | 1241700.0 |
| 2004-02-03 12:30:00 | SPY | ETF | 113.99 | 114.07 | 113.94 | 114.01 | 392300.0 |
| 2004-02-03 13:00:00 | SPY | ETF | 114.01 | 114.14 | 113.87 | 113.99 | 825800.0 |
| 2004-02-03 13:30:00 | SPY | ETF | 113.98 | 114.02 | 113.9 | 113.98 | 425800.0 |
| 2004-02-03 14:00:00 | SPY | ETF | 113.97 | 114.07 | 113.71 | 113.79 | 1914000.0 |
| 2004-02-03 14:30:00 | SPY | ETF | 113.77 | 113.84 | 113.57 | 113.81 | 1793000.0 |
| 2004-02-03 15:00:00 | SPY | ETF | 113.79 | 113.98 | 113.76 | 113.83 | 1629900.0 |
| 2004-02-03 15:30:00 | SPY | ETF | 113.87 | 114.0 | 113.78 | 113.96 | 1684600.0 |
| 2004-02-03 16:00:00 | SPY | ETF | 113.95 | 114.03 | 113.72 | 113.83 | 1812100.0 |
| 2004-02-03 16:30:00 | SPY | ETF | 113.79 | 113.83 | 113.46 | 113.52 | 153400.0 |
| 2004-02-03 17:00:00 | SPY | ETF | 113.52 | 113.58 | 113.35 | 113.39 | 89000.0 |
| 2004-02-03 17:30:00 | SPY | ETF | 113.39 | 113.53 | 113.35 | 113.41 | 28300.0 |
| 2004-02-03 18:00:00 | SPY | ETF | 113.41 | 113.42 | 113.37 | 113.4 | 30700.0 |
| 2004-02-03 18:30:00 | SPY | ETF | 113.4 | 113.4 | 113.37 | 113.38 | 700.0 |
| 2004-02-03 19:00:00 | SPY | ETF | 113.39 | 113.41 | 113.38 | 113.38 | 2800.0 |
| 2004-02-03 19:30:00 | SPY | ETF | 113.41 | 113.41 | 113.41 | 113.41 | 100.0 |
| 2004-02-03 08:00:00 | QQQ | ETF | 36.91 | 36.98 | 36.91 | 36.98 | 23300.0 |
| 2004-02-03 08:30:00 | QQQ | ETF | 36.98 | 36.98 | 36.92 | 36.92 | 31700.0 |
| 2004-02-03 09:00:00 | QQQ | ETF | 36.92 | 36.93 | 36.89 | 36.9 | 44400.0 |
| 2004-02-03 09:30:00 | QQQ | ETF | 36.91 | 37.12 | 36.84 | 37.089 | 11750200.0 |
| 2004-02-03 10:00:00 | QQQ | ETF | 37.09 | 37.21 | 37.049 | 37.13 | 7168700.0 |
| 2004-02-03 10:30:00 | QQQ | ETF | 37.132 | 37.16 | 36.95 | 37.13 | 5730500.0 |
| 2004-02-03 11:00:00 | QQQ | ETF | 37.137 | 37.18 | 37.08 | 37.166 | 3052800.0 |
| 2004-02-03 11:30:00 | QQQ | ETF | 37.17 | 37.17 | 37.0 | 37.04 | 3867200.0 |
| 2004-02-03 12:00:00 | QQQ | ETF | 37.039 | 37.16 | 37.01 | 37.12 | 3157000.0 |
| 2004-02-03 12:30:00 | QQQ | ETF | 37.118 | 37.19 | 37.097 | 37.163 | 1395100.0 |
| 2004-02-03 13:00:00 | QQQ | ETF | 37.17 | 37.24 | 37.09 | 37.13 | 3400200.0 |
| 2004-02-03 13:30:00 | QQQ | ETF | 37.13 | 37.16 | 37.09 | 37.14 | 2152500.0 |
| 2004-02-03 14:00:00 | QQQ | ETF | 37.137 | 37.18 | 36.96 | 37.0 | 3836600.0 |
| 2004-02-03 14:30:00 | QQQ | ETF | 37.0 | 37.03 | 36.9 | 36.99 | 4779100.0 |
| 2004-02-03 15:00:00 | QQQ | ETF | 37.001 | 37.1 | 36.98 | 37.053 | 4400500.0 |
| 2004-02-03 15:30:00 | QQQ | ETF | 37.055 | 37.12 | 37.0 | 37.06 | 6387900.0 |
| 2004-02-03 16:00:00 | QQQ | ETF | 37.05 | 37.09 | 36.87 | 36.98 | 4975300.0 |
| 2004-02-03 16:30:00 | QQQ | ETF | 36.98 | 36.98 | 36.74 | 36.77 | 2046100.0 |
| 2004-02-03 17:00:00 | QQQ | ETF | 36.77 | 36.836 | 36.65 | 36.67 | 2670400.0 |
| 2004-02-03 17:30:00 | QQQ | ETF | 36.67 | 36.69 | 36.606 | 36.68 | 536100.0 |
| 2004-02-03 18:00:00 | QQQ | ETF | 36.68 | 36.71 | 36.68 | 36.7 | 170600.0 |
| 2004-02-03 18:30:00 | QQQ | ETF | 36.69 | 36.71 | 36.69 | 36.71 | 51700.0 |
| 2004-02-03 19:00:00 | QQQ | ETF | 36.72 | 36.73 | 36.7 | 36.71 | 26600.0 |
| 2004-02-03 19:30:00 | QQQ | ETF | 36.7 | 36.72 | 36.7 | 36.72 | 9600.0 |
| 2004-02-03 09:30:00 | IWM | ETF | 57.8 | 57.91 | 57.56 | 57.815 | 593600.0 |
| 2004-02-03 10:00:00 | IWM | ETF | 57.825 | 57.905 | 57.75 | 57.83 | 346200.0 |
> showing 50 of 1,191 rows — these rows as CSV