PREVIEW / etf_30min / 2006-03-07
file: by_date/etf_30min/2006/2006-03-07.parquet size: 62 KB rows: 2,224
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-07 07:00:00 | SPY | ETF | 127.92 | 127.92 | 127.78 | 127.86 | 266500.0 |
| 2006-03-07 07:30:00 | SPY | ETF | 127.83 | 127.87 | 127.78 | 127.86 | 27100.0 |
| 2006-03-07 08:00:00 | SPY | ETF | 127.84 | 128.0 | 127.8 | 127.89 | 380500.0 |
| 2006-03-07 08:30:00 | SPY | ETF | 127.89 | 127.89 | 127.63 | 127.77 | 1372900.0 |
| 2006-03-07 09:00:00 | SPY | ETF | 127.78 | 127.93 | 127.76 | 127.91 | 446000.0 |
| 2006-03-07 09:30:00 | SPY | ETF | 127.92 | 127.93 | 127.63 | 127.73 | 7910500.0 |
| 2006-03-07 10:00:00 | SPY | ETF | 127.73 | 128.06 | 127.71 | 128.01 | 7402500.0 |
| 2006-03-07 10:30:00 | SPY | ETF | 128.0 | 128.05 | 127.74 | 127.78 | 3361300.0 |
| 2006-03-07 11:00:00 | SPY | ETF | 127.77 | 128.05 | 127.75 | 128.01 | 3230400.0 |
| 2006-03-07 11:30:00 | SPY | ETF | 128.0 | 128.01 | 127.8 | 127.89 | 2147500.0 |
| 2006-03-07 12:00:00 | SPY | ETF | 127.91 | 128.05 | 127.76 | 127.79 | 1658900.0 |
| 2006-03-07 12:30:00 | SPY | ETF | 127.78 | 127.84 | 127.48 | 127.51 | 5298000.0 |
| 2006-03-07 13:00:00 | SPY | ETF | 127.51 | 127.7 | 127.4 | 127.54 | 3293700.0 |
| 2006-03-07 13:30:00 | SPY | ETF | 127.54 | 127.83 | 127.54 | 127.74 | 4336000.0 |
| 2006-03-07 14:00:00 | SPY | ETF | 127.75 | 127.79 | 127.51 | 127.55 | 2759700.0 |
| 2006-03-07 14:30:00 | SPY | ETF | 127.54 | 127.85 | 127.4 | 127.73 | 4448600.0 |
| 2006-03-07 15:00:00 | SPY | ETF | 127.76 | 127.88 | 127.55 | 127.72 | 2836800.0 |
| 2006-03-07 15:30:00 | SPY | ETF | 127.73 | 127.99 | 127.72 | 127.86 | 6820200.0 |
| 2006-03-07 16:00:00 | SPY | ETF | 127.87 | 127.99 | 127.84 | 127.97 | 1394100.0 |
| 2006-03-07 16:30:00 | SPY | ETF | 127.98 | 128.0 | 127.93 | 127.93 | 57500.0 |
| 2006-03-07 17:00:00 | SPY | ETF | 127.93 | 127.94 | 127.85 | 127.91 | 47600.0 |
| 2006-03-07 17:30:00 | SPY | ETF | 127.91 | 127.91 | 127.86 | 127.86 | 178100.0 |
| 2006-03-07 18:00:00 | SPY | ETF | 127.93 | 127.93 | 127.89 | 127.89 | 3900.0 |
| 2006-03-07 19:00:00 | SPY | ETF | 127.88 | 127.88 | 127.88 | 127.88 | 1900.0 |
| 2006-03-07 19:30:00 | SPY | ETF | 127.94 | 127.98 | 127.94 | 127.98 | 1700.0 |
| 2006-03-07 09:30:00 | QQQ | ETF | 41.03 | 41.05 | 40.81 | 40.87 | 12623700.0 |
| 2006-03-07 10:00:00 | QQQ | ETF | 40.87 | 41.07 | 40.86 | 41.01 | 10656600.0 |
| 2006-03-07 10:30:00 | QQQ | ETF | 41.01 | 41.03 | 40.91 | 40.93 | 5484500.0 |
| 2006-03-07 11:00:00 | QQQ | ETF | 40.93 | 41.04 | 40.92 | 41.03 | 5075900.0 |
| 2006-03-07 11:30:00 | QQQ | ETF | 41.03 | 41.03 | 40.88 | 40.92 | 3739500.0 |
| 2006-03-07 12:00:00 | QQQ | ETF | 40.92 | 40.98 | 40.82 | 40.84 | 3934100.0 |
| 2006-03-07 12:30:00 | QQQ | ETF | 40.83 | 40.87 | 40.75 | 40.76 | 7858600.0 |
| 2006-03-07 13:00:00 | QQQ | ETF | 40.76 | 40.81 | 40.67 | 40.77 | 8943600.0 |
| 2006-03-07 13:30:00 | QQQ | ETF | 40.77 | 40.87 | 40.76 | 40.81 | 3850600.0 |
| 2006-03-07 14:00:00 | QQQ | ETF | 40.8 | 40.84 | 40.7 | 40.72 | 7285000.0 |
| 2006-03-07 14:30:00 | QQQ | ETF | 40.72 | 40.86 | 40.65 | 40.82 | 6363900.0 |
| 2006-03-07 15:00:00 | QQQ | ETF | 40.83 | 40.84 | 40.74 | 40.82 | 4364100.0 |
| 2006-03-07 15:30:00 | QQQ | ETF | 40.82 | 40.92 | 40.8 | 40.86 | 9832800.0 |
| 2006-03-07 08:00:00 | IWM | ETF | 72.49 | 72.49 | 72.38 | 72.38 | 12100.0 |
| 2006-03-07 08:30:00 | IWM | ETF | 72.41 | 72.41 | 72.28 | 72.32 | 190200.0 |
| 2006-03-07 09:00:00 | IWM | ETF | 72.32 | 72.4 | 72.31 | 72.4 | 446700.0 |
| 2006-03-07 09:30:00 | IWM | ETF | 72.39 | 72.4 | 71.83 | 71.91 | 4833400.0 |
| 2006-03-07 10:00:00 | IWM | ETF | 71.91 | 72.19 | 71.9 | 72.04 | 4554200.0 |
| 2006-03-07 10:30:00 | IWM | ETF | 72.03 | 72.1 | 71.9 | 71.92 | 1584400.0 |
| 2006-03-07 11:00:00 | IWM | ETF | 71.94 | 72.11 | 71.89 | 72.08 | 2041400.0 |
| 2006-03-07 11:30:00 | IWM | ETF | 72.07 | 72.07 | 71.91 | 71.95 | 1179200.0 |
| 2006-03-07 12:00:00 | IWM | ETF | 71.95 | 72.05 | 71.85 | 71.85 | 1129800.0 |
| 2006-03-07 12:30:00 | IWM | ETF | 71.85 | 71.886 | 71.62 | 71.64 | 3463900.0 |
| 2006-03-07 13:00:00 | IWM | ETF | 71.65 | 71.69 | 71.46 | 71.6 | 1702800.0 |
| 2006-03-07 13:30:00 | IWM | ETF | 71.6 | 71.77 | 71.59 | 71.65 | 1639200.0 |
> showing 50 of 2,224 rows — these rows as CSV