PREVIEW / etf_30min / 2005-08-24
file: by_date/etf_30min/2005/2005-08-24.parquet size: 48 KB rows: 1,641
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-24 07:00:00 | SPY | ETF | 121.98 | 121.98 | 121.98 | 121.98 | 100.0 |
| 2005-08-24 07:30:00 | SPY | ETF | 121.95 | 121.95 | 121.95 | 121.95 | 1000.0 |
| 2005-08-24 08:00:00 | SPY | ETF | 121.95 | 121.98 | 121.93 | 121.98 | 65900.0 |
| 2005-08-24 08:30:00 | SPY | ETF | 121.97 | 122.16 | 121.75 | 121.9 | 482600.0 |
| 2005-08-24 09:00:00 | SPY | ETF | 121.89 | 121.93 | 121.84 | 121.92 | 182800.0 |
| 2005-08-24 09:30:00 | SPY | ETF | 121.94 | 122.03 | 121.77 | 122.01 | 6946200.0 |
| 2005-08-24 10:00:00 | SPY | ETF | 122.0 | 122.24 | 121.94 | 122.09 | 8692600.0 |
| 2005-08-24 10:30:00 | SPY | ETF | 122.06 | 122.57 | 122.03 | 122.41 | 7338300.0 |
| 2005-08-24 11:00:00 | SPY | ETF | 122.41 | 122.46 | 122.18 | 122.34 | 3400100.0 |
| 2005-08-24 11:30:00 | SPY | ETF | 122.33 | 122.5 | 122.27 | 122.38 | 2360100.0 |
| 2005-08-24 12:00:00 | SPY | ETF | 122.39 | 122.7 | 122.27 | 122.62 | 2524600.0 |
| 2005-08-24 12:30:00 | SPY | ETF | 122.63 | 122.73 | 122.51 | 122.63 | 2359200.0 |
| 2005-08-24 13:00:00 | SPY | ETF | 122.64 | 122.65 | 122.34 | 122.45 | 3069600.0 |
| 2005-08-24 13:30:00 | SPY | ETF | 122.44 | 122.49 | 122.21 | 122.29 | 3797000.0 |
| 2005-08-24 14:00:00 | SPY | ETF | 122.29 | 122.42 | 122.12 | 122.19 | 2425000.0 |
| 2005-08-24 14:30:00 | SPY | ETF | 122.19 | 122.27 | 121.79 | 121.81 | 7336400.0 |
| 2005-08-24 15:00:00 | SPY | ETF | 121.82 | 121.87 | 121.22 | 121.37 | 14514700.0 |
| 2005-08-24 15:30:00 | SPY | ETF | 121.37 | 121.56 | 121.19 | 121.24 | 10928200.0 |
| 2005-08-24 16:00:00 | SPY | ETF | 121.23 | 122.35 | 121.09 | 121.09 | 854200.0 |
| 2005-08-24 16:30:00 | SPY | ETF | 121.1 | 121.23 | 121.05 | 121.14 | 171800.0 |
| 2005-08-24 17:00:00 | SPY | ETF | 121.13 | 121.15 | 121.12 | 121.13 | 26800.0 |
| 2005-08-24 17:30:00 | SPY | ETF | 121.14 | 121.18 | 121.14 | 121.17 | 4500.0 |
| 2005-08-24 18:00:00 | SPY | ETF | 121.15 | 121.17 | 121.1 | 121.17 | 27500.0 |
| 2005-08-24 18:30:00 | SPY | ETF | 121.17 | 121.21 | 121.17 | 121.21 | 1500.0 |
| 2005-08-24 19:30:00 | SPY | ETF | 121.2 | 121.2 | 121.19 | 121.19 | 4000.0 |
| 2005-08-24 09:30:00 | QQQ | ETF | 38.65 | 38.71 | 38.59 | 38.7 | 7348300.0 |
| 2005-08-24 10:00:00 | QQQ | ETF | 38.71 | 38.78 | 38.69 | 38.71 | 6494300.0 |
| 2005-08-24 10:30:00 | QQQ | ETF | 38.71 | 39.09 | 38.69 | 39.01 | 14789100.0 |
| 2005-08-24 11:00:00 | QQQ | ETF | 39.01 | 39.05 | 38.94 | 39.0 | 5959800.0 |
| 2005-08-24 11:30:00 | QQQ | ETF | 39.0 | 39.08 | 38.96 | 39.05 | 3863200.0 |
| 2005-08-24 12:00:00 | QQQ | ETF | 39.05 | 39.15 | 39.01 | 39.14 | 4565100.0 |
| 2005-08-24 12:30:00 | QQQ | ETF | 39.14 | 39.18 | 39.09 | 39.13 | 3512900.0 |
| 2005-08-24 13:00:00 | QQQ | ETF | 39.13 | 39.13 | 39.03 | 39.05 | 2708800.0 |
| 2005-08-24 13:30:00 | QQQ | ETF | 39.05 | 39.06 | 38.97 | 39.01 | 3134700.0 |
| 2005-08-24 14:00:00 | QQQ | ETF | 39.0 | 39.03 | 38.86 | 38.9 | 5254900.0 |
| 2005-08-24 14:30:00 | QQQ | ETF | 38.9 | 38.92 | 38.76 | 38.77 | 5416700.0 |
| 2005-08-24 15:00:00 | QQQ | ETF | 38.77 | 38.78 | 38.48 | 38.55 | 17614200.0 |
| 2005-08-24 15:30:00 | QQQ | ETF | 38.55 | 38.64 | 38.46 | 38.5 | 8085600.0 |
| 2005-08-24 08:00:00 | IWM | ETF | 65.31 | 65.31 | 65.31 | 65.31 | 500.0 |
| 2005-08-24 08:30:00 | IWM | ETF | 65.19 | 65.25 | 65.17 | 65.18 | 147800.0 |
| 2005-08-24 09:00:00 | IWM | ETF | 65.21 | 65.25 | 65.19 | 65.23 | 92000.0 |
| 2005-08-24 09:30:00 | IWM | ETF | 65.24 | 65.32 | 65.1 | 65.2 | 1411200.0 |
| 2005-08-24 10:00:00 | IWM | ETF | 65.23 | 65.5 | 65.21 | 65.4 | 1685300.0 |
| 2005-08-24 10:30:00 | IWM | ETF | 65.4 | 65.82 | 65.4 | 65.71 | 2477300.0 |
| 2005-08-24 11:00:00 | IWM | ETF | 65.71 | 65.74 | 65.55 | 65.56 | 1546200.0 |
| 2005-08-24 11:30:00 | IWM | ETF | 65.56 | 65.68 | 65.52 | 65.58 | 703300.0 |
| 2005-08-24 12:00:00 | IWM | ETF | 65.58 | 65.82 | 65.48 | 65.8 | 1404800.0 |
| 2005-08-24 12:30:00 | IWM | ETF | 65.81 | 65.99 | 65.78 | 65.98 | 2574000.0 |
| 2005-08-24 13:00:00 | IWM | ETF | 65.99 | 66.01 | 65.87 | 65.91 | 895300.0 |
| 2005-08-24 13:30:00 | IWM | ETF | 65.92 | 65.98 | 65.78 | 65.88 | 1320200.0 |
> showing 50 of 1,641 rows — these rows as CSV