PREVIEW / etf_30min / 2001-05-30
file: by_date/etf_30min/2001/2001-05-30.parquet size: 15 KB rows: 361
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-30 09:30:00 | SPY | ETF | 126.59 | 126.89 | 126.46 | 126.79 | 1850200.0 |
| 2001-05-30 10:00:00 | SPY | ETF | 126.78 | 127.09 | 126.27 | 126.33 | 1015100.0 |
| 2001-05-30 10:30:00 | SPY | ETF | 126.36 | 126.54 | 126.02 | 126.17 | 643400.0 |
| 2001-05-30 11:00:00 | SPY | ETF | 126.16 | 126.24 | 125.67 | 125.67 | 851700.0 |
| 2001-05-30 11:30:00 | SPY | ETF | 125.65 | 126.0 | 125.61 | 125.93 | 371100.0 |
| 2001-05-30 12:00:00 | SPY | ETF | 125.86 | 126.07 | 125.72 | 125.83 | 197500.0 |
| 2001-05-30 12:30:00 | SPY | ETF | 125.92 | 125.96 | 125.7 | 125.94 | 113400.0 |
| 2001-05-30 13:00:00 | SPY | ETF | 125.87 | 125.9 | 125.45 | 125.5 | 423800.0 |
| 2001-05-30 13:30:00 | SPY | ETF | 125.52 | 125.64 | 125.0 | 125.13 | 973500.0 |
| 2001-05-30 14:00:00 | SPY | ETF | 125.16 | 125.59 | 125.11 | 125.4 | 676400.0 |
| 2001-05-30 14:30:00 | SPY | ETF | 125.36 | 125.82 | 125.3 | 125.74 | 507300.0 |
| 2001-05-30 15:00:00 | SPY | ETF | 125.74 | 125.95 | 125.37 | 125.4 | 775100.0 |
| 2001-05-30 15:30:00 | SPY | ETF | 125.38 | 125.5 | 125.08 | 125.29 | 1039500.0 |
| 2001-05-30 16:00:00 | SPY | ETF | 125.22 | 125.92 | 125.2 | 125.31 | 362400.0 |
| 2001-05-30 16:30:00 | SPY | ETF | 125.26 | 125.58 | 125.25 | 125.33 | 5500.0 |
| 2001-05-30 17:00:00 | SPY | ETF | 125.35 | 125.35 | 125.3 | 125.3 | 2000.0 |
| 2001-05-30 09:30:00 | QQQ | ETF | 45.43 | 45.56 | 45.15 | 45.49 | 10521200.0 |
| 2001-05-30 10:00:00 | QQQ | ETF | 45.45 | 45.85 | 45.15 | 45.22 | 8873600.0 |
| 2001-05-30 10:30:00 | QQQ | ETF | 45.25 | 45.37 | 44.85 | 44.91 | 7185200.0 |
| 2001-05-30 11:00:00 | QQQ | ETF | 44.9 | 44.96 | 44.47 | 44.5 | 7035000.0 |
| 2001-05-30 11:30:00 | QQQ | ETF | 44.5 | 44.89 | 44.48 | 44.77 | 5245800.0 |
| 2001-05-30 12:00:00 | QQQ | ETF | 44.73 | 44.94 | 44.55 | 44.68 | 4107500.0 |
| 2001-05-30 12:30:00 | QQQ | ETF | 44.68 | 44.79 | 44.51 | 44.75 | 1322800.0 |
| 2001-05-30 13:00:00 | QQQ | ETF | 44.74 | 44.75 | 44.22 | 44.36 | 5646400.0 |
| 2001-05-30 13:30:00 | QQQ | ETF | 44.31 | 44.45 | 44.08 | 44.18 | 5170400.0 |
| 2001-05-30 14:00:00 | QQQ | ETF | 44.17 | 44.51 | 44.09 | 44.32 | 4046900.0 |
| 2001-05-30 14:30:00 | QQQ | ETF | 44.32 | 44.82 | 44.27 | 44.73 | 5272400.0 |
| 2001-05-30 15:00:00 | QQQ | ETF | 44.73 | 44.94 | 44.36 | 44.39 | 5146100.0 |
| 2001-05-30 15:30:00 | QQQ | ETF | 44.39 | 44.47 | 44.11 | 44.3 | 8147100.0 |
| 2001-05-30 16:00:00 | QQQ | ETF | 44.3 | 44.93 | 44.27 | 44.38 | 1536900.0 |
| 2001-05-30 16:30:00 | QQQ | ETF | 44.4 | 44.6 | 44.3 | 44.6 | 97800.0 |
| 2001-05-30 17:00:00 | QQQ | ETF | 44.55 | 44.62 | 44.47 | 44.6 | 17100.0 |
| 2001-05-30 17:30:00 | QQQ | ETF | 44.54 | 44.58 | 44.5 | 44.58 | 8700.0 |
| 2001-05-30 18:00:00 | QQQ | ETF | 44.59 | 44.65 | 44.55 | 44.65 | 9500.0 |
| 2001-05-30 09:30:00 | IWM | ETF | 49.95 | 49.95 | 49.775 | 49.8 | 29800.0 |
| 2001-05-30 10:00:00 | IWM | ETF | 49.8 | 49.95 | 49.725 | 49.725 | 29800.0 |
| 2001-05-30 10:30:00 | IWM | ETF | 49.7 | 49.7 | 49.52 | 49.6 | 32000.0 |
| 2001-05-30 11:00:00 | IWM | ETF | 49.595 | 49.625 | 49.44 | 49.545 | 111400.0 |
| 2001-05-30 11:30:00 | IWM | ETF | 49.5 | 49.525 | 49.435 | 49.5 | 62000.0 |
| 2001-05-30 12:00:00 | IWM | ETF | 49.5 | 49.5 | 49.35 | 49.425 | 48800.0 |
| 2001-05-30 12:30:00 | IWM | ETF | 49.6 | 49.6 | 49.405 | 49.49 | 42600.0 |
| 2001-05-30 13:00:00 | IWM | ETF | 49.405 | 49.405 | 49.25 | 49.25 | 43200.0 |
| 2001-05-30 13:30:00 | IWM | ETF | 49.25 | 49.305 | 49.15 | 49.175 | 96200.0 |
| 2001-05-30 14:00:00 | IWM | ETF | 49.195 | 49.415 | 49.185 | 49.3 | 90800.0 |
| 2001-05-30 14:30:00 | IWM | ETF | 49.3 | 49.445 | 49.3 | 49.44 | 87800.0 |
| 2001-05-30 15:00:00 | IWM | ETF | 49.445 | 49.49 | 49.325 | 49.325 | 57400.0 |
| 2001-05-30 15:30:00 | IWM | ETF | 49.325 | 49.375 | 49.265 | 49.3 | 47800.0 |
| 2001-05-30 16:00:00 | IWM | ETF | 49.35 | 49.475 | 49.25 | 49.35 | 7600.0 |
| 2001-05-30 09:30:00 | DIA | ETF | 110.02 | 110.5 | 110.0 | 110.27 | 397100.0 |
| 2001-05-30 10:00:00 | DIA | ETF | 110.25 | 110.59 | 109.9 | 110.04 | 377000.0 |
> showing 50 of 361 rows — these rows as CSV