PREVIEW / etf_30min / 2001-01-30
file: by_date/etf_30min/2001/2001-01-30.parquet size: 14 KB rows: 330
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-01-30 09:30:00 | SPY | ETF | 136.3 | 136.76 | 136.3 | 136.72 | 830500.0 |
| 2001-01-30 10:00:00 | SPY | ETF | 136.73 | 136.73 | 135.79 | 136.02 | 838700.0 |
| 2001-01-30 10:30:00 | SPY | ETF | 135.95 | 136.54 | 135.95 | 136.42 | 816200.0 |
| 2001-01-30 11:00:00 | SPY | ETF | 136.54 | 136.85 | 136.5 | 136.75 | 216300.0 |
| 2001-01-30 11:30:00 | SPY | ETF | 136.8 | 136.96 | 136.5 | 136.67 | 399400.0 |
| 2001-01-30 12:00:00 | SPY | ETF | 136.7 | 136.87 | 136.31 | 136.87 | 572800.0 |
| 2001-01-30 12:30:00 | SPY | ETF | 136.75 | 136.95 | 136.66 | 136.79 | 345000.0 |
| 2001-01-30 13:00:00 | SPY | ETF | 136.74 | 137.04 | 136.74 | 136.95 | 211700.0 |
| 2001-01-30 13:30:00 | SPY | ETF | 136.96 | 137.16 | 136.86 | 136.97 | 311200.0 |
| 2001-01-30 14:00:00 | SPY | ETF | 136.92 | 137.09 | 136.71 | 136.89 | 185800.0 |
| 2001-01-30 14:30:00 | SPY | ETF | 136.86 | 137.29 | 136.65 | 137.1 | 217300.0 |
| 2001-01-30 15:00:00 | SPY | ETF | 137.2 | 137.71 | 137.15 | 137.4 | 514900.0 |
| 2001-01-30 15:30:00 | SPY | ETF | 137.49 | 137.92 | 137.3 | 137.75 | 870400.0 |
| 2001-01-30 16:00:00 | SPY | ETF | 137.75 | 137.8 | 137.12 | 137.8 | 599300.0 |
| 2001-01-30 09:30:00 | QQQ | ETF | 67.15 | 67.74 | 66.88 | 67.74 | 7526500.0 |
| 2001-01-30 10:00:00 | QQQ | ETF | 67.72 | 67.74 | 66.31 | 66.6 | 6676500.0 |
| 2001-01-30 10:30:00 | QQQ | ETF | 66.5 | 66.92 | 66.43 | 66.8 | 3365100.0 |
| 2001-01-30 11:00:00 | QQQ | ETF | 66.8 | 67.31 | 66.76 | 67.25 | 2821300.0 |
| 2001-01-30 11:30:00 | QQQ | ETF | 67.28 | 67.38 | 66.88 | 66.97 | 1501100.0 |
| 2001-01-30 12:00:00 | QQQ | ETF | 66.98 | 66.99 | 66.51 | 66.98 | 1559400.0 |
| 2001-01-30 12:30:00 | QQQ | ETF | 66.95 | 67.09 | 66.76 | 66.87 | 1069000.0 |
| 2001-01-30 13:00:00 | QQQ | ETF | 66.88 | 67.0 | 66.71 | 66.83 | 1107800.0 |
| 2001-01-30 13:30:00 | QQQ | ETF | 66.87 | 67.2 | 66.81 | 67.08 | 1310200.0 |
| 2001-01-30 14:00:00 | QQQ | ETF | 67.0 | 67.08 | 66.44 | 66.62 | 1630800.0 |
| 2001-01-30 14:30:00 | QQQ | ETF | 66.58 | 66.83 | 66.3 | 66.51 | 2147700.0 |
| 2001-01-30 15:00:00 | QQQ | ETF | 66.51 | 67.12 | 66.46 | 66.73 | 3574600.0 |
| 2001-01-30 15:30:00 | QQQ | ETF | 66.75 | 67.23 | 66.65 | 66.86 | 3632400.0 |
| 2001-01-30 16:00:00 | QQQ | ETF | 66.88 | 67.0 | 66.0 | 66.5 | 1378200.0 |
| 2001-01-30 16:30:00 | QQQ | ETF | 66.62 | 67.0 | 63.55 | 66.88 | 549200.0 |
| 2001-01-30 17:00:00 | QQQ | ETF | 66.85 | 67.25 | 66.6 | 66.85 | 42600.0 |
| 2001-01-30 17:30:00 | QQQ | ETF | 66.85 | 66.85 | 66.75 | 66.75 | 13600.0 |
| 2001-01-30 18:00:00 | QQQ | ETF | 66.8 | 67.0 | 66.71 | 66.8 | 10000.0 |
| 2001-01-30 09:30:00 | IWM | ETF | 51.0 | 51.0 | 50.6 | 50.95 | 62600.0 |
| 2001-01-30 10:00:00 | IWM | ETF | 50.9 | 50.9 | 50.425 | 50.5 | 48400.0 |
| 2001-01-30 10:30:00 | IWM | ETF | 50.7 | 50.76 | 50.61 | 50.76 | 73800.0 |
| 2001-01-30 11:00:00 | IWM | ETF | 50.775 | 50.825 | 50.65 | 50.825 | 75000.0 |
| 2001-01-30 11:30:00 | IWM | ETF | 50.95 | 50.95 | 50.725 | 50.725 | 99200.0 |
| 2001-01-30 12:00:00 | IWM | ETF | 50.655 | 50.8 | 50.655 | 50.8 | 37200.0 |
| 2001-01-30 12:30:00 | IWM | ETF | 50.755 | 50.9 | 50.725 | 50.81 | 145800.0 |
| 2001-01-30 13:00:00 | IWM | ETF | 50.85 | 50.915 | 50.85 | 50.915 | 1200.0 |
| 2001-01-30 13:30:00 | IWM | ETF | 50.75 | 50.9 | 50.7 | 50.9 | 168000.0 |
| 2001-01-30 14:00:00 | IWM | ETF | 50.75 | 50.87 | 50.58 | 50.7 | 78800.0 |
| 2001-01-30 14:30:00 | IWM | ETF | 50.53 | 50.775 | 50.53 | 50.775 | 35600.0 |
| 2001-01-30 15:00:00 | IWM | ETF | 50.7 | 50.95 | 50.615 | 50.95 | 134400.0 |
| 2001-01-30 15:30:00 | IWM | ETF | 50.845 | 51.0 | 50.775 | 51.0 | 234200.0 |
| 2001-01-30 16:00:00 | IWM | ETF | 51.075 | 51.155 | 50.875 | 51.155 | 119800.0 |
| 2001-01-30 09:30:00 | DIA | ETF | 107.24 | 107.4 | 107.06 | 107.3 | 47900.0 |
| 2001-01-30 10:00:00 | DIA | ETF | 107.3 | 107.3 | 106.8 | 107.09 | 43100.0 |
| 2001-01-30 10:30:00 | DIA | ETF | 107.0 | 107.5 | 107.0 | 107.35 | 51700.0 |
| 2001-01-30 11:00:00 | DIA | ETF | 107.4 | 107.59 | 107.4 | 107.5 | 61300.0 |
> showing 50 of 330 rows — these rows as CSV