PREVIEW / etf_30min / 2004-06-15
file: by_date/etf_30min/2004/2004-06-15.parquet size: 36 KB rows: 1,173
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-06-15 08:00:00 | SPY | ETF | 113.51 | 113.6 | 113.45 | 113.55 | 61200.0 |
| 2004-06-15 08:30:00 | SPY | ETF | 113.62 | 114.08 | 113.53 | 113.91 | 362900.0 |
| 2004-06-15 09:00:00 | SPY | ETF | 113.91 | 113.98 | 113.88 | 113.91 | 91200.0 |
| 2004-06-15 09:30:00 | SPY | ETF | 113.9 | 114.16 | 113.9 | 113.92 | 5076200.0 |
| 2004-06-15 10:00:00 | SPY | ETF | 113.92 | 114.27 | 113.9 | 114.18 | 2582200.0 |
| 2004-06-15 10:30:00 | SPY | ETF | 114.17 | 114.25 | 114.02 | 114.03 | 1342600.0 |
| 2004-06-15 11:00:00 | SPY | ETF | 114.04 | 114.17 | 113.98 | 114.07 | 1277300.0 |
| 2004-06-15 11:30:00 | SPY | ETF | 114.07 | 114.28 | 114.06 | 114.18 | 1594400.0 |
| 2004-06-15 12:00:00 | SPY | ETF | 114.19 | 114.29 | 114.14 | 114.21 | 1441500.0 |
| 2004-06-15 12:30:00 | SPY | ETF | 114.22 | 114.445 | 114.21 | 114.36 | 2703500.0 |
| 2004-06-15 13:00:00 | SPY | ETF | 114.36 | 114.43 | 114.2 | 114.26 | 2679200.0 |
| 2004-06-15 13:30:00 | SPY | ETF | 114.26 | 114.33 | 114.19 | 114.28 | 1281200.0 |
| 2004-06-15 14:00:00 | SPY | ETF | 114.28 | 114.32 | 114.06 | 114.13 | 2195700.0 |
| 2004-06-15 14:30:00 | SPY | ETF | 114.14 | 114.23 | 113.98 | 114.01 | 1482000.0 |
| 2004-06-15 15:00:00 | SPY | ETF | 114.01 | 114.1 | 113.51 | 113.75 | 5405000.0 |
| 2004-06-15 15:30:00 | SPY | ETF | 113.75 | 113.96 | 113.59 | 113.95 | 4261700.0 |
| 2004-06-15 16:00:00 | SPY | ETF | 113.95 | 114.06 | 113.87 | 113.98 | 1726600.0 |
| 2004-06-15 16:30:00 | SPY | ETF | 113.99 | 114.0 | 113.9 | 113.92 | 106500.0 |
| 2004-06-15 17:00:00 | SPY | ETF | 113.92 | 113.94 | 113.92 | 113.93 | 1900.0 |
| 2004-06-15 17:30:00 | SPY | ETF | 113.95 | 113.95 | 113.95 | 113.95 | 500.0 |
| 2004-06-15 18:00:00 | SPY | ETF | 113.95 | 113.95 | 113.95 | 113.95 | 500.0 |
| 2004-06-15 19:30:00 | SPY | ETF | 113.92 | 113.92 | 113.92 | 113.92 | 100.0 |
| 2004-06-15 08:00:00 | QQQ | ETF | 36.43 | 36.45 | 36.36 | 36.36 | 156300.0 |
| 2004-06-15 08:30:00 | QQQ | ETF | 36.39 | 36.65 | 36.38 | 36.6 | 983200.0 |
| 2004-06-15 09:00:00 | QQQ | ETF | 36.6 | 36.62 | 36.54 | 36.56 | 486300.0 |
| 2004-06-15 09:30:00 | QQQ | ETF | 36.56 | 36.75 | 36.56 | 36.63 | 11950700.0 |
| 2004-06-15 10:00:00 | QQQ | ETF | 36.63 | 36.77 | 36.61 | 36.706 | 5737200.0 |
| 2004-06-15 10:30:00 | QQQ | ETF | 36.71 | 36.77 | 36.7 | 36.71 | 3119000.0 |
| 2004-06-15 11:00:00 | QQQ | ETF | 36.71 | 36.78 | 36.69 | 36.72 | 4245200.0 |
| 2004-06-15 11:30:00 | QQQ | ETF | 36.72 | 36.83 | 36.71 | 36.78 | 5797700.0 |
| 2004-06-15 12:00:00 | QQQ | ETF | 36.79 | 36.83 | 36.77 | 36.79 | 1858400.0 |
| 2004-06-15 12:30:00 | QQQ | ETF | 36.78 | 36.974 | 36.78 | 36.94 | 8349800.0 |
| 2004-06-15 13:00:00 | QQQ | ETF | 36.949 | 36.98 | 36.89 | 36.93 | 5309200.0 |
| 2004-06-15 13:30:00 | QQQ | ETF | 36.92 | 36.97 | 36.91 | 36.96 | 3815500.0 |
| 2004-06-15 14:00:00 | QQQ | ETF | 36.96 | 36.99 | 36.86 | 36.877 | 5038000.0 |
| 2004-06-15 14:30:00 | QQQ | ETF | 36.877 | 36.96 | 36.8 | 36.83 | 5418400.0 |
| 2004-06-15 15:00:00 | QQQ | ETF | 36.823 | 36.86 | 36.64 | 36.756 | 12273000.0 |
| 2004-06-15 15:30:00 | QQQ | ETF | 36.76 | 36.853 | 36.7 | 36.84 | 11099800.0 |
| 2004-06-15 16:00:00 | QQQ | ETF | 36.84 | 36.86 | 36.77 | 36.81 | 3965500.0 |
| 2004-06-15 16:30:00 | QQQ | ETF | 36.8 | 36.8 | 36.74 | 36.742 | 147400.0 |
| 2004-06-15 17:00:00 | QQQ | ETF | 36.75 | 36.75 | 36.73 | 36.745 | 116900.0 |
| 2004-06-15 17:30:00 | QQQ | ETF | 36.76 | 36.79 | 36.76 | 36.79 | 30900.0 |
| 2004-06-15 18:00:00 | QQQ | ETF | 36.78 | 36.79 | 36.77 | 36.79 | 15300.0 |
| 2004-06-15 18:30:00 | QQQ | ETF | 36.79 | 36.79 | 36.79 | 36.79 | 2400.0 |
| 2004-06-15 19:00:00 | QQQ | ETF | 36.79 | 36.79 | 36.79 | 36.79 | 500.0 |
| 2004-06-15 19:30:00 | QQQ | ETF | 36.8 | 36.8 | 36.78 | 36.8 | 11600.0 |
| 2004-06-15 08:00:00 | IWM | ETF | 55.82 | 55.82 | 55.82 | 55.82 | 1000.0 |
| 2004-06-15 08:30:00 | IWM | ETF | 56.07 | 56.18 | 56.065 | 56.135 | 29200.0 |
| 2004-06-15 09:00:00 | IWM | ETF | 56.155 | 56.185 | 56.065 | 56.08 | 17800.0 |
| 2004-06-15 09:30:00 | IWM | ETF | 56.105 | 56.465 | 56.105 | 56.295 | 2116600.0 |
> showing 50 of 1,173 rows — these rows as CSV