PREVIEW / etf_30min / 2003-04-14
file: by_date/etf_30min/2003/2003-04-14.parquet size: 21 KB rows: 636
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-04-14 08:00:00 | SPY | ETF | 87.76 | 87.76 | 87.65 | 87.68 | 34400.0 |
| 2003-04-14 08:30:00 | SPY | ETF | 87.68 | 87.68 | 87.51 | 87.51 | 25000.0 |
| 2003-04-14 09:00:00 | SPY | ETF | 87.53 | 87.54 | 87.39 | 87.4 | 16400.0 |
| 2003-04-14 09:30:00 | SPY | ETF | 87.47 | 87.72 | 87.22 | 87.4 | 2823900.0 |
| 2003-04-14 10:00:00 | SPY | ETF | 87.38 | 87.64 | 87.25 | 87.57 | 1649200.0 |
| 2003-04-14 10:30:00 | SPY | ETF | 87.55 | 87.8 | 87.42 | 87.7 | 1534000.0 |
| 2003-04-14 11:00:00 | SPY | ETF | 87.69 | 87.84 | 87.53 | 87.82 | 1202100.0 |
| 2003-04-14 11:30:00 | SPY | ETF | 87.76 | 88.31 | 87.76 | 88.23 | 4136400.0 |
| 2003-04-14 12:00:00 | SPY | ETF | 88.23 | 88.4 | 88.17 | 88.3 | 1965400.0 |
| 2003-04-14 12:30:00 | SPY | ETF | 88.29 | 88.48 | 88.17 | 88.43 | 2290900.0 |
| 2003-04-14 13:00:00 | SPY | ETF | 88.45 | 88.57 | 88.27 | 88.38 | 1947500.0 |
| 2003-04-14 13:30:00 | SPY | ETF | 88.38 | 88.43 | 88.2 | 88.4 | 1448500.0 |
| 2003-04-14 14:00:00 | SPY | ETF | 88.4 | 88.47 | 88.12 | 88.21 | 1034500.0 |
| 2003-04-14 14:30:00 | SPY | ETF | 88.21 | 88.58 | 88.1 | 88.23 | 2521400.0 |
| 2003-04-14 15:00:00 | SPY | ETF | 88.26 | 88.45 | 88.22 | 88.42 | 1752100.0 |
| 2003-04-14 15:30:00 | SPY | ETF | 88.42 | 88.87 | 88.4 | 88.84 | 6802800.0 |
| 2003-04-14 16:00:00 | SPY | ETF | 88.85 | 89.09 | 88.8 | 89.05 | 2473800.0 |
| 2003-04-14 16:30:00 | SPY | ETF | 89.05 | 89.16 | 88.9 | 89.01 | 821300.0 |
| 2003-04-14 17:00:00 | SPY | ETF | 89.01 | 89.07 | 88.9 | 88.9 | 204700.0 |
| 2003-04-14 17:30:00 | SPY | ETF | 88.94 | 88.97 | 88.85 | 88.86 | 23900.0 |
| 2003-04-14 18:00:00 | SPY | ETF | 88.87 | 88.92 | 88.87 | 88.92 | 52300.0 |
| 2003-04-14 18:30:00 | SPY | ETF | 88.93 | 88.99 | 88.92 | 88.95 | 12700.0 |
| 2003-04-14 19:00:00 | SPY | ETF | 88.99 | 89.0 | 88.99 | 89.0 | 7800.0 |
| 2003-04-14 19:30:00 | SPY | ETF | 88.97 | 88.97 | 88.89 | 88.95 | 2900.0 |
| 2003-04-14 08:00:00 | QQQ | ETF | 25.67 | 25.67 | 25.6 | 25.62 | 25000.0 |
| 2003-04-14 08:30:00 | QQQ | ETF | 25.63 | 25.65 | 25.59 | 25.59 | 48500.0 |
| 2003-04-14 09:00:00 | QQQ | ETF | 25.59 | 25.61 | 25.56 | 25.56 | 15500.0 |
| 2003-04-14 09:30:00 | QQQ | ETF | 25.6 | 25.7 | 25.49 | 25.64 | 6343500.0 |
| 2003-04-14 10:00:00 | QQQ | ETF | 25.64 | 25.69 | 25.56 | 25.63 | 2709000.0 |
| 2003-04-14 10:30:00 | QQQ | ETF | 25.63 | 25.71 | 25.56 | 25.68 | 2341200.0 |
| 2003-04-14 11:00:00 | QQQ | ETF | 25.67 | 25.73 | 25.62 | 25.71 | 1761700.0 |
| 2003-04-14 11:30:00 | QQQ | ETF | 25.72 | 25.91 | 25.7 | 25.91 | 5728800.0 |
| 2003-04-14 12:00:00 | QQQ | ETF | 25.9 | 25.98 | 25.87 | 25.95 | 4705200.0 |
| 2003-04-14 12:30:00 | QQQ | ETF | 25.96 | 26.05 | 25.89 | 26.04 | 4283500.0 |
| 2003-04-14 13:00:00 | QQQ | ETF | 26.03 | 26.07 | 25.96 | 26.0 | 3329400.0 |
| 2003-04-14 13:30:00 | QQQ | ETF | 25.99 | 26.01 | 25.93 | 26.0 | 1595200.0 |
| 2003-04-14 14:00:00 | QQQ | ETF | 26.0 | 26.02 | 25.88 | 25.91 | 2622100.0 |
| 2003-04-14 14:30:00 | QQQ | ETF | 25.91 | 26.02 | 25.87 | 25.91 | 2463500.0 |
| 2003-04-14 15:00:00 | QQQ | ETF | 25.91 | 26.01 | 25.9 | 25.98 | 1728800.0 |
| 2003-04-14 15:30:00 | QQQ | ETF | 25.98 | 26.14 | 25.97 | 26.05 | 6988200.0 |
| 2003-04-14 16:00:00 | QQQ | ETF | 26.09 | 26.12 | 26.01 | 26.11 | 1510300.0 |
| 2003-04-14 16:30:00 | QQQ | ETF | 26.12 | 26.18 | 25.94 | 26.04 | 978900.0 |
| 2003-04-14 17:00:00 | QQQ | ETF | 26.05 | 26.1 | 25.95 | 25.95 | 331000.0 |
| 2003-04-14 17:30:00 | QQQ | ETF | 25.95 | 25.98 | 25.94 | 25.96 | 737100.0 |
| 2003-04-14 18:00:00 | QQQ | ETF | 25.95 | 25.98 | 25.93 | 25.98 | 163400.0 |
| 2003-04-14 18:30:00 | QQQ | ETF | 25.97 | 25.99 | 25.94 | 25.96 | 11300.0 |
| 2003-04-14 19:00:00 | QQQ | ETF | 25.94 | 25.96 | 25.94 | 25.96 | 1000.0 |
| 2003-04-14 19:30:00 | QQQ | ETF | 25.96 | 26.0 | 25.96 | 25.99 | 10100.0 |
| 2003-04-14 09:30:00 | IWM | ETF | 37.01 | 37.205 | 37.01 | 37.14 | 250600.0 |
| 2003-04-14 10:00:00 | IWM | ETF | 37.115 | 37.175 | 37.095 | 37.14 | 119400.0 |
> showing 50 of 636 rows — these rows as CSV