PREVIEW / etf_30min / 2005-11-16
file: by_date/etf_30min/2005/2005-11-16.parquet size: 49 KB rows: 1,765
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-11-16 07:00:00 | SPY | ETF | 123.16 | 123.16 | 123.16 | 123.16 | 500.0 |
| 2005-11-16 07:30:00 | SPY | ETF | 123.26 | 123.26 | 123.26 | 123.26 | 400.0 |
| 2005-11-16 08:00:00 | SPY | ETF | 123.2 | 123.36 | 123.18 | 123.25 | 704900.0 |
| 2005-11-16 08:30:00 | SPY | ETF | 123.24 | 123.4 | 123.19 | 123.39 | 1296500.0 |
| 2005-11-16 09:00:00 | SPY | ETF | 123.4 | 123.45 | 123.3 | 123.39 | 734700.0 |
| 2005-11-16 09:30:00 | SPY | ETF | 123.37 | 123.55 | 123.26 | 123.32 | 6543200.0 |
| 2005-11-16 10:00:00 | SPY | ETF | 123.31 | 123.35 | 123.01 | 123.09 | 5757700.0 |
| 2005-11-16 10:30:00 | SPY | ETF | 123.09 | 123.26 | 122.99 | 123.22 | 3490200.0 |
| 2005-11-16 11:00:00 | SPY | ETF | 123.22 | 123.22 | 122.98 | 123.21 | 3490800.0 |
| 2005-11-16 11:30:00 | SPY | ETF | 123.22 | 123.43 | 123.14 | 123.35 | 4326400.0 |
| 2005-11-16 12:00:00 | SPY | ETF | 123.36 | 123.46 | 123.32 | 123.32 | 2265100.0 |
| 2005-11-16 12:30:00 | SPY | ETF | 123.32 | 123.34 | 123.2 | 123.23 | 1660700.0 |
| 2005-11-16 13:00:00 | SPY | ETF | 123.22 | 123.32 | 123.02 | 123.28 | 2209700.0 |
| 2005-11-16 13:30:00 | SPY | ETF | 123.29 | 123.32 | 123.13 | 123.21 | 2241200.0 |
| 2005-11-16 14:00:00 | SPY | ETF | 123.21 | 123.37 | 123.09 | 123.3 | 1930300.0 |
| 2005-11-16 14:30:00 | SPY | ETF | 123.29 | 123.43 | 123.07 | 123.36 | 2426500.0 |
| 2005-11-16 15:00:00 | SPY | ETF | 123.36 | 123.49 | 123.26 | 123.43 | 2672000.0 |
| 2005-11-16 15:30:00 | SPY | ETF | 123.43 | 123.49 | 123.27 | 123.46 | 4381400.0 |
| 2005-11-16 16:00:00 | SPY | ETF | 123.48 | 123.55 | 123.2797 | 123.53 | 3320600.0 |
| 2005-11-16 16:30:00 | SPY | ETF | 123.53 | 123.53 | 123.39 | 123.49 | 391000.0 |
| 2005-11-16 17:00:00 | SPY | ETF | 123.46 | 123.46 | 123.45 | 123.45 | 4500.0 |
| 2005-11-16 17:30:00 | SPY | ETF | 123.45 | 123.47 | 123.44 | 123.45 | 3800.0 |
| 2005-11-16 18:30:00 | SPY | ETF | 123.45 | 123.45 | 123.45 | 123.45 | 500.0 |
| 2005-11-16 19:00:00 | SPY | ETF | 123.44 | 123.44 | 123.44 | 123.44 | 100.0 |
| 2005-11-16 09:30:00 | QQQ | ETF | 40.64 | 40.71 | 40.63 | 40.64 | 9106900.0 |
| 2005-11-16 10:00:00 | QQQ | ETF | 40.64 | 40.66 | 40.53 | 40.6 | 6052400.0 |
| 2005-11-16 10:30:00 | QQQ | ETF | 40.59 | 40.64 | 40.55 | 40.61 | 5845100.0 |
| 2005-11-16 11:00:00 | QQQ | ETF | 40.61 | 40.63 | 40.46 | 40.59 | 7140900.0 |
| 2005-11-16 11:30:00 | QQQ | ETF | 40.6 | 40.73 | 40.56 | 40.68 | 6662000.0 |
| 2005-11-16 12:00:00 | QQQ | ETF | 40.68 | 40.7 | 40.66 | 40.67 | 2095200.0 |
| 2005-11-16 12:30:00 | QQQ | ETF | 40.67 | 40.68 | 40.61 | 40.63 | 2089500.0 |
| 2005-11-16 13:00:00 | QQQ | ETF | 40.63 | 40.65 | 40.55 | 40.64 | 3343000.0 |
| 2005-11-16 13:30:00 | QQQ | ETF | 40.64 | 40.67 | 40.6 | 40.64 | 1621600.0 |
| 2005-11-16 14:00:00 | QQQ | ETF | 40.64 | 40.67 | 40.59 | 40.65 | 2132500.0 |
| 2005-11-16 14:30:00 | QQQ | ETF | 40.64 | 40.69 | 40.57 | 40.68 | 2356900.0 |
| 2005-11-16 15:00:00 | QQQ | ETF | 40.68 | 40.72 | 40.63 | 40.71 | 7309700.0 |
| 2005-11-16 15:30:00 | QQQ | ETF | 40.72 | 40.78 | 40.68 | 40.77 | 5800200.0 |
| 2005-11-16 08:00:00 | IWM | ETF | 65.13 | 65.32 | 65.13 | 65.32 | 12200.0 |
| 2005-11-16 08:30:00 | IWM | ETF | 65.28 | 65.33 | 65.21 | 65.33 | 13900.0 |
| 2005-11-16 09:00:00 | IWM | ETF | 65.33 | 65.37 | 65.31 | 65.35 | 28600.0 |
| 2005-11-16 09:30:00 | IWM | ETF | 65.33 | 65.5 | 65.11 | 65.15 | 3046200.0 |
| 2005-11-16 10:00:00 | IWM | ETF | 65.15 | 65.17 | 64.8 | 64.89 | 3338400.0 |
| 2005-11-16 10:30:00 | IWM | ETF | 64.88 | 64.98 | 64.82 | 64.92 | 1952300.0 |
| 2005-11-16 11:00:00 | IWM | ETF | 64.92 | 64.93 | 64.58 | 64.86 | 2649900.0 |
| 2005-11-16 11:30:00 | IWM | ETF | 64.84 | 65.1 | 64.76 | 65.02 | 3444900.0 |
| 2005-11-16 12:00:00 | IWM | ETF | 65.03 | 65.19 | 65.02 | 65.1 | 1180000.0 |
| 2005-11-16 12:30:00 | IWM | ETF | 65.1 | 65.11 | 64.97 | 64.98 | 1585800.0 |
| 2005-11-16 13:00:00 | IWM | ETF | 64.97 | 65.06 | 64.78 | 65.03 | 1760100.0 |
| 2005-11-16 13:30:00 | IWM | ETF | 65.03 | 65.06 | 64.91 | 64.95 | 913900.0 |
| 2005-11-16 14:00:00 | IWM | ETF | 64.95 | 65.03 | 64.82 | 64.95 | 1269700.0 |
> showing 50 of 1,765 rows — these rows as CSV