PREVIEW / etf_30min / 2006-10-20
file: by_date/etf_30min/2006/2006-10-20.parquet size: 79 KB rows: 2,878
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-20 06:00:00 | SPY | ETF | 136.98 | 136.98 | 136.98 | 136.98 | 2000.0 |
| 2006-10-20 07:00:00 | SPY | ETF | 136.99 | 137.02 | 136.94 | 136.95 | 12500.0 |
| 2006-10-20 07:30:00 | SPY | ETF | 136.91 | 136.91 | 136.62 | 136.69 | 237900.0 |
| 2006-10-20 08:00:00 | SPY | ETF | 136.7 | 136.96 | 136.61 | 136.75 | 527600.0 |
| 2006-10-20 08:30:00 | SPY | ETF | 136.72 | 136.77 | 136.63 | 136.64 | 157400.0 |
| 2006-10-20 09:00:00 | SPY | ETF | 136.64 | 136.89 | 136.63 | 136.82 | 922200.0 |
| 2006-10-20 09:30:00 | SPY | ETF | 136.81 | 136.89 | 136.33 | 136.49 | 7982200.0 |
| 2006-10-20 10:00:00 | SPY | ETF | 136.48 | 136.57 | 136.39 | 136.51 | 5136800.0 |
| 2006-10-20 10:30:00 | SPY | ETF | 136.51 | 136.6 | 136.38 | 136.55 | 3546300.0 |
| 2006-10-20 11:00:00 | SPY | ETF | 136.55 | 136.7 | 136.52 | 136.61 | 2989200.0 |
| 2006-10-20 11:30:00 | SPY | ETF | 136.6 | 136.7 | 136.56 | 136.58 | 2772900.0 |
| 2006-10-20 12:00:00 | SPY | ETF | 136.58 | 136.7 | 136.5 | 136.67 | 2535300.0 |
| 2006-10-20 12:30:00 | SPY | ETF | 136.67 | 136.8 | 136.65 | 136.73 | 3089200.0 |
| 2006-10-20 13:00:00 | SPY | ETF | 136.73 | 136.77 | 136.7 | 136.75 | 373700.0 |
| 2006-10-20 13:30:00 | SPY | ETF | 136.74 | 136.77 | 136.59 | 136.6 | 1887100.0 |
| 2006-10-20 14:00:00 | SPY | ETF | 136.6 | 136.67 | 136.58 | 136.64 | 1191800.0 |
| 2006-10-20 14:30:00 | SPY | ETF | 136.63 | 136.73 | 136.59 | 136.68 | 1102600.0 |
| 2006-10-20 15:00:00 | SPY | ETF | 136.6889 | 136.87 | 136.66 | 136.85 | 3458600.0 |
| 2006-10-20 15:30:00 | SPY | ETF | 136.85 | 136.95 | 136.79 | 136.85 | 4536400.0 |
| 2006-10-20 16:00:00 | SPY | ETF | 136.87 | 136.88 | 136.82 | 136.87 | 658500.0 |
| 2006-10-20 16:30:00 | SPY | ETF | 136.86 | 136.86 | 136.77 | 136.77 | 55500.0 |
| 2006-10-20 17:00:00 | SPY | ETF | 136.77 | 136.87 | 136.77 | 136.8 | 1510900.0 |
| 2006-10-20 17:30:00 | SPY | ETF | 136.83 | 136.83 | 136.83 | 136.83 | 5000.0 |
| 2006-10-20 19:30:00 | SPY | ETF | 136.83 | 136.83 | 136.83 | 136.83 | 200.0 |
| 2006-10-20 09:30:00 | QQQ | ETF | 42.06 | 42.06 | 41.64 | 41.76 | 28610000.0 |
| 2006-10-20 10:00:00 | QQQ | ETF | 41.76 | 41.84 | 41.68 | 41.78 | 10518800.0 |
| 2006-10-20 10:30:00 | QQQ | ETF | 41.78 | 41.9 | 41.73 | 41.84 | 5380600.0 |
| 2006-10-20 11:00:00 | QQQ | ETF | 41.84 | 41.89 | 41.78 | 41.83 | 2416700.0 |
| 2006-10-20 11:30:00 | QQQ | ETF | 41.83 | 41.88 | 41.83 | 41.86 | 1752500.0 |
| 2006-10-20 12:00:00 | QQQ | ETF | 41.86 | 41.9 | 41.8 | 41.9 | 4504000.0 |
| 2006-10-20 12:30:00 | QQQ | ETF | 41.9 | 41.99 | 41.89 | 41.93 | 6245500.0 |
| 2006-10-20 13:00:00 | QQQ | ETF | 41.93 | 41.98 | 41.92 | 41.97 | 1563300.0 |
| 2006-10-20 13:30:00 | QQQ | ETF | 41.97 | 41.98 | 41.85 | 41.86 | 4917100.0 |
| 2006-10-20 14:00:00 | QQQ | ETF | 41.86 | 41.91 | 41.83 | 41.89 | 5116500.0 |
| 2006-10-20 14:30:00 | QQQ | ETF | 41.88 | 41.92 | 41.86 | 41.9 | 2650200.0 |
| 2006-10-20 15:00:00 | QQQ | ETF | 41.9 | 41.98 | 41.87 | 41.97 | 5661400.0 |
| 2006-10-20 15:30:00 | QQQ | ETF | 41.97 | 42.01 | 41.96 | 41.99 | 14708300.0 |
| 2006-10-20 07:30:00 | IWM | ETF | 76.15 | 76.3 | 76.15 | 76.3 | 1300.0 |
| 2006-10-20 08:00:00 | IWM | ETF | 76.22 | 76.26 | 76.22 | 76.25 | 6300.0 |
| 2006-10-20 08:30:00 | IWM | ETF | 76.27 | 76.31 | 76.21 | 76.21 | 6500.0 |
| 2006-10-20 09:00:00 | IWM | ETF | 76.23 | 76.4 | 76.21 | 76.37 | 34300.0 |
| 2006-10-20 09:30:00 | IWM | ETF | 76.37 | 76.41 | 75.57 | 75.69 | 6894900.0 |
| 2006-10-20 10:00:00 | IWM | ETF | 75.69 | 75.75 | 75.48 | 75.68 | 3194100.0 |
| 2006-10-20 10:30:00 | IWM | ETF | 75.68 | 75.85 | 75.59 | 75.76 | 2222000.0 |
| 2006-10-20 11:00:00 | IWM | ETF | 75.76 | 75.81 | 75.64 | 75.72 | 1345000.0 |
| 2006-10-20 11:30:00 | IWM | ETF | 75.71 | 75.91 | 75.71 | 75.85 | 1201900.0 |
| 2006-10-20 12:00:00 | IWM | ETF | 75.84 | 75.89 | 75.76 | 75.89 | 1254500.0 |
| 2006-10-20 12:30:00 | IWM | ETF | 75.89 | 75.98 | 75.79 | 75.92 | 2352300.0 |
| 2006-10-20 13:00:00 | IWM | ETF | 75.93 | 75.94 | 75.87 | 75.92 | 3808000.0 |
| 2006-10-20 13:30:00 | IWM | ETF | 75.92 | 75.95 | 75.76 | 75.77 | 1775400.0 |
> showing 50 of 2,878 rows — these rows as CSV