PREVIEW / etf_30min / 2006-09-06
file: by_date/etf_30min/2006/2006-09-06.parquet size: 78 KB rows: 2,801
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-09-06 06:30:00 | SPY | ETF | 131.45 | 131.45 | 131.25 | 131.25 | 14400.0 |
| 2006-09-06 07:00:00 | SPY | ETF | 131.27 | 131.4 | 131.27 | 131.37 | 147300.0 |
| 2006-09-06 07:30:00 | SPY | ETF | 131.33 | 131.41 | 131.25 | 131.32 | 80100.0 |
| 2006-09-06 08:00:00 | SPY | ETF | 131.45 | 131.67 | 131.26 | 131.28 | 1080300.0 |
| 2006-09-06 08:30:00 | SPY | ETF | 131.27 | 131.27 | 131.1 | 131.13 | 847200.0 |
| 2006-09-06 09:00:00 | SPY | ETF | 131.13 | 131.67 | 131.07 | 131.1 | 410400.0 |
| 2006-09-06 09:30:00 | SPY | ETF | 131.11 | 131.16 | 130.94 | 130.99 | 6624700.0 |
| 2006-09-06 10:00:00 | SPY | ETF | 130.99 | 131.13 | 130.99 | 131.09 | 3649100.0 |
| 2006-09-06 10:30:00 | SPY | ETF | 131.09 | 131.09 | 130.83 | 130.91 | 3103900.0 |
| 2006-09-06 11:00:00 | SPY | ETF | 130.92 | 131.03 | 130.85 | 130.9 | 2347000.0 |
| 2006-09-06 11:30:00 | SPY | ETF | 130.9 | 130.9 | 130.75 | 130.76 | 4482600.0 |
| 2006-09-06 12:00:00 | SPY | ETF | 130.76 | 130.82 | 130.71 | 130.77 | 2813300.0 |
| 2006-09-06 12:30:00 | SPY | ETF | 130.78 | 130.93 | 130.74 | 130.88 | 1874500.0 |
| 2006-09-06 13:00:00 | SPY | ETF | 130.88 | 130.98 | 130.78 | 130.95 | 1297700.0 |
| 2006-09-06 13:30:00 | SPY | ETF | 130.95 | 131.03 | 130.89 | 130.93 | 1623500.0 |
| 2006-09-06 14:00:00 | SPY | ETF | 130.93 | 131.0 | 130.64 | 130.77 | 6123200.0 |
| 2006-09-06 14:30:00 | SPY | ETF | 130.76 | 130.81 | 130.4 | 130.5 | 4030500.0 |
| 2006-09-06 15:00:00 | SPY | ETF | 130.48 | 130.57 | 130.34 | 130.43 | 5802400.0 |
| 2006-09-06 15:30:00 | SPY | ETF | 130.44 | 130.53 | 130.33 | 130.42 | 5336900.0 |
| 2006-09-06 16:00:00 | SPY | ETF | 130.43 | 130.55 | 130.4 | 130.55 | 490000.0 |
| 2006-09-06 16:30:00 | SPY | ETF | 130.51 | 130.51 | 130.44 | 130.51 | 265700.0 |
| 2006-09-06 17:00:00 | SPY | ETF | 130.47 | 130.47 | 130.41 | 130.43 | 26100.0 |
| 2006-09-06 17:30:00 | SPY | ETF | 130.43 | 130.43 | 130.38 | 130.41 | 9700.0 |
| 2006-09-06 18:00:00 | SPY | ETF | 130.41 | 130.41 | 130.38 | 130.38 | 55000.0 |
| 2006-09-06 19:30:00 | SPY | ETF | 130.46 | 130.46 | 130.46 | 130.46 | 1500.0 |
| 2006-09-06 09:30:00 | QQQ | ETF | 39.09 | 39.17 | 39.02 | 39.11 | 10506500.0 |
| 2006-09-06 10:00:00 | QQQ | ETF | 39.1 | 39.19 | 39.09 | 39.16 | 5352000.0 |
| 2006-09-06 10:30:00 | QQQ | ETF | 39.16 | 39.17 | 38.99 | 39.06 | 9080800.0 |
| 2006-09-06 11:00:00 | QQQ | ETF | 39.06 | 39.12 | 39.04 | 39.05 | 2635400.0 |
| 2006-09-06 11:30:00 | QQQ | ETF | 39.04 | 39.05 | 38.89 | 38.89 | 9708300.0 |
| 2006-09-06 12:00:00 | QQQ | ETF | 38.89 | 38.94 | 38.87 | 38.9 | 3284500.0 |
| 2006-09-06 12:30:00 | QQQ | ETF | 38.9 | 38.99 | 38.86 | 38.95 | 5554300.0 |
| 2006-09-06 13:00:00 | QQQ | ETF | 38.95 | 39.03 | 38.91 | 38.99 | 2318700.0 |
| 2006-09-06 13:30:00 | QQQ | ETF | 39.0 | 39.02 | 38.96 | 38.99 | 2882800.0 |
| 2006-09-06 14:00:00 | QQQ | ETF | 38.98 | 39.02 | 38.88 | 38.94 | 5440800.0 |
| 2006-09-06 14:30:00 | QQQ | ETF | 38.93 | 39.0 | 38.71 | 38.74 | 7902100.0 |
| 2006-09-06 15:00:00 | QQQ | ETF | 38.75 | 38.75 | 38.61 | 38.66 | 11539000.0 |
| 2006-09-06 15:30:00 | QQQ | ETF | 38.67 | 38.77 | 38.65 | 38.68 | 9196400.0 |
| 2006-09-06 07:30:00 | IWM | ETF | 72.14 | 72.14 | 72.1 | 72.11 | 30400.0 |
| 2006-09-06 08:00:00 | IWM | ETF | 72.13 | 72.2 | 72.1 | 72.2 | 60700.0 |
| 2006-09-06 08:30:00 | IWM | ETF | 72.13 | 72.13 | 71.92 | 71.96 | 192500.0 |
| 2006-09-06 09:00:00 | IWM | ETF | 71.94 | 72.02 | 71.92 | 71.97 | 115600.0 |
| 2006-09-06 09:30:00 | IWM | ETF | 71.92 | 71.93 | 71.46 | 71.52 | 5141900.0 |
| 2006-09-06 10:00:00 | IWM | ETF | 71.52 | 71.72 | 71.5 | 71.64 | 2769800.0 |
| 2006-09-06 10:30:00 | IWM | ETF | 71.64 | 71.64 | 71.27 | 71.37 | 1931700.0 |
| 2006-09-06 11:00:00 | IWM | ETF | 71.37 | 71.49 | 71.33 | 71.4 | 2233200.0 |
| 2006-09-06 11:30:00 | IWM | ETF | 71.4 | 71.4 | 71.11 | 71.11 | 5202000.0 |
| 2006-09-06 12:00:00 | IWM | ETF | 71.12 | 71.19 | 71.07 | 71.18 | 2204500.0 |
| 2006-09-06 12:30:00 | IWM | ETF | 71.18 | 71.3 | 71.13 | 71.23 | 1696900.0 |
| 2006-09-06 13:00:00 | IWM | ETF | 71.23 | 71.33 | 71.19 | 71.32 | 3639700.0 |
> showing 50 of 2,801 rows — these rows as CSV