PREVIEW / etf_30min / 2003-12-12
file: by_date/etf_30min/2003/2003-12-12.parquet size: 27 KB rows: 873
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-12 08:00:00 | SPY | ETF | 108.02 | 108.02 | 107.93 | 107.95 | 6300.0 |
| 2003-12-12 08:30:00 | SPY | ETF | 107.98 | 108.18 | 107.98 | 108.1 | 43900.0 |
| 2003-12-12 09:00:00 | SPY | ETF | 108.1 | 108.1 | 107.95 | 107.97 | 10800.0 |
| 2003-12-12 09:30:00 | SPY | ETF | 107.97 | 108.02 | 107.45 | 107.49 | 5727200.0 |
| 2003-12-12 10:00:00 | SPY | ETF | 107.49 | 107.75 | 107.39 | 107.64 | 3646900.0 |
| 2003-12-12 10:30:00 | SPY | ETF | 107.64 | 107.8 | 107.56 | 107.63 | 1783600.0 |
| 2003-12-12 11:00:00 | SPY | ETF | 107.63 | 107.9 | 107.55 | 107.87 | 1701100.0 |
| 2003-12-12 11:30:00 | SPY | ETF | 107.87 | 107.87 | 107.7 | 107.76 | 3751500.0 |
| 2003-12-12 12:00:00 | SPY | ETF | 107.75 | 108.04 | 107.73 | 108.01 | 3930300.0 |
| 2003-12-12 12:30:00 | SPY | ETF | 108.0 | 108.02 | 107.7 | 107.78 | 823300.0 |
| 2003-12-12 13:00:00 | SPY | ETF | 107.79 | 107.85 | 107.72 | 107.73 | 619100.0 |
| 2003-12-12 13:30:00 | SPY | ETF | 107.73 | 107.94 | 107.7 | 107.75 | 824200.0 |
| 2003-12-12 14:00:00 | SPY | ETF | 107.74 | 107.93 | 107.61 | 107.83 | 956500.0 |
| 2003-12-12 14:30:00 | SPY | ETF | 107.83 | 107.97 | 107.81 | 107.9 | 698600.0 |
| 2003-12-12 15:00:00 | SPY | ETF | 107.91 | 108.2 | 107.86 | 108.0 | 2129300.0 |
| 2003-12-12 15:30:00 | SPY | ETF | 108.02 | 108.17 | 107.99 | 108.13 | 3576600.0 |
| 2003-12-12 16:00:00 | SPY | ETF | 108.12 | 108.16 | 107.95 | 108.08 | 1514600.0 |
| 2003-12-12 16:30:00 | SPY | ETF | 108.03 | 108.07 | 107.98 | 107.98 | 3200.0 |
| 2003-12-12 17:30:00 | SPY | ETF | 108.03 | 108.1 | 108.01 | 108.01 | 1700.0 |
| 2003-12-12 18:00:00 | SPY | ETF | 108.01 | 108.01 | 108.0 | 108.0 | 1000.0 |
| 2003-12-12 19:00:00 | SPY | ETF | 108.01 | 108.05 | 108.01 | 108.05 | 400.0 |
| 2003-12-12 08:00:00 | QQQ | ETF | 35.29 | 35.33 | 35.29 | 35.32 | 30200.0 |
| 2003-12-12 08:30:00 | QQQ | ETF | 35.33 | 35.42 | 35.3 | 35.38 | 88100.0 |
| 2003-12-12 09:00:00 | QQQ | ETF | 35.38 | 35.38 | 35.31 | 35.31 | 158600.0 |
| 2003-12-12 09:30:00 | QQQ | ETF | 35.31 | 35.34 | 35.0 | 35.0 | 11867000.0 |
| 2003-12-12 10:00:00 | QQQ | ETF | 35.0 | 35.132 | 34.93 | 35.032 | 8568500.0 |
| 2003-12-12 10:30:00 | QQQ | ETF | 35.03 | 35.13 | 34.96 | 35.001 | 4143100.0 |
| 2003-12-12 11:00:00 | QQQ | ETF | 35.0 | 35.15 | 34.92 | 35.11 | 5760000.0 |
| 2003-12-12 11:30:00 | QQQ | ETF | 35.11 | 35.133 | 35.04 | 35.05 | 3079400.0 |
| 2003-12-12 12:00:00 | QQQ | ETF | 35.08 | 35.16 | 35.04 | 35.13 | 3001100.0 |
| 2003-12-12 12:30:00 | QQQ | ETF | 35.14 | 35.14 | 34.97 | 35.0 | 2726400.0 |
| 2003-12-12 13:00:00 | QQQ | ETF | 35.0 | 35.07 | 34.99 | 35.01 | 1636300.0 |
| 2003-12-12 13:30:00 | QQQ | ETF | 35.011 | 35.1 | 34.95 | 34.98 | 2349500.0 |
| 2003-12-12 14:00:00 | QQQ | ETF | 34.97 | 35.076 | 34.92 | 35.01 | 3902900.0 |
| 2003-12-12 14:30:00 | QQQ | ETF | 35.012 | 35.12 | 35.0 | 35.09 | 3226500.0 |
| 2003-12-12 15:00:00 | QQQ | ETF | 35.09 | 35.27 | 35.06 | 35.196 | 6218300.0 |
| 2003-12-12 15:30:00 | QQQ | ETF | 35.196 | 35.29 | 35.16 | 35.23 | 7248200.0 |
| 2003-12-12 16:00:00 | QQQ | ETF | 35.23 | 35.29 | 35.08 | 35.233 | 2409100.0 |
| 2003-12-12 16:30:00 | QQQ | ETF | 35.24 | 35.28 | 35.211 | 35.221 | 73600.0 |
| 2003-12-12 17:00:00 | QQQ | ETF | 35.24 | 35.25 | 35.22 | 35.23 | 4500.0 |
| 2003-12-12 17:30:00 | QQQ | ETF | 35.23 | 35.25 | 35.23 | 35.25 | 16500.0 |
| 2003-12-12 18:00:00 | QQQ | ETF | 35.25 | 35.27 | 35.24 | 35.25 | 16700.0 |
| 2003-12-12 18:30:00 | QQQ | ETF | 35.23 | 35.23 | 35.23 | 35.23 | 3900.0 |
| 2003-12-12 19:00:00 | QQQ | ETF | 35.23 | 35.25 | 35.23 | 35.25 | 1200.0 |
| 2003-12-12 19:30:00 | QQQ | ETF | 35.26 | 35.28 | 35.26 | 35.28 | 3200.0 |
| 2003-12-12 08:00:00 | IWM | ETF | 54.18 | 54.18 | 54.18 | 54.18 | 11000.0 |
| 2003-12-12 08:30:00 | IWM | ETF | 54.215 | 54.255 | 54.215 | 54.255 | 3000.0 |
| 2003-12-12 09:30:00 | IWM | ETF | 54.181 | 54.365 | 53.85 | 53.855 | 1361600.0 |
| 2003-12-12 10:00:00 | IWM | ETF | 53.85 | 54.015 | 53.77 | 53.955 | 1230600.0 |
| 2003-12-12 10:30:00 | IWM | ETF | 53.95 | 54.2 | 53.95 | 54.055 | 620600.0 |
> showing 50 of 873 rows — these rows as CSV