PREVIEW / etf_30min / 2004-11-05
file: by_date/etf_30min/2004/2004-11-05.parquet size: 41 KB rows: 1,358
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-11-05 08:00:00 | SPY | ETF | 116.65 | 116.68 | 116.55 | 116.68 | 59700.0 |
| 2004-11-05 08:30:00 | SPY | ETF | 116.78 | 117.46 | 116.78 | 117.21 | 1247000.0 |
| 2004-11-05 09:00:00 | SPY | ETF | 117.23 | 117.26 | 117.04 | 117.04 | 284200.0 |
| 2004-11-05 09:30:00 | SPY | ETF | 117.05 | 117.1 | 116.79 | 117.06 | 10010200.0 |
| 2004-11-05 10:00:00 | SPY | ETF | 117.05 | 117.57 | 116.96 | 117.54 | 6456100.0 |
| 2004-11-05 10:30:00 | SPY | ETF | 117.57 | 117.64 | 117.21 | 117.25 | 5297000.0 |
| 2004-11-05 11:00:00 | SPY | ETF | 117.26 | 117.28 | 116.62 | 116.75 | 8067000.0 |
| 2004-11-05 11:30:00 | SPY | ETF | 116.75 | 116.93 | 116.49 | 116.68 | 5449000.0 |
| 2004-11-05 12:00:00 | SPY | ETF | 116.67 | 117.0 | 116.55 | 117.0 | 3471600.0 |
| 2004-11-05 12:30:00 | SPY | ETF | 117.0 | 117.17 | 116.9 | 117.14 | 2419000.0 |
| 2004-11-05 13:00:00 | SPY | ETF | 117.14 | 117.18 | 116.89 | 117.15 | 2994600.0 |
| 2004-11-05 13:30:00 | SPY | ETF | 117.14 | 117.24 | 116.89 | 117.0 | 1879800.0 |
| 2004-11-05 14:00:00 | SPY | ETF | 117.01 | 117.07 | 116.78 | 116.78 | 1650300.0 |
| 2004-11-05 14:30:00 | SPY | ETF | 116.79 | 117.02 | 116.74 | 116.94 | 2287800.0 |
| 2004-11-05 15:00:00 | SPY | ETF | 116.94 | 117.13 | 116.77 | 117.02 | 2777000.0 |
| 2004-11-05 15:30:00 | SPY | ETF | 117.03 | 117.24 | 117.0 | 117.1 | 3609300.0 |
| 2004-11-05 16:00:00 | SPY | ETF | 117.09 | 117.28 | 117.04 | 117.23 | 2378400.0 |
| 2004-11-05 16:30:00 | SPY | ETF | 117.23 | 117.28 | 117.21 | 117.28 | 3700.0 |
| 2004-11-05 17:00:00 | SPY | ETF | 117.3 | 117.3 | 117.19 | 117.19 | 11500.0 |
| 2004-11-05 17:30:00 | SPY | ETF | 117.19 | 117.27 | 117.19 | 117.27 | 8900.0 |
| 2004-11-05 18:00:00 | SPY | ETF | 117.29 | 117.3 | 117.25 | 117.25 | 2000.0 |
| 2004-11-05 19:30:00 | SPY | ETF | 117.27 | 117.27 | 117.27 | 117.27 | 200.0 |
| 2004-11-05 08:00:00 | QQQ | ETF | 37.78 | 37.79 | 37.73 | 37.78 | 496100.0 |
| 2004-11-05 08:30:00 | QQQ | ETF | 37.8 | 38.17 | 37.8 | 38.07 | 3055400.0 |
| 2004-11-05 09:00:00 | QQQ | ETF | 38.05 | 38.09 | 38.0 | 38.03 | 918100.0 |
| 2004-11-05 09:30:00 | QQQ | ETF | 38.02 | 38.06 | 37.8 | 38.018 | 17144900.0 |
| 2004-11-05 10:00:00 | QQQ | ETF | 38.02 | 38.15 | 37.95 | 38.14 | 10646500.0 |
| 2004-11-05 10:30:00 | QQQ | ETF | 38.14 | 38.16 | 37.96 | 37.97 | 9679200.0 |
| 2004-11-05 11:00:00 | QQQ | ETF | 37.97 | 37.99 | 37.72 | 37.791 | 11868100.0 |
| 2004-11-05 11:30:00 | QQQ | ETF | 37.79 | 37.86 | 37.61 | 37.68 | 10889200.0 |
| 2004-11-05 12:00:00 | QQQ | ETF | 37.665 | 37.85 | 37.63 | 37.85 | 7231100.0 |
| 2004-11-05 12:30:00 | QQQ | ETF | 37.841 | 37.91 | 37.8 | 37.88 | 4557000.0 |
| 2004-11-05 13:00:00 | QQQ | ETF | 37.88 | 37.92 | 37.79 | 37.88 | 4468800.0 |
| 2004-11-05 13:30:00 | QQQ | ETF | 37.875 | 37.91 | 37.81 | 37.85 | 4355400.0 |
| 2004-11-05 14:00:00 | QQQ | ETF | 37.85 | 37.87 | 37.68 | 37.68 | 5768300.0 |
| 2004-11-05 14:30:00 | QQQ | ETF | 37.69 | 37.85 | 37.67 | 37.83 | 6054900.0 |
| 2004-11-05 15:00:00 | QQQ | ETF | 37.83 | 37.92 | 37.77 | 37.89 | 6261500.0 |
| 2004-11-05 15:30:00 | QQQ | ETF | 37.88 | 37.98 | 37.879 | 37.92 | 7633700.0 |
| 2004-11-05 16:00:00 | QQQ | ETF | 37.91 | 38.0 | 37.79 | 37.96 | 2978000.0 |
| 2004-11-05 16:30:00 | QQQ | ETF | 37.96 | 38.0 | 37.96 | 37.96 | 753900.0 |
| 2004-11-05 17:00:00 | QQQ | ETF | 37.96 | 38.0 | 37.95 | 37.97 | 46400.0 |
| 2004-11-05 17:30:00 | QQQ | ETF | 37.98 | 38.0 | 37.97 | 37.99 | 16500.0 |
| 2004-11-05 18:00:00 | QQQ | ETF | 37.99 | 38.0 | 37.95 | 38.0 | 13000.0 |
| 2004-11-05 18:30:00 | QQQ | ETF | 37.99 | 37.99 | 37.99 | 37.99 | 3000.0 |
| 2004-11-05 19:00:00 | QQQ | ETF | 38.0 | 38.0 | 37.99 | 37.99 | 9200.0 |
| 2004-11-05 19:30:00 | QQQ | ETF | 37.97 | 37.97 | 37.96 | 37.96 | 1700.0 |
| 2004-11-05 08:00:00 | IWM | ETF | 60.04 | 60.04 | 60.04 | 60.04 | 1200.0 |
| 2004-11-05 08:30:00 | IWM | ETF | 60.36 | 60.585 | 60.36 | 60.5 | 101800.0 |
| 2004-11-05 09:00:00 | IWM | ETF | 60.485 | 60.485 | 60.28 | 60.28 | 76800.0 |
| 2004-11-05 09:30:00 | IWM | ETF | 60.2 | 60.345 | 60.085 | 60.335 | 2113200.0 |
> showing 50 of 1,358 rows — these rows as CSV