PREVIEW / etf_30min / 2004-05-10
file: by_date/etf_30min/2004/2004-05-10.parquet size: 40 KB rows: 1,266
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-05-10 08:00:00 | SPY | ETF | 109.16 | 109.35 | 109.11 | 109.32 | 49400.0 |
| 2004-05-10 08:30:00 | SPY | ETF | 109.29 | 109.33 | 109.2 | 109.33 | 123600.0 |
| 2004-05-10 09:00:00 | SPY | ETF | 109.32 | 109.49 | 109.29 | 109.42 | 62700.0 |
| 2004-05-10 09:30:00 | SPY | ETF | 109.44 | 109.79 | 109.18 | 109.27 | 8783800.0 |
| 2004-05-10 10:00:00 | SPY | ETF | 109.29 | 109.4 | 108.7 | 109.125 | 7023900.0 |
| 2004-05-10 10:30:00 | SPY | ETF | 109.1 | 109.17 | 108.61 | 108.95 | 4961500.0 |
| 2004-05-10 11:00:00 | SPY | ETF | 108.97 | 108.99 | 108.42 | 108.57 | 4443100.0 |
| 2004-05-10 11:30:00 | SPY | ETF | 108.53 | 108.89 | 108.36 | 108.75 | 5470000.0 |
| 2004-05-10 12:00:00 | SPY | ETF | 108.77 | 109.04 | 108.7 | 108.97 | 2804400.0 |
| 2004-05-10 12:30:00 | SPY | ETF | 108.97 | 109.4 | 108.92 | 109.39 | 4615100.0 |
| 2004-05-10 13:00:00 | SPY | ETF | 109.39 | 109.53 | 109.22 | 109.3 | 3545400.0 |
| 2004-05-10 13:30:00 | SPY | ETF | 109.32 | 109.36 | 108.9 | 108.96 | 2414300.0 |
| 2004-05-10 14:00:00 | SPY | ETF | 108.98 | 109.1 | 108.74 | 108.79 | 2641100.0 |
| 2004-05-10 14:30:00 | SPY | ETF | 108.79 | 108.95 | 108.57 | 108.91 | 2394000.0 |
| 2004-05-10 15:00:00 | SPY | ETF | 108.92 | 109.12 | 108.7 | 108.8 | 3777700.0 |
| 2004-05-10 15:30:00 | SPY | ETF | 108.75 | 109.2 | 108.52 | 109.13 | 4737400.0 |
| 2004-05-10 16:00:00 | SPY | ETF | 109.11 | 110.3044 | 108.83 | 108.86 | 2349400.0 |
| 2004-05-10 16:30:00 | SPY | ETF | 108.87 | 109.22 | 108.83 | 108.89 | 129200.0 |
| 2004-05-10 17:00:00 | SPY | ETF | 109.17 | 109.17 | 108.83 | 108.83 | 170900.0 |
| 2004-05-10 17:30:00 | SPY | ETF | 108.85 | 108.87 | 108.85 | 108.85 | 10800.0 |
| 2004-05-10 18:00:00 | SPY | ETF | 108.86 | 108.88 | 108.77 | 108.81 | 28000.0 |
| 2004-05-10 18:30:00 | SPY | ETF | 108.74 | 108.87 | 108.71 | 108.8 | 29900.0 |
| 2004-05-10 19:00:00 | SPY | ETF | 108.8 | 108.82 | 108.76 | 108.8 | 11800.0 |
| 2004-05-10 19:30:00 | SPY | ETF | 108.8 | 108.81 | 108.8 | 108.8 | 2900.0 |
| 2004-05-10 08:00:00 | QQQ | ETF | 34.56 | 34.65 | 34.53 | 34.62 | 313100.0 |
| 2004-05-10 08:30:00 | QQQ | ETF | 34.62 | 34.62 | 34.57 | 34.61 | 169600.0 |
| 2004-05-10 09:00:00 | QQQ | ETF | 34.61 | 34.72 | 34.61 | 34.67 | 508600.0 |
| 2004-05-10 09:30:00 | QQQ | ETF | 34.67 | 34.9 | 34.57 | 34.7 | 21162700.0 |
| 2004-05-10 10:00:00 | QQQ | ETF | 34.696 | 34.78 | 34.51 | 34.7 | 15667400.0 |
| 2004-05-10 10:30:00 | QQQ | ETF | 34.701 | 34.71 | 34.51 | 34.61 | 10142000.0 |
| 2004-05-10 11:00:00 | QQQ | ETF | 34.62 | 34.62 | 34.43 | 34.5 | 10880800.0 |
| 2004-05-10 11:30:00 | QQQ | ETF | 34.49 | 34.68 | 34.42 | 34.58 | 12448600.0 |
| 2004-05-10 12:00:00 | QQQ | ETF | 34.58 | 34.7 | 34.517 | 34.68 | 4224800.0 |
| 2004-05-10 12:30:00 | QQQ | ETF | 34.689 | 34.8 | 34.62 | 34.78 | 9507000.0 |
| 2004-05-10 13:00:00 | QQQ | ETF | 34.784 | 34.9 | 34.73 | 34.8 | 12747400.0 |
| 2004-05-10 13:30:00 | QQQ | ETF | 34.8 | 34.83 | 34.63 | 34.66 | 5169300.0 |
| 2004-05-10 14:00:00 | QQQ | ETF | 34.654 | 34.76 | 34.63 | 34.651 | 4684800.0 |
| 2004-05-10 14:30:00 | QQQ | ETF | 34.651 | 34.71 | 34.55 | 34.67 | 5589000.0 |
| 2004-05-10 15:00:00 | QQQ | ETF | 34.668 | 34.75 | 34.56 | 34.59 | 7770800.0 |
| 2004-05-10 15:30:00 | QQQ | ETF | 34.59 | 34.77 | 34.5 | 34.747 | 12446900.0 |
| 2004-05-10 16:00:00 | QQQ | ETF | 34.748 | 34.77 | 34.656 | 34.671 | 2383100.0 |
| 2004-05-10 16:30:00 | QQQ | ETF | 34.662 | 34.7 | 34.64 | 34.7 | 317300.0 |
| 2004-05-10 17:00:00 | QQQ | ETF | 34.699 | 34.72 | 34.673 | 34.7 | 77800.0 |
| 2004-05-10 17:30:00 | QQQ | ETF | 34.7 | 34.72 | 34.69 | 34.71 | 8600.0 |
| 2004-05-10 18:00:00 | QQQ | ETF | 34.71 | 34.71 | 34.651 | 34.68 | 139200.0 |
| 2004-05-10 18:30:00 | QQQ | ETF | 34.68 | 34.69 | 34.66 | 34.66 | 23400.0 |
| 2004-05-10 19:00:00 | QQQ | ETF | 34.67 | 34.68 | 34.66 | 34.66 | 28800.0 |
| 2004-05-10 19:30:00 | QQQ | ETF | 34.68 | 34.69 | 34.67 | 34.67 | 12300.0 |
| 2004-05-10 08:00:00 | IWM | ETF | 53.855 | 53.855 | 53.84 | 53.84 | 2200.0 |
| 2004-05-10 08:30:00 | IWM | ETF | 53.935 | 53.935 | 53.85 | 53.865 | 3000.0 |
> showing 50 of 1,266 rows — these rows as CSV