PREVIEW / etf_30min / 2004-06-18
file: by_date/etf_30min/2004/2004-06-18.parquet size: 34 KB rows: 1,144
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-06-18 08:00:00 | SPY | ETF | 113.13 | 113.23 | 113.12 | 113.23 | 62800.0 |
| 2004-06-18 08:30:00 | SPY | ETF | 113.25 | 113.33 | 113.24 | 113.33 | 40600.0 |
| 2004-06-18 09:00:00 | SPY | ETF | 113.32 | 113.32 | 113.26 | 113.26 | 65700.0 |
| 2004-06-18 09:30:00 | SPY | ETF | 113.2 | 113.65 | 113.2 | 113.55 | 5216500.0 |
| 2004-06-18 10:00:00 | SPY | ETF | 113.56 | 114.06 | 113.54 | 114.06 | 5056300.0 |
| 2004-06-18 10:30:00 | SPY | ETF | 114.06 | 114.22 | 113.97 | 114.04 | 2376600.0 |
| 2004-06-18 11:00:00 | SPY | ETF | 114.04 | 114.14 | 113.98 | 114.04 | 2238100.0 |
| 2004-06-18 11:30:00 | SPY | ETF | 114.02 | 114.11 | 113.98 | 113.99 | 961100.0 |
| 2004-06-18 12:00:00 | SPY | ETF | 113.97 | 114.02 | 113.84 | 113.93 | 1261500.0 |
| 2004-06-18 12:30:00 | SPY | ETF | 113.94 | 114.0 | 113.85 | 113.88 | 692600.0 |
| 2004-06-18 13:00:00 | SPY | ETF | 113.88 | 114.07 | 113.85 | 113.92 | 983500.0 |
| 2004-06-18 13:30:00 | SPY | ETF | 113.92 | 114.02 | 113.86 | 113.9 | 1110400.0 |
| 2004-06-18 14:00:00 | SPY | ETF | 113.91 | 114.03 | 113.87 | 114.03 | 825000.0 |
| 2004-06-18 14:30:00 | SPY | ETF | 114.01 | 114.04 | 113.48 | 113.68 | 3271800.0 |
| 2004-06-18 15:00:00 | SPY | ETF | 113.67 | 113.84 | 113.58 | 113.72 | 1734100.0 |
| 2004-06-18 15:30:00 | SPY | ETF | 113.74 | 113.89 | 113.63 | 113.71 | 2112800.0 |
| 2004-06-18 16:00:00 | SPY | ETF | 113.71 | 113.85 | 113.63 | 113.79 | 2053700.0 |
| 2004-06-18 16:30:00 | SPY | ETF | 113.79 | 113.82 | 113.78 | 113.81 | 43900.0 |
| 2004-06-18 17:00:00 | SPY | ETF | 113.8 | 113.85 | 113.78 | 113.78 | 21900.0 |
| 2004-06-18 17:30:00 | SPY | ETF | 113.89 | 113.89 | 113.81 | 113.85 | 1000.0 |
| 2004-06-18 18:00:00 | SPY | ETF | 113.81 | 113.84 | 113.76 | 113.78 | 1200.0 |
| 2004-06-18 18:30:00 | SPY | ETF | 113.76 | 113.76 | 113.76 | 113.76 | 500.0 |
| 2004-06-18 19:00:00 | SPY | ETF | 113.8 | 113.8 | 113.8 | 113.8 | 1000.0 |
| 2004-06-18 19:30:00 | SPY | ETF | 113.78 | 113.79 | 113.76 | 113.79 | 1300.0 |
| 2004-06-18 08:00:00 | QQQ | ETF | 36.27 | 36.29 | 36.26 | 36.29 | 37000.0 |
| 2004-06-18 08:30:00 | QQQ | ETF | 36.29 | 36.33 | 36.29 | 36.32 | 31300.0 |
| 2004-06-18 09:00:00 | QQQ | ETF | 36.33 | 36.35 | 36.28 | 36.3 | 317900.0 |
| 2004-06-18 09:30:00 | QQQ | ETF | 36.3 | 36.51 | 36.26 | 36.47 | 10485200.0 |
| 2004-06-18 10:00:00 | QQQ | ETF | 36.47 | 36.73 | 36.47 | 36.72 | 13526700.0 |
| 2004-06-18 10:30:00 | QQQ | ETF | 36.735 | 36.84 | 36.68 | 36.7 | 7544500.0 |
| 2004-06-18 11:00:00 | QQQ | ETF | 36.69 | 36.73 | 36.65 | 36.661 | 3782200.0 |
| 2004-06-18 11:30:00 | QQQ | ETF | 36.665 | 36.7 | 36.57 | 36.61 | 3871900.0 |
| 2004-06-18 12:00:00 | QQQ | ETF | 36.61 | 36.62 | 36.55 | 36.59 | 3700000.0 |
| 2004-06-18 12:30:00 | QQQ | ETF | 36.59 | 36.62 | 36.49 | 36.51 | 4745300.0 |
| 2004-06-18 13:00:00 | QQQ | ETF | 36.52 | 36.59 | 36.49 | 36.53 | 3894300.0 |
| 2004-06-18 13:30:00 | QQQ | ETF | 36.529 | 36.58 | 36.51 | 36.54 | 1863500.0 |
| 2004-06-18 14:00:00 | QQQ | ETF | 36.54 | 36.61 | 36.52 | 36.59 | 2546600.0 |
| 2004-06-18 14:30:00 | QQQ | ETF | 36.59 | 36.6 | 36.389 | 36.47 | 6229300.0 |
| 2004-06-18 15:00:00 | QQQ | ETF | 36.47 | 36.52 | 36.42 | 36.488 | 3148000.0 |
| 2004-06-18 15:30:00 | QQQ | ETF | 36.486 | 36.55 | 36.4 | 36.415 | 7769800.0 |
| 2004-06-18 16:00:00 | QQQ | ETF | 36.42 | 36.46 | 36.38 | 36.41 | 2220800.0 |
| 2004-06-18 16:30:00 | QQQ | ETF | 36.41 | 36.47 | 36.39 | 36.46 | 128700.0 |
| 2004-06-18 17:00:00 | QQQ | ETF | 36.46 | 36.5 | 36.45 | 36.49 | 68900.0 |
| 2004-06-18 17:30:00 | QQQ | ETF | 36.49 | 36.55 | 36.47 | 36.47 | 45300.0 |
| 2004-06-18 18:00:00 | QQQ | ETF | 36.48 | 36.49 | 36.41 | 36.46 | 77700.0 |
| 2004-06-18 18:30:00 | QQQ | ETF | 36.46 | 36.46 | 36.44 | 36.44 | 2800.0 |
| 2004-06-18 19:00:00 | QQQ | ETF | 36.45 | 36.45 | 36.43 | 36.43 | 3800.0 |
| 2004-06-18 19:30:00 | QQQ | ETF | 36.43 | 36.48 | 36.43 | 36.46 | 4300.0 |
| 2004-06-18 09:00:00 | IWM | ETF | 56.63 | 56.63 | 56.565 | 56.565 | 3000.0 |
| 2004-06-18 09:30:00 | IWM | ETF | 56.53 | 56.875 | 56.5 | 56.725 | 683000.0 |
> showing 50 of 1,144 rows — these rows as CSV