PREVIEW / etf_30min / 2006-04-12
file: by_date/etf_30min/2006/2006-04-12.parquet size: 59 KB rows: 2,202
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-12 06:00:00 | SPY | ETF | 128.62 | 128.62 | 128.62 | 128.62 | 200.0 |
| 2006-04-12 06:30:00 | SPY | ETF | 128.6 | 128.6 | 128.6 | 128.6 | 100.0 |
| 2006-04-12 07:00:00 | SPY | ETF | 128.65 | 128.74 | 128.65 | 128.74 | 3500.0 |
| 2006-04-12 07:30:00 | SPY | ETF | 128.7 | 128.86 | 128.7 | 128.86 | 56600.0 |
| 2006-04-12 08:00:00 | SPY | ETF | 128.8 | 128.88 | 128.69 | 128.86 | 231700.0 |
| 2006-04-12 08:30:00 | SPY | ETF | 128.88 | 128.94 | 128.73 | 128.75 | 319200.0 |
| 2006-04-12 09:00:00 | SPY | ETF | 128.77 | 128.85 | 128.58 | 128.78 | 430700.0 |
| 2006-04-12 09:30:00 | SPY | ETF | 128.77 | 129.03 | 128.73 | 128.82 | 4956500.0 |
| 2006-04-12 10:00:00 | SPY | ETF | 128.82 | 129.13 | 128.79 | 128.95 | 4547400.0 |
| 2006-04-12 10:30:00 | SPY | ETF | 128.95 | 128.98 | 128.61 | 128.88 | 5646700.0 |
| 2006-04-12 11:00:00 | SPY | ETF | 128.89 | 129.0 | 128.82 | 128.91 | 3079900.0 |
| 2006-04-12 11:30:00 | SPY | ETF | 128.91 | 128.99 | 128.7 | 128.72 | 2885400.0 |
| 2006-04-12 12:00:00 | SPY | ETF | 128.73 | 128.9 | 128.65 | 128.78 | 1643500.0 |
| 2006-04-12 12:30:00 | SPY | ETF | 128.79 | 128.95 | 128.77 | 128.89 | 1681800.0 |
| 2006-04-12 13:00:00 | SPY | ETF | 128.89 | 129.01 | 128.79 | 128.82 | 2886900.0 |
| 2006-04-12 13:30:00 | SPY | ETF | 128.83 | 128.86 | 128.73 | 128.78 | 1726800.0 |
| 2006-04-12 14:00:00 | SPY | ETF | 128.78 | 128.86 | 128.67 | 128.74 | 1842800.0 |
| 2006-04-12 14:30:00 | SPY | ETF | 128.76 | 128.8 | 128.63 | 128.71 | 2520700.0 |
| 2006-04-12 15:00:00 | SPY | ETF | 128.7 | 128.86 | 128.64 | 128.81 | 2793500.0 |
| 2006-04-12 15:30:00 | SPY | ETF | 128.81 | 128.9 | 128.76 | 128.85 | 3779700.0 |
| 2006-04-12 16:00:00 | SPY | ETF | 128.83 | 128.92 | 128.79 | 128.9 | 404100.0 |
| 2006-04-12 16:30:00 | SPY | ETF | 128.9 | 128.97 | 128.85 | 128.89 | 403800.0 |
| 2006-04-12 17:00:00 | SPY | ETF | 128.89 | 128.9 | 128.87 | 128.89 | 7300.0 |
| 2006-04-12 17:30:00 | SPY | ETF | 128.91 | 128.96 | 128.89 | 128.9 | 9600.0 |
| 2006-04-12 18:00:00 | SPY | ETF | 128.93 | 128.95 | 128.9 | 128.9 | 10100.0 |
| 2006-04-12 19:30:00 | SPY | ETF | 128.96 | 128.96 | 128.95 | 128.96 | 700.0 |
| 2006-04-12 09:30:00 | QQQ | ETF | 41.95 | 42.01 | 41.91 | 41.95 | 11242400.0 |
| 2006-04-12 10:00:00 | QQQ | ETF | 41.95 | 42.08 | 41.93 | 42.01 | 6646200.0 |
| 2006-04-12 10:30:00 | QQQ | ETF | 42.01 | 42.01 | 41.86 | 41.96 | 6576500.0 |
| 2006-04-12 11:00:00 | QQQ | ETF | 41.96 | 42.03 | 41.94 | 42.0 | 4030100.0 |
| 2006-04-12 11:30:00 | QQQ | ETF | 42.0 | 42.02 | 41.9 | 41.91 | 3391600.0 |
| 2006-04-12 12:00:00 | QQQ | ETF | 41.92 | 41.97 | 41.88 | 41.94 | 2169800.0 |
| 2006-04-12 12:30:00 | QQQ | ETF | 41.94 | 42.01 | 41.91 | 42.01 | 3078700.0 |
| 2006-04-12 13:00:00 | QQQ | ETF | 42.01 | 42.03 | 41.93 | 41.94 | 4118600.0 |
| 2006-04-12 13:30:00 | QQQ | ETF | 41.94 | 41.97 | 41.91 | 41.94 | 2083700.0 |
| 2006-04-12 14:00:00 | QQQ | ETF | 41.94 | 41.96 | 41.85 | 41.88 | 2707800.0 |
| 2006-04-12 14:30:00 | QQQ | ETF | 41.89 | 41.9 | 41.8 | 41.86 | 4174700.0 |
| 2006-04-12 15:00:00 | QQQ | ETF | 41.85 | 41.95 | 41.84 | 41.92 | 2470100.0 |
| 2006-04-12 15:30:00 | QQQ | ETF | 41.92 | 41.95 | 41.91 | 41.93 | 3204500.0 |
| 2006-04-12 08:00:00 | IWM | ETF | 73.5 | 73.65 | 73.5 | 73.65 | 3800.0 |
| 2006-04-12 08:30:00 | IWM | ETF | 73.7 | 73.7 | 73.65 | 73.65 | 13400.0 |
| 2006-04-12 09:00:00 | IWM | ETF | 73.6 | 73.67 | 73.6 | 73.61 | 87900.0 |
| 2006-04-12 09:30:00 | IWM | ETF | 73.62 | 74.04 | 73.55 | 73.89 | 6436100.0 |
| 2006-04-12 10:00:00 | IWM | ETF | 73.89 | 74.19 | 73.89 | 74.01 | 3246800.0 |
| 2006-04-12 10:30:00 | IWM | ETF | 74.01 | 74.0675 | 73.77 | 73.98 | 6577500.0 |
| 2006-04-12 11:00:00 | IWM | ETF | 73.97 | 74.14 | 73.85 | 74.11 | 1495000.0 |
| 2006-04-12 11:30:00 | IWM | ETF | 74.1 | 74.1399 | 73.86 | 73.9 | 2420900.0 |
| 2006-04-12 12:00:00 | IWM | ETF | 73.9 | 74.1 | 73.81 | 74.0 | 827300.0 |
| 2006-04-12 12:30:00 | IWM | ETF | 74.0 | 74.19 | 73.97 | 74.19 | 1396000.0 |
| 2006-04-12 13:00:00 | IWM | ETF | 74.19 | 74.4 | 74.16 | 74.24 | 4478000.0 |
> showing 50 of 2,202 rows — these rows as CSV