PREVIEW / etf_30min / 2006-04-25
file: by_date/etf_30min/2006/2006-04-25.parquet size: 62 KB rows: 2,205
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-04-25 07:00:00 | SPY | ETF | 131.0 | 131.1 | 131.0 | 131.1 | 1200.0 |
| 2006-04-25 07:30:00 | SPY | ETF | 131.1 | 131.15 | 131.1 | 131.1 | 4700.0 |
| 2006-04-25 08:00:00 | SPY | ETF | 131.1 | 131.15 | 131.0 | 131.08 | 852100.0 |
| 2006-04-25 08:30:00 | SPY | ETF | 131.09 | 131.12 | 131.05 | 131.06 | 314400.0 |
| 2006-04-25 09:00:00 | SPY | ETF | 131.06 | 131.12 | 131.03 | 131.05 | 46100.0 |
| 2006-04-25 09:30:00 | SPY | ETF | 131.04 | 131.12 | 130.88 | 131.0 | 3717400.0 |
| 2006-04-25 10:00:00 | SPY | ETF | 131.01 | 131.08 | 130.22 | 130.38 | 13897400.0 |
| 2006-04-25 10:30:00 | SPY | ETF | 130.38 | 130.78 | 130.29 | 130.59 | 10652800.0 |
| 2006-04-25 11:00:00 | SPY | ETF | 130.6 | 130.74 | 130.46 | 130.5 | 4634400.0 |
| 2006-04-25 11:30:00 | SPY | ETF | 130.49 | 130.56 | 130.03 | 130.16 | 11924700.0 |
| 2006-04-25 12:00:00 | SPY | ETF | 130.16 | 130.21 | 129.99 | 130.18 | 3996500.0 |
| 2006-04-25 12:30:00 | SPY | ETF | 130.1701 | 130.38 | 130.13 | 130.17 | 2623400.0 |
| 2006-04-25 13:00:00 | SPY | ETF | 130.18 | 130.19 | 129.92 | 130.08 | 5754000.0 |
| 2006-04-25 13:30:00 | SPY | ETF | 130.08 | 130.3 | 130.03 | 130.16 | 4728500.0 |
| 2006-04-25 14:00:00 | SPY | ETF | 130.16 | 130.4 | 130.07 | 130.2699 | 3670200.0 |
| 2006-04-25 14:30:00 | SPY | ETF | 130.27 | 130.44 | 130.09 | 130.12 | 4032300.0 |
| 2006-04-25 15:00:00 | SPY | ETF | 130.12 | 130.23 | 129.93 | 130.1 | 4419700.0 |
| 2006-04-25 15:30:00 | SPY | ETF | 130.1 | 130.28 | 130.0595 | 130.21 | 6371500.0 |
| 2006-04-25 16:00:00 | SPY | ETF | 130.23 | 130.42 | 130.12 | 130.4 | 1592400.0 |
| 2006-04-25 16:30:00 | SPY | ETF | 130.4 | 130.42 | 130.29 | 130.35 | 171200.0 |
| 2006-04-25 17:00:00 | SPY | ETF | 130.33 | 130.39 | 130.33 | 130.39 | 163600.0 |
| 2006-04-25 17:30:00 | SPY | ETF | 130.36 | 130.36 | 130.36 | 130.36 | 1000.0 |
| 2006-04-25 18:30:00 | SPY | ETF | 130.36 | 130.36 | 130.36 | 130.36 | 100.0 |
| 2006-04-25 19:00:00 | SPY | ETF | 130.39 | 130.39 | 130.39 | 130.39 | 100.0 |
| 2006-04-25 19:30:00 | SPY | ETF | 130.4 | 130.4 | 130.39 | 130.39 | 800.0 |
| 2006-04-25 09:30:00 | QQQ | ETF | 42.08 | 42.1 | 41.91 | 41.99 | 7379700.0 |
| 2006-04-25 10:00:00 | QQQ | ETF | 42.0 | 42.03 | 41.72 | 41.79 | 13569000.0 |
| 2006-04-25 10:30:00 | QQQ | ETF | 41.79 | 42.01 | 41.75 | 41.86 | 10936300.0 |
| 2006-04-25 11:00:00 | QQQ | ETF | 41.87 | 41.92 | 41.81 | 41.84 | 3930300.0 |
| 2006-04-25 11:30:00 | QQQ | ETF | 41.84 | 41.87 | 41.7 | 41.74 | 5851200.0 |
| 2006-04-25 12:00:00 | QQQ | ETF | 41.74 | 41.81 | 41.69 | 41.79 | 4923700.0 |
| 2006-04-25 12:30:00 | QQQ | ETF | 41.79 | 41.83 | 41.74 | 41.75 | 2281700.0 |
| 2006-04-25 13:00:00 | QQQ | ETF | 41.75 | 41.76 | 41.65 | 41.72 | 5576100.0 |
| 2006-04-25 13:30:00 | QQQ | ETF | 41.71 | 41.84 | 41.69 | 41.78 | 4184300.0 |
| 2006-04-25 14:00:00 | QQQ | ETF | 41.78 | 41.88 | 41.73 | 41.85 | 3094100.0 |
| 2006-04-25 14:30:00 | QQQ | ETF | 41.85 | 41.91 | 41.75 | 41.75 | 3981200.0 |
| 2006-04-25 15:00:00 | QQQ | ETF | 41.76 | 41.8 | 41.72 | 41.77 | 2224200.0 |
| 2006-04-25 15:30:00 | QQQ | ETF | 41.77 | 41.88 | 41.77 | 41.87 | 5563000.0 |
| 2006-04-25 08:00:00 | IWM | ETF | 76.12 | 76.21 | 76.12 | 76.21 | 502500.0 |
| 2006-04-25 08:30:00 | IWM | ETF | 76.21 | 76.21 | 76.14 | 76.15 | 5100.0 |
| 2006-04-25 09:00:00 | IWM | ETF | 76.15 | 76.21 | 76.15 | 76.2 | 52200.0 |
| 2006-04-25 09:30:00 | IWM | ETF | 76.1 | 76.21 | 75.86 | 76.07 | 2778000.0 |
| 2006-04-25 10:00:00 | IWM | ETF | 76.07 | 76.11 | 75.57 | 75.63 | 4839200.0 |
| 2006-04-25 10:30:00 | IWM | ETF | 75.62 | 76.0 | 75.59 | 75.83 | 2937600.0 |
| 2006-04-25 11:00:00 | IWM | ETF | 75.84 | 75.93 | 75.73 | 75.8 | 2277700.0 |
| 2006-04-25 11:30:00 | IWM | ETF | 75.79 | 75.82 | 75.48 | 75.62 | 3537800.0 |
| 2006-04-25 12:00:00 | IWM | ETF | 75.62 | 75.75 | 75.53 | 75.73 | 2290300.0 |
| 2006-04-25 12:30:00 | IWM | ETF | 75.72 | 76.0 | 75.72 | 75.82 | 3055000.0 |
| 2006-04-25 13:00:00 | IWM | ETF | 75.83 | 75.97 | 75.58 | 75.68 | 2128500.0 |
| 2006-04-25 13:30:00 | IWM | ETF | 75.68 | 75.86 | 75.66 | 75.76 | 1609300.0 |
> showing 50 of 2,205 rows — these rows as CSV