PREVIEW / etf_30min / 2005-06-13
file: by_date/etf_30min/2005/2005-06-13.parquet size: 43 KB rows: 1,487
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-06-13 07:00:00 | SPY | ETF | 120.13 | 120.13 | 120.03 | 120.09 | 55700.0 |
| 2005-06-13 07:30:00 | SPY | ETF | 120.09 | 120.09 | 120.04 | 120.09 | 55200.0 |
| 2005-06-13 08:00:00 | SPY | ETF | 120.09 | 120.09 | 119.99 | 120.04 | 73600.0 |
| 2005-06-13 08:30:00 | SPY | ETF | 120.01 | 120.08 | 120.01 | 120.08 | 60000.0 |
| 2005-06-13 09:00:00 | SPY | ETF | 120.03 | 120.03 | 119.9 | 119.94 | 73600.0 |
| 2005-06-13 09:30:00 | SPY | ETF | 119.94 | 120.14 | 119.85 | 119.96 | 4384400.0 |
| 2005-06-13 10:00:00 | SPY | ETF | 119.96 | 120.02 | 119.81 | 119.99 | 2945400.0 |
| 2005-06-13 10:30:00 | SPY | ETF | 120.01 | 120.71 | 119.99 | 120.68 | 7275000.0 |
| 2005-06-13 11:00:00 | SPY | ETF | 120.69 | 121.08 | 120.68 | 120.91 | 5399900.0 |
| 2005-06-13 11:30:00 | SPY | ETF | 120.92 | 120.99 | 120.8 | 120.85 | 2012000.0 |
| 2005-06-13 12:00:00 | SPY | ETF | 120.85 | 120.9 | 120.7 | 120.82 | 3190700.0 |
| 2005-06-13 12:30:00 | SPY | ETF | 120.81 | 120.91 | 120.63 | 120.77 | 792600.0 |
| 2005-06-13 13:00:00 | SPY | ETF | 120.77 | 120.88 | 120.69 | 120.81 | 1707700.0 |
| 2005-06-13 13:30:00 | SPY | ETF | 120.8 | 120.82 | 120.51 | 120.54 | 1683000.0 |
| 2005-06-13 14:00:00 | SPY | ETF | 120.55 | 120.75 | 120.47 | 120.5 | 2574800.0 |
| 2005-06-13 14:30:00 | SPY | ETF | 120.5 | 120.72 | 120.39 | 120.6 | 2755200.0 |
| 2005-06-13 15:00:00 | SPY | ETF | 120.6 | 120.65 | 120.18 | 120.34 | 5997800.0 |
| 2005-06-13 15:30:00 | SPY | ETF | 120.36 | 120.55 | 120.3 | 120.49 | 3904500.0 |
| 2005-06-13 16:00:00 | SPY | ETF | 120.5 | 120.64 | 120.46 | 120.6 | 219900.0 |
| 2005-06-13 16:30:00 | SPY | ETF | 120.6 | 120.61 | 120.5 | 120.61 | 106300.0 |
| 2005-06-13 17:00:00 | SPY | ETF | 120.61 | 120.62 | 120.58 | 120.62 | 15100.0 |
| 2005-06-13 17:30:00 | SPY | ETF | 120.63 | 120.63 | 120.54 | 120.62 | 7900.0 |
| 2005-06-13 18:30:00 | SPY | ETF | 120.58 | 120.58 | 120.58 | 120.58 | 1000.0 |
| 2005-06-13 19:30:00 | SPY | ETF | 120.57 | 120.57 | 120.56 | 120.56 | 600.0 |
| 2005-06-13 09:30:00 | QQQ | ETF | 37.48 | 37.63 | 37.46 | 37.56 | 9702600.0 |
| 2005-06-13 10:00:00 | QQQ | ETF | 37.56 | 37.61 | 37.47 | 37.6 | 6598300.0 |
| 2005-06-13 10:30:00 | QQQ | ETF | 37.6 | 37.89 | 37.59 | 37.86 | 14596900.0 |
| 2005-06-13 11:00:00 | QQQ | ETF | 37.86 | 37.95 | 37.85 | 37.9 | 9671800.0 |
| 2005-06-13 11:30:00 | QQQ | ETF | 37.9 | 37.91 | 37.85 | 37.88 | 4864300.0 |
| 2005-06-13 12:00:00 | QQQ | ETF | 37.88 | 37.89 | 37.78 | 37.85 | 4353900.0 |
| 2005-06-13 12:30:00 | QQQ | ETF | 37.84 | 37.88 | 37.77 | 37.83 | 2108900.0 |
| 2005-06-13 13:00:00 | QQQ | ETF | 37.83 | 37.86 | 37.77 | 37.81 | 2493400.0 |
| 2005-06-13 13:30:00 | QQQ | ETF | 37.82 | 37.85 | 37.73 | 37.73 | 4200300.0 |
| 2005-06-13 14:00:00 | QQQ | ETF | 37.73 | 37.81 | 37.7 | 37.7 | 5249100.0 |
| 2005-06-13 14:30:00 | QQQ | ETF | 37.7 | 37.79 | 37.65 | 37.75 | 5442200.0 |
| 2005-06-13 15:00:00 | QQQ | ETF | 37.75 | 37.77 | 37.64 | 37.71 | 5381600.0 |
| 2005-06-13 15:30:00 | QQQ | ETF | 37.7 | 37.76 | 37.68 | 37.71 | 4730900.0 |
| 2005-06-13 07:00:00 | IWM | ETF | 62.35 | 62.35 | 62.35 | 62.35 | 100.0 |
| 2005-06-13 07:30:00 | IWM | ETF | 62.36 | 62.36 | 62.3 | 62.3 | 44000.0 |
| 2005-06-13 08:30:00 | IWM | ETF | 62.3 | 62.3 | 62.3 | 62.3 | 14900.0 |
| 2005-06-13 09:00:00 | IWM | ETF | 62.26 | 62.26 | 62.25 | 62.25 | 11800.0 |
| 2005-06-13 09:30:00 | IWM | ETF | 62.27 | 62.4 | 62.19 | 62.25 | 1315500.0 |
| 2005-06-13 10:00:00 | IWM | ETF | 62.24 | 62.32 | 62.13 | 62.3 | 571300.0 |
| 2005-06-13 10:30:00 | IWM | ETF | 62.3 | 62.71 | 62.29 | 62.7 | 1790000.0 |
| 2005-06-13 11:00:00 | IWM | ETF | 62.7 | 62.82 | 62.67 | 62.72 | 1128500.0 |
| 2005-06-13 11:30:00 | IWM | ETF | 62.72 | 62.731 | 62.55 | 62.64 | 443100.0 |
| 2005-06-13 12:00:00 | IWM | ETF | 62.65 | 62.65 | 62.51 | 62.65 | 321800.0 |
| 2005-06-13 12:30:00 | IWM | ETF | 62.65 | 62.68 | 62.5 | 62.61 | 498000.0 |
| 2005-06-13 13:00:00 | IWM | ETF | 62.6 | 62.71 | 62.55 | 62.6988 | 535000.0 |
| 2005-06-13 13:30:00 | IWM | ETF | 62.7 | 62.73 | 62.44 | 62.47 | 2740400.0 |
> showing 50 of 1,487 rows — these rows as CSV