PREVIEW / etf_30min / 2004-11-11
file: by_date/etf_30min/2004/2004-11-11.parquet size: 39 KB rows: 1,322
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-11-11 08:00:00 | SPY | ETF | 117.37 | 117.37 | 117.3 | 117.3 | 64500.0 |
| 2004-11-11 08:30:00 | SPY | ETF | 117.3 | 117.35 | 117.28 | 117.3 | 33100.0 |
| 2004-11-11 09:00:00 | SPY | ETF | 117.28 | 117.28 | 117.17 | 117.17 | 89300.0 |
| 2004-11-11 09:30:00 | SPY | ETF | 117.2 | 117.35 | 117.11 | 117.28 | 1767700.0 |
| 2004-11-11 10:00:00 | SPY | ETF | 117.29 | 117.4 | 117.12 | 117.26 | 1983000.0 |
| 2004-11-11 10:30:00 | SPY | ETF | 117.27 | 117.5 | 117.15 | 117.39 | 2897800.0 |
| 2004-11-11 11:00:00 | SPY | ETF | 117.39 | 117.41 | 117.26 | 117.33 | 1797000.0 |
| 2004-11-11 11:30:00 | SPY | ETF | 117.33 | 117.46 | 117.31 | 117.4 | 1013300.0 |
| 2004-11-11 12:00:00 | SPY | ETF | 117.4 | 117.65 | 117.37 | 117.6 | 3495500.0 |
| 2004-11-11 12:30:00 | SPY | ETF | 117.6 | 117.65 | 117.47 | 117.58 | 1738100.0 |
| 2004-11-11 13:00:00 | SPY | ETF | 117.58 | 117.59 | 117.46 | 117.5 | 933300.0 |
| 2004-11-11 13:30:00 | SPY | ETF | 117.52 | 117.67 | 117.48 | 117.62 | 1415300.0 |
| 2004-11-11 14:00:00 | SPY | ETF | 117.61 | 118.01 | 117.59 | 117.96 | 3996100.0 |
| 2004-11-11 14:30:00 | SPY | ETF | 117.97 | 118.06 | 117.85 | 117.95 | 3780500.0 |
| 2004-11-11 15:00:00 | SPY | ETF | 117.94 | 118.07 | 117.88 | 118.03 | 2371200.0 |
| 2004-11-11 15:30:00 | SPY | ETF | 118.04 | 118.12 | 117.93 | 117.99 | 6081300.0 |
| 2004-11-11 16:00:00 | SPY | ETF | 117.99 | 118.02 | 117.8 | 117.84 | 1579000.0 |
| 2004-11-11 16:30:00 | SPY | ETF | 117.85 | 117.86 | 117.8 | 117.85 | 86300.0 |
| 2004-11-11 17:00:00 | SPY | ETF | 117.84 | 117.9 | 117.81 | 117.85 | 55800.0 |
| 2004-11-11 17:30:00 | SPY | ETF | 117.85 | 117.94 | 117.84 | 117.85 | 509800.0 |
| 2004-11-11 18:00:00 | SPY | ETF | 117.91 | 117.91 | 117.89 | 117.89 | 8200.0 |
| 2004-11-11 18:30:00 | SPY | ETF | 117.86 | 117.89 | 117.86 | 117.89 | 900.0 |
| 2004-11-11 19:00:00 | SPY | ETF | 117.86 | 117.86 | 117.86 | 117.86 | 100.0 |
| 2004-11-11 19:30:00 | SPY | ETF | 117.87 | 117.87 | 117.87 | 117.87 | 2400.0 |
| 2004-11-11 08:00:00 | QQQ | ETF | 37.99 | 37.99 | 37.94 | 37.94 | 48300.0 |
| 2004-11-11 08:30:00 | QQQ | ETF | 37.95 | 37.95 | 37.94 | 37.95 | 68400.0 |
| 2004-11-11 09:00:00 | QQQ | ETF | 37.95 | 37.95 | 37.9 | 37.91 | 88500.0 |
| 2004-11-11 09:30:00 | QQQ | ETF | 37.92 | 37.98 | 37.86 | 37.921 | 4194900.0 |
| 2004-11-11 10:00:00 | QQQ | ETF | 37.92 | 37.99 | 37.88 | 37.94 | 5382600.0 |
| 2004-11-11 10:30:00 | QQQ | ETF | 37.941 | 38.13 | 37.89 | 38.05 | 12117200.0 |
| 2004-11-11 11:00:00 | QQQ | ETF | 38.05 | 38.07 | 37.94 | 37.946 | 10240500.0 |
| 2004-11-11 11:30:00 | QQQ | ETF | 37.942 | 38.03 | 37.93 | 38.0 | 3088200.0 |
| 2004-11-11 12:00:00 | QQQ | ETF | 38.008 | 38.07 | 37.99 | 38.05 | 2609400.0 |
| 2004-11-11 12:30:00 | QQQ | ETF | 38.05 | 38.05 | 38.01 | 38.04 | 3368300.0 |
| 2004-11-11 13:00:00 | QQQ | ETF | 38.048 | 38.05 | 37.99 | 38.03 | 1886800.0 |
| 2004-11-11 13:30:00 | QQQ | ETF | 38.03 | 38.13 | 38.02 | 38.091 | 5287000.0 |
| 2004-11-11 14:00:00 | QQQ | ETF | 38.1 | 38.29 | 38.09 | 38.28 | 10642800.0 |
| 2004-11-11 14:30:00 | QQQ | ETF | 38.27 | 38.33 | 38.24 | 38.27 | 10363200.0 |
| 2004-11-11 15:00:00 | QQQ | ETF | 38.27 | 38.36 | 38.23 | 38.319 | 6853500.0 |
| 2004-11-11 15:30:00 | QQQ | ETF | 38.321 | 38.38 | 38.27 | 38.32 | 10837500.0 |
| 2004-11-11 16:00:00 | QQQ | ETF | 38.33 | 38.34 | 38.24 | 38.27 | 4320600.0 |
| 2004-11-11 16:30:00 | QQQ | ETF | 38.27 | 38.32 | 38.22 | 38.28 | 391200.0 |
| 2004-11-11 17:00:00 | QQQ | ETF | 38.28 | 38.307 | 38.26 | 38.29 | 101700.0 |
| 2004-11-11 17:30:00 | QQQ | ETF | 38.29 | 38.41 | 38.28 | 38.39 | 296100.0 |
| 2004-11-11 18:00:00 | QQQ | ETF | 38.39 | 38.39 | 38.332 | 38.347 | 164100.0 |
| 2004-11-11 18:30:00 | QQQ | ETF | 38.35 | 38.35 | 38.34 | 38.34 | 1300.0 |
| 2004-11-11 19:00:00 | QQQ | ETF | 38.34 | 38.36 | 38.34 | 38.36 | 52400.0 |
| 2004-11-11 19:30:00 | QQQ | ETF | 38.36 | 38.37 | 38.35 | 38.35 | 4000.0 |
| 2004-11-11 08:00:00 | IWM | ETF | 60.95 | 60.95 | 60.95 | 60.95 | 2000.0 |
| 2004-11-11 09:00:00 | IWM | ETF | 60.955 | 60.955 | 60.83 | 60.83 | 1000.0 |
> showing 50 of 1,322 rows — these rows as CSV