PREVIEW / etf_30min / 2006-03-13
file: by_date/etf_30min/2006/2006-03-13.parquet size: 59 KB rows: 2,176
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-13 07:00:00 | SPY | ETF | 128.9 | 128.9 | 128.82 | 128.84 | 10000.0 |
| 2006-03-13 07:30:00 | SPY | ETF | 128.89 | 128.9 | 128.8 | 128.82 | 25300.0 |
| 2006-03-13 08:00:00 | SPY | ETF | 128.82 | 128.93 | 128.7 | 128.83 | 623700.0 |
| 2006-03-13 08:30:00 | SPY | ETF | 128.83 | 128.86 | 128.81 | 128.86 | 129800.0 |
| 2006-03-13 09:00:00 | SPY | ETF | 128.87 | 128.9 | 128.69 | 128.86 | 323900.0 |
| 2006-03-13 09:30:00 | SPY | ETF | 128.84 | 129.04 | 128.83 | 128.93 | 7015400.0 |
| 2006-03-13 10:00:00 | SPY | ETF | 128.94 | 129.16 | 128.93 | 128.99 | 6637100.0 |
| 2006-03-13 10:30:00 | SPY | ETF | 128.99 | 129.13 | 128.91 | 129.01 | 2876500.0 |
| 2006-03-13 11:00:00 | SPY | ETF | 129.01 | 129.04 | 128.75 | 128.88 | 3429300.0 |
| 2006-03-13 11:30:00 | SPY | ETF | 128.88 | 128.94 | 128.71 | 128.76 | 2197200.0 |
| 2006-03-13 12:00:00 | SPY | ETF | 128.75 | 128.84 | 128.67 | 128.81 | 1767100.0 |
| 2006-03-13 12:30:00 | SPY | ETF | 128.82 | 128.89 | 128.7 | 128.83 | 1211100.0 |
| 2006-03-13 13:00:00 | SPY | ETF | 128.82 | 128.86 | 128.53 | 128.68 | 2113100.0 |
| 2006-03-13 13:30:00 | SPY | ETF | 128.69 | 128.82 | 128.6 | 128.74 | 2685300.0 |
| 2006-03-13 14:00:00 | SPY | ETF | 128.75 | 128.96 | 128.74 | 128.89 | 2162600.0 |
| 2006-03-13 14:30:00 | SPY | ETF | 128.88 | 128.96 | 128.64 | 128.67 | 2180300.0 |
| 2006-03-13 15:00:00 | SPY | ETF | 128.67 | 128.86 | 128.53 | 128.66 | 3100300.0 |
| 2006-03-13 15:30:00 | SPY | ETF | 128.66 | 128.84 | 128.64 | 128.82 | 4247800.0 |
| 2006-03-13 16:00:00 | SPY | ETF | 128.83 | 128.91 | 128.75 | 128.84 | 721100.0 |
| 2006-03-13 16:30:00 | SPY | ETF | 128.84 | 128.88 | 128.82 | 128.84 | 165100.0 |
| 2006-03-13 17:00:00 | SPY | ETF | 128.84 | 128.85 | 128.81 | 128.84 | 72300.0 |
| 2006-03-13 17:30:00 | SPY | ETF | 128.85 | 128.85 | 128.85 | 128.85 | 2800.0 |
| 2006-03-13 18:00:00 | SPY | ETF | 128.85 | 128.85 | 128.76 | 128.76 | 233900.0 |
| 2006-03-13 18:30:00 | SPY | ETF | 128.82 | 128.86 | 128.82 | 128.86 | 500.0 |
| 2006-03-13 19:30:00 | SPY | ETF | 128.82 | 128.82 | 128.77 | 128.8 | 23100.0 |
| 2006-03-13 09:30:00 | QQQ | ETF | 40.76 | 40.9 | 40.73 | 40.85 | 10575900.0 |
| 2006-03-13 10:00:00 | QQQ | ETF | 40.85 | 40.94 | 40.81 | 40.81 | 8927700.0 |
| 2006-03-13 10:30:00 | QQQ | ETF | 40.82 | 40.89 | 40.75 | 40.84 | 4895600.0 |
| 2006-03-13 11:00:00 | QQQ | ETF | 40.84 | 40.84 | 40.67 | 40.72 | 5306800.0 |
| 2006-03-13 11:30:00 | QQQ | ETF | 40.71 | 40.73 | 40.65 | 40.67 | 4177300.0 |
| 2006-03-13 12:00:00 | QQQ | ETF | 40.66 | 40.73 | 40.63 | 40.71 | 2535500.0 |
| 2006-03-13 12:30:00 | QQQ | ETF | 40.7 | 40.78 | 40.68 | 40.75 | 2522100.0 |
| 2006-03-13 13:00:00 | QQQ | ETF | 40.75 | 40.77 | 40.62 | 40.68 | 4702200.0 |
| 2006-03-13 13:30:00 | QQQ | ETF | 40.68 | 40.71 | 40.63 | 40.66 | 4324100.0 |
| 2006-03-13 14:00:00 | QQQ | ETF | 40.66 | 40.78 | 40.65 | 40.74 | 3300700.0 |
| 2006-03-13 14:30:00 | QQQ | ETF | 40.73 | 40.78 | 40.62 | 40.65 | 3103700.0 |
| 2006-03-13 15:00:00 | QQQ | ETF | 40.64 | 40.73 | 40.62 | 40.66 | 3233700.0 |
| 2006-03-13 15:30:00 | QQQ | ETF | 40.66 | 40.71 | 40.64 | 40.67 | 5939100.0 |
| 2006-03-13 07:30:00 | IWM | ETF | 72.38 | 72.44 | 72.38 | 72.44 | 600.0 |
| 2006-03-13 08:00:00 | IWM | ETF | 72.38 | 72.56 | 72.38 | 72.55 | 122800.0 |
| 2006-03-13 08:30:00 | IWM | ETF | 72.57 | 72.6 | 72.54 | 72.56 | 96600.0 |
| 2006-03-13 09:00:00 | IWM | ETF | 72.6 | 72.64 | 72.58 | 72.62 | 171300.0 |
| 2006-03-13 09:30:00 | IWM | ETF | 72.6 | 72.95 | 72.6 | 72.8 | 5375100.0 |
| 2006-03-13 10:00:00 | IWM | ETF | 72.8 | 73.03 | 72.79 | 72.89 | 2804200.0 |
| 2006-03-13 10:30:00 | IWM | ETF | 72.89 | 73.08 | 72.81 | 72.92 | 1895700.0 |
| 2006-03-13 11:00:00 | IWM | ETF | 72.92 | 72.94 | 72.75 | 72.86 | 1942300.0 |
| 2006-03-13 11:30:00 | IWM | ETF | 72.85 | 72.86 | 72.69 | 72.69 | 2162200.0 |
| 2006-03-13 12:00:00 | IWM | ETF | 72.69 | 72.79 | 72.66 | 72.76 | 973300.0 |
| 2006-03-13 12:30:00 | IWM | ETF | 72.75 | 72.84 | 72.7 | 72.84 | 756900.0 |
| 2006-03-13 13:00:00 | IWM | ETF | 72.84 | 72.85 | 72.6 | 72.74 | 2102800.0 |
> showing 50 of 2,176 rows — these rows as CSV