PREVIEW / etf_30min / 2004-02-24
file: by_date/etf_30min/2004/2004-02-24.parquet size: 36 KB rows: 1,202
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-24 08:00:00 | SPY | ETF | 114.35 | 114.35 | 114.21 | 114.22 | 30400.0 |
| 2004-02-24 08:30:00 | SPY | ETF | 114.22 | 114.22 | 114.09 | 114.16 | 51500.0 |
| 2004-02-24 09:00:00 | SPY | ETF | 114.15 | 114.25 | 114.15 | 114.25 | 41600.0 |
| 2004-02-24 09:30:00 | SPY | ETF | 114.27 | 114.38 | 114.15 | 114.34 | 6952500.0 |
| 2004-02-24 10:00:00 | SPY | ETF | 114.28 | 114.54 | 113.99 | 114.51 | 5533100.0 |
| 2004-02-24 10:30:00 | SPY | ETF | 114.52 | 114.99 | 114.49 | 114.8 | 5729500.0 |
| 2004-02-24 11:00:00 | SPY | ETF | 114.81 | 114.88 | 114.6 | 114.66 | 2077000.0 |
| 2004-02-24 11:30:00 | SPY | ETF | 114.66 | 114.74 | 114.47 | 114.6 | 2076100.0 |
| 2004-02-24 12:00:00 | SPY | ETF | 114.59 | 114.74 | 114.42 | 114.66 | 1032000.0 |
| 2004-02-24 12:30:00 | SPY | ETF | 114.65 | 114.71 | 114.56 | 114.62 | 562500.0 |
| 2004-02-24 13:00:00 | SPY | ETF | 114.62 | 114.84 | 114.55 | 114.77 | 1530200.0 |
| 2004-02-24 13:30:00 | SPY | ETF | 114.75 | 114.8 | 114.41 | 114.47 | 1459200.0 |
| 2004-02-24 14:00:00 | SPY | ETF | 114.5 | 114.52 | 114.1 | 114.23 | 3261300.0 |
| 2004-02-24 14:30:00 | SPY | ETF | 114.23 | 114.23 | 113.9 | 114.07 | 4267300.0 |
| 2004-02-24 15:00:00 | SPY | ETF | 114.07 | 114.38 | 114.05 | 114.2 | 2436800.0 |
| 2004-02-24 15:30:00 | SPY | ETF | 114.2 | 114.49 | 114.18 | 114.45 | 2153700.0 |
| 2004-02-24 16:00:00 | SPY | ETF | 114.45 | 114.47 | 114.33 | 114.42 | 1169700.0 |
| 2004-02-24 16:30:00 | SPY | ETF | 114.42 | 114.48 | 114.4 | 114.43 | 42500.0 |
| 2004-02-24 17:00:00 | SPY | ETF | 114.43 | 114.47 | 114.43 | 114.47 | 300.0 |
| 2004-02-24 17:30:00 | SPY | ETF | 114.47 | 114.48 | 114.45 | 114.48 | 3100.0 |
| 2004-02-24 18:00:00 | SPY | ETF | 114.48 | 114.48 | 114.46 | 114.46 | 4000.0 |
| 2004-02-24 18:30:00 | SPY | ETF | 114.46 | 114.46 | 114.46 | 114.46 | 200.0 |
| 2004-02-24 19:00:00 | SPY | ETF | 114.45 | 114.5 | 114.45 | 114.5 | 1100.0 |
| 2004-02-24 19:30:00 | SPY | ETF | 114.5 | 114.5 | 114.5 | 114.5 | 100.0 |
| 2004-02-24 08:00:00 | QQQ | ETF | 36.45 | 36.45 | 36.27 | 36.27 | 112100.0 |
| 2004-02-24 08:30:00 | QQQ | ETF | 36.29 | 36.29 | 36.17 | 36.22 | 159300.0 |
| 2004-02-24 09:00:00 | QQQ | ETF | 36.22 | 36.31 | 36.22 | 36.31 | 117400.0 |
| 2004-02-24 09:30:00 | QQQ | ETF | 36.3 | 36.34 | 36.15 | 36.32 | 17901100.0 |
| 2004-02-24 10:00:00 | QQQ | ETF | 36.32 | 36.5 | 36.1 | 36.5 | 19599400.0 |
| 2004-02-24 10:30:00 | QQQ | ETF | 36.49 | 36.65 | 36.49 | 36.53 | 17262700.0 |
| 2004-02-24 11:00:00 | QQQ | ETF | 36.53 | 36.6 | 36.39 | 36.41 | 9326100.0 |
| 2004-02-24 11:30:00 | QQQ | ETF | 36.41 | 36.49 | 36.37 | 36.44 | 5049900.0 |
| 2004-02-24 12:00:00 | QQQ | ETF | 36.44 | 36.56 | 36.36 | 36.5 | 3472400.0 |
| 2004-02-24 12:30:00 | QQQ | ETF | 36.51 | 36.53 | 36.4 | 36.41 | 2359900.0 |
| 2004-02-24 13:00:00 | QQQ | ETF | 36.413 | 36.59 | 36.39 | 36.54 | 4096200.0 |
| 2004-02-24 13:30:00 | QQQ | ETF | 36.54 | 36.566 | 36.38 | 36.45 | 4117500.0 |
| 2004-02-24 14:00:00 | QQQ | ETF | 36.452 | 36.46 | 36.25 | 36.271 | 9554200.0 |
| 2004-02-24 14:30:00 | QQQ | ETF | 36.271 | 36.286 | 36.15 | 36.22 | 7691000.0 |
| 2004-02-24 15:00:00 | QQQ | ETF | 36.23 | 36.38 | 36.2 | 36.241 | 5334900.0 |
| 2004-02-24 15:30:00 | QQQ | ETF | 36.245 | 36.4 | 36.23 | 36.38 | 5901700.0 |
| 2004-02-24 16:00:00 | QQQ | ETF | 36.39 | 36.4 | 36.329 | 36.39 | 1627100.0 |
| 2004-02-24 16:30:00 | QQQ | ETF | 36.399 | 36.42 | 36.35 | 36.4 | 506600.0 |
| 2004-02-24 17:00:00 | QQQ | ETF | 36.39 | 36.42 | 36.39 | 36.41 | 300100.0 |
| 2004-02-24 17:30:00 | QQQ | ETF | 36.43 | 36.43 | 36.382 | 36.41 | 20600.0 |
| 2004-02-24 18:00:00 | QQQ | ETF | 36.41 | 36.42 | 36.39 | 36.41 | 15200.0 |
| 2004-02-24 18:30:00 | QQQ | ETF | 36.41 | 36.42 | 36.41 | 36.42 | 3800.0 |
| 2004-02-24 19:00:00 | QQQ | ETF | 36.4 | 36.42 | 36.4 | 36.42 | 600.0 |
| 2004-02-24 19:30:00 | QQQ | ETF | 36.42 | 36.43 | 36.42 | 36.43 | 6400.0 |
| 2004-02-24 08:00:00 | IWM | ETF | 56.785 | 56.785 | 56.725 | 56.725 | 2200.0 |
| 2004-02-24 08:30:00 | IWM | ETF | 56.65 | 56.665 | 56.65 | 56.655 | 55600.0 |
> showing 50 of 1,202 rows — these rows as CSV