PREVIEW / etf_30min / 2003-10-17
file: by_date/etf_30min/2003/2003-10-17.parquet size: 26 KB rows: 785
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-10-17 08:00:00 | SPY | ETF | 105.28 | 105.28 | 105.24 | 105.26 | 3200.0 |
| 2003-10-17 08:30:00 | SPY | ETF | 105.28 | 105.45 | 105.25 | 105.41 | 7300.0 |
| 2003-10-17 09:00:00 | SPY | ETF | 105.4 | 105.51 | 105.37 | 105.5 | 88600.0 |
| 2003-10-17 09:30:00 | SPY | ETF | 105.47 | 105.63 | 105.03 | 105.09 | 3154100.0 |
| 2003-10-17 10:00:00 | SPY | ETF | 105.1 | 105.11 | 104.59 | 104.81 | 5947000.0 |
| 2003-10-17 10:30:00 | SPY | ETF | 104.81 | 104.84 | 104.6 | 104.74 | 2184700.0 |
| 2003-10-17 11:00:00 | SPY | ETF | 104.73 | 104.76 | 104.47 | 104.74 | 2491200.0 |
| 2003-10-17 11:30:00 | SPY | ETF | 104.73 | 104.77 | 104.61 | 104.73 | 1861500.0 |
| 2003-10-17 12:00:00 | SPY | ETF | 104.72 | 104.74 | 104.39 | 104.57 | 3131400.0 |
| 2003-10-17 12:30:00 | SPY | ETF | 104.58 | 104.72 | 104.57 | 104.68 | 873200.0 |
| 2003-10-17 13:00:00 | SPY | ETF | 104.7 | 104.7 | 104.47 | 104.51 | 717900.0 |
| 2003-10-17 13:30:00 | SPY | ETF | 104.51 | 104.59 | 104.36 | 104.55 | 1292300.0 |
| 2003-10-17 14:00:00 | SPY | ETF | 104.54 | 104.57 | 104.2 | 104.29 | 1002100.0 |
| 2003-10-17 14:30:00 | SPY | ETF | 104.31 | 104.35 | 104.13 | 104.15 | 2203800.0 |
| 2003-10-17 15:00:00 | SPY | ETF | 104.16 | 104.29 | 103.98 | 104.21 | 2144200.0 |
| 2003-10-17 15:30:00 | SPY | ETF | 104.2 | 104.3 | 104.11 | 104.23 | 2578500.0 |
| 2003-10-17 16:00:00 | SPY | ETF | 104.22 | 104.34 | 104.19 | 104.2 | 1047100.0 |
| 2003-10-17 16:30:00 | SPY | ETF | 104.21 | 104.25 | 104.18 | 104.21 | 23900.0 |
| 2003-10-17 17:00:00 | SPY | ETF | 104.21 | 104.21 | 104.15 | 104.15 | 15100.0 |
| 2003-10-17 17:30:00 | SPY | ETF | 104.15 | 104.15 | 104.15 | 104.15 | 300.0 |
| 2003-10-17 18:00:00 | SPY | ETF | 104.13 | 104.21 | 104.13 | 104.21 | 8900.0 |
| 2003-10-17 18:30:00 | SPY | ETF | 104.25 | 104.26 | 104.25 | 104.26 | 700.0 |
| 2003-10-17 19:00:00 | SPY | ETF | 104.24 | 104.24 | 104.24 | 104.24 | 1000.0 |
| 2003-10-17 08:00:00 | QQQ | ETF | 35.4 | 35.4 | 35.38 | 35.4 | 14500.0 |
| 2003-10-17 08:30:00 | QQQ | ETF | 35.4 | 35.43 | 35.39 | 35.43 | 29600.0 |
| 2003-10-17 09:00:00 | QQQ | ETF | 35.42 | 35.44 | 35.4 | 35.4 | 56100.0 |
| 2003-10-17 09:30:00 | QQQ | ETF | 35.413 | 35.49 | 35.08 | 35.11 | 11514300.0 |
| 2003-10-17 10:00:00 | QQQ | ETF | 35.108 | 35.18 | 34.86 | 34.937 | 15004800.0 |
| 2003-10-17 10:30:00 | QQQ | ETF | 34.936 | 34.99 | 34.79 | 34.889 | 11513100.0 |
| 2003-10-17 11:00:00 | QQQ | ETF | 34.889 | 34.95 | 34.73 | 34.933 | 6311100.0 |
| 2003-10-17 11:30:00 | QQQ | ETF | 34.939 | 35.0 | 34.86 | 34.903 | 4877600.0 |
| 2003-10-17 12:00:00 | QQQ | ETF | 34.9 | 34.92 | 34.75 | 34.85 | 5497600.0 |
| 2003-10-17 12:30:00 | QQQ | ETF | 34.84 | 34.9 | 34.799 | 34.87 | 3028400.0 |
| 2003-10-17 13:00:00 | QQQ | ETF | 34.88 | 34.88 | 34.8 | 34.808 | 1835300.0 |
| 2003-10-17 13:30:00 | QQQ | ETF | 34.81 | 34.85 | 34.69 | 34.83 | 4832000.0 |
| 2003-10-17 14:00:00 | QQQ | ETF | 34.83 | 34.85 | 34.66 | 34.7 | 3774100.0 |
| 2003-10-17 14:30:00 | QQQ | ETF | 34.7 | 34.75 | 34.66 | 34.661 | 3363600.0 |
| 2003-10-17 15:00:00 | QQQ | ETF | 34.67 | 34.77 | 34.61 | 34.692 | 4928200.0 |
| 2003-10-17 15:30:00 | QQQ | ETF | 34.7 | 34.74 | 34.62 | 34.66 | 8537100.0 |
| 2003-10-17 16:00:00 | QQQ | ETF | 34.65 | 35.4831 | 34.6 | 34.62 | 4684700.0 |
| 2003-10-17 16:30:00 | QQQ | ETF | 34.62 | 34.64 | 34.56 | 34.6 | 140300.0 |
| 2003-10-17 17:00:00 | QQQ | ETF | 34.6 | 34.6 | 34.56 | 34.57 | 49900.0 |
| 2003-10-17 17:30:00 | QQQ | ETF | 34.58 | 34.58 | 34.48 | 34.57 | 106600.0 |
| 2003-10-17 18:00:00 | QQQ | ETF | 34.57 | 34.57 | 34.45 | 34.54 | 86300.0 |
| 2003-10-17 18:30:00 | QQQ | ETF | 34.55 | 34.56 | 34.5 | 34.52 | 29300.0 |
| 2003-10-17 19:00:00 | QQQ | ETF | 34.54 | 34.55 | 34.53 | 34.53 | 2900.0 |
| 2003-10-17 19:30:00 | QQQ | ETF | 34.52 | 34.55 | 34.51 | 34.52 | 5800.0 |
| 2003-10-17 20:00:00 | QQQ | ETF | 34.52 | 34.52 | 34.52 | 34.52 | 400.0 |
| 2003-10-17 09:30:00 | IWM | ETF | 52.85 | 52.955 | 52.534 | 52.545 | 377800.0 |
| 2003-10-17 10:00:00 | IWM | ETF | 52.505 | 52.555 | 52.246 | 52.33 | 1092200.0 |
> showing 50 of 785 rows — these rows as CSV