PREVIEW / etf_30min / 2003-05-09
file: by_date/etf_30min/2003/2003-05-09.parquet size: 22 KB rows: 657
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-09 08:00:00 | SPY | ETF | 92.84 | 92.9 | 92.8 | 92.9 | 5900.0 |
| 2003-05-09 08:30:00 | SPY | ETF | 92.91 | 92.92 | 92.82 | 92.86 | 14100.0 |
| 2003-05-09 09:00:00 | SPY | ETF | 92.8 | 92.86 | 92.8 | 92.85 | 13200.0 |
| 2003-05-09 09:30:00 | SPY | ETF | 92.86 | 93.1 | 92.75 | 92.97 | 4217600.0 |
| 2003-05-09 10:00:00 | SPY | ETF | 92.98 | 93.03 | 92.61 | 92.8 | 2580700.0 |
| 2003-05-09 10:30:00 | SPY | ETF | 92.83 | 93.17 | 92.74 | 93.15 | 1912300.0 |
| 2003-05-09 11:00:00 | SPY | ETF | 93.14 | 93.39 | 93.1 | 93.3 | 3961300.0 |
| 2003-05-09 11:30:00 | SPY | ETF | 93.3 | 93.37 | 93.19 | 93.29 | 1775000.0 |
| 2003-05-09 12:00:00 | SPY | ETF | 93.27 | 93.79 | 93.25 | 93.77 | 2756400.0 |
| 2003-05-09 12:30:00 | SPY | ETF | 93.77 | 93.8 | 93.6 | 93.65 | 1827100.0 |
| 2003-05-09 13:00:00 | SPY | ETF | 93.64 | 93.74 | 93.57 | 93.66 | 1045900.0 |
| 2003-05-09 13:30:00 | SPY | ETF | 93.65 | 93.74 | 93.63 | 93.65 | 565600.0 |
| 2003-05-09 14:00:00 | SPY | ETF | 93.64 | 93.79 | 93.4 | 93.45 | 2005200.0 |
| 2003-05-09 14:30:00 | SPY | ETF | 93.44 | 93.67 | 93.26 | 93.6 | 2050000.0 |
| 2003-05-09 15:00:00 | SPY | ETF | 93.6 | 93.66 | 93.39 | 93.59 | 1098200.0 |
| 2003-05-09 15:30:00 | SPY | ETF | 93.57 | 93.78 | 93.49 | 93.71 | 1968300.0 |
| 2003-05-09 16:00:00 | SPY | ETF | 93.7 | 93.85 | 93.63 | 93.83 | 1301700.0 |
| 2003-05-09 16:30:00 | SPY | ETF | 93.8 | 93.85 | 93.75 | 93.76 | 32800.0 |
| 2003-05-09 17:00:00 | SPY | ETF | 93.76 | 93.82 | 93.75 | 93.8 | 4700.0 |
| 2003-05-09 17:30:00 | SPY | ETF | 93.77 | 93.77 | 93.7 | 93.7 | 16500.0 |
| 2003-05-09 18:00:00 | SPY | ETF | 93.7 | 93.7 | 93.7 | 93.7 | 9900.0 |
| 2003-05-09 18:30:00 | SPY | ETF | 93.72 | 93.75 | 93.67 | 93.75 | 4500.0 |
| 2003-05-09 19:00:00 | SPY | ETF | 93.67 | 93.67 | 93.6 | 93.6 | 4400.0 |
| 2003-05-09 19:30:00 | SPY | ETF | 93.66 | 93.75 | 93.6 | 93.75 | 7700.0 |
| 2003-05-09 08:00:00 | QQQ | ETF | 27.97 | 28.03 | 27.97 | 28.02 | 44000.0 |
| 2003-05-09 08:30:00 | QQQ | ETF | 28.03 | 28.07 | 28.01 | 28.01 | 70900.0 |
| 2003-05-09 09:00:00 | QQQ | ETF | 28.01 | 28.04 | 28.0 | 28.04 | 23100.0 |
| 2003-05-09 09:30:00 | QQQ | ETF | 28.04 | 28.23 | 28.0 | 28.15 | 8443800.0 |
| 2003-05-09 10:00:00 | QQQ | ETF | 28.16 | 28.17 | 27.99 | 28.09 | 6222800.0 |
| 2003-05-09 10:30:00 | QQQ | ETF | 28.09 | 28.22 | 28.05 | 28.21 | 2461200.0 |
| 2003-05-09 11:00:00 | QQQ | ETF | 28.18 | 28.29 | 28.13 | 28.22 | 6529700.0 |
| 2003-05-09 11:30:00 | QQQ | ETF | 28.24 | 28.26 | 28.19 | 28.25 | 2723400.0 |
| 2003-05-09 12:00:00 | QQQ | ETF | 28.26 | 28.48 | 28.23 | 28.44 | 5981200.0 |
| 2003-05-09 12:30:00 | QQQ | ETF | 28.44 | 28.46 | 28.36 | 28.4 | 2597300.0 |
| 2003-05-09 13:00:00 | QQQ | ETF | 28.4 | 28.42 | 28.31 | 28.38 | 1900200.0 |
| 2003-05-09 13:30:00 | QQQ | ETF | 28.38 | 28.42 | 28.34 | 28.37 | 1002000.0 |
| 2003-05-09 14:00:00 | QQQ | ETF | 28.37 | 28.44 | 28.26 | 28.27 | 2603400.0 |
| 2003-05-09 14:30:00 | QQQ | ETF | 28.27 | 28.38 | 28.2 | 28.36 | 2532200.0 |
| 2003-05-09 15:00:00 | QQQ | ETF | 28.35 | 28.37 | 28.26 | 28.35 | 1604800.0 |
| 2003-05-09 15:30:00 | QQQ | ETF | 28.35 | 28.44 | 28.3 | 28.41 | 5112000.0 |
| 2003-05-09 16:00:00 | QQQ | ETF | 28.42 | 28.43 | 28.35 | 28.38 | 1531300.0 |
| 2003-05-09 16:30:00 | QQQ | ETF | 28.38 | 28.4 | 28.37 | 28.39 | 29500.0 |
| 2003-05-09 17:00:00 | QQQ | ETF | 28.39 | 28.42 | 28.38 | 28.42 | 41100.0 |
| 2003-05-09 17:30:00 | QQQ | ETF | 28.42 | 28.43 | 28.41 | 28.43 | 19800.0 |
| 2003-05-09 18:00:00 | QQQ | ETF | 28.43 | 28.44 | 28.41 | 28.44 | 15900.0 |
| 2003-05-09 18:30:00 | QQQ | ETF | 28.42 | 28.42 | 28.41 | 28.42 | 25100.0 |
| 2003-05-09 19:00:00 | QQQ | ETF | 28.42 | 28.44 | 28.42 | 28.44 | 15900.0 |
| 2003-05-09 19:30:00 | QQQ | ETF | 28.43 | 28.43 | 28.4 | 28.42 | 3300.0 |
| 2003-05-09 09:30:00 | IWM | ETF | 40.86 | 40.94 | 40.795 | 40.89 | 446000.0 |
| 2003-05-09 10:00:00 | IWM | ETF | 40.88 | 40.89 | 40.775 | 40.835 | 223400.0 |
> showing 50 of 657 rows — these rows as CSV