PREVIEW / etf_30min / 2003-07-07
file: by_date/etf_30min/2003/2003-07-07.parquet size: 24 KB rows: 729
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-07-07 08:00:00 | SPY | ETF | 99.65 | 99.66 | 99.35 | 99.43 | 59600.0 |
| 2003-07-07 08:30:00 | SPY | ETF | 99.5 | 99.62 | 99.45 | 99.62 | 51600.0 |
| 2003-07-07 09:00:00 | SPY | ETF | 99.62 | 99.7 | 99.53 | 99.67 | 115900.0 |
| 2003-07-07 09:30:00 | SPY | ETF | 99.653 | 100.45 | 99.65 | 100.33 | 5064400.0 |
| 2003-07-07 10:00:00 | SPY | ETF | 100.38 | 100.84 | 100.24 | 100.73 | 3571700.0 |
| 2003-07-07 10:30:00 | SPY | ETF | 100.73 | 100.78 | 100.41 | 100.62 | 2747900.0 |
| 2003-07-07 11:00:00 | SPY | ETF | 100.68 | 100.89 | 100.52 | 100.75 | 2294300.0 |
| 2003-07-07 11:30:00 | SPY | ETF | 100.742 | 100.88 | 100.48 | 100.58 | 1056200.0 |
| 2003-07-07 12:00:00 | SPY | ETF | 100.58 | 100.77 | 100.58 | 100.71 | 465500.0 |
| 2003-07-07 12:30:00 | SPY | ETF | 100.7 | 100.78 | 100.5 | 100.55 | 815000.0 |
| 2003-07-07 13:00:00 | SPY | ETF | 100.54 | 100.64 | 100.41 | 100.56 | 1057100.0 |
| 2003-07-07 13:30:00 | SPY | ETF | 100.6 | 100.65 | 100.5 | 100.59 | 909500.0 |
| 2003-07-07 14:00:00 | SPY | ETF | 100.59 | 100.79 | 100.58 | 100.67 | 1595600.0 |
| 2003-07-07 14:30:00 | SPY | ETF | 100.64 | 100.9 | 100.63 | 100.8 | 2026000.0 |
| 2003-07-07 15:00:00 | SPY | ETF | 100.8 | 100.84 | 100.42 | 100.559 | 1488700.0 |
| 2003-07-07 15:30:00 | SPY | ETF | 100.56 | 100.79 | 100.51 | 100.74 | 1781200.0 |
| 2003-07-07 16:00:00 | SPY | ETF | 100.74 | 101.0 | 100.67 | 100.89 | 1601200.0 |
| 2003-07-07 16:30:00 | SPY | ETF | 100.87 | 100.87 | 100.66 | 100.7 | 150200.0 |
| 2003-07-07 17:00:00 | SPY | ETF | 100.68 | 100.75 | 100.62 | 100.74 | 49800.0 |
| 2003-07-07 17:30:00 | SPY | ETF | 100.739 | 100.74 | 100.68 | 100.68 | 13200.0 |
| 2003-07-07 18:00:00 | SPY | ETF | 100.72 | 100.72 | 100.65 | 100.67 | 10000.0 |
| 2003-07-07 18:30:00 | SPY | ETF | 100.67 | 100.67 | 100.63 | 100.67 | 2400.0 |
| 2003-07-07 19:00:00 | SPY | ETF | 100.69 | 100.69 | 100.67 | 100.67 | 2100.0 |
| 2003-07-07 19:30:00 | SPY | ETF | 100.67 | 100.67 | 100.67 | 100.67 | 1400.0 |
| 2003-07-07 08:00:00 | QQQ | ETF | 30.98 | 30.98 | 30.89 | 30.91 | 77100.0 |
| 2003-07-07 08:30:00 | QQQ | ETF | 30.94 | 30.99 | 30.91 | 30.97 | 64900.0 |
| 2003-07-07 09:00:00 | QQQ | ETF | 30.98 | 31.0 | 30.95 | 31.0 | 208400.0 |
| 2003-07-07 09:30:00 | QQQ | ETF | 30.97 | 31.39 | 30.962 | 31.344 | 16952500.0 |
| 2003-07-07 10:00:00 | QQQ | ETF | 31.36 | 31.57 | 31.27 | 31.51 | 11253200.0 |
| 2003-07-07 10:30:00 | QQQ | ETF | 31.517 | 31.57 | 31.42 | 31.55 | 5801600.0 |
| 2003-07-07 11:00:00 | QQQ | ETF | 31.56 | 31.68 | 31.5 | 31.64 | 5126800.0 |
| 2003-07-07 11:30:00 | QQQ | ETF | 31.64 | 31.69 | 31.54 | 31.61 | 5638700.0 |
| 2003-07-07 12:00:00 | QQQ | ETF | 31.61 | 31.71 | 31.6 | 31.7 | 2535400.0 |
| 2003-07-07 12:30:00 | QQQ | ETF | 31.7 | 31.74 | 31.61 | 31.654 | 3173800.0 |
| 2003-07-07 13:00:00 | QQQ | ETF | 31.66 | 31.66 | 31.58 | 31.64 | 3389700.0 |
| 2003-07-07 13:30:00 | QQQ | ETF | 31.64 | 31.71 | 31.61 | 31.67 | 1948100.0 |
| 2003-07-07 14:00:00 | QQQ | ETF | 31.67 | 31.78 | 31.66 | 31.73 | 3394200.0 |
| 2003-07-07 14:30:00 | QQQ | ETF | 31.73 | 31.88 | 31.718 | 31.85 | 7276800.0 |
| 2003-07-07 15:00:00 | QQQ | ETF | 31.84 | 31.87 | 31.666 | 31.76 | 4535400.0 |
| 2003-07-07 15:30:00 | QQQ | ETF | 31.76 | 31.86 | 31.71 | 31.839 | 6854900.0 |
| 2003-07-07 16:00:00 | QQQ | ETF | 31.84 | 32.0 | 31.82 | 31.93 | 2686800.0 |
| 2003-07-07 16:30:00 | QQQ | ETF | 31.94 | 31.98 | 31.89 | 31.9 | 266900.0 |
| 2003-07-07 17:00:00 | QQQ | ETF | 31.91 | 31.93 | 31.88 | 31.921 | 105600.0 |
| 2003-07-07 17:30:00 | QQQ | ETF | 31.93 | 31.93 | 31.9 | 31.92 | 50300.0 |
| 2003-07-07 18:00:00 | QQQ | ETF | 31.92 | 31.93 | 31.9 | 31.92 | 35500.0 |
| 2003-07-07 18:30:00 | QQQ | ETF | 31.905 | 31.92 | 31.9 | 31.91 | 27800.0 |
| 2003-07-07 19:00:00 | QQQ | ETF | 31.92 | 31.93 | 31.91 | 31.93 | 11000.0 |
| 2003-07-07 19:30:00 | QQQ | ETF | 31.93 | 31.94 | 31.9 | 31.93 | 23200.0 |
| 2003-07-07 08:30:00 | IWM | ETF | 45.745 | 45.745 | 45.745 | 45.745 | 600.0 |
| 2003-07-07 09:00:00 | IWM | ETF | 45.935 | 45.955 | 45.935 | 45.955 | 3000.0 |
> showing 50 of 729 rows — these rows as CSV