PREVIEW / etf_30min / 2003-05-19
file: by_date/etf_30min/2003/2003-05-19.parquet size: 23 KB rows: 699
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-05-19 08:00:00 | SPY | ETF | 94.23 | 94.31 | 94.2 | 94.3 | 50900.0 |
| 2003-05-19 08:30:00 | SPY | ETF | 94.3 | 94.33 | 94.25 | 94.28 | 11100.0 |
| 2003-05-19 09:00:00 | SPY | ETF | 94.27 | 94.28 | 94.15 | 94.23 | 38400.0 |
| 2003-05-19 09:30:00 | SPY | ETF | 94.2 | 94.42 | 93.9 | 93.97 | 6028800.0 |
| 2003-05-19 10:00:00 | SPY | ETF | 93.95 | 94.08 | 93.31 | 93.34 | 5176000.0 |
| 2003-05-19 10:30:00 | SPY | ETF | 93.34 | 93.47 | 93.06 | 93.2 | 5395000.0 |
| 2003-05-19 11:00:00 | SPY | ETF | 93.2 | 93.3 | 93.05 | 93.16 | 1464000.0 |
| 2003-05-19 11:30:00 | SPY | ETF | 93.16 | 93.23 | 92.78 | 92.83 | 2070000.0 |
| 2003-05-19 12:00:00 | SPY | ETF | 92.83 | 93.03 | 92.76 | 92.93 | 2341500.0 |
| 2003-05-19 12:30:00 | SPY | ETF | 92.93 | 92.99 | 92.68 | 92.76 | 1033000.0 |
| 2003-05-19 13:00:00 | SPY | ETF | 92.81 | 92.98 | 92.71 | 92.92 | 1049000.0 |
| 2003-05-19 13:30:00 | SPY | ETF | 92.92 | 93.04 | 92.64 | 92.67 | 1297700.0 |
| 2003-05-19 14:00:00 | SPY | ETF | 92.66 | 92.71 | 92.5 | 92.59 | 1695300.0 |
| 2003-05-19 14:30:00 | SPY | ETF | 92.57 | 92.91 | 92.56 | 92.71 | 1397500.0 |
| 2003-05-19 15:00:00 | SPY | ETF | 92.71 | 92.85 | 92.53 | 92.61 | 1325200.0 |
| 2003-05-19 15:30:00 | SPY | ETF | 92.6 | 92.69 | 92.41 | 92.51 | 3190300.0 |
| 2003-05-19 16:00:00 | SPY | ETF | 92.5 | 92.73 | 92.45 | 92.58 | 1469500.0 |
| 2003-05-19 16:30:00 | SPY | ETF | 92.6 | 92.74 | 92.6 | 92.69 | 176500.0 |
| 2003-05-19 17:00:00 | SPY | ETF | 92.7 | 92.75 | 92.63 | 92.65 | 33700.0 |
| 2003-05-19 17:30:00 | SPY | ETF | 92.63 | 92.65 | 92.63 | 92.64 | 9900.0 |
| 2003-05-19 18:00:00 | SPY | ETF | 92.65 | 92.72 | 92.61 | 92.61 | 4100.0 |
| 2003-05-19 18:30:00 | SPY | ETF | 92.65 | 92.7 | 92.65 | 92.67 | 2500.0 |
| 2003-05-19 19:00:00 | SPY | ETF | 92.68 | 92.68 | 92.6 | 92.6 | 1200.0 |
| 2003-05-19 19:30:00 | SPY | ETF | 92.59 | 92.59 | 92.5 | 92.57 | 3300.0 |
| 2003-05-19 08:00:00 | QQQ | ETF | 28.51 | 28.53 | 28.46 | 28.5 | 51400.0 |
| 2003-05-19 08:30:00 | QQQ | ETF | 28.52 | 28.52 | 28.47 | 28.5 | 28900.0 |
| 2003-05-19 09:00:00 | QQQ | ETF | 28.49 | 28.53 | 28.47 | 28.53 | 44200.0 |
| 2003-05-19 09:30:00 | QQQ | ETF | 28.52 | 28.68 | 28.43 | 28.47 | 10879500.0 |
| 2003-05-19 10:00:00 | QQQ | ETF | 28.47 | 28.55 | 28.18 | 28.2 | 11781300.0 |
| 2003-05-19 10:30:00 | QQQ | ETF | 28.2 | 28.23 | 28.02 | 28.09 | 9463100.0 |
| 2003-05-19 11:00:00 | QQQ | ETF | 28.08 | 28.14 | 28.01 | 28.1 | 4097100.0 |
| 2003-05-19 11:30:00 | QQQ | ETF | 28.1 | 28.12 | 28.0 | 28.02 | 4115000.0 |
| 2003-05-19 12:00:00 | QQQ | ETF | 28.01 | 28.03 | 27.92 | 28.02 | 5097300.0 |
| 2003-05-19 12:30:00 | QQQ | ETF | 28.02 | 28.04 | 27.88 | 27.95 | 3512300.0 |
| 2003-05-19 13:00:00 | QQQ | ETF | 27.95 | 28.02 | 27.88 | 28.02 | 2657700.0 |
| 2003-05-19 13:30:00 | QQQ | ETF | 28.01 | 28.03 | 27.87 | 27.9 | 2951600.0 |
| 2003-05-19 14:00:00 | QQQ | ETF | 27.9 | 27.93 | 27.8 | 27.82 | 3901000.0 |
| 2003-05-19 14:30:00 | QQQ | ETF | 27.82 | 28.0 | 27.81 | 27.87 | 3412300.0 |
| 2003-05-19 15:00:00 | QQQ | ETF | 27.85 | 27.93 | 27.78 | 27.79 | 3270200.0 |
| 2003-05-19 15:30:00 | QQQ | ETF | 27.8 | 27.85 | 27.61 | 27.7 | 7472800.0 |
| 2003-05-19 16:00:00 | QQQ | ETF | 27.68 | 27.79 | 27.65 | 27.69 | 2546300.0 |
| 2003-05-19 16:30:00 | QQQ | ETF | 27.7 | 27.71 | 27.68 | 27.69 | 134500.0 |
| 2003-05-19 17:00:00 | QQQ | ETF | 27.68 | 27.7 | 27.65 | 27.67 | 55700.0 |
| 2003-05-19 17:30:00 | QQQ | ETF | 27.67 | 27.72 | 27.65 | 27.72 | 224100.0 |
| 2003-05-19 18:00:00 | QQQ | ETF | 27.71 | 27.71 | 27.67 | 27.68 | 34900.0 |
| 2003-05-19 18:30:00 | QQQ | ETF | 27.67 | 27.7 | 27.67 | 27.67 | 3400.0 |
| 2003-05-19 19:00:00 | QQQ | ETF | 27.68 | 27.69 | 27.66 | 27.66 | 13600.0 |
| 2003-05-19 19:30:00 | QQQ | ETF | 27.66 | 27.68 | 27.65 | 27.65 | 28800.0 |
| 2003-05-19 09:30:00 | IWM | ETF | 41.3 | 41.58 | 41.3 | 41.385 | 398600.0 |
| 2003-05-19 10:00:00 | IWM | ETF | 41.355 | 41.4 | 41.05 | 41.12 | 761400.0 |
> showing 50 of 699 rows — these rows as CSV