PREVIEW / etf_30min / 2005-05-11
file: by_date/etf_30min/2005/2005-05-11.parquet size: 44 KB rows: 1,459
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-05-11 05:00:00 | SPY | ETF | 117.06 | 117.06 | 116.99 | 116.99 | 500.0 |
| 2005-05-11 06:30:00 | SPY | ETF | 117.01 | 117.01 | 117.01 | 117.01 | 2000.0 |
| 2005-05-11 07:00:00 | SPY | ETF | 116.9 | 116.97 | 116.9 | 116.97 | 29800.0 |
| 2005-05-11 07:30:00 | SPY | ETF | 116.96 | 116.96 | 116.86 | 116.87 | 161100.0 |
| 2005-05-11 08:00:00 | SPY | ETF | 116.8 | 116.9 | 116.77 | 116.83 | 151500.0 |
| 2005-05-11 08:30:00 | SPY | ETF | 116.85 | 117.01 | 116.8 | 116.96 | 352200.0 |
| 2005-05-11 09:00:00 | SPY | ETF | 116.96 | 116.99 | 116.87 | 116.92 | 277500.0 |
| 2005-05-11 09:30:00 | SPY | ETF | 116.93 | 117.01 | 116.66 | 116.71 | 9720400.0 |
| 2005-05-11 10:00:00 | SPY | ETF | 116.69 | 116.77 | 116.48 | 116.63 | 7462700.0 |
| 2005-05-11 10:30:00 | SPY | ETF | 116.63 | 116.84 | 116.26 | 116.36 | 10603100.0 |
| 2005-05-11 11:00:00 | SPY | ETF | 116.36 | 116.42 | 116.14 | 116.32 | 5937700.0 |
| 2005-05-11 11:30:00 | SPY | ETF | 116.31 | 116.5567 | 116.3 | 116.38 | 5078400.0 |
| 2005-05-11 12:00:00 | SPY | ETF | 116.38 | 116.6 | 115.85 | 116.42 | 21576500.0 |
| 2005-05-11 12:30:00 | SPY | ETF | 116.4 | 116.55 | 116.38 | 116.52 | 2104100.0 |
| 2005-05-11 13:00:00 | SPY | ETF | 116.52 | 116.9 | 116.5 | 116.761 | 4185100.0 |
| 2005-05-11 13:30:00 | SPY | ETF | 116.76 | 116.83 | 116.52 | 116.64 | 2256600.0 |
| 2005-05-11 14:00:00 | SPY | ETF | 116.64 | 117.38 | 116.62 | 117.15 | 8252800.0 |
| 2005-05-11 14:30:00 | SPY | ETF | 117.16 | 117.34 | 117.1 | 117.16 | 2467300.0 |
| 2005-05-11 15:00:00 | SPY | ETF | 117.16 | 117.34 | 116.98 | 117.23 | 3986200.0 |
| 2005-05-11 15:30:00 | SPY | ETF | 117.23 | 117.4 | 117.19 | 117.2 | 4912200.0 |
| 2005-05-11 16:00:00 | SPY | ETF | 117.24 | 117.33 | 116.4738 | 117.25 | 468000.0 |
| 2005-05-11 16:30:00 | SPY | ETF | 117.25 | 117.31 | 117.23 | 117.3 | 176800.0 |
| 2005-05-11 17:00:00 | SPY | ETF | 117.3 | 117.31 | 117.3 | 117.3 | 175800.0 |
| 2005-05-11 17:30:00 | SPY | ETF | 117.32 | 117.32 | 117.32 | 117.32 | 100.0 |
| 2005-05-11 18:00:00 | SPY | ETF | 117.28 | 117.3 | 117.25 | 117.25 | 1300.0 |
| 2005-05-11 18:30:00 | SPY | ETF | 117.25 | 117.26 | 117.25 | 117.26 | 500.0 |
| 2005-05-11 19:00:00 | SPY | ETF | 117.25 | 117.25 | 117.24 | 117.24 | 2000.0 |
| 2005-05-11 19:30:00 | SPY | ETF | 117.24 | 117.3 | 117.22 | 117.3 | 29500.0 |
| 2005-05-11 09:30:00 | QQQ | ETF | 35.82 | 35.89 | 35.71 | 35.72 | 10351200.0 |
| 2005-05-11 10:00:00 | QQQ | ETF | 35.72 | 35.75 | 35.66 | 35.7 | 6714800.0 |
| 2005-05-11 10:30:00 | QQQ | ETF | 35.7 | 35.78 | 35.47 | 35.5 | 17247200.0 |
| 2005-05-11 11:00:00 | QQQ | ETF | 35.5 | 35.52 | 35.37 | 35.46 | 9637400.0 |
| 2005-05-11 11:30:00 | QQQ | ETF | 35.46 | 35.52 | 35.43 | 35.48 | 5353700.0 |
| 2005-05-11 12:00:00 | QQQ | ETF | 35.48 | 35.55 | 35.3 | 35.5 | 17781000.0 |
| 2005-05-11 12:30:00 | QQQ | ETF | 35.5 | 35.55 | 35.47 | 35.54 | 2355300.0 |
| 2005-05-11 13:00:00 | QQQ | ETF | 35.54 | 35.68 | 35.52 | 35.62 | 6838200.0 |
| 2005-05-11 13:30:00 | QQQ | ETF | 35.62 | 35.67 | 35.56 | 35.63 | 3463100.0 |
| 2005-05-11 14:00:00 | QQQ | ETF | 35.63 | 36.03 | 35.62 | 35.95 | 19800500.0 |
| 2005-05-11 14:30:00 | QQQ | ETF | 35.95 | 35.98 | 35.87 | 35.88 | 5837100.0 |
| 2005-05-11 15:00:00 | QQQ | ETF | 35.87 | 35.94 | 35.82 | 35.9 | 7226400.0 |
| 2005-05-11 15:30:00 | QQQ | ETF | 35.9 | 35.99 | 35.88 | 35.95 | 10650800.0 |
| 2005-05-11 07:00:00 | IWM | ETF | 59.395 | 59.395 | 59.395 | 59.395 | 1000.0 |
| 2005-05-11 08:00:00 | IWM | ETF | 59.375 | 59.375 | 59.375 | 59.375 | 1800.0 |
| 2005-05-11 08:30:00 | IWM | ETF | 59.375 | 59.45 | 59.335 | 59.375 | 134000.0 |
| 2005-05-11 09:00:00 | IWM | ETF | 59.375 | 59.375 | 59.355 | 59.355 | 18200.0 |
| 2005-05-11 09:30:00 | IWM | ETF | 59.375 | 59.42 | 59.05 | 59.06 | 4192800.0 |
| 2005-05-11 10:00:00 | IWM | ETF | 59.065 | 59.105 | 58.75 | 58.825 | 4214400.0 |
| 2005-05-11 10:30:00 | IWM | ETF | 58.825 | 59.105 | 58.655 | 58.71 | 3125000.0 |
| 2005-05-11 11:00:00 | IWM | ETF | 58.71 | 58.78 | 58.55 | 58.705 | 1882800.0 |
| 2005-05-11 11:30:00 | IWM | ETF | 58.7 | 58.82 | 58.69 | 58.705 | 1218000.0 |
> showing 50 of 1,459 rows — these rows as CSV