PREVIEW / etf_30min / 2003-11-25
file: by_date/etf_30min/2003/2003-11-25.parquet size: 26 KB rows: 841
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-25 08:00:00 | SPY | ETF | 105.84 | 105.97 | 105.84 | 105.93 | 28800.0 |
| 2003-11-25 08:30:00 | SPY | ETF | 106.0 | 106.05 | 105.65 | 105.7 | 81400.0 |
| 2003-11-25 09:00:00 | SPY | ETF | 105.69 | 105.76 | 105.69 | 105.71 | 52500.0 |
| 2003-11-25 09:30:00 | SPY | ETF | 105.73 | 105.93 | 105.45 | 105.851 | 4952400.0 |
| 2003-11-25 10:00:00 | SPY | ETF | 105.85 | 105.98 | 105.5 | 105.71 | 5446600.0 |
| 2003-11-25 10:30:00 | SPY | ETF | 105.7 | 106.02 | 105.58 | 106.0 | 1801000.0 |
| 2003-11-25 11:00:00 | SPY | ETF | 105.99 | 106.11 | 105.87 | 105.98 | 1861400.0 |
| 2003-11-25 11:30:00 | SPY | ETF | 106.0 | 106.07 | 105.75 | 105.81 | 1071100.0 |
| 2003-11-25 12:00:00 | SPY | ETF | 105.8 | 105.91 | 105.77 | 105.87 | 1248700.0 |
| 2003-11-25 12:30:00 | SPY | ETF | 105.87 | 105.98 | 105.84 | 105.88 | 1741600.0 |
| 2003-11-25 13:00:00 | SPY | ETF | 105.87 | 105.96 | 105.81 | 105.87 | 780000.0 |
| 2003-11-25 13:30:00 | SPY | ETF | 105.89 | 105.98 | 105.79 | 105.91 | 539200.0 |
| 2003-11-25 14:00:00 | SPY | ETF | 105.91 | 106.08 | 105.91 | 106.03 | 3766800.0 |
| 2003-11-25 14:30:00 | SPY | ETF | 106.06 | 106.27 | 106.02 | 106.24 | 2058900.0 |
| 2003-11-25 15:00:00 | SPY | ETF | 106.22 | 106.42 | 106.22 | 106.35 | 1479200.0 |
| 2003-11-25 15:30:00 | SPY | ETF | 106.35 | 106.4 | 105.93 | 106.01 | 2867100.0 |
| 2003-11-25 16:00:00 | SPY | ETF | 106.03 | 106.04 | 105.9 | 105.98 | 1355400.0 |
| 2003-11-25 16:30:00 | SPY | ETF | 105.94 | 106.01 | 105.93 | 105.93 | 18200.0 |
| 2003-11-25 17:00:00 | SPY | ETF | 105.95 | 105.97 | 105.95 | 105.95 | 2600.0 |
| 2003-11-25 17:30:00 | SPY | ETF | 105.93 | 105.93 | 105.93 | 105.93 | 300.0 |
| 2003-11-25 18:00:00 | SPY | ETF | 105.99 | 106.02 | 105.99 | 106.01 | 1400.0 |
| 2003-11-25 18:30:00 | SPY | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 500.0 |
| 2003-11-25 19:00:00 | SPY | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 200.0 |
| 2003-11-25 19:30:00 | SPY | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 300.0 |
| 2003-11-25 08:00:00 | QQQ | ETF | 35.35 | 35.47 | 35.32 | 35.45 | 114700.0 |
| 2003-11-25 08:30:00 | QQQ | ETF | 35.47 | 35.55 | 35.31 | 35.35 | 251800.0 |
| 2003-11-25 09:00:00 | QQQ | ETF | 35.35 | 35.38 | 35.28 | 35.28 | 154000.0 |
| 2003-11-25 09:30:00 | QQQ | ETF | 35.29 | 35.37 | 35.09 | 35.35 | 9875000.0 |
| 2003-11-25 10:00:00 | QQQ | ETF | 35.34 | 35.41 | 35.14 | 35.235 | 9773300.0 |
| 2003-11-25 10:30:00 | QQQ | ETF | 35.24 | 35.34 | 35.16 | 35.33 | 4113900.0 |
| 2003-11-25 11:00:00 | QQQ | ETF | 35.31 | 35.37 | 35.23 | 35.31 | 4444500.0 |
| 2003-11-25 11:30:00 | QQQ | ETF | 35.3 | 35.34 | 35.2 | 35.22 | 2882200.0 |
| 2003-11-25 12:00:00 | QQQ | ETF | 35.22 | 35.301 | 35.19 | 35.23 | 4563200.0 |
| 2003-11-25 12:30:00 | QQQ | ETF | 35.23 | 35.31 | 35.21 | 35.26 | 3652700.0 |
| 2003-11-25 13:00:00 | QQQ | ETF | 35.26 | 35.3 | 35.24 | 35.26 | 1219000.0 |
| 2003-11-25 13:30:00 | QQQ | ETF | 35.25 | 35.29 | 35.18 | 35.242 | 3002300.0 |
| 2003-11-25 14:00:00 | QQQ | ETF | 35.24 | 35.32 | 35.21 | 35.26 | 2125300.0 |
| 2003-11-25 14:30:00 | QQQ | ETF | 35.26 | 35.39 | 35.22 | 35.38 | 4085400.0 |
| 2003-11-25 15:00:00 | QQQ | ETF | 35.378 | 35.45 | 35.33 | 35.38 | 5493200.0 |
| 2003-11-25 15:30:00 | QQQ | ETF | 35.38 | 35.4 | 35.11 | 35.13 | 5175800.0 |
| 2003-11-25 16:00:00 | QQQ | ETF | 35.13 | 35.2987 | 35.1 | 35.17 | 2620800.0 |
| 2003-11-25 16:30:00 | QQQ | ETF | 35.17 | 35.19 | 35.15 | 35.15 | 385800.0 |
| 2003-11-25 17:00:00 | QQQ | ETF | 35.147 | 35.17 | 35.145 | 35.17 | 97700.0 |
| 2003-11-25 17:30:00 | QQQ | ETF | 35.16 | 35.17 | 35.16 | 35.17 | 10200.0 |
| 2003-11-25 18:00:00 | QQQ | ETF | 35.165 | 35.2 | 35.165 | 35.2 | 44100.0 |
| 2003-11-25 18:30:00 | QQQ | ETF | 35.18 | 35.2 | 35.18 | 35.19 | 1900.0 |
| 2003-11-25 19:00:00 | QQQ | ETF | 35.19 | 35.22 | 35.19 | 35.22 | 1500.0 |
| 2003-11-25 19:30:00 | QQQ | ETF | 35.2 | 35.21 | 35.18 | 35.2 | 6000.0 |
| 2003-11-25 08:00:00 | IWM | ETF | 53.97 | 53.97 | 53.97 | 53.97 | 2000.0 |
| 2003-11-25 08:30:00 | IWM | ETF | 53.925 | 53.925 | 53.925 | 53.925 | 1000.0 |
> showing 50 of 841 rows — these rows as CSV