PREVIEW / etf_30min / 2003-11-04
file: by_date/etf_30min/2003/2003-11-04.parquet size: 26 KB rows: 824
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-04 08:00:00 | SPY | ETF | 106.02 | 106.04 | 106.02 | 106.04 | 6000.0 |
| 2003-11-04 08:30:00 | SPY | ETF | 106.02 | 106.03 | 105.99 | 106.03 | 37500.0 |
| 2003-11-04 09:00:00 | SPY | ETF | 106.03 | 106.08 | 106.0 | 106.0 | 13000.0 |
| 2003-11-04 09:30:00 | SPY | ETF | 105.99 | 105.99 | 105.73 | 105.8 | 4412131.0 |
| 2003-11-04 10:00:00 | SPY | ETF | 105.81 | 106.08 | 105.67 | 105.95 | 3618761.0 |
| 2003-11-04 10:30:00 | SPY | ETF | 105.94 | 106.12 | 105.85 | 105.97 | 1682760.0 |
| 2003-11-04 11:00:00 | SPY | ETF | 105.97 | 106.17 | 105.94 | 106.17 | 1515247.0 |
| 2003-11-04 11:30:00 | SPY | ETF | 106.15 | 106.27 | 106.05 | 106.1 | 3777485.0 |
| 2003-11-04 12:00:00 | SPY | ETF | 106.09 | 106.12 | 105.77 | 105.8 | 3382742.0 |
| 2003-11-04 12:30:00 | SPY | ETF | 105.8 | 105.9 | 105.71 | 105.77 | 1189988.0 |
| 2003-11-04 13:00:00 | SPY | ETF | 105.76 | 105.87 | 105.66 | 105.76 | 882869.0 |
| 2003-11-04 13:30:00 | SPY | ETF | 105.77 | 105.88 | 105.65 | 105.74 | 650932.0 |
| 2003-11-04 14:00:00 | SPY | ETF | 105.74 | 105.79 | 105.58 | 105.79 | 2797829.0 |
| 2003-11-04 14:30:00 | SPY | ETF | 105.79 | 105.98 | 105.75 | 105.93 | 1283365.0 |
| 2003-11-04 15:00:00 | SPY | ETF | 105.93 | 105.94 | 105.76 | 105.78 | 708945.0 |
| 2003-11-04 15:30:00 | SPY | ETF | 105.8 | 105.85 | 105.6 | 105.78 | 2219666.0 |
| 2003-11-04 16:00:00 | SPY | ETF | 105.78 | 105.85 | 105.65 | 105.81 | 927197.0 |
| 2003-11-04 16:30:00 | SPY | ETF | 105.79 | 105.8 | 105.75 | 105.8 | 23600.0 |
| 2003-11-04 17:00:00 | SPY | ETF | 105.76 | 105.79 | 105.75 | 105.75 | 51300.0 |
| 2003-11-04 17:30:00 | SPY | ETF | 105.79 | 105.79 | 105.79 | 105.79 | 9000.0 |
| 2003-11-04 18:00:00 | SPY | ETF | 105.76 | 105.76 | 105.76 | 105.76 | 5200.0 |
| 2003-11-04 19:00:00 | SPY | ETF | 105.74 | 105.74 | 105.71 | 105.71 | 1000.0 |
| 2003-11-04 19:30:00 | SPY | ETF | 105.68 | 105.71 | 105.63 | 105.68 | 700.0 |
| 2003-11-04 08:00:00 | QQQ | ETF | 35.8 | 35.8 | 35.75 | 35.76 | 17900.0 |
| 2003-11-04 08:30:00 | QQQ | ETF | 35.74 | 35.74 | 35.67 | 35.69 | 35500.0 |
| 2003-11-04 09:00:00 | QQQ | ETF | 35.69 | 35.72 | 35.68 | 35.7 | 51300.0 |
| 2003-11-04 09:30:00 | QQQ | ETF | 35.69 | 35.75 | 35.57 | 35.63 | 7423746.0 |
| 2003-11-04 10:00:00 | QQQ | ETF | 35.637 | 35.78 | 35.57 | 35.69 | 5853886.0 |
| 2003-11-04 10:30:00 | QQQ | ETF | 35.7 | 35.79 | 35.63 | 35.72 | 4503456.0 |
| 2003-11-04 11:00:00 | QQQ | ETF | 35.71 | 35.84 | 35.7 | 35.82 | 4171439.0 |
| 2003-11-04 11:30:00 | QQQ | ETF | 35.814 | 35.87 | 35.742 | 35.756 | 4995517.0 |
| 2003-11-04 12:00:00 | QQQ | ETF | 35.76 | 35.78 | 35.59 | 35.61 | 4393755.0 |
| 2003-11-04 12:30:00 | QQQ | ETF | 35.62 | 35.65 | 35.57 | 35.59 | 3291099.0 |
| 2003-11-04 13:00:00 | QQQ | ETF | 35.589 | 35.6 | 35.51 | 35.56 | 3315006.0 |
| 2003-11-04 13:30:00 | QQQ | ETF | 35.56 | 35.6 | 35.47 | 35.54 | 2031228.0 |
| 2003-11-04 14:00:00 | QQQ | ETF | 35.54 | 35.6 | 35.45 | 35.6 | 3520617.0 |
| 2003-11-04 14:30:00 | QQQ | ETF | 35.59 | 35.72 | 35.59 | 35.69 | 3439492.0 |
| 2003-11-04 15:00:00 | QQQ | ETF | 35.69 | 35.7 | 35.586 | 35.588 | 1975210.0 |
| 2003-11-04 15:30:00 | QQQ | ETF | 35.6 | 35.63 | 35.51 | 35.59 | 3078561.0 |
| 2003-11-04 16:00:00 | QQQ | ETF | 35.58 | 35.6 | 35.474 | 35.52 | 2146924.0 |
| 2003-11-04 16:30:00 | QQQ | ETF | 35.52 | 35.529 | 35.49 | 35.504 | 146350.0 |
| 2003-11-04 17:00:00 | QQQ | ETF | 35.5 | 35.518 | 35.49 | 35.496 | 14700.0 |
| 2003-11-04 17:30:00 | QQQ | ETF | 35.5 | 35.52 | 35.5 | 35.5 | 27300.0 |
| 2003-11-04 18:00:00 | QQQ | ETF | 35.5 | 35.508 | 35.49 | 35.494 | 11400.0 |
| 2003-11-04 18:30:00 | QQQ | ETF | 35.5 | 35.5 | 35.49 | 35.49 | 17300.0 |
| 2003-11-04 19:00:00 | QQQ | ETF | 35.49 | 35.49 | 35.48 | 35.48 | 13300.0 |
| 2003-11-04 19:30:00 | QQQ | ETF | 35.48 | 35.48 | 35.43 | 35.45 | 22600.0 |
| 2003-11-04 08:30:00 | IWM | ETF | 53.56 | 53.56 | 53.56 | 53.56 | 1800.0 |
| 2003-11-04 09:30:00 | IWM | ETF | 53.6 | 53.625 | 53.46 | 53.58 | 299190.0 |
| 2003-11-04 10:00:00 | IWM | ETF | 53.575 | 53.895 | 53.53 | 53.805 | 462772.0 |
> showing 50 of 824 rows — these rows as CSV