PREVIEW / etf_30min / 2005-03-30
file: by_date/etf_30min/2005/2005-03-30.parquet size: 45 KB rows: 1,502
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-30 08:00:00 | SPY | ETF | 116.9 | 116.9 | 116.81 | 116.81 | 33400.0 |
| 2005-03-30 08:30:00 | SPY | ETF | 116.8 | 116.93 | 116.79 | 116.79 | 589900.0 |
| 2005-03-30 09:00:00 | SPY | ETF | 116.75 | 116.8 | 116.7 | 116.78 | 81000.0 |
| 2005-03-30 09:30:00 | SPY | ETF | 116.78 | 117.1 | 116.77 | 116.95 | 7522200.0 |
| 2005-03-30 10:00:00 | SPY | ETF | 116.96 | 117.21 | 116.9 | 117.15 | 6318000.0 |
| 2005-03-30 10:30:00 | SPY | ETF | 117.14 | 117.41 | 117.13 | 117.289 | 5346900.0 |
| 2005-03-30 11:00:00 | SPY | ETF | 117.29 | 117.36 | 117.18 | 117.28 | 2156000.0 |
| 2005-03-30 11:30:00 | SPY | ETF | 117.28 | 117.67 | 117.24 | 117.66 | 4100700.0 |
| 2005-03-30 12:00:00 | SPY | ETF | 117.67 | 117.76 | 117.57 | 117.74 | 5423300.0 |
| 2005-03-30 12:30:00 | SPY | ETF | 117.75 | 117.81 | 117.68 | 117.72 | 1206700.0 |
| 2005-03-30 13:00:00 | SPY | ETF | 117.71 | 117.8 | 117.65 | 117.76 | 2306500.0 |
| 2005-03-30 13:30:00 | SPY | ETF | 117.76 | 117.85 | 117.52 | 117.73 | 3484900.0 |
| 2005-03-30 14:00:00 | SPY | ETF | 117.74 | 117.92 | 117.52 | 117.57 | 5831800.0 |
| 2005-03-30 14:30:00 | SPY | ETF | 117.57 | 117.75 | 117.42 | 117.67 | 4369400.0 |
| 2005-03-30 15:00:00 | SPY | ETF | 117.66 | 117.88 | 117.66 | 117.8 | 2496400.0 |
| 2005-03-30 15:30:00 | SPY | ETF | 117.81 | 118.13 | 117.76 | 118.12 | 7613300.0 |
| 2005-03-30 16:00:00 | SPY | ETF | 118.12 | 118.29 | 118.07 | 118.21 | 1418200.0 |
| 2005-03-30 16:30:00 | SPY | ETF | 118.2 | 118.23 | 118.17 | 118.2 | 367300.0 |
| 2005-03-30 17:00:00 | SPY | ETF | 118.2 | 118.22 | 118.2 | 118.22 | 10800.0 |
| 2005-03-30 17:30:00 | SPY | ETF | 118.22 | 118.24 | 118.2 | 118.2 | 4200.0 |
| 2005-03-30 18:00:00 | SPY | ETF | 118.23 | 118.24 | 118.2 | 118.2 | 5900.0 |
| 2005-03-30 18:30:00 | SPY | ETF | 118.23 | 118.27 | 118.23 | 118.27 | 1900.0 |
| 2005-03-30 19:00:00 | SPY | ETF | 118.22 | 118.22 | 118.22 | 118.22 | 900.0 |
| 2005-03-30 09:30:00 | QQQ | ETF | 36.23 | 36.35 | 36.22 | 36.26 | 14097000.0 |
| 2005-03-30 10:00:00 | QQQ | ETF | 36.26 | 36.45 | 36.25 | 36.42 | 9320400.0 |
| 2005-03-30 10:30:00 | QQQ | ETF | 36.42 | 36.59 | 36.42 | 36.54 | 11493300.0 |
| 2005-03-30 11:00:00 | QQQ | ETF | 36.54 | 36.58 | 36.5 | 36.54 | 5052200.0 |
| 2005-03-30 11:30:00 | QQQ | ETF | 36.54 | 36.73 | 36.51 | 36.72 | 8429800.0 |
| 2005-03-30 12:00:00 | QQQ | ETF | 36.72 | 37.71 | 36.65 | 36.72 | 8789200.0 |
| 2005-03-30 12:30:00 | QQQ | ETF | 36.72 | 36.74 | 36.69 | 36.7 | 5002500.0 |
| 2005-03-30 13:00:00 | QQQ | ETF | 36.7 | 36.77 | 36.61 | 36.68 | 5569500.0 |
| 2005-03-30 13:30:00 | QQQ | ETF | 36.68 | 36.72 | 36.62 | 36.66 | 3154200.0 |
| 2005-03-30 14:00:00 | QQQ | ETF | 36.66 | 36.75 | 36.6 | 36.62 | 9004200.0 |
| 2005-03-30 14:30:00 | QQQ | ETF | 36.62 | 36.66 | 36.51 | 36.62 | 9269500.0 |
| 2005-03-30 15:00:00 | QQQ | ETF | 36.62 | 36.71 | 36.61 | 36.66 | 7089100.0 |
| 2005-03-30 15:30:00 | QQQ | ETF | 36.66 | 36.74 | 36.61 | 36.73 | 11654000.0 |
| 2005-03-30 08:00:00 | IWM | ETF | 60.345 | 60.345 | 60.345 | 60.345 | 1000.0 |
| 2005-03-30 08:30:00 | IWM | ETF | 60.375 | 60.435 | 60.325 | 60.325 | 51200.0 |
| 2005-03-30 09:00:00 | IWM | ETF | 60.395 | 60.395 | 60.32 | 60.32 | 13800.0 |
| 2005-03-30 09:30:00 | IWM | ETF | 60.29 | 60.625 | 60.275 | 60.43 | 2119000.0 |
| 2005-03-30 10:00:00 | IWM | ETF | 60.43 | 60.6 | 60.425 | 60.535 | 1681600.0 |
| 2005-03-30 10:30:00 | IWM | ETF | 60.535 | 60.725 | 60.535 | 60.65 | 1845800.0 |
| 2005-03-30 11:00:00 | IWM | ETF | 60.66 | 60.665 | 60.475 | 60.53 | 1011400.0 |
| 2005-03-30 11:30:00 | IWM | ETF | 60.53 | 60.805 | 60.505 | 60.775 | 1619400.0 |
| 2005-03-30 12:00:00 | IWM | ETF | 60.78 | 60.88 | 60.775 | 60.88 | 2653800.0 |
| 2005-03-30 12:30:00 | IWM | ETF | 60.88 | 60.95 | 60.87 | 60.88 | 889000.0 |
| 2005-03-30 13:00:00 | IWM | ETF | 60.86 | 60.87 | 60.79 | 60.845 | 627800.0 |
| 2005-03-30 13:30:00 | IWM | ETF | 60.85 | 60.91 | 60.715 | 60.835 | 496200.0 |
| 2005-03-30 14:00:00 | IWM | ETF | 60.84 | 60.98 | 60.725 | 60.785 | 922400.0 |
| 2005-03-30 14:30:00 | IWM | ETF | 60.78 | 60.855 | 60.69 | 60.76 | 833600.0 |
> showing 50 of 1,502 rows — these rows as CSV