PREVIEW / etf_30min / 2003-08-15
file: by_date/etf_30min/2003/2003-08-15.parquet size: 17 KB rows: 455
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-08-15 08:00:00 | SPY | ETF | 99.48 | 99.53 | 99.42 | 99.45 | 58900.0 |
| 2003-08-15 08:30:00 | SPY | ETF | 99.33 | 99.38 | 99.29 | 99.37 | 72400.0 |
| 2003-08-15 09:00:00 | SPY | ETF | 99.36 | 99.45 | 99.19 | 99.39 | 147800.0 |
| 2003-08-15 09:30:00 | SPY | ETF | 99.36 | 99.47 | 99.235 | 99.31 | 1477000.0 |
| 2003-08-15 10:00:00 | SPY | ETF | 99.31 | 99.51 | 99.122 | 99.46 | 1132500.0 |
| 2003-08-15 10:30:00 | SPY | ETF | 99.45 | 99.79 | 99.45 | 99.66 | 1113100.0 |
| 2003-08-15 11:00:00 | SPY | ETF | 99.67 | 99.705 | 99.51 | 99.6 | 842400.0 |
| 2003-08-15 11:30:00 | SPY | ETF | 99.59 | 99.63 | 99.48 | 99.5 | 335400.0 |
| 2003-08-15 12:00:00 | SPY | ETF | 99.48 | 99.5 | 99.32 | 99.32 | 554900.0 |
| 2003-08-15 12:30:00 | SPY | ETF | 99.32 | 99.37 | 99.19 | 99.26 | 607700.0 |
| 2003-08-15 13:00:00 | SPY | ETF | 99.26 | 99.37 | 99.24 | 99.29 | 473800.0 |
| 2003-08-15 13:30:00 | SPY | ETF | 99.3 | 99.37 | 99.184 | 99.35 | 420400.0 |
| 2003-08-15 14:00:00 | SPY | ETF | 99.36 | 99.43 | 99.31 | 99.41 | 405000.0 |
| 2003-08-15 14:30:00 | SPY | ETF | 99.4 | 99.53 | 99.3 | 99.5 | 613600.0 |
| 2003-08-15 15:00:00 | SPY | ETF | 99.52 | 99.54 | 99.38 | 99.44 | 322100.0 |
| 2003-08-15 15:30:00 | SPY | ETF | 99.44 | 99.58 | 99.42 | 99.52 | 794400.0 |
| 2003-08-15 16:00:00 | SPY | ETF | 99.52 | 99.69 | 99.51 | 99.59 | 647600.0 |
| 2003-08-15 16:30:00 | SPY | ETF | 99.59 | 99.6 | 99.59 | 99.6 | 2200.0 |
| 2003-08-15 17:00:00 | SPY | ETF | 99.6 | 99.6 | 99.55 | 99.55 | 2500.0 |
| 2003-08-15 17:30:00 | SPY | ETF | 99.6 | 99.6 | 99.6 | 99.6 | 100.0 |
| 2003-08-15 18:00:00 | SPY | ETF | 99.55 | 99.55 | 99.55 | 99.55 | 100.0 |
| 2003-08-15 19:30:00 | SPY | ETF | 99.6 | 99.6 | 99.6 | 99.6 | 400.0 |
| 2003-08-15 08:00:00 | QQQ | ETF | 31.02 | 31.06 | 31.0 | 31.0 | 40700.0 |
| 2003-08-15 08:30:00 | QQQ | ETF | 31.0 | 31.0 | 30.97 | 30.98 | 51200.0 |
| 2003-08-15 09:00:00 | QQQ | ETF | 30.99 | 31.0 | 30.94 | 30.99 | 224400.0 |
| 2003-08-15 09:30:00 | QQQ | ETF | 31.0 | 31.091 | 30.93 | 31.08 | 3279900.0 |
| 2003-08-15 10:00:00 | QQQ | ETF | 31.063 | 31.15 | 30.98 | 31.142 | 2957500.0 |
| 2003-08-15 10:30:00 | QQQ | ETF | 31.13 | 31.29 | 31.13 | 31.198 | 3454700.0 |
| 2003-08-15 11:00:00 | QQQ | ETF | 31.2 | 31.24 | 31.13 | 31.19 | 1786000.0 |
| 2003-08-15 11:30:00 | QQQ | ETF | 31.19 | 31.203 | 31.11 | 31.14 | 1301500.0 |
| 2003-08-15 12:00:00 | QQQ | ETF | 31.14 | 31.16 | 31.04 | 31.05 | 1561700.0 |
| 2003-08-15 12:30:00 | QQQ | ETF | 31.05 | 31.07 | 30.97 | 31.03 | 1534800.0 |
| 2003-08-15 13:00:00 | QQQ | ETF | 31.022 | 31.08 | 31.0 | 31.07 | 1105000.0 |
| 2003-08-15 13:30:00 | QQQ | ETF | 31.07 | 31.109 | 31.02 | 31.1 | 781900.0 |
| 2003-08-15 14:00:00 | QQQ | ETF | 31.1 | 31.14 | 31.08 | 31.11 | 796100.0 |
| 2003-08-15 14:30:00 | QQQ | ETF | 31.11 | 31.15 | 31.05 | 31.15 | 947100.0 |
| 2003-08-15 15:00:00 | QQQ | ETF | 31.14 | 31.16 | 31.07 | 31.11 | 1083500.0 |
| 2003-08-15 15:30:00 | QQQ | ETF | 31.11 | 31.17 | 31.1 | 31.146 | 1433900.0 |
| 2003-08-15 16:00:00 | QQQ | ETF | 31.13 | 31.19 | 31.123 | 31.18 | 844200.0 |
| 2003-08-15 16:30:00 | QQQ | ETF | 31.18 | 31.2 | 31.161 | 31.17 | 31000.0 |
| 2003-08-15 17:00:00 | QQQ | ETF | 31.17 | 31.18 | 31.15 | 31.17 | 13100.0 |
| 2003-08-15 17:30:00 | QQQ | ETF | 31.17 | 31.18 | 31.16 | 31.16 | 5800.0 |
| 2003-08-15 18:00:00 | QQQ | ETF | 31.17 | 31.19 | 31.16 | 31.17 | 12200.0 |
| 2003-08-15 18:30:00 | QQQ | ETF | 31.18 | 31.18 | 31.18 | 31.18 | 1400.0 |
| 2003-08-15 19:00:00 | QQQ | ETF | 31.19 | 31.19 | 31.19 | 31.19 | 1400.0 |
| 2003-08-15 19:30:00 | QQQ | ETF | 31.19 | 31.2 | 31.19 | 31.2 | 2000.0 |
| 2003-08-15 09:30:00 | IWM | ETF | 47.025 | 47.19 | 47.02 | 47.17 | 267600.0 |
| 2003-08-15 10:00:00 | IWM | ETF | 47.1 | 47.28 | 47.055 | 47.275 | 228600.0 |
| 2003-08-15 10:30:00 | IWM | ETF | 47.28 | 47.335 | 47.265 | 47.285 | 155400.0 |
| 2003-08-15 11:00:00 | IWM | ETF | 47.3 | 47.3 | 47.26 | 47.275 | 36200.0 |
> showing 50 of 455 rows — these rows as CSV