PREVIEW / etf_30min / 2005-02-16
file: by_date/etf_30min/2005/2005-02-16.parquet size: 42 KB rows: 1,461
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-02-16 08:00:00 | SPY | ETF | 121.02 | 121.04 | 120.79 | 120.79 | 97400.0 |
| 2005-02-16 08:30:00 | SPY | ETF | 120.84 | 120.89 | 120.48 | 120.72 | 1107200.0 |
| 2005-02-16 09:00:00 | SPY | ETF | 120.73 | 120.97 | 120.73 | 120.93 | 799200.0 |
| 2005-02-16 09:30:00 | SPY | ETF | 120.93 | 120.95 | 120.77 | 120.85 | 5587900.0 |
| 2005-02-16 10:00:00 | SPY | ETF | 120.84 | 121.13 | 120.67 | 120.98 | 7669000.0 |
| 2005-02-16 10:30:00 | SPY | ETF | 121.0 | 121.05 | 120.76 | 120.87 | 2778400.0 |
| 2005-02-16 11:00:00 | SPY | ETF | 120.87 | 121.01 | 120.82 | 121.0 | 2443000.0 |
| 2005-02-16 11:30:00 | SPY | ETF | 120.98 | 120.99 | 120.83 | 120.87 | 1345700.0 |
| 2005-02-16 12:00:00 | SPY | ETF | 120.87 | 120.88 | 120.77 | 120.86 | 5397700.0 |
| 2005-02-16 12:30:00 | SPY | ETF | 120.86 | 120.96 | 120.83 | 120.86 | 1562200.0 |
| 2005-02-16 13:00:00 | SPY | ETF | 120.86 | 120.98 | 120.8 | 120.89 | 2305500.0 |
| 2005-02-16 13:30:00 | SPY | ETF | 120.89 | 121.05 | 120.76 | 120.9 | 2866700.0 |
| 2005-02-16 14:00:00 | SPY | ETF | 120.9 | 121.05 | 120.9 | 121.04 | 1568200.0 |
| 2005-02-16 14:30:00 | SPY | ETF | 121.04 | 121.42 | 120.97 | 121.39 | 5045800.0 |
| 2005-02-16 15:00:00 | SPY | ETF | 121.39 | 121.46 | 121.24 | 121.29 | 4150100.0 |
| 2005-02-16 15:30:00 | SPY | ETF | 121.28 | 121.3 | 121.16 | 121.19 | 4766300.0 |
| 2005-02-16 16:00:00 | SPY | ETF | 121.19 | 121.26 | 121.12 | 121.24 | 410900.0 |
| 2005-02-16 16:30:00 | SPY | ETF | 121.22 | 121.24 | 121.08 | 121.15 | 254200.0 |
| 2005-02-16 17:00:00 | SPY | ETF | 121.15 | 121.22 | 121.15 | 121.17 | 26200.0 |
| 2005-02-16 17:30:00 | SPY | ETF | 121.19 | 121.2 | 121.19 | 121.2 | 259100.0 |
| 2005-02-16 18:00:00 | SPY | ETF | 121.19 | 121.19 | 121.15 | 121.15 | 5900.0 |
| 2005-02-16 18:30:00 | SPY | ETF | 121.14 | 121.14 | 121.14 | 121.14 | 100.0 |
| 2005-02-16 19:30:00 | SPY | ETF | 121.19 | 121.23 | 121.19 | 121.23 | 6700.0 |
| 2005-02-16 09:30:00 | QQQ | ETF | 38.03 | 38.05 | 37.87 | 37.95 | 9447400.0 |
| 2005-02-16 10:00:00 | QQQ | ETF | 37.95 | 38.16 | 37.9 | 38.08 | 10640900.0 |
| 2005-02-16 10:30:00 | QQQ | ETF | 38.08 | 38.11 | 37.95 | 38.03 | 5223200.0 |
| 2005-02-16 11:00:00 | QQQ | ETF | 38.03 | 38.14 | 38.0 | 38.11 | 4314900.0 |
| 2005-02-16 11:30:00 | QQQ | ETF | 38.11 | 38.11 | 38.01 | 38.02 | 2004800.0 |
| 2005-02-16 12:00:00 | QQQ | ETF | 38.02 | 38.03 | 37.92 | 37.99 | 3268000.0 |
| 2005-02-16 12:30:00 | QQQ | ETF | 37.99 | 38.04 | 37.95 | 37.97 | 1588500.0 |
| 2005-02-16 13:00:00 | QQQ | ETF | 37.97 | 38.0 | 37.91 | 37.93 | 4993500.0 |
| 2005-02-16 13:30:00 | QQQ | ETF | 37.92 | 38.01 | 37.83 | 37.96 | 6983400.0 |
| 2005-02-16 14:00:00 | QQQ | ETF | 37.96 | 38.05 | 37.96 | 38.01 | 4492900.0 |
| 2005-02-16 14:30:00 | QQQ | ETF | 38.01 | 38.12 | 37.98 | 38.11 | 6135100.0 |
| 2005-02-16 15:00:00 | QQQ | ETF | 38.11 | 38.14 | 38.01 | 38.04 | 4833000.0 |
| 2005-02-16 15:30:00 | QQQ | ETF | 38.04 | 38.05 | 37.95 | 37.98 | 5066800.0 |
| 2005-02-16 08:00:00 | IWM | ETF | 63.1 | 63.1 | 63.075 | 63.075 | 13800.0 |
| 2005-02-16 08:30:00 | IWM | ETF | 63.06 | 63.06 | 62.87 | 62.96 | 95200.0 |
| 2005-02-16 09:00:00 | IWM | ETF | 63.15 | 63.16 | 63.07 | 63.125 | 60800.0 |
| 2005-02-16 09:30:00 | IWM | ETF | 63.2 | 63.225 | 63.0 | 63.085 | 1623400.0 |
| 2005-02-16 10:00:00 | IWM | ETF | 63.1 | 63.36 | 62.98 | 63.295 | 2353400.0 |
| 2005-02-16 10:30:00 | IWM | ETF | 63.295 | 63.325 | 62.975 | 63.17 | 1284000.0 |
| 2005-02-16 11:00:00 | IWM | ETF | 63.16 | 63.295 | 63.125 | 63.295 | 594800.0 |
| 2005-02-16 11:30:00 | IWM | ETF | 63.3 | 63.34 | 63.23 | 63.31 | 468200.0 |
| 2005-02-16 12:00:00 | IWM | ETF | 63.305 | 63.305 | 63.17 | 63.28 | 591800.0 |
| 2005-02-16 12:30:00 | IWM | ETF | 63.285 | 63.5 | 63.25 | 63.395 | 799000.0 |
| 2005-02-16 13:00:00 | IWM | ETF | 63.4 | 63.445 | 63.28 | 63.32 | 824400.0 |
| 2005-02-16 13:30:00 | IWM | ETF | 63.32 | 63.45 | 63.2 | 63.38 | 564000.0 |
| 2005-02-16 14:00:00 | IWM | ETF | 63.395 | 63.585 | 63.375 | 63.54 | 1282200.0 |
| 2005-02-16 14:30:00 | IWM | ETF | 63.54 | 63.85 | 63.535 | 63.825 | 2352200.0 |
> showing 50 of 1,461 rows — these rows as CSV