PREVIEW / etf_30min / 2001-08-09
file: by_date/etf_30min/2001/2001-08-09.parquet size: 15 KB rows: 373
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-08-09 09:30:00 | SPY | ETF | 118.7 | 118.87 | 118.23 | 118.8 | 2360100.0 |
| 2001-08-09 10:00:00 | SPY | ETF | 118.79 | 118.9 | 118.35 | 118.51 | 1285500.0 |
| 2001-08-09 10:30:00 | SPY | ETF | 118.45 | 118.48 | 117.88 | 118.17 | 1811900.0 |
| 2001-08-09 11:00:00 | SPY | ETF | 118.23 | 118.47 | 118.06 | 118.42 | 826800.0 |
| 2001-08-09 11:30:00 | SPY | ETF | 118.4 | 118.49 | 117.91 | 117.93 | 479700.0 |
| 2001-08-09 12:00:00 | SPY | ETF | 117.95 | 118.14 | 117.86 | 117.93 | 480900.0 |
| 2001-08-09 12:30:00 | SPY | ETF | 117.91 | 118.54 | 117.9 | 118.5 | 584200.0 |
| 2001-08-09 13:00:00 | SPY | ETF | 118.55 | 118.83 | 118.32 | 118.63 | 555100.0 |
| 2001-08-09 13:30:00 | SPY | ETF | 118.62 | 118.89 | 118.22 | 118.31 | 622800.0 |
| 2001-08-09 14:00:00 | SPY | ETF | 118.31 | 118.58 | 118.13 | 118.16 | 688300.0 |
| 2001-08-09 14:30:00 | SPY | ETF | 118.16 | 118.43 | 117.95 | 118.25 | 782800.0 |
| 2001-08-09 15:00:00 | SPY | ETF | 118.27 | 118.92 | 118.24 | 118.62 | 861900.0 |
| 2001-08-09 15:30:00 | SPY | ETF | 118.61 | 118.97 | 118.56 | 118.74 | 1133900.0 |
| 2001-08-09 16:00:00 | SPY | ETF | 118.74 | 118.98 | 118.43 | 118.85 | 941900.0 |
| 2001-08-09 16:30:00 | SPY | ETF | 118.85 | 118.85 | 118.7 | 118.7 | 50900.0 |
| 2001-08-09 17:30:00 | SPY | ETF | 119.04 | 119.04 | 119.04 | 119.04 | 1000.0 |
| 2001-08-09 09:30:00 | QQQ | ETF | 40.41 | 40.75 | 40.16 | 40.73 | 9653200.0 |
| 2001-08-09 10:00:00 | QQQ | ETF | 40.75 | 40.88 | 40.29 | 40.38 | 6057800.0 |
| 2001-08-09 10:30:00 | QQQ | ETF | 40.37 | 40.43 | 39.98 | 40.25 | 5867000.0 |
| 2001-08-09 11:00:00 | QQQ | ETF | 40.25 | 40.64 | 40.11 | 40.54 | 5580900.0 |
| 2001-08-09 11:30:00 | QQQ | ETF | 40.54 | 40.61 | 40.23 | 40.26 | 3493300.0 |
| 2001-08-09 12:00:00 | QQQ | ETF | 40.26 | 40.38 | 40.04 | 40.11 | 2368400.0 |
| 2001-08-09 12:30:00 | QQQ | ETF | 40.1 | 40.47 | 40.07 | 40.41 | 3155200.0 |
| 2001-08-09 13:00:00 | QQQ | ETF | 40.43 | 40.63 | 40.22 | 40.53 | 2631700.0 |
| 2001-08-09 13:30:00 | QQQ | ETF | 40.52 | 40.75 | 40.25 | 40.38 | 4064200.0 |
| 2001-08-09 14:00:00 | QQQ | ETF | 40.4 | 40.53 | 40.15 | 40.18 | 2868000.0 |
| 2001-08-09 14:30:00 | QQQ | ETF | 40.2 | 40.31 | 40.02 | 40.17 | 4890000.0 |
| 2001-08-09 15:00:00 | QQQ | ETF | 40.16 | 40.5 | 40.1 | 40.4 | 5082600.0 |
| 2001-08-09 15:30:00 | QQQ | ETF | 40.39 | 40.68 | 40.36 | 40.54 | 5487200.0 |
| 2001-08-09 16:00:00 | QQQ | ETF | 40.6 | 40.75 | 40.0 | 40.65 | 1727300.0 |
| 2001-08-09 16:30:00 | QQQ | ETF | 40.69 | 40.74 | 40.5 | 40.7 | 243100.0 |
| 2001-08-09 17:00:00 | QQQ | ETF | 40.68 | 40.79 | 40.67 | 40.73 | 30400.0 |
| 2001-08-09 17:30:00 | QQQ | ETF | 40.75 | 40.9 | 40.74 | 40.81 | 27000.0 |
| 2001-08-09 18:00:00 | QQQ | ETF | 40.81 | 40.9 | 40.72 | 40.8 | 32900.0 |
| 2001-08-09 09:30:00 | IWM | ETF | 47.1 | 47.17 | 46.955 | 47.17 | 204000.0 |
| 2001-08-09 10:00:00 | IWM | ETF | 47.245 | 47.25 | 47.12 | 47.12 | 10600.0 |
| 2001-08-09 10:30:00 | IWM | ETF | 47.005 | 47.025 | 46.75 | 46.945 | 167200.0 |
| 2001-08-09 11:00:00 | IWM | ETF | 46.94 | 47.085 | 46.905 | 47.085 | 10200.0 |
| 2001-08-09 11:30:00 | IWM | ETF | 47.085 | 47.085 | 47.06 | 47.07 | 3800.0 |
| 2001-08-09 12:00:00 | IWM | ETF | 46.85 | 46.9 | 46.725 | 46.75 | 6600.0 |
| 2001-08-09 12:30:00 | IWM | ETF | 46.825 | 46.895 | 46.82 | 46.895 | 3200.0 |
| 2001-08-09 13:00:00 | IWM | ETF | 46.9 | 47.07 | 46.9 | 46.905 | 14600.0 |
| 2001-08-09 13:30:00 | IWM | ETF | 47.0 | 47.095 | 47.0 | 47.095 | 10200.0 |
| 2001-08-09 14:00:00 | IWM | ETF | 46.975 | 46.975 | 46.945 | 46.975 | 2000.0 |
| 2001-08-09 14:30:00 | IWM | ETF | 46.975 | 47.05 | 46.97 | 46.995 | 21200.0 |
| 2001-08-09 15:00:00 | IWM | ETF | 46.995 | 47.125 | 46.955 | 47.125 | 19600.0 |
| 2001-08-09 15:30:00 | IWM | ETF | 47.1 | 47.22 | 47.055 | 47.125 | 53600.0 |
| 2001-08-09 16:00:00 | IWM | ETF | 47.325 | 47.35 | 47.325 | 47.35 | 1200.0 |
| 2001-08-09 09:30:00 | DIA | ETF | 102.99 | 103.05 | 102.67 | 102.86 | 357400.0 |
| 2001-08-09 10:00:00 | DIA | ETF | 102.86 | 102.9 | 102.54 | 102.73 | 481700.0 |
> showing 50 of 373 rows — these rows as CSV