PREVIEW / etf_30min / 2003-11-20
file: by_date/etf_30min/2003/2003-11-20.parquet size: 27 KB rows: 832
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-11-20 08:00:00 | SPY | ETF | 104.21 | 104.29 | 104.21 | 104.23 | 21500.0 |
| 2003-11-20 08:30:00 | SPY | ETF | 104.23 | 104.37 | 104.21 | 104.37 | 35500.0 |
| 2003-11-20 09:00:00 | SPY | ETF | 104.39 | 104.4 | 103.76 | 103.94 | 227000.0 |
| 2003-11-20 09:30:00 | SPY | ETF | 104.0 | 104.41 | 103.82 | 104.35 | 9390500.0 |
| 2003-11-20 10:00:00 | SPY | ETF | 104.35 | 104.73 | 104.32 | 104.57 | 5243500.0 |
| 2003-11-20 10:30:00 | SPY | ETF | 104.57 | 104.85 | 104.49 | 104.72 | 2536000.0 |
| 2003-11-20 11:00:00 | SPY | ETF | 104.73 | 104.83 | 104.57 | 104.83 | 2612700.0 |
| 2003-11-20 11:30:00 | SPY | ETF | 104.81 | 104.98 | 104.58 | 104.89 | 2314600.0 |
| 2003-11-20 12:00:00 | SPY | ETF | 104.88 | 104.91 | 104.69 | 104.71 | 1767800.0 |
| 2003-11-20 12:30:00 | SPY | ETF | 104.71 | 105.13 | 104.68 | 105.04 | 1223400.0 |
| 2003-11-20 13:00:00 | SPY | ETF | 105.05 | 105.24 | 105.04 | 105.1 | 1598000.0 |
| 2003-11-20 13:30:00 | SPY | ETF | 105.11 | 105.18 | 104.95 | 105.04 | 1691300.0 |
| 2003-11-20 14:00:00 | SPY | ETF | 105.03 | 105.12 | 104.86 | 104.86 | 1004500.0 |
| 2003-11-20 14:30:00 | SPY | ETF | 104.87 | 104.93 | 104.63 | 104.66 | 3323800.0 |
| 2003-11-20 15:00:00 | SPY | ETF | 104.66 | 104.68 | 103.9 | 104.0 | 8006600.0 |
| 2003-11-20 15:30:00 | SPY | ETF | 104.03 | 104.22 | 103.83 | 103.9 | 4241100.0 |
| 2003-11-20 16:00:00 | SPY | ETF | 103.88 | 103.94 | 103.72 | 103.78 | 5211200.0 |
| 2003-11-20 16:30:00 | SPY | ETF | 103.74 | 103.9 | 103.74 | 103.87 | 87800.0 |
| 2003-11-20 17:00:00 | SPY | ETF | 103.88 | 103.88 | 103.82 | 103.82 | 35900.0 |
| 2003-11-20 17:30:00 | SPY | ETF | 103.85 | 103.86 | 103.78 | 103.8 | 7400.0 |
| 2003-11-20 18:00:00 | SPY | ETF | 103.84 | 103.89 | 103.82 | 103.82 | 22200.0 |
| 2003-11-20 18:30:00 | SPY | ETF | 103.82 | 103.82 | 103.82 | 103.82 | 200.0 |
| 2003-11-20 19:00:00 | SPY | ETF | 103.82 | 103.9 | 103.8 | 103.9 | 1200.0 |
| 2003-11-20 19:30:00 | SPY | ETF | 103.9 | 103.94 | 103.9 | 103.94 | 3500.0 |
| 2003-11-20 08:00:00 | QQQ | ETF | 33.98 | 34.03 | 33.95 | 34.03 | 149700.0 |
| 2003-11-20 08:30:00 | QQQ | ETF | 34.04 | 34.06 | 33.99 | 34.05 | 155500.0 |
| 2003-11-20 09:00:00 | QQQ | ETF | 34.04 | 34.06 | 33.87 | 33.92 | 294300.0 |
| 2003-11-20 09:30:00 | QQQ | ETF | 33.92 | 34.19 | 33.81 | 34.15 | 19166500.0 |
| 2003-11-20 10:00:00 | QQQ | ETF | 34.15 | 34.45 | 34.14 | 34.33 | 14102500.0 |
| 2003-11-20 10:30:00 | QQQ | ETF | 34.33 | 34.51 | 34.3 | 34.46 | 7507100.0 |
| 2003-11-20 11:00:00 | QQQ | ETF | 34.462 | 34.53 | 34.364 | 34.5 | 4036800.0 |
| 2003-11-20 11:30:00 | QQQ | ETF | 34.501 | 34.62 | 34.37 | 34.6 | 10728700.0 |
| 2003-11-20 12:00:00 | QQQ | ETF | 34.6 | 34.62 | 34.46 | 34.48 | 5458900.0 |
| 2003-11-20 12:30:00 | QQQ | ETF | 34.49 | 34.68 | 34.46 | 34.62 | 5334300.0 |
| 2003-11-20 13:00:00 | QQQ | ETF | 34.62 | 34.68 | 34.56 | 34.59 | 2833500.0 |
| 2003-11-20 13:30:00 | QQQ | ETF | 34.59 | 34.65 | 34.53 | 34.57 | 3085100.0 |
| 2003-11-20 14:00:00 | QQQ | ETF | 34.57 | 34.62 | 34.476 | 34.485 | 3816700.0 |
| 2003-11-20 14:30:00 | QQQ | ETF | 34.481 | 34.5 | 34.32 | 34.33 | 7663400.0 |
| 2003-11-20 15:00:00 | QQQ | ETF | 34.33 | 34.38 | 33.98 | 34.07 | 13520600.0 |
| 2003-11-20 15:30:00 | QQQ | ETF | 34.07 | 34.15 | 33.9 | 33.96 | 12532600.0 |
| 2003-11-20 16:00:00 | QQQ | ETF | 33.97 | 33.97 | 33.852 | 33.9 | 3175700.0 |
| 2003-11-20 16:30:00 | QQQ | ETF | 33.89 | 33.905 | 33.85 | 33.88 | 400900.0 |
| 2003-11-20 17:00:00 | QQQ | ETF | 33.89 | 33.9 | 33.861 | 33.88 | 107400.0 |
| 2003-11-20 17:30:00 | QQQ | ETF | 33.88 | 33.9 | 33.87 | 33.9 | 21400.0 |
| 2003-11-20 18:00:00 | QQQ | ETF | 33.9 | 33.92 | 33.88 | 33.901 | 43500.0 |
| 2003-11-20 18:30:00 | QQQ | ETF | 33.91 | 33.91 | 33.9 | 33.91 | 1000.0 |
| 2003-11-20 19:00:00 | QQQ | ETF | 33.91 | 33.93 | 33.9 | 33.92 | 6300.0 |
| 2003-11-20 19:30:00 | QQQ | ETF | 33.93 | 33.96 | 33.92 | 33.96 | 10300.0 |
| 2003-11-20 08:30:00 | IWM | ETF | 52.145 | 52.145 | 52.145 | 52.145 | 400.0 |
| 2003-11-20 09:00:00 | IWM | ETF | 52.13 | 52.13 | 52.13 | 52.13 | 1200.0 |
> showing 50 of 832 rows — these rows as CSV