PREVIEW / etf_30min / 2003-06-30
file: by_date/etf_30min/2003/2003-06-30.parquet size: 24 KB rows: 716
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-06-30 08:00:00 | SPY | ETF | 98.29 | 98.34 | 98.24 | 98.34 | 9800.0 |
| 2003-06-30 08:30:00 | SPY | ETF | 98.34 | 98.34 | 98.26 | 98.26 | 5200.0 |
| 2003-06-30 09:00:00 | SPY | ETF | 98.25 | 98.3 | 98.19 | 98.19 | 30500.0 |
| 2003-06-30 09:30:00 | SPY | ETF | 98.22 | 98.669 | 98.18 | 98.426 | 4075700.0 |
| 2003-06-30 10:00:00 | SPY | ETF | 98.442 | 98.58 | 98.1 | 98.1 | 3022200.0 |
| 2003-06-30 10:30:00 | SPY | ETF | 98.07 | 98.17 | 97.82 | 98.07 | 1733600.0 |
| 2003-06-30 11:00:00 | SPY | ETF | 98.07 | 98.12 | 97.81 | 97.84 | 1880300.0 |
| 2003-06-30 11:30:00 | SPY | ETF | 97.83 | 97.83 | 97.61 | 97.71 | 3052200.0 |
| 2003-06-30 12:00:00 | SPY | ETF | 97.7 | 97.92 | 97.59 | 97.91 | 818300.0 |
| 2003-06-30 12:30:00 | SPY | ETF | 97.87 | 98.09 | 97.83 | 98.05 | 1118100.0 |
| 2003-06-30 13:00:00 | SPY | ETF | 98.05 | 98.39 | 98.02 | 98.3 | 926900.0 |
| 2003-06-30 13:30:00 | SPY | ETF | 98.29 | 98.59 | 98.29 | 98.51 | 1666900.0 |
| 2003-06-30 14:00:00 | SPY | ETF | 98.52 | 98.6 | 98.24 | 98.29 | 2191100.0 |
| 2003-06-30 14:30:00 | SPY | ETF | 98.3 | 98.36 | 98.093 | 98.21 | 1423200.0 |
| 2003-06-30 15:00:00 | SPY | ETF | 98.19 | 98.21 | 97.75 | 97.87 | 1824800.0 |
| 2003-06-30 15:30:00 | SPY | ETF | 97.87 | 98.12 | 97.68 | 97.689 | 2857600.0 |
| 2003-06-30 16:00:00 | SPY | ETF | 97.697 | 97.93 | 97.47 | 97.64 | 3402400.0 |
| 2003-06-30 16:30:00 | SPY | ETF | 97.63 | 97.69 | 97.61 | 97.64 | 83100.0 |
| 2003-06-30 17:00:00 | SPY | ETF | 97.66 | 97.7 | 97.62 | 97.65 | 463400.0 |
| 2003-06-30 17:30:00 | SPY | ETF | 97.68 | 97.74 | 97.68 | 97.72 | 91200.0 |
| 2003-06-30 18:00:00 | SPY | ETF | 97.66 | 97.73 | 97.66 | 97.729 | 27000.0 |
| 2003-06-30 18:30:00 | SPY | ETF | 97.69 | 97.69 | 97.68 | 97.68 | 700.0 |
| 2003-06-30 19:00:00 | SPY | ETF | 97.71 | 97.71 | 97.71 | 97.71 | 300.0 |
| 2003-06-30 19:30:00 | SPY | ETF | 97.74 | 97.74 | 97.74 | 97.74 | 100.0 |
| 2003-06-30 08:00:00 | QQQ | ETF | 30.15 | 30.2 | 30.13 | 30.2 | 60200.0 |
| 2003-06-30 08:30:00 | QQQ | ETF | 30.16 | 30.2 | 30.16 | 30.18 | 50600.0 |
| 2003-06-30 09:00:00 | QQQ | ETF | 30.16 | 30.18 | 30.15 | 30.18 | 52000.0 |
| 2003-06-30 09:30:00 | QQQ | ETF | 30.16 | 30.34 | 30.12 | 30.154 | 9795400.0 |
| 2003-06-30 10:00:00 | QQQ | ETF | 30.15 | 30.25 | 30.03 | 30.04 | 5786900.0 |
| 2003-06-30 10:30:00 | QQQ | ETF | 30.04 | 30.09 | 29.91 | 30.044 | 6077300.0 |
| 2003-06-30 11:00:00 | QQQ | ETF | 30.03 | 30.11 | 29.96 | 29.99 | 2691100.0 |
| 2003-06-30 11:30:00 | QQQ | ETF | 29.99 | 30.0 | 29.88 | 29.9 | 3835000.0 |
| 2003-06-30 12:00:00 | QQQ | ETF | 29.89 | 29.973 | 29.8 | 29.97 | 6042800.0 |
| 2003-06-30 12:30:00 | QQQ | ETF | 29.96 | 30.02 | 29.89 | 29.99 | 1825600.0 |
| 2003-06-30 13:00:00 | QQQ | ETF | 29.98 | 30.06 | 29.96 | 30.04 | 2776300.0 |
| 2003-06-30 13:30:00 | QQQ | ETF | 30.04 | 30.16 | 30.03 | 30.1 | 3055300.0 |
| 2003-06-30 14:00:00 | QQQ | ETF | 30.097 | 30.13 | 29.95 | 29.984 | 2846800.0 |
| 2003-06-30 14:30:00 | QQQ | ETF | 29.97 | 30.03 | 29.92 | 29.98 | 3054800.0 |
| 2003-06-30 15:00:00 | QQQ | ETF | 29.98 | 29.99 | 29.84 | 29.94 | 3669100.0 |
| 2003-06-30 15:30:00 | QQQ | ETF | 29.94 | 30.01 | 29.846 | 29.85 | 9374600.0 |
| 2003-06-30 16:00:00 | QQQ | ETF | 29.85 | 29.97 | 29.82 | 29.93 | 2871500.0 |
| 2003-06-30 16:30:00 | QQQ | ETF | 29.92 | 29.921 | 29.9 | 29.92 | 122700.0 |
| 2003-06-30 17:00:00 | QQQ | ETF | 29.92 | 29.93 | 29.91 | 29.92 | 49700.0 |
| 2003-06-30 17:30:00 | QQQ | ETF | 29.92 | 29.93 | 29.91 | 29.91 | 4500.0 |
| 2003-06-30 18:00:00 | QQQ | ETF | 29.92 | 29.92 | 29.88 | 29.9 | 28700.0 |
| 2003-06-30 18:30:00 | QQQ | ETF | 29.9 | 29.9 | 29.88 | 29.88 | 7400.0 |
| 2003-06-30 19:00:00 | QQQ | ETF | 29.9 | 29.9 | 29.9 | 29.9 | 2000.0 |
| 2003-06-30 19:30:00 | QQQ | ETF | 29.89 | 29.9 | 29.86 | 29.9 | 7800.0 |
| 2003-06-30 08:30:00 | IWM | ETF | 44.87 | 44.88 | 44.87 | 44.88 | 3000.0 |
| 2003-06-30 09:30:00 | IWM | ETF | 44.845 | 45.155 | 44.745 | 44.94 | 624000.0 |
> showing 50 of 716 rows — these rows as CSV