PREVIEW / etf_30min / 2003-01-16
file: by_date/etf_30min/2003/2003-01-16.parquet size: 22 KB rows: 645
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-01-16 08:00:00 | SPY | ETF | 92.34 | 92.51 | 92.34 | 92.51 | 18500.0 |
| 2003-01-16 08:30:00 | SPY | ETF | 92.56 | 92.81 | 92.52 | 92.52 | 64800.0 |
| 2003-01-16 09:00:00 | SPY | ETF | 92.55 | 92.55 | 92.4 | 92.4 | 5500.0 |
| 2003-01-16 09:30:00 | SPY | ETF | 92.5 | 92.92 | 92.2 | 92.8 | 4667400.0 |
| 2003-01-16 10:00:00 | SPY | ETF | 92.81 | 92.93 | 92.47 | 92.55 | 3697000.0 |
| 2003-01-16 10:30:00 | SPY | ETF | 92.56 | 92.59 | 92.05 | 92.14 | 2221600.0 |
| 2003-01-16 11:00:00 | SPY | ETF | 92.17 | 92.44 | 91.9 | 92.34 | 5250800.0 |
| 2003-01-16 11:30:00 | SPY | ETF | 92.31 | 92.6 | 92.21 | 92.59 | 1256400.0 |
| 2003-01-16 12:00:00 | SPY | ETF | 92.59 | 92.7 | 92.1 | 92.19 | 4035500.0 |
| 2003-01-16 12:30:00 | SPY | ETF | 92.2 | 92.33 | 92.07 | 92.15 | 1439500.0 |
| 2003-01-16 13:00:00 | SPY | ETF | 92.16 | 92.17 | 91.67 | 91.8 | 4550000.0 |
| 2003-01-16 13:30:00 | SPY | ETF | 91.82 | 91.95 | 91.62 | 91.92 | 1937700.0 |
| 2003-01-16 14:00:00 | SPY | ETF | 91.92 | 91.94 | 91.69 | 91.83 | 1886600.0 |
| 2003-01-16 14:30:00 | SPY | ETF | 91.83 | 91.97 | 91.61 | 91.67 | 2248700.0 |
| 2003-01-16 15:00:00 | SPY | ETF | 91.65 | 91.72 | 91.45 | 91.53 | 1441800.0 |
| 2003-01-16 15:30:00 | SPY | ETF | 91.53 | 91.84 | 91.47 | 91.82 | 2791400.0 |
| 2003-01-16 16:00:00 | SPY | ETF | 91.8 | 92.1 | 91.71 | 92.03 | 2777700.0 |
| 2003-01-16 16:30:00 | SPY | ETF | 92.07 | 92.63 | 91.73 | 91.75 | 1628700.0 |
| 2003-01-16 17:00:00 | SPY | ETF | 91.75 | 91.81 | 91.57 | 91.65 | 612900.0 |
| 2003-01-16 17:30:00 | SPY | ETF | 91.61 | 91.74 | 91.61 | 91.74 | 332200.0 |
| 2003-01-16 18:00:00 | SPY | ETF | 91.64 | 91.66 | 91.52 | 91.53 | 45500.0 |
| 2003-01-16 18:30:00 | SPY | ETF | 91.5 | 91.56 | 91.5 | 91.5 | 4200.0 |
| 2003-01-16 19:00:00 | SPY | ETF | 91.45 | 91.47 | 91.33 | 91.47 | 3800.0 |
| 2003-01-16 19:30:00 | SPY | ETF | 91.5 | 91.5 | 91.5 | 91.5 | 100.0 |
| 2003-01-16 08:00:00 | QQQ | ETF | 26.67 | 26.75 | 26.4 | 26.74 | 16500.0 |
| 2003-01-16 08:30:00 | QQQ | ETF | 26.8 | 26.93 | 26.75 | 26.81 | 65500.0 |
| 2003-01-16 09:00:00 | QQQ | ETF | 26.8 | 26.81 | 26.74 | 26.74 | 41600.0 |
| 2003-01-16 09:30:00 | QQQ | ETF | 26.79 | 26.98 | 26.59 | 26.91 | 9693900.0 |
| 2003-01-16 10:00:00 | QQQ | ETF | 26.9 | 26.94 | 26.69 | 26.72 | 5411500.0 |
| 2003-01-16 10:30:00 | QQQ | ETF | 26.74 | 26.78 | 26.53 | 26.58 | 4022400.0 |
| 2003-01-16 11:00:00 | QQQ | ETF | 26.58 | 26.72 | 26.45 | 26.63 | 4790400.0 |
| 2003-01-16 11:30:00 | QQQ | ETF | 26.65 | 26.74 | 26.6 | 26.7 | 2506800.0 |
| 2003-01-16 12:00:00 | QQQ | ETF | 26.69 | 26.75 | 26.53 | 26.61 | 3820800.0 |
| 2003-01-16 12:30:00 | QQQ | ETF | 26.6 | 26.64 | 26.52 | 26.55 | 1862800.0 |
| 2003-01-16 13:00:00 | QQQ | ETF | 26.55 | 26.56 | 26.36 | 26.44 | 5530500.0 |
| 2003-01-16 13:30:00 | QQQ | ETF | 26.44 | 26.47 | 26.33 | 26.45 | 2881800.0 |
| 2003-01-16 14:00:00 | QQQ | ETF | 26.46 | 26.49 | 26.4 | 26.45 | 2545300.0 |
| 2003-01-16 14:30:00 | QQQ | ETF | 26.45 | 26.54 | 26.37 | 26.4 | 2774900.0 |
| 2003-01-16 15:00:00 | QQQ | ETF | 26.39 | 26.43 | 26.28 | 26.31 | 4609600.0 |
| 2003-01-16 15:30:00 | QQQ | ETF | 26.3 | 26.45 | 26.29 | 26.4 | 6469600.0 |
| 2003-01-16 16:00:00 | QQQ | ETF | 26.38 | 26.5 | 26.31 | 26.45 | 1752100.0 |
| 2003-01-16 16:30:00 | QQQ | ETF | 26.44 | 26.76 | 26.15 | 26.18 | 4364900.0 |
| 2003-01-16 17:00:00 | QQQ | ETF | 26.18 | 26.25 | 26.14 | 26.17 | 1038700.0 |
| 2003-01-16 17:30:00 | QQQ | ETF | 26.17 | 26.19 | 25.17 | 26.17 | 274500.0 |
| 2003-01-16 18:00:00 | QQQ | ETF | 26.17 | 26.21 | 26.1 | 26.11 | 748100.0 |
| 2003-01-16 18:30:00 | QQQ | ETF | 26.12 | 26.16 | 26.1 | 26.12 | 24200.0 |
| 2003-01-16 19:00:00 | QQQ | ETF | 26.12 | 26.12 | 26.09 | 26.09 | 33100.0 |
| 2003-01-16 19:30:00 | QQQ | ETF | 26.09 | 26.16 | 26.07 | 26.12 | 17500.0 |
| 2003-01-16 09:30:00 | IWM | ETF | 39.5 | 39.735 | 39.23 | 39.69 | 448200.0 |
| 2003-01-16 10:00:00 | IWM | ETF | 39.705 | 39.75 | 39.55 | 39.55 | 92400.0 |
> showing 50 of 645 rows — these rows as CSV