PREVIEW / etf_30min / 2003-09-05
file: by_date/etf_30min/2003/2003-09-05.parquet size: 24 KB rows: 727
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-09-05 08:00:00 | SPY | ETF | 103.28 | 103.36 | 103.2 | 103.2 | 30000.0 |
| 2003-09-05 08:30:00 | SPY | ETF | 103.15 | 103.15 | 102.93 | 102.99 | 162300.0 |
| 2003-09-05 09:00:00 | SPY | ETF | 102.95 | 103.03 | 102.82 | 102.94 | 154100.0 |
| 2003-09-05 09:30:00 | SPY | ETF | 102.94 | 103.12 | 102.86 | 103.069 | 2883900.0 |
| 2003-09-05 10:00:00 | SPY | ETF | 103.08 | 103.38 | 103.03 | 103.27 | 2385100.0 |
| 2003-09-05 10:30:00 | SPY | ETF | 103.29 | 103.38 | 103.1 | 103.33 | 1853800.0 |
| 2003-09-05 11:00:00 | SPY | ETF | 103.33 | 103.549 | 103.14 | 103.42 | 2197500.0 |
| 2003-09-05 11:30:00 | SPY | ETF | 103.42 | 103.53 | 103.32 | 103.45 | 1326900.0 |
| 2003-09-05 12:00:00 | SPY | ETF | 103.46 | 103.5 | 103.28 | 103.36 | 811700.0 |
| 2003-09-05 12:30:00 | SPY | ETF | 103.36 | 103.37 | 102.96 | 103.1 | 2498800.0 |
| 2003-09-05 13:00:00 | SPY | ETF | 103.1 | 103.13 | 102.52 | 102.7 | 3507800.0 |
| 2003-09-05 13:30:00 | SPY | ETF | 102.69 | 102.83 | 102.55 | 102.58 | 1681100.0 |
| 2003-09-05 14:00:00 | SPY | ETF | 102.56 | 102.65 | 102.4 | 102.5 | 2616700.0 |
| 2003-09-05 14:30:00 | SPY | ETF | 102.5 | 102.73 | 102.46 | 102.7 | 1427200.0 |
| 2003-09-05 15:00:00 | SPY | ETF | 102.68 | 102.76 | 102.51 | 102.73 | 1339000.0 |
| 2003-09-05 15:30:00 | SPY | ETF | 102.71 | 102.92 | 102.65 | 102.67 | 2576600.0 |
| 2003-09-05 16:00:00 | SPY | ETF | 102.733 | 102.99 | 102.66 | 102.86 | 1594200.0 |
| 2003-09-05 16:30:00 | SPY | ETF | 102.85 | 102.85 | 102.73 | 102.8 | 84600.0 |
| 2003-09-05 17:00:00 | SPY | ETF | 102.89 | 102.94 | 102.84 | 102.88 | 4800.0 |
| 2003-09-05 17:30:00 | SPY | ETF | 102.94 | 102.97 | 102.88 | 102.88 | 13900.0 |
| 2003-09-05 18:00:00 | SPY | ETF | 102.86 | 102.86 | 102.86 | 102.86 | 100.0 |
| 2003-09-05 19:00:00 | SPY | ETF | 102.87 | 102.91 | 102.86 | 102.86 | 1100.0 |
| 2003-09-05 19:30:00 | SPY | ETF | 102.84 | 102.89 | 102.82 | 102.89 | 900.0 |
| 2003-09-05 08:00:00 | QQQ | ETF | 34.16 | 34.2 | 34.12 | 34.13 | 89700.0 |
| 2003-09-05 08:30:00 | QQQ | ETF | 34.15 | 34.16 | 33.98 | 33.98 | 391400.0 |
| 2003-09-05 09:00:00 | QQQ | ETF | 33.97 | 34.0 | 33.93 | 33.97 | 230500.0 |
| 2003-09-05 09:30:00 | QQQ | ETF | 33.966 | 34.04 | 33.87 | 33.983 | 11387000.0 |
| 2003-09-05 10:00:00 | QQQ | ETF | 33.988 | 34.2 | 33.95 | 34.171 | 8375800.0 |
| 2003-09-05 10:30:00 | QQQ | ETF | 34.172 | 34.25 | 34.09 | 34.22 | 6374800.0 |
| 2003-09-05 11:00:00 | QQQ | ETF | 34.22 | 34.32 | 34.11 | 34.27 | 7267800.0 |
| 2003-09-05 11:30:00 | QQQ | ETF | 34.273 | 34.34 | 34.2 | 34.292 | 3817300.0 |
| 2003-09-05 12:00:00 | QQQ | ETF | 34.3 | 34.32 | 34.17 | 34.21 | 2854900.0 |
| 2003-09-05 12:30:00 | QQQ | ETF | 34.21 | 34.23 | 33.98 | 34.08 | 5701600.0 |
| 2003-09-05 13:00:00 | QQQ | ETF | 34.08 | 34.1 | 33.799 | 33.89 | 8386700.0 |
| 2003-09-05 13:30:00 | QQQ | ETF | 33.889 | 33.95 | 33.82 | 33.86 | 4864700.0 |
| 2003-09-05 14:00:00 | QQQ | ETF | 33.85 | 33.87 | 33.67 | 33.753 | 6337100.0 |
| 2003-09-05 14:30:00 | QQQ | ETF | 33.757 | 33.9 | 33.73 | 33.87 | 4327700.0 |
| 2003-09-05 15:00:00 | QQQ | ETF | 33.87 | 33.93 | 33.78 | 33.91 | 3959900.0 |
| 2003-09-05 15:30:00 | QQQ | ETF | 33.91 | 33.99 | 33.83 | 33.86 | 6090800.0 |
| 2003-09-05 16:00:00 | QQQ | ETF | 33.86 | 33.974 | 33.83 | 33.91 | 1435900.0 |
| 2003-09-05 16:30:00 | QQQ | ETF | 33.9 | 33.94 | 33.85 | 33.9 | 58200.0 |
| 2003-09-05 17:00:00 | QQQ | ETF | 33.9 | 33.95 | 33.9 | 33.91 | 32900.0 |
| 2003-09-05 17:30:00 | QQQ | ETF | 33.92 | 33.95 | 33.919 | 33.93 | 5300.0 |
| 2003-09-05 18:00:00 | QQQ | ETF | 33.93 | 33.95 | 33.93 | 33.93 | 13300.0 |
| 2003-09-05 18:30:00 | QQQ | ETF | 33.93 | 33.94 | 33.92 | 33.94 | 6700.0 |
| 2003-09-05 19:00:00 | QQQ | ETF | 33.95 | 33.95 | 33.95 | 33.95 | 1000.0 |
| 2003-09-05 19:30:00 | QQQ | ETF | 33.95 | 33.95 | 33.92 | 33.95 | 5300.0 |
| 2003-09-05 09:30:00 | IWM | ETF | 50.9 | 50.965 | 50.795 | 50.905 | 746000.0 |
| 2003-09-05 10:00:00 | IWM | ETF | 50.87 | 51.075 | 50.865 | 51.05 | 396600.0 |
| 2003-09-05 10:30:00 | IWM | ETF | 51.08 | 51.2 | 51.025 | 51.175 | 347800.0 |
> showing 50 of 727 rows — these rows as CSV