PREVIEW / etf_30min / 2004-09-24
file: by_date/etf_30min/2004/2004-09-24.parquet size: 33 KB rows: 1,107
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-09-24 08:00:00 | SPY | ETF | 111.09 | 111.1 | 111.01 | 111.01 | 102300.0 |
| 2004-09-24 08:30:00 | SPY | ETF | 111.01 | 111.16 | 111.01 | 111.06 | 118800.0 |
| 2004-09-24 09:00:00 | SPY | ETF | 111.07 | 111.16 | 111.07 | 111.16 | 30100.0 |
| 2004-09-24 09:30:00 | SPY | ETF | 111.17 | 111.48 | 111.13 | 111.41 | 4469300.0 |
| 2004-09-24 10:00:00 | SPY | ETF | 111.4 | 111.45 | 111.27 | 111.33 | 2542200.0 |
| 2004-09-24 10:30:00 | SPY | ETF | 111.33 | 111.52 | 111.27 | 111.5 | 2422300.0 |
| 2004-09-24 11:00:00 | SPY | ETF | 111.5 | 111.64 | 111.47 | 111.52 | 5660200.0 |
| 2004-09-24 11:30:00 | SPY | ETF | 111.53 | 111.58 | 111.38 | 111.4 | 1794000.0 |
| 2004-09-24 12:00:00 | SPY | ETF | 111.4 | 111.43 | 111.26 | 111.4 | 2520000.0 |
| 2004-09-24 12:30:00 | SPY | ETF | 111.4 | 111.46 | 111.37 | 111.42 | 883300.0 |
| 2004-09-24 13:00:00 | SPY | ETF | 111.42 | 111.56 | 111.36 | 111.51 | 1507100.0 |
| 2004-09-24 13:30:00 | SPY | ETF | 111.52 | 111.73 | 111.5 | 111.62 | 2041200.0 |
| 2004-09-24 14:00:00 | SPY | ETF | 111.62 | 111.72 | 111.45 | 111.51 | 1815600.0 |
| 2004-09-24 14:30:00 | SPY | ETF | 111.5 | 111.56 | 111.33 | 111.4 | 1922400.0 |
| 2004-09-24 15:00:00 | SPY | ETF | 111.41 | 111.57 | 111.28 | 111.5 | 2302900.0 |
| 2004-09-24 15:30:00 | SPY | ETF | 111.49 | 111.57 | 111.24 | 111.34 | 2934200.0 |
| 2004-09-24 16:00:00 | SPY | ETF | 111.35 | 111.52 | 111.3 | 111.47 | 1218600.0 |
| 2004-09-24 16:30:00 | SPY | ETF | 111.44 | 111.49 | 111.38 | 111.42 | 56800.0 |
| 2004-09-24 17:00:00 | SPY | ETF | 111.42 | 111.45 | 111.4 | 111.45 | 3700.0 |
| 2004-09-24 17:30:00 | SPY | ETF | 111.46 | 111.5 | 111.46 | 111.5 | 800.0 |
| 2004-09-24 18:00:00 | SPY | ETF | 111.48 | 111.5 | 111.48 | 111.5 | 600.0 |
| 2004-09-24 19:00:00 | SPY | ETF | 111.48 | 111.48 | 111.48 | 111.48 | 200.0 |
| 2004-09-24 08:00:00 | QQQ | ETF | 34.92 | 34.94 | 34.91 | 34.92 | 42600.0 |
| 2004-09-24 08:30:00 | QQQ | ETF | 34.92 | 34.96 | 34.9 | 34.92 | 176200.0 |
| 2004-09-24 09:00:00 | QQQ | ETF | 34.93 | 35.0 | 34.93 | 34.99 | 343800.0 |
| 2004-09-24 09:30:00 | QQQ | ETF | 34.99 | 35.12 | 34.93 | 35.1 | 10982800.0 |
| 2004-09-24 10:00:00 | QQQ | ETF | 35.1 | 35.11 | 35.04 | 35.04 | 6829800.0 |
| 2004-09-24 10:30:00 | QQQ | ETF | 35.05 | 35.13 | 34.99 | 35.119 | 7658000.0 |
| 2004-09-24 11:00:00 | QQQ | ETF | 35.12 | 35.19 | 35.09 | 35.136 | 6700500.0 |
| 2004-09-24 11:30:00 | QQQ | ETF | 35.137 | 35.153 | 34.98 | 34.987 | 5520600.0 |
| 2004-09-24 12:00:00 | QQQ | ETF | 34.985 | 34.99 | 34.75 | 34.87 | 13368400.0 |
| 2004-09-24 12:30:00 | QQQ | ETF | 34.87 | 34.9 | 34.82 | 34.88 | 5748800.0 |
| 2004-09-24 13:00:00 | QQQ | ETF | 34.879 | 35.03 | 34.84 | 35.0 | 6685800.0 |
| 2004-09-24 13:30:00 | QQQ | ETF | 34.99 | 35.12 | 34.946 | 35.02 | 8219100.0 |
| 2004-09-24 14:00:00 | QQQ | ETF | 35.02 | 35.05 | 34.87 | 34.9 | 6624600.0 |
| 2004-09-24 14:30:00 | QQQ | ETF | 34.9 | 34.93 | 34.81 | 34.817 | 4195800.0 |
| 2004-09-24 15:00:00 | QQQ | ETF | 34.819 | 34.91 | 34.76 | 34.88 | 6875600.0 |
| 2004-09-24 15:30:00 | QQQ | ETF | 34.88 | 34.91 | 34.76 | 34.8 | 9849900.0 |
| 2004-09-24 16:00:00 | QQQ | ETF | 34.8 | 34.856 | 34.78 | 34.8 | 1709100.0 |
| 2004-09-24 16:30:00 | QQQ | ETF | 34.792 | 34.85 | 34.78 | 34.85 | 87900.0 |
| 2004-09-24 17:00:00 | QQQ | ETF | 34.83 | 34.85 | 34.83 | 34.84 | 4100.0 |
| 2004-09-24 17:30:00 | QQQ | ETF | 34.84 | 34.85 | 34.84 | 34.85 | 9700.0 |
| 2004-09-24 18:00:00 | QQQ | ETF | 34.84 | 34.85 | 34.84 | 34.85 | 12300.0 |
| 2004-09-24 19:00:00 | QQQ | ETF | 34.87 | 34.9 | 34.86 | 34.9 | 7200.0 |
| 2004-09-24 19:30:00 | QQQ | ETF | 34.85 | 34.85 | 34.85 | 34.85 | 400.0 |
| 2004-09-24 08:00:00 | IWM | ETF | 56.305 | 56.305 | 56.305 | 56.305 | 4000.0 |
| 2004-09-24 08:30:00 | IWM | ETF | 56.365 | 56.365 | 56.3 | 56.3 | 4200.0 |
| 2004-09-24 09:00:00 | IWM | ETF | 56.3 | 56.45 | 56.3 | 56.45 | 18200.0 |
| 2004-09-24 09:30:00 | IWM | ETF | 56.5 | 56.65 | 56.355 | 56.55 | 2228200.0 |
| 2004-09-24 10:00:00 | IWM | ETF | 56.55 | 56.59 | 56.44 | 56.455 | 794200.0 |
> showing 50 of 1,107 rows — these rows as CSV