PREVIEW / etf_30min / 2004-03-02
file: by_date/etf_30min/2004/2004-03-02.parquet size: 37 KB rows: 1,209
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-03-02 08:00:00 | SPY | ETF | 116.06 | 116.11 | 115.96 | 115.96 | 8600.0 |
| 2004-03-02 08:30:00 | SPY | ETF | 115.98 | 115.98 | 115.95 | 115.96 | 5600.0 |
| 2004-03-02 09:00:00 | SPY | ETF | 116.0 | 116.01 | 115.96 | 115.98 | 12900.0 |
| 2004-03-02 09:30:00 | SPY | ETF | 115.94 | 116.23 | 115.9 | 116.15 | 2141300.0 |
| 2004-03-02 10:00:00 | SPY | ETF | 116.13 | 116.22 | 116.01 | 116.01 | 2135000.0 |
| 2004-03-02 10:30:00 | SPY | ETF | 116.02 | 116.17 | 115.854 | 116.11 | 2515300.0 |
| 2004-03-02 11:00:00 | SPY | ETF | 116.13 | 116.19 | 115.78 | 116.16 | 1234300.0 |
| 2004-03-02 11:30:00 | SPY | ETF | 116.17 | 116.2 | 116.0 | 116.04 | 1037600.0 |
| 2004-03-02 12:00:00 | SPY | ETF | 116.04 | 116.14 | 115.61 | 115.8 | 2558700.0 |
| 2004-03-02 12:30:00 | SPY | ETF | 115.8 | 115.92 | 115.49 | 115.6 | 2546800.0 |
| 2004-03-02 13:00:00 | SPY | ETF | 115.6 | 115.8 | 115.51 | 115.67 | 1541500.0 |
| 2004-03-02 13:30:00 | SPY | ETF | 115.66 | 115.68 | 115.23 | 115.41 | 4578700.0 |
| 2004-03-02 14:00:00 | SPY | ETF | 115.4 | 115.57 | 115.33 | 115.55 | 1259700.0 |
| 2004-03-02 14:30:00 | SPY | ETF | 115.55 | 115.68 | 115.39 | 115.6 | 2220100.0 |
| 2004-03-02 15:00:00 | SPY | ETF | 115.6 | 115.87 | 115.49 | 115.86 | 2657500.0 |
| 2004-03-02 15:30:00 | SPY | ETF | 115.85 | 115.89 | 115.44 | 115.49 | 2504000.0 |
| 2004-03-02 16:00:00 | SPY | ETF | 115.49 | 115.54 | 115.41 | 115.52 | 901200.0 |
| 2004-03-02 16:30:00 | SPY | ETF | 115.5 | 115.5 | 115.36 | 115.36 | 56800.0 |
| 2004-03-02 17:00:00 | SPY | ETF | 115.41 | 115.41 | 115.41 | 115.41 | 100.0 |
| 2004-03-02 17:30:00 | SPY | ETF | 115.45 | 115.45 | 115.45 | 115.45 | 500.0 |
| 2004-03-02 18:00:00 | SPY | ETF | 115.41 | 115.47 | 115.41 | 115.47 | 50500.0 |
| 2004-03-02 19:30:00 | SPY | ETF | 115.47 | 115.47 | 115.47 | 115.47 | 500.0 |
| 2004-03-02 08:00:00 | QQQ | ETF | 37.04 | 37.07 | 36.99 | 37.0 | 26000.0 |
| 2004-03-02 08:30:00 | QQQ | ETF | 36.98 | 37.0 | 36.96 | 36.98 | 61800.0 |
| 2004-03-02 09:00:00 | QQQ | ETF | 37.0 | 37.03 | 36.99 | 37.0 | 66600.0 |
| 2004-03-02 09:30:00 | QQQ | ETF | 36.984 | 37.14 | 36.95 | 37.12 | 6478000.0 |
| 2004-03-02 10:00:00 | QQQ | ETF | 37.12 | 37.18 | 37.03 | 37.04 | 8287500.0 |
| 2004-03-02 10:30:00 | QQQ | ETF | 37.04 | 37.17 | 36.95 | 37.15 | 5189000.0 |
| 2004-03-02 11:00:00 | QQQ | ETF | 37.14 | 37.142 | 36.96 | 37.1 | 4819600.0 |
| 2004-03-02 11:30:00 | QQQ | ETF | 37.1 | 37.115 | 37.0 | 37.022 | 3470900.0 |
| 2004-03-02 12:00:00 | QQQ | ETF | 37.03 | 37.06 | 36.8 | 36.89 | 6696200.0 |
| 2004-03-02 12:30:00 | QQQ | ETF | 36.88 | 36.9 | 36.73 | 36.78 | 3402700.0 |
| 2004-03-02 13:00:00 | QQQ | ETF | 36.79 | 36.86 | 36.75 | 36.82 | 7898800.0 |
| 2004-03-02 13:30:00 | QQQ | ETF | 36.83 | 36.83 | 36.66 | 36.7 | 7541400.0 |
| 2004-03-02 14:00:00 | QQQ | ETF | 36.706 | 36.782 | 36.7 | 36.781 | 2626200.0 |
| 2004-03-02 14:30:00 | QQQ | ETF | 36.78 | 36.801 | 36.63 | 36.72 | 4704100.0 |
| 2004-03-02 15:00:00 | QQQ | ETF | 36.71 | 36.836 | 36.66 | 36.819 | 6527200.0 |
| 2004-03-02 15:30:00 | QQQ | ETF | 36.82 | 36.84 | 36.62 | 36.677 | 6418200.0 |
| 2004-03-02 16:00:00 | QQQ | ETF | 36.672 | 36.7 | 36.58 | 36.6 | 1729300.0 |
| 2004-03-02 16:30:00 | QQQ | ETF | 36.6 | 36.6 | 36.57 | 36.59 | 480500.0 |
| 2004-03-02 17:00:00 | QQQ | ETF | 36.58 | 36.6 | 36.56 | 36.59 | 77000.0 |
| 2004-03-02 17:30:00 | QQQ | ETF | 36.59 | 36.6 | 36.56 | 36.6 | 33500.0 |
| 2004-03-02 18:00:00 | QQQ | ETF | 36.6 | 36.6 | 36.57 | 36.59 | 21800.0 |
| 2004-03-02 18:30:00 | QQQ | ETF | 36.59 | 36.6 | 36.57 | 36.58 | 18200.0 |
| 2004-03-02 19:00:00 | QQQ | ETF | 36.58 | 36.58 | 36.57 | 36.58 | 7800.0 |
| 2004-03-02 19:30:00 | QQQ | ETF | 36.58 | 36.59 | 36.57 | 36.57 | 6700.0 |
| 2004-03-02 09:00:00 | IWM | ETF | 59.135 | 59.205 | 59.135 | 59.205 | 400.0 |
| 2004-03-02 09:30:00 | IWM | ETF | 59.23 | 59.42 | 59.1 | 59.42 | 1117600.0 |
| 2004-03-02 10:00:00 | IWM | ETF | 59.39 | 59.45 | 59.31 | 59.35 | 439400.0 |
| 2004-03-02 10:30:00 | IWM | ETF | 59.36 | 59.392 | 59.195 | 59.392 | 1356800.0 |
> showing 50 of 1,209 rows — these rows as CSV