PREVIEW / etf_30min / 2006-10-25
file: by_date/etf_30min/2006/2006-10-25.parquet size: 85 KB rows: 2,991
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-25 06:00:00 | SPY | ETF | 137.99 | 137.99 | 137.99 | 137.99 | 3000.0 |
| 2006-10-25 06:30:00 | SPY | ETF | 137.98 | 137.98 | 137.93 | 137.93 | 2800.0 |
| 2006-10-25 07:00:00 | SPY | ETF | 137.91 | 137.91 | 137.9 | 137.9 | 4000.0 |
| 2006-10-25 07:30:00 | SPY | ETF | 138.03 | 138.03 | 137.94 | 137.94 | 5500.0 |
| 2006-10-25 08:00:00 | SPY | ETF | 137.95 | 137.99 | 137.88 | 137.92 | 119600.0 |
| 2006-10-25 08:30:00 | SPY | ETF | 137.9 | 137.9 | 137.76 | 137.85 | 165400.0 |
| 2006-10-25 09:00:00 | SPY | ETF | 137.83 | 137.85 | 137.73 | 137.73 | 167600.0 |
| 2006-10-25 09:30:00 | SPY | ETF | 137.74 | 137.94 | 137.71 | 137.86 | 3275700.0 |
| 2006-10-25 10:00:00 | SPY | ETF | 137.86 | 138.07 | 137.75 | 138.01 | 4689800.0 |
| 2006-10-25 10:30:00 | SPY | ETF | 138.02 | 138.04 | 137.84 | 137.88 | 6770900.0 |
| 2006-10-25 11:00:00 | SPY | ETF | 137.88 | 137.98 | 137.8 | 137.88 | 2448100.0 |
| 2006-10-25 11:30:00 | SPY | ETF | 137.89 | 138.0 | 137.87 | 137.94 | 1705100.0 |
| 2006-10-25 12:00:00 | SPY | ETF | 137.94 | 137.96 | 137.73 | 137.76 | 3713300.0 |
| 2006-10-25 12:30:00 | SPY | ETF | 137.75 | 137.77 | 137.63 | 137.74 | 4215800.0 |
| 2006-10-25 13:00:00 | SPY | ETF | 137.73 | 137.93 | 137.7 | 137.89 | 2059500.0 |
| 2006-10-25 13:30:00 | SPY | ETF | 137.89 | 137.97 | 137.85 | 137.93 | 1817400.0 |
| 2006-10-25 14:00:00 | SPY | ETF | 137.92 | 138.39 | 137.73 | 137.86 | 15073700.0 |
| 2006-10-25 14:30:00 | SPY | ETF | 137.86 | 138.37 | 137.51 | 138.11 | 8139400.0 |
| 2006-10-25 15:00:00 | SPY | ETF | 138.12 | 138.31 | 138.01 | 138.16 | 4700600.0 |
| 2006-10-25 15:30:00 | SPY | ETF | 138.17 | 138.41 | 138.16 | 138.2 | 6358100.0 |
| 2006-10-25 16:00:00 | SPY | ETF | 138.2 | 138.43 | 138.17 | 138.4 | 881400.0 |
| 2006-10-25 16:30:00 | SPY | ETF | 138.36 | 138.43 | 138.35 | 138.38 | 631800.0 |
| 2006-10-25 17:00:00 | SPY | ETF | 138.39 | 138.43 | 138.39 | 138.43 | 5800.0 |
| 2006-10-25 17:30:00 | SPY | ETF | 138.42 | 138.43 | 138.38 | 138.4 | 7802700.0 |
| 2006-10-25 18:00:00 | SPY | ETF | 138.38 | 138.38 | 138.34 | 138.34 | 7500.0 |
| 2006-10-25 19:00:00 | SPY | ETF | 138.36 | 138.37 | 138.33 | 138.37 | 3000.0 |
| 2006-10-25 19:30:00 | SPY | ETF | 138.37 | 138.37 | 138.37 | 138.37 | 300.0 |
| 2006-10-25 09:30:00 | QQQ | ETF | 42.15 | 42.35 | 42.12 | 42.31 | 9128900.0 |
| 2006-10-25 10:00:00 | QQQ | ETF | 42.3 | 42.52 | 42.24 | 42.47 | 10801000.0 |
| 2006-10-25 10:30:00 | QQQ | ETF | 42.47 | 42.49 | 42.33 | 42.33 | 7153200.0 |
| 2006-10-25 11:00:00 | QQQ | ETF | 42.34 | 42.37 | 42.31 | 42.36 | 4232200.0 |
| 2006-10-25 11:30:00 | QQQ | ETF | 42.36 | 42.43 | 42.33 | 42.35 | 2551300.0 |
| 2006-10-25 12:00:00 | QQQ | ETF | 42.35 | 42.38 | 42.22 | 42.25 | 5301500.0 |
| 2006-10-25 12:30:00 | QQQ | ETF | 42.24 | 42.28 | 42.19 | 42.27 | 7691200.0 |
| 2006-10-25 13:00:00 | QQQ | ETF | 42.26 | 42.32 | 42.25 | 42.3 | 2958700.0 |
| 2006-10-25 13:30:00 | QQQ | ETF | 42.29 | 42.35 | 42.25 | 42.27 | 3921300.0 |
| 2006-10-25 14:00:00 | QQQ | ETF | 42.27 | 42.46 | 42.18 | 42.23 | 19604800.0 |
| 2006-10-25 14:30:00 | QQQ | ETF | 42.24 | 42.27 | 42.05 | 42.26 | 21432900.0 |
| 2006-10-25 15:00:00 | QQQ | ETF | 42.26 | 42.42 | 42.23 | 42.33 | 11067400.0 |
| 2006-10-25 15:30:00 | QQQ | ETF | 42.33 | 42.49 | 42.33 | 42.42 | 10659000.0 |
| 2006-10-25 07:30:00 | IWM | ETF | 75.85 | 75.85 | 75.85 | 75.85 | 100.0 |
| 2006-10-25 08:00:00 | IWM | ETF | 75.84 | 75.84 | 75.84 | 75.84 | 3900.0 |
| 2006-10-25 08:30:00 | IWM | ETF | 75.82 | 75.83 | 75.8 | 75.83 | 86400.0 |
| 2006-10-25 09:00:00 | IWM | ETF | 75.84 | 75.84 | 75.74 | 75.74 | 70900.0 |
| 2006-10-25 09:30:00 | IWM | ETF | 75.73 | 76.23 | 75.73 | 76.1414 | 3806100.0 |
| 2006-10-25 10:00:00 | IWM | ETF | 76.15 | 76.46 | 76.08 | 76.34 | 5672400.0 |
| 2006-10-25 10:30:00 | IWM | ETF | 76.34 | 76.36 | 76.11 | 76.13 | 3943700.0 |
| 2006-10-25 11:00:00 | IWM | ETF | 76.13 | 76.26 | 76.09 | 76.24 | 1640800.0 |
| 2006-10-25 11:30:00 | IWM | ETF | 76.25 | 76.3 | 76.15 | 76.21 | 1052900.0 |
| 2006-10-25 12:00:00 | IWM | ETF | 76.2 | 76.25 | 75.91 | 75.93 | 2530100.0 |
> showing 50 of 2,991 rows — these rows as CSV