PREVIEW / etf_30min / 2003-12-09
file: by_date/etf_30min/2003/2003-12-09.parquet size: 28 KB rows: 877
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-12-09 08:00:00 | SPY | ETF | 107.88 | 107.93 | 107.84 | 107.93 | 7000.0 |
| 2003-12-09 08:30:00 | SPY | ETF | 107.92 | 107.92 | 107.85 | 107.85 | 24100.0 |
| 2003-12-09 09:00:00 | SPY | ETF | 107.88 | 107.9 | 107.83 | 107.86 | 51000.0 |
| 2003-12-09 09:30:00 | SPY | ETF | 107.9 | 107.93 | 107.56 | 107.64 | 2507000.0 |
| 2003-12-09 10:00:00 | SPY | ETF | 107.63 | 107.72 | 107.43 | 107.48 | 1857100.0 |
| 2003-12-09 10:30:00 | SPY | ETF | 107.47 | 107.56 | 107.35 | 107.36 | 1504200.0 |
| 2003-12-09 11:00:00 | SPY | ETF | 107.34 | 107.39 | 107.18 | 107.31 | 1833300.0 |
| 2003-12-09 11:30:00 | SPY | ETF | 107.3 | 107.46 | 107.24 | 107.4 | 2046900.0 |
| 2003-12-09 12:00:00 | SPY | ETF | 107.4 | 107.44 | 107.22 | 107.28 | 1608300.0 |
| 2003-12-09 12:30:00 | SPY | ETF | 107.26 | 107.42 | 107.21 | 107.42 | 743000.0 |
| 2003-12-09 13:00:00 | SPY | ETF | 107.4 | 107.43 | 107.2 | 107.31 | 1908500.0 |
| 2003-12-09 13:30:00 | SPY | ETF | 107.32 | 107.41 | 107.19 | 107.31 | 770300.0 |
| 2003-12-09 14:00:00 | SPY | ETF | 107.29 | 107.62 | 107.08 | 107.14 | 9527400.0 |
| 2003-12-09 14:30:00 | SPY | ETF | 107.12 | 107.27 | 106.75 | 106.85 | 5739800.0 |
| 2003-12-09 15:00:00 | SPY | ETF | 106.84 | 107.05 | 106.59 | 106.66 | 4190500.0 |
| 2003-12-09 15:30:00 | SPY | ETF | 106.68 | 106.79 | 106.54 | 106.62 | 2658900.0 |
| 2003-12-09 16:00:00 | SPY | ETF | 106.64 | 106.81 | 106.58 | 106.81 | 1725700.0 |
| 2003-12-09 16:30:00 | SPY | ETF | 106.74 | 106.77 | 106.7 | 106.74 | 83700.0 |
| 2003-12-09 17:00:00 | SPY | ETF | 106.72 | 106.75 | 106.7 | 106.7 | 1703000.0 |
| 2003-12-09 17:30:00 | SPY | ETF | 106.7 | 106.72 | 106.68 | 106.68 | 23700.0 |
| 2003-12-09 18:00:00 | SPY | ETF | 106.73 | 106.73 | 106.7 | 106.7 | 700.0 |
| 2003-12-09 19:00:00 | SPY | ETF | 106.72 | 106.72 | 106.7 | 106.7 | 3200.0 |
| 2003-12-09 08:00:00 | QQQ | ETF | 35.44 | 35.44 | 35.4 | 35.41 | 138700.0 |
| 2003-12-09 08:30:00 | QQQ | ETF | 35.41 | 35.42 | 35.38 | 35.38 | 24500.0 |
| 2003-12-09 09:00:00 | QQQ | ETF | 35.38 | 35.44 | 35.38 | 35.44 | 73600.0 |
| 2003-12-09 09:30:00 | QQQ | ETF | 35.44 | 35.46 | 35.21 | 35.26 | 9555500.0 |
| 2003-12-09 10:00:00 | QQQ | ETF | 35.26 | 35.34 | 35.14 | 35.168 | 6643600.0 |
| 2003-12-09 10:30:00 | QQQ | ETF | 35.165 | 35.26 | 35.07 | 35.11 | 5412400.0 |
| 2003-12-09 11:00:00 | QQQ | ETF | 35.11 | 35.13 | 34.87 | 34.98 | 8101800.0 |
| 2003-12-09 11:30:00 | QQQ | ETF | 34.98 | 35.07 | 34.92 | 35.03 | 6850800.0 |
| 2003-12-09 12:00:00 | QQQ | ETF | 35.03 | 35.031 | 34.91 | 34.95 | 3965300.0 |
| 2003-12-09 12:30:00 | QQQ | ETF | 34.948 | 35.04 | 34.93 | 35.02 | 3115100.0 |
| 2003-12-09 13:00:00 | QQQ | ETF | 35.03 | 35.04 | 34.88 | 34.94 | 3063900.0 |
| 2003-12-09 13:30:00 | QQQ | ETF | 34.933 | 34.98 | 34.85 | 34.93 | 2923500.0 |
| 2003-12-09 14:00:00 | QQQ | ETF | 34.921 | 35.06 | 34.733 | 34.743 | 10106500.0 |
| 2003-12-09 14:30:00 | QQQ | ETF | 34.742 | 34.88 | 34.59 | 34.62 | 15737700.0 |
| 2003-12-09 15:00:00 | QQQ | ETF | 34.619 | 34.75 | 34.47 | 34.54 | 10397400.0 |
| 2003-12-09 15:30:00 | QQQ | ETF | 34.54 | 34.57 | 34.37 | 34.42 | 15309700.0 |
| 2003-12-09 16:00:00 | QQQ | ETF | 34.42 | 34.45 | 34.38 | 34.44 | 2408700.0 |
| 2003-12-09 16:30:00 | QQQ | ETF | 34.45 | 34.45 | 34.412 | 34.43 | 86900.0 |
| 2003-12-09 17:00:00 | QQQ | ETF | 34.43 | 34.44 | 34.419 | 34.419 | 62000.0 |
| 2003-12-09 17:30:00 | QQQ | ETF | 34.438 | 34.44 | 34.42 | 34.42 | 16900.0 |
| 2003-12-09 18:00:00 | QQQ | ETF | 34.43 | 34.44 | 34.42 | 34.44 | 14800.0 |
| 2003-12-09 18:30:00 | QQQ | ETF | 34.44 | 34.45 | 34.44 | 34.45 | 6800.0 |
| 2003-12-09 19:00:00 | QQQ | ETF | 34.46 | 34.48 | 34.46 | 34.46 | 11700.0 |
| 2003-12-09 19:30:00 | QQQ | ETF | 34.48 | 34.48 | 34.45 | 34.45 | 8100.0 |
| 2003-12-09 09:00:00 | IWM | ETF | 54.41 | 54.41 | 54.41 | 54.41 | 14000.0 |
| 2003-12-09 09:30:00 | IWM | ETF | 54.365 | 54.475 | 53.99 | 54.13 | 791600.0 |
| 2003-12-09 10:00:00 | IWM | ETF | 54.13 | 54.17 | 53.82 | 53.88 | 427000.0 |
| 2003-12-09 10:30:00 | IWM | ETF | 53.86 | 53.975 | 53.75 | 53.805 | 240000.0 |
> showing 50 of 877 rows — these rows as CSV