PREVIEW / etf_30min / 2005-12-01
file: by_date/etf_30min/2005/2005-12-01.parquet size: 58 KB rows: 2,035
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-12-01 04:00:00 | SPY | ETF | 125.9 | 125.9 | 125.9 | 125.9 | 500.0 |
| 2005-12-01 06:00:00 | SPY | ETF | 125.94 | 125.99 | 125.94 | 125.99 | 50000.0 |
| 2005-12-01 06:30:00 | SPY | ETF | 125.96 | 125.98 | 125.95 | 125.95 | 6600.0 |
| 2005-12-01 07:00:00 | SPY | ETF | 125.99 | 126.09 | 125.93 | 126.09 | 86500.0 |
| 2005-12-01 07:30:00 | SPY | ETF | 126.05 | 126.1 | 125.91 | 125.95 | 28400.0 |
| 2005-12-01 08:00:00 | SPY | ETF | 125.41 | 126.09 | 125.41 | 125.92 | 1594000.0 |
| 2005-12-01 08:30:00 | SPY | ETF | 125.9 | 126.04 | 125.9 | 126.01 | 1423200.0 |
| 2005-12-01 09:00:00 | SPY | ETF | 126.01 | 126.03 | 125.41 | 126.01 | 522800.0 |
| 2005-12-01 09:30:00 | SPY | ETF | 126.02 | 126.45 | 125.98 | 126.32 | 9064600.0 |
| 2005-12-01 10:00:00 | SPY | ETF | 126.3301 | 126.49 | 126.22 | 126.28 | 5374200.0 |
| 2005-12-01 10:30:00 | SPY | ETF | 126.28 | 126.53 | 126.17 | 126.48 | 5038300.0 |
| 2005-12-01 11:00:00 | SPY | ETF | 126.5 | 126.58 | 126.36 | 126.4 | 6647700.0 |
| 2005-12-01 11:30:00 | SPY | ETF | 126.41 | 126.58 | 126.37 | 126.52 | 3432000.0 |
| 2005-12-01 12:00:00 | SPY | ETF | 126.51 | 126.65 | 126.5 | 126.58 | 3357100.0 |
| 2005-12-01 12:30:00 | SPY | ETF | 126.59 | 126.84 | 126.56 | 126.78 | 3723900.0 |
| 2005-12-01 13:00:00 | SPY | ETF | 126.78 | 126.99 | 126.71 | 126.96 | 4251300.0 |
| 2005-12-01 13:30:00 | SPY | ETF | 126.96 | 127.03 | 126.77 | 126.84 | 4512400.0 |
| 2005-12-01 14:00:00 | SPY | ETF | 126.83 | 126.88 | 126.73 | 126.83 | 2339400.0 |
| 2005-12-01 14:30:00 | SPY | ETF | 126.83 | 126.92 | 126.72 | 126.84 | 2088400.0 |
| 2005-12-01 15:00:00 | SPY | ETF | 126.84 | 126.99 | 126.82 | 126.85 | 3623400.0 |
| 2005-12-01 15:30:00 | SPY | ETF | 126.85 | 126.99 | 126.76 | 126.91 | 5060700.0 |
| 2005-12-01 16:00:00 | SPY | ETF | 126.91 | 126.91 | 126.69 | 126.77 | 1084100.0 |
| 2005-12-01 16:30:00 | SPY | ETF | 126.74 | 126.78 | 125.41 | 126.75 | 31700.0 |
| 2005-12-01 17:00:00 | SPY | ETF | 126.74 | 126.75 | 126.65 | 126.72 | 236000.0 |
| 2005-12-01 17:30:00 | SPY | ETF | 126.03 | 126.72 | 126.03 | 126.67 | 9500.0 |
| 2005-12-01 18:00:00 | SPY | ETF | 126.69 | 126.72 | 126.67 | 126.72 | 10200.0 |
| 2005-12-01 18:30:00 | SPY | ETF | 126.74 | 126.74 | 126.74 | 126.74 | 8000.0 |
| 2005-12-01 19:00:00 | SPY | ETF | 126.74 | 126.74 | 126.74 | 126.74 | 6800.0 |
| 2005-12-01 09:30:00 | QQQ | ETF | 41.53 | 41.8 | 41.5 | 41.72 | 12766200.0 |
| 2005-12-01 10:00:00 | QQQ | ETF | 41.73 | 41.87 | 41.72 | 41.78 | 10277200.0 |
| 2005-12-01 10:30:00 | QQQ | ETF | 41.78 | 41.82 | 41.72 | 41.79 | 7924800.0 |
| 2005-12-01 11:00:00 | QQQ | ETF | 41.8 | 41.86 | 41.73 | 41.74 | 9959500.0 |
| 2005-12-01 11:30:00 | QQQ | ETF | 41.75 | 41.82 | 41.74 | 41.79 | 3059900.0 |
| 2005-12-01 12:00:00 | QQQ | ETF | 41.79 | 41.86 | 41.79 | 41.82 | 2450400.0 |
| 2005-12-01 12:30:00 | QQQ | ETF | 41.82 | 41.94 | 41.81 | 41.94 | 5336100.0 |
| 2005-12-01 13:00:00 | QQQ | ETF | 41.94 | 42.0 | 41.91 | 41.98 | 4914100.0 |
| 2005-12-01 13:30:00 | QQQ | ETF | 41.99 | 42.02 | 41.9 | 41.93 | 3745400.0 |
| 2005-12-01 14:00:00 | QQQ | ETF | 41.93 | 41.98 | 41.89 | 41.92 | 2472200.0 |
| 2005-12-01 14:30:00 | QQQ | ETF | 41.91 | 41.95 | 41.85 | 41.93 | 3551200.0 |
| 2005-12-01 15:00:00 | QQQ | ETF | 41.93 | 42.01 | 41.93 | 41.96 | 4717000.0 |
| 2005-12-01 15:30:00 | QQQ | ETF | 41.97 | 42.05 | 41.94 | 42.01 | 10476000.0 |
| 2005-12-01 07:30:00 | IWM | ETF | 67.7 | 67.7 | 67.7 | 67.7 | 1000.0 |
| 2005-12-01 08:00:00 | IWM | ETF | 67.45 | 67.82 | 67.45 | 67.74 | 174200.0 |
| 2005-12-01 08:30:00 | IWM | ETF | 67.73 | 67.82 | 67.71 | 67.82 | 36500.0 |
| 2005-12-01 09:00:00 | IWM | ETF | 67.8 | 67.86 | 67.45 | 67.8 | 301400.0 |
| 2005-12-01 09:30:00 | IWM | ETF | 67.79 | 68.29 | 67.71 | 68.2399 | 4607600.0 |
| 2005-12-01 10:00:00 | IWM | ETF | 68.24 | 68.33 | 68.16 | 68.21 | 3586300.0 |
| 2005-12-01 10:30:00 | IWM | ETF | 68.23 | 68.41 | 68.11 | 68.34 | 2682800.0 |
| 2005-12-01 11:00:00 | IWM | ETF | 68.35 | 68.48 | 68.25 | 68.28 | 3266200.0 |
| 2005-12-01 11:30:00 | IWM | ETF | 68.27 | 68.42 | 68.27 | 68.37 | 912800.0 |
> showing 50 of 2,035 rows — these rows as CSV