PREVIEW / etf_30min / 2005-02-14
file: by_date/etf_30min/2005/2005-02-14.parquet size: 40 KB rows: 1,451
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-02-14 08:00:00 | SPY | ETF | 120.71 | 120.77 | 120.7 | 120.7 | 87100.0 |
| 2005-02-14 08:30:00 | SPY | ETF | 120.73 | 120.78 | 120.73 | 120.75 | 14300.0 |
| 2005-02-14 09:00:00 | SPY | ETF | 120.74 | 120.74 | 120.67 | 120.67 | 12800.0 |
| 2005-02-14 09:30:00 | SPY | ETF | 120.69 | 120.79 | 120.58 | 120.64 | 4420000.0 |
| 2005-02-14 10:00:00 | SPY | ETF | 120.64 | 120.74 | 120.52 | 120.71 | 3741400.0 |
| 2005-02-14 10:30:00 | SPY | ETF | 120.71 | 120.77 | 120.5 | 120.53 | 3178300.0 |
| 2005-02-14 11:00:00 | SPY | ETF | 120.55 | 120.67 | 120.48 | 120.66 | 1843400.0 |
| 2005-02-14 11:30:00 | SPY | ETF | 120.67 | 120.71 | 120.6 | 120.63 | 2296800.0 |
| 2005-02-14 12:00:00 | SPY | ETF | 120.63 | 120.71 | 120.52 | 120.66 | 1715700.0 |
| 2005-02-14 12:30:00 | SPY | ETF | 120.66 | 120.75 | 120.59 | 120.67 | 1660400.0 |
| 2005-02-14 13:00:00 | SPY | ETF | 120.69 | 120.7 | 120.61 | 120.66 | 710200.0 |
| 2005-02-14 13:30:00 | SPY | ETF | 120.65 | 120.76 | 120.59 | 120.62 | 1356900.0 |
| 2005-02-14 14:00:00 | SPY | ETF | 120.62 | 120.71 | 120.53 | 120.69 | 1800500.0 |
| 2005-02-14 14:30:00 | SPY | ETF | 120.67 | 120.76 | 120.58 | 120.72 | 1479000.0 |
| 2005-02-14 15:00:00 | SPY | ETF | 120.73 | 120.81 | 120.63 | 120.77 | 1822900.0 |
| 2005-02-14 15:30:00 | SPY | ETF | 120.77 | 120.86 | 120.7 | 120.78 | 2936700.0 |
| 2005-02-14 16:00:00 | SPY | ETF | 120.79 | 120.85 | 120.66 | 120.72 | 2147300.0 |
| 2005-02-14 16:30:00 | SPY | ETF | 120.7 | 120.71 | 120.67 | 120.68 | 540300.0 |
| 2005-02-14 17:00:00 | SPY | ETF | 120.55 | 120.76 | 120.55 | 120.76 | 116000.0 |
| 2005-02-14 17:30:00 | SPY | ETF | 120.76 | 120.78 | 120.76 | 120.78 | 600.0 |
| 2005-02-14 18:00:00 | SPY | ETF | 120.72 | 120.72 | 120.72 | 120.72 | 200.0 |
| 2005-02-14 19:00:00 | SPY | ETF | 120.71 | 120.71 | 120.69 | 120.71 | 5000.0 |
| 2005-02-14 09:30:00 | QQQ | ETF | 37.71 | 37.88 | 37.68 | 37.82 | 11147800.0 |
| 2005-02-14 10:00:00 | QQQ | ETF | 37.83 | 37.9 | 37.74 | 37.88 | 5101100.0 |
| 2005-02-14 10:30:00 | QQQ | ETF | 37.88 | 37.94 | 37.79 | 37.8 | 6078500.0 |
| 2005-02-14 11:00:00 | QQQ | ETF | 37.8 | 37.83 | 37.74 | 37.82 | 3962300.0 |
| 2005-02-14 11:30:00 | QQQ | ETF | 37.82 | 37.87 | 37.78 | 37.84 | 2553200.0 |
| 2005-02-14 12:00:00 | QQQ | ETF | 37.84 | 37.86 | 37.79 | 37.84 | 2166700.0 |
| 2005-02-14 12:30:00 | QQQ | ETF | 37.84 | 37.88 | 37.81 | 37.83 | 1183700.0 |
| 2005-02-14 13:00:00 | QQQ | ETF | 37.84 | 37.84 | 37.77 | 37.8 | 1690900.0 |
| 2005-02-14 13:30:00 | QQQ | ETF | 37.8 | 37.87 | 37.78 | 37.8 | 1725800.0 |
| 2005-02-14 14:00:00 | QQQ | ETF | 37.8 | 37.85 | 37.75 | 37.83 | 2442700.0 |
| 2005-02-14 14:30:00 | QQQ | ETF | 37.83 | 37.87 | 37.79 | 37.87 | 2633100.0 |
| 2005-02-14 15:00:00 | QQQ | ETF | 37.87 | 37.9 | 37.82 | 37.86 | 3200700.0 |
| 2005-02-14 15:30:00 | QQQ | ETF | 37.86 | 37.93 | 37.84 | 37.88 | 5212900.0 |
| 2005-02-14 08:30:00 | IWM | ETF | 63.3 | 63.3 | 63.3 | 63.3 | 4000.0 |
| 2005-02-14 09:00:00 | IWM | ETF | 63.3 | 63.3 | 63.275 | 63.275 | 11800.0 |
| 2005-02-14 09:30:00 | IWM | ETF | 63.2 | 63.5 | 63.195 | 63.275 | 1203000.0 |
| 2005-02-14 10:00:00 | IWM | ETF | 63.275 | 63.37 | 63.175 | 63.355 | 809000.0 |
| 2005-02-14 10:30:00 | IWM | ETF | 63.34 | 63.39 | 63.145 | 63.185 | 578200.0 |
| 2005-02-14 11:00:00 | IWM | ETF | 63.185 | 63.295 | 63.165 | 63.285 | 417800.0 |
| 2005-02-14 11:30:00 | IWM | ETF | 63.295 | 63.33 | 63.255 | 63.305 | 185600.0 |
| 2005-02-14 12:00:00 | IWM | ETF | 63.28 | 63.325 | 63.23 | 63.29 | 130600.0 |
| 2005-02-14 12:30:00 | IWM | ETF | 63.27 | 63.31 | 63.235 | 63.2696 | 279400.0 |
| 2005-02-14 13:00:00 | IWM | ETF | 63.27 | 63.27 | 63.16 | 63.21 | 454400.0 |
| 2005-02-14 13:30:00 | IWM | ETF | 63.245 | 63.25 | 62.995 | 63.0 | 1165400.0 |
| 2005-02-14 14:00:00 | IWM | ETF | 63.0 | 63.13 | 62.86 | 63.09 | 1411200.0 |
| 2005-02-14 14:30:00 | IWM | ETF | 63.09 | 63.18 | 62.99 | 63.16 | 609200.0 |
| 2005-02-14 15:00:00 | IWM | ETF | 63.165 | 63.205 | 63.1 | 63.175 | 426000.0 |
| 2005-02-14 15:30:00 | IWM | ETF | 63.175 | 63.31 | 63.145 | 63.305 | 874600.0 |
> showing 50 of 1,451 rows — these rows as CSV