PREVIEW / etf_30min / 2006-03-21
file: by_date/etf_30min/2006/2006-03-21.parquet size: 63 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-03-21 07:00:00 | SPY | ETF | 130.3 | 130.3 | 130.3 | 130.3 | 800.0 |
| 2006-03-21 07:30:00 | SPY | ETF | 130.25 | 130.25 | 130.17 | 130.19 | 111200.0 |
| 2006-03-21 08:00:00 | SPY | ETF | 130.2 | 130.29 | 130.15 | 130.24 | 477300.0 |
| 2006-03-21 08:30:00 | SPY | ETF | 130.22 | 130.26 | 130.11 | 130.24 | 593400.0 |
| 2006-03-21 09:00:00 | SPY | ETF | 130.27 | 130.44 | 130.18 | 130.34 | 513400.0 |
| 2006-03-21 09:30:00 | SPY | ETF | 130.34 | 130.48 | 130.08 | 130.22 | 8026500.0 |
| 2006-03-21 10:00:00 | SPY | ETF | 130.22 | 130.24 | 129.94 | 130.14 | 6521600.0 |
| 2006-03-21 10:30:00 | SPY | ETF | 130.14 | 130.39 | 130.09 | 130.14 | 4529900.0 |
| 2006-03-21 11:00:00 | SPY | ETF | 130.13 | 130.44 | 130.12 | 130.34 | 2120200.0 |
| 2006-03-21 11:30:00 | SPY | ETF | 130.34 | 130.91 | 130.32 | 130.78 | 8479500.0 |
| 2006-03-21 12:00:00 | SPY | ETF | 130.78 | 130.87 | 130.69 | 130.79 | 2667700.0 |
| 2006-03-21 12:30:00 | SPY | ETF | 130.79 | 130.99 | 130.66 | 130.72 | 4118600.0 |
| 2006-03-21 13:00:00 | SPY | ETF | 130.72 | 130.81 | 130.58 | 130.63 | 3274300.0 |
| 2006-03-21 13:30:00 | SPY | ETF | 130.62 | 130.7 | 130.17 | 130.28 | 7287100.0 |
| 2006-03-21 14:00:00 | SPY | ETF | 130.28 | 130.34 | 129.76 | 129.84 | 8620000.0 |
| 2006-03-21 14:30:00 | SPY | ETF | 129.83 | 129.94 | 129.53 | 129.64 | 9520300.0 |
| 2006-03-21 15:00:00 | SPY | ETF | 129.62 | 129.7 | 129.47 | 129.52 | 7938300.0 |
| 2006-03-21 15:30:00 | SPY | ETF | 129.52 | 129.71 | 129.45 | 129.59 | 7960900.0 |
| 2006-03-21 16:00:00 | SPY | ETF | 129.59 | 129.6376 | 129.54 | 129.62 | 1561700.0 |
| 2006-03-21 16:30:00 | SPY | ETF | 129.63 | 129.66 | 129.62 | 129.66 | 28500.0 |
| 2006-03-21 17:00:00 | SPY | ETF | 129.66 | 129.68 | 129.63 | 129.65 | 57900.0 |
| 2006-03-21 17:30:00 | SPY | ETF | 129.65 | 129.65 | 129.48 | 129.59 | 130600.0 |
| 2006-03-21 18:00:00 | SPY | ETF | 129.59 | 129.59 | 129.43 | 129.52 | 176700.0 |
| 2006-03-21 18:30:00 | SPY | ETF | 129.52 | 129.52 | 129.49 | 129.49 | 18100.0 |
| 2006-03-21 19:00:00 | SPY | ETF | 129.5 | 129.54 | 129.49 | 129.54 | 10900.0 |
| 2006-03-21 09:30:00 | QQQ | ETF | 41.51 | 41.54 | 41.28 | 41.4 | 12195200.0 |
| 2006-03-21 10:00:00 | QQQ | ETF | 41.4 | 41.43 | 41.23 | 41.35 | 6345300.0 |
| 2006-03-21 10:30:00 | QQQ | ETF | 41.36 | 41.48 | 41.35 | 41.4 | 6477300.0 |
| 2006-03-21 11:00:00 | QQQ | ETF | 41.4 | 41.68 | 41.4 | 41.64 | 10372100.0 |
| 2006-03-21 11:30:00 | QQQ | ETF | 41.63 | 42.01 | 41.63 | 41.93 | 18947400.0 |
| 2006-03-21 12:00:00 | QQQ | ETF | 41.93 | 41.97 | 41.89 | 41.92 | 6526800.0 |
| 2006-03-21 12:30:00 | QQQ | ETF | 41.93 | 41.99 | 41.85 | 41.87 | 7333500.0 |
| 2006-03-21 13:00:00 | QQQ | ETF | 41.87 | 41.88 | 41.8 | 41.81 | 4157700.0 |
| 2006-03-21 13:30:00 | QQQ | ETF | 41.82 | 41.85 | 41.62 | 41.67 | 8015700.0 |
| 2006-03-21 14:00:00 | QQQ | ETF | 41.66 | 41.85 | 41.37 | 41.41 | 15137700.0 |
| 2006-03-21 14:30:00 | QQQ | ETF | 41.41 | 41.45 | 41.25 | 41.27 | 12277000.0 |
| 2006-03-21 15:00:00 | QQQ | ETF | 41.27 | 41.29 | 41.1 | 41.12 | 12577100.0 |
| 2006-03-21 15:30:00 | QQQ | ETF | 41.12 | 41.17 | 41.08 | 41.11 | 9617800.0 |
| 2006-03-21 07:30:00 | IWM | ETF | 73.91 | 73.91 | 73.91 | 73.91 | 100.0 |
| 2006-03-21 08:00:00 | IWM | ETF | 73.97 | 73.97 | 73.92 | 73.96 | 157100.0 |
| 2006-03-21 08:30:00 | IWM | ETF | 73.94 | 73.96 | 73.88 | 73.96 | 44700.0 |
| 2006-03-21 09:00:00 | IWM | ETF | 73.95 | 74.02 | 73.95 | 74.02 | 33400.0 |
| 2006-03-21 09:30:00 | IWM | ETF | 74.0 | 74.08 | 73.71 | 73.87 | 2746200.0 |
| 2006-03-21 10:00:00 | IWM | ETF | 73.87 | 73.88 | 73.53 | 73.64 | 3591100.0 |
| 2006-03-21 10:30:00 | IWM | ETF | 73.69 | 73.89 | 73.68 | 73.75 | 1536300.0 |
| 2006-03-21 11:00:00 | IWM | ETF | 73.75 | 74.04 | 73.74 | 73.99 | 1337800.0 |
| 2006-03-21 11:30:00 | IWM | ETF | 73.97 | 74.6 | 73.97 | 74.49 | 6122100.0 |
| 2006-03-21 12:00:00 | IWM | ETF | 74.49 | 74.54 | 74.45 | 74.5 | 747600.0 |
| 2006-03-21 12:30:00 | IWM | ETF | 74.51 | 74.6 | 74.4 | 74.44 | 1478500.0 |
| 2006-03-21 13:00:00 | IWM | ETF | 74.44 | 74.48 | 74.31 | 74.34 | 1508800.0 |
> showing 50 of 2,205 rows — these rows as CSV