PREVIEW / etf_30min / 2006-07-25
file: by_date/etf_30min/2006/2006-07-25.parquet size: 77 KB rows: 2,650
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-07-25 04:00:00 | SPY | ETF | 126.1 | 126.1 | 126.1 | 126.1 | 1000.0 |
| 2006-07-25 05:30:00 | SPY | ETF | 126.19 | 126.19 | 126.19 | 126.19 | 500.0 |
| 2006-07-25 06:30:00 | SPY | ETF | 126.35 | 126.35 | 126.32 | 126.32 | 300.0 |
| 2006-07-25 07:00:00 | SPY | ETF | 126.32 | 126.33 | 126.29 | 126.3 | 22900.0 |
| 2006-07-25 07:30:00 | SPY | ETF | 126.26 | 126.26 | 126.16 | 126.24 | 21800.0 |
| 2006-07-25 08:00:00 | SPY | ETF | 126.21 | 126.32 | 126.11 | 126.14 | 287600.0 |
| 2006-07-25 08:30:00 | SPY | ETF | 126.1 | 126.16 | 126.05 | 126.06 | 172600.0 |
| 2006-07-25 09:00:00 | SPY | ETF | 126.06 | 126.09 | 125.97 | 125.98 | 1090100.0 |
| 2006-07-25 09:30:00 | SPY | ETF | 125.98 | 126.17 | 125.83 | 126.12 | 8197200.0 |
| 2006-07-25 10:00:00 | SPY | ETF | 126.1 | 126.77 | 126.07 | 126.43 | 15483700.0 |
| 2006-07-25 10:30:00 | SPY | ETF | 126.44 | 126.47 | 125.72 | 125.96 | 11470500.0 |
| 2006-07-25 11:00:00 | SPY | ETF | 125.97 | 126.07 | 125.73 | 126.05 | 4527900.0 |
| 2006-07-25 11:30:00 | SPY | ETF | 126.04 | 126.06 | 125.75 | 125.84 | 2558100.0 |
| 2006-07-25 12:00:00 | SPY | ETF | 125.84 | 126.08 | 125.72 | 126.03 | 2968900.0 |
| 2006-07-25 12:30:00 | SPY | ETF | 126.04 | 126.2 | 125.98 | 126.15 | 2974000.0 |
| 2006-07-25 13:00:00 | SPY | ETF | 126.15 | 126.25 | 126.03 | 126.1292 | 2635200.0 |
| 2006-07-25 13:30:00 | SPY | ETF | 126.13 | 126.16 | 125.91 | 126.09 | 2115300.0 |
| 2006-07-25 14:00:00 | SPY | ETF | 126.09 | 126.15 | 125.85 | 126.03 | 3257600.0 |
| 2006-07-25 14:30:00 | SPY | ETF | 126.03 | 126.44 | 125.99 | 126.34 | 6608200.0 |
| 2006-07-25 15:00:00 | SPY | ETF | 126.34 | 127.1 | 126.34 | 127.1 | 12347000.0 |
| 2006-07-25 15:30:00 | SPY | ETF | 127.1 | 127.3 | 126.91 | 126.95 | 11168500.0 |
| 2006-07-25 16:00:00 | SPY | ETF | 126.95 | 126.9585 | 125.943 | 126.62 | 4411600.0 |
| 2006-07-25 16:30:00 | SPY | ETF | 126.62 | 126.65 | 126.5 | 126.57 | 93800.0 |
| 2006-07-25 17:00:00 | SPY | ETF | 126.58 | 126.63 | 126.56 | 126.62 | 115300.0 |
| 2006-07-25 17:30:00 | SPY | ETF | 126.6 | 126.65 | 126.59 | 126.63 | 4000.0 |
| 2006-07-25 18:00:00 | SPY | ETF | 126.63 | 126.63 | 126.63 | 126.63 | 2900.0 |
| 2006-07-25 18:30:00 | SPY | ETF | 126.58 | 126.58 | 126.56 | 126.56 | 41100.0 |
| 2006-07-25 19:30:00 | SPY | ETF | 126.55 | 126.6 | 126.55 | 126.6 | 3100.0 |
| 2006-07-25 09:30:00 | QQQ | ETF | 36.47 | 36.51 | 36.36 | 36.5 | 13210500.0 |
| 2006-07-25 10:00:00 | QQQ | ETF | 36.5 | 37.73 | 36.49 | 36.55 | 18967100.0 |
| 2006-07-25 10:30:00 | QQQ | ETF | 36.55 | 36.56 | 36.27 | 36.34 | 12611600.0 |
| 2006-07-25 11:00:00 | QQQ | ETF | 36.35 | 36.45 | 36.27 | 36.4 | 5207800.0 |
| 2006-07-25 11:30:00 | QQQ | ETF | 36.41 | 36.41 | 36.28 | 36.32 | 3390000.0 |
| 2006-07-25 12:00:00 | QQQ | ETF | 36.31 | 36.38 | 36.25 | 36.37 | 2503500.0 |
| 2006-07-25 12:30:00 | QQQ | ETF | 36.37 | 36.45 | 36.34 | 36.41 | 4317600.0 |
| 2006-07-25 13:00:00 | QQQ | ETF | 36.41 | 36.45 | 36.36 | 36.39 | 3050800.0 |
| 2006-07-25 13:30:00 | QQQ | ETF | 36.38 | 36.4 | 36.29 | 36.36 | 3182700.0 |
| 2006-07-25 14:00:00 | QQQ | ETF | 36.35 | 36.38 | 36.24 | 36.31 | 3387800.0 |
| 2006-07-25 14:30:00 | QQQ | ETF | 36.32 | 36.48 | 36.3 | 36.42 | 7211200.0 |
| 2006-07-25 15:00:00 | QQQ | ETF | 36.42 | 36.64 | 36.41 | 36.62 | 9175900.0 |
| 2006-07-25 15:30:00 | QQQ | ETF | 36.63 | 36.72 | 36.55 | 36.6 | 13702500.0 |
| 2006-07-25 07:30:00 | IWM | ETF | 68.95 | 69.0 | 68.95 | 69.0 | 10000.0 |
| 2006-07-25 08:00:00 | IWM | ETF | 69.06 | 69.67 | 68.86 | 68.91 | 430100.0 |
| 2006-07-25 08:30:00 | IWM | ETF | 68.88 | 68.91 | 68.75 | 68.76 | 148500.0 |
| 2006-07-25 09:00:00 | IWM | ETF | 68.78 | 68.86 | 68.7 | 68.7 | 213100.0 |
| 2006-07-25 09:30:00 | IWM | ETF | 68.7 | 69.4 | 68.39 | 69.06 | 12081400.0 |
| 2006-07-25 10:00:00 | IWM | ETF | 69.06 | 69.78 | 69.04 | 69.38 | 17492700.0 |
| 2006-07-25 10:30:00 | IWM | ETF | 69.45 | 69.55 | 68.5 | 68.79 | 11573500.0 |
| 2006-07-25 11:00:00 | IWM | ETF | 68.8 | 69.0 | 68.65 | 68.97 | 3637700.0 |
| 2006-07-25 11:30:00 | IWM | ETF | 68.98 | 68.98 | 68.7 | 68.79 | 1693900.0 |
> showing 50 of 2,650 rows — these rows as CSV