PREVIEW / etf_30min / 2003-04-07
file: by_date/etf_30min/2003/2003-04-07.parquet size: 23 KB rows: 689
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-07 08:00:00 | SPY | ETF | 90.53 | 90.62 | 90.45 | 90.45 | 17300.0 |
| 2003-04-07 08:30:00 | SPY | ETF | 90.41 | 90.41 | 90.24 | 90.3 | 76900.0 |
| 2003-04-07 09:00:00 | SPY | ETF | 90.3 | 90.41 | 90.17 | 90.26 | 95400.0 |
| 2003-04-07 09:30:00 | SPY | ETF | 90.34 | 90.66 | 90.11 | 90.44 | 10131400.0 |
| 2003-04-07 10:00:00 | SPY | ETF | 90.46 | 90.85 | 90.28 | 90.52 | 10202100.0 |
| 2003-04-07 10:30:00 | SPY | ETF | 90.55 | 90.64 | 89.8 | 89.85 | 5757900.0 |
| 2003-04-07 11:00:00 | SPY | ETF | 89.87 | 90.2 | 89.8 | 90.2 | 4824200.0 |
| 2003-04-07 11:30:00 | SPY | ETF | 90.2 | 90.22 | 89.85 | 89.93 | 3006800.0 |
| 2003-04-07 12:00:00 | SPY | ETF | 89.93 | 90.03 | 89.63 | 90.03 | 3131500.0 |
| 2003-04-07 12:30:00 | SPY | ETF | 89.97 | 90.09 | 89.85 | 89.88 | 1724500.0 |
| 2003-04-07 13:00:00 | SPY | ETF | 89.9 | 90.06 | 89.8 | 89.97 | 1703300.0 |
| 2003-04-07 13:30:00 | SPY | ETF | 89.99 | 90.05 | 89.69 | 89.88 | 1707100.0 |
| 2003-04-07 14:00:00 | SPY | ETF | 89.87 | 89.97 | 89.46 | 89.5 | 1616700.0 |
| 2003-04-07 14:30:00 | SPY | ETF | 89.52 | 89.68 | 89.2 | 89.24 | 3314600.0 |
| 2003-04-07 15:00:00 | SPY | ETF | 89.2 | 89.28 | 88.83 | 88.86 | 5859300.0 |
| 2003-04-07 15:30:00 | SPY | ETF | 88.89 | 88.92 | 88.19 | 88.23 | 7858900.0 |
| 2003-04-07 16:00:00 | SPY | ETF | 88.22 | 88.24 | 87.97 | 88.05 | 2661200.0 |
| 2003-04-07 16:30:00 | SPY | ETF | 88.05 | 90.52 | 88.0 | 88.12 | 823900.0 |
| 2003-04-07 17:00:00 | SPY | ETF | 88.15 | 88.2 | 88.1 | 88.1 | 21800.0 |
| 2003-04-07 17:30:00 | SPY | ETF | 88.1 | 88.14 | 88.07 | 88.11 | 27700.0 |
| 2003-04-07 18:00:00 | SPY | ETF | 88.06 | 88.1 | 88.0 | 88.0 | 17300.0 |
| 2003-04-07 18:30:00 | SPY | ETF | 88.0 | 88.11 | 88.0 | 88.06 | 4000.0 |
| 2003-04-07 19:00:00 | SPY | ETF | 88.06 | 88.06 | 87.95 | 87.95 | 2700.0 |
| 2003-04-07 19:30:00 | SPY | ETF | 87.96 | 87.98 | 87.9 | 87.98 | 5400.0 |
| 2003-04-07 08:00:00 | QQQ | ETF | 27.04 | 27.07 | 26.63 | 27.03 | 98300.0 |
| 2003-04-07 08:30:00 | QQQ | ETF | 27.01 | 27.03 | 26.94 | 26.99 | 114400.0 |
| 2003-04-07 09:00:00 | QQQ | ETF | 27.0 | 27.11 | 26.97 | 27.1 | 183200.0 |
| 2003-04-07 09:30:00 | QQQ | ETF | 27.11 | 27.18 | 26.95 | 27.09 | 14654100.0 |
| 2003-04-07 10:00:00 | QQQ | ETF | 27.1 | 27.15 | 26.99 | 27.04 | 5815500.0 |
| 2003-04-07 10:30:00 | QQQ | ETF | 27.04 | 27.07 | 26.81 | 26.84 | 6112900.0 |
| 2003-04-07 11:00:00 | QQQ | ETF | 26.84 | 26.97 | 26.81 | 26.96 | 3802000.0 |
| 2003-04-07 11:30:00 | QQQ | ETF | 26.96 | 26.97 | 26.89 | 26.92 | 3911500.0 |
| 2003-04-07 12:00:00 | QQQ | ETF | 26.92 | 26.95 | 26.77 | 26.84 | 3264800.0 |
| 2003-04-07 12:30:00 | QQQ | ETF | 26.85 | 26.9 | 26.79 | 26.8 | 2842600.0 |
| 2003-04-07 13:00:00 | QQQ | ETF | 26.8 | 26.88 | 26.78 | 26.87 | 2119000.0 |
| 2003-04-07 13:30:00 | QQQ | ETF | 26.84 | 26.9 | 26.79 | 26.86 | 2216500.0 |
| 2003-04-07 14:00:00 | QQQ | ETF | 26.84 | 26.89 | 26.71 | 26.75 | 2215500.0 |
| 2003-04-07 14:30:00 | QQQ | ETF | 26.74 | 26.78 | 26.57 | 26.57 | 4653000.0 |
| 2003-04-07 15:00:00 | QQQ | ETF | 26.57 | 26.6 | 26.38 | 26.41 | 10189200.0 |
| 2003-04-07 15:30:00 | QQQ | ETF | 26.42 | 26.45 | 26.18 | 26.21 | 10525000.0 |
| 2003-04-07 16:00:00 | QQQ | ETF | 26.2 | 26.25 | 26.07 | 26.09 | 2970400.0 |
| 2003-04-07 16:30:00 | QQQ | ETF | 26.1 | 26.13 | 26.06 | 26.08 | 147900.0 |
| 2003-04-07 17:00:00 | QQQ | ETF | 26.09 | 26.14 | 26.08 | 26.12 | 100700.0 |
| 2003-04-07 17:30:00 | QQQ | ETF | 26.12 | 26.13 | 26.09 | 26.13 | 31900.0 |
| 2003-04-07 18:00:00 | QQQ | ETF | 26.12 | 26.14 | 26.1 | 26.12 | 22900.0 |
| 2003-04-07 18:30:00 | QQQ | ETF | 26.13 | 26.16 | 26.11 | 26.11 | 25600.0 |
| 2003-04-07 19:00:00 | QQQ | ETF | 26.11 | 26.18 | 26.11 | 26.16 | 14500.0 |
| 2003-04-07 19:30:00 | QQQ | ETF | 26.15 | 26.15 | 26.11 | 26.11 | 45500.0 |
| 2003-04-07 09:30:00 | IWM | ETF | 38.075 | 38.2 | 37.925 | 38.125 | 499600.0 |
| 2003-04-07 10:00:00 | IWM | ETF | 38.135 | 38.22 | 38.04 | 38.135 | 561200.0 |
> showing 50 of 689 rows — these rows as CSV