PREVIEW / etf_30min / 2003-12-17
file: by_date/etf_30min/2003/2003-12-17.parquet size: 27 KB rows: 870
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-17 08:00:00 | SPY | ETF | 108.09 | 108.16 | 108.09 | 108.15 | 5800.0 |
| 2003-12-17 08:30:00 | SPY | ETF | 108.14 | 108.14 | 108.09 | 108.1 | 7200.0 |
| 2003-12-17 09:00:00 | SPY | ETF | 108.09 | 108.09 | 108.05 | 108.08 | 3500.0 |
| 2003-12-17 09:30:00 | SPY | ETF | 108.06 | 108.13 | 107.8 | 107.95 | 2805000.0 |
| 2003-12-17 10:00:00 | SPY | ETF | 107.94 | 108.04 | 107.86 | 107.92 | 1967000.0 |
| 2003-12-17 10:30:00 | SPY | ETF | 107.92 | 108.15 | 107.9 | 108.08 | 1803600.0 |
| 2003-12-17 11:00:00 | SPY | ETF | 108.08 | 108.2 | 108.05 | 108.08 | 1482000.0 |
| 2003-12-17 11:30:00 | SPY | ETF | 108.08 | 108.1 | 108.0 | 108.04 | 850400.0 |
| 2003-12-17 12:00:00 | SPY | ETF | 108.04 | 108.14 | 107.95 | 108.09 | 582500.0 |
| 2003-12-17 12:30:00 | SPY | ETF | 108.09 | 108.14 | 107.88 | 107.92 | 1247900.0 |
| 2003-12-17 13:00:00 | SPY | ETF | 107.92 | 108.0 | 107.8 | 107.87 | 951300.0 |
| 2003-12-17 13:30:00 | SPY | ETF | 107.85 | 107.95 | 107.83 | 107.88 | 698900.0 |
| 2003-12-17 14:00:00 | SPY | ETF | 107.88 | 108.11 | 107.87 | 108.05 | 2043800.0 |
| 2003-12-17 14:30:00 | SPY | ETF | 108.06 | 108.25 | 108.05 | 108.08 | 2508800.0 |
| 2003-12-17 15:00:00 | SPY | ETF | 108.09 | 108.18 | 107.94 | 108.13 | 1144300.0 |
| 2003-12-17 15:30:00 | SPY | ETF | 108.1 | 108.38 | 108.1 | 108.34 | 2918500.0 |
| 2003-12-17 16:00:00 | SPY | ETF | 108.34 | 108.53 | 108.33 | 108.48 | 757600.0 |
| 2003-12-17 16:30:00 | SPY | ETF | 108.5 | 108.55 | 108.45 | 108.45 | 142100.0 |
| 2003-12-17 17:00:00 | SPY | ETF | 108.45 | 108.48 | 108.41 | 108.48 | 123700.0 |
| 2003-12-17 17:30:00 | SPY | ETF | 108.44 | 108.44 | 108.41 | 108.42 | 4000.0 |
| 2003-12-17 18:00:00 | SPY | ETF | 108.42 | 108.48 | 108.42 | 108.48 | 4000.0 |
| 2003-12-17 18:30:00 | SPY | ETF | 108.47 | 108.47 | 108.47 | 108.47 | 300.0 |
| 2003-12-17 19:30:00 | SPY | ETF | 108.47 | 108.48 | 108.47 | 108.48 | 900.0 |
| 2003-12-17 08:00:00 | QQQ | ETF | 34.84 | 34.9 | 34.81 | 34.9 | 72100.0 |
| 2003-12-17 08:30:00 | QQQ | ETF | 34.88 | 34.9 | 34.86 | 34.86 | 48800.0 |
| 2003-12-17 09:00:00 | QQQ | ETF | 34.85 | 34.86 | 34.82 | 34.83 | 87200.0 |
| 2003-12-17 09:30:00 | QQQ | ETF | 34.81 | 34.83 | 34.627 | 34.727 | 11741000.0 |
| 2003-12-17 10:00:00 | QQQ | ETF | 34.73 | 34.79 | 34.62 | 34.73 | 5147000.0 |
| 2003-12-17 10:30:00 | QQQ | ETF | 34.728 | 34.91 | 34.69 | 34.87 | 7820700.0 |
| 2003-12-17 11:00:00 | QQQ | ETF | 34.87 | 35.0 | 34.84 | 34.883 | 5422800.0 |
| 2003-12-17 11:30:00 | QQQ | ETF | 34.88 | 34.9 | 34.747 | 34.803 | 2717100.0 |
| 2003-12-17 12:00:00 | QQQ | ETF | 34.81 | 34.82 | 34.71 | 34.79 | 2461600.0 |
| 2003-12-17 12:30:00 | QQQ | ETF | 34.8 | 34.84 | 34.64 | 34.69 | 3820300.0 |
| 2003-12-17 13:00:00 | QQQ | ETF | 34.66 | 34.72 | 34.58 | 34.611 | 2585800.0 |
| 2003-12-17 13:30:00 | QQQ | ETF | 34.61 | 34.69 | 34.574 | 34.608 | 3106800.0 |
| 2003-12-17 14:00:00 | QQQ | ETF | 34.61 | 34.787 | 34.6 | 34.739 | 4115300.0 |
| 2003-12-17 14:30:00 | QQQ | ETF | 34.75 | 34.85 | 34.657 | 34.7 | 5170700.0 |
| 2003-12-17 15:00:00 | QQQ | ETF | 34.7 | 34.77 | 34.63 | 34.746 | 3154500.0 |
| 2003-12-17 15:30:00 | QQQ | ETF | 34.75 | 34.86 | 34.73 | 34.8 | 5061100.0 |
| 2003-12-17 16:00:00 | QQQ | ETF | 34.8 | 34.94 | 34.79 | 34.93 | 1772600.0 |
| 2003-12-17 16:30:00 | QQQ | ETF | 34.92 | 34.938 | 34.895 | 34.91 | 217400.0 |
| 2003-12-17 17:00:00 | QQQ | ETF | 34.91 | 34.92 | 34.859 | 34.882 | 1805300.0 |
| 2003-12-17 17:30:00 | QQQ | ETF | 34.87 | 34.9 | 34.81 | 34.88 | 417500.0 |
| 2003-12-17 18:00:00 | QQQ | ETF | 34.87 | 34.882 | 34.87 | 34.882 | 23800.0 |
| 2003-12-17 18:30:00 | QQQ | ETF | 34.88 | 34.9 | 34.88 | 34.9 | 5100.0 |
| 2003-12-17 19:00:00 | QQQ | ETF | 34.91 | 34.91 | 34.91 | 34.91 | 200.0 |
| 2003-12-17 19:30:00 | QQQ | ETF | 34.91 | 34.92 | 34.91 | 34.92 | 4100.0 |
| 2003-12-17 09:30:00 | IWM | ETF | 53.6 | 53.6 | 53.015 | 53.095 | 1065000.0 |
| 2003-12-17 10:00:00 | IWM | ETF | 53.095 | 53.201 | 53.06 | 53.145 | 618600.0 |
| 2003-12-17 10:30:00 | IWM | ETF | 53.105 | 53.409 | 53.105 | 53.355 | 526800.0 |
> showing 50 of 870 rows — these rows as CSV