PREVIEW / etf_30min / 2004-06-03
file: by_date/etf_30min/2004/2004-06-03.parquet size: 35 KB rows: 1,169
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-03 08:00:00 | SPY | ETF | 112.64 | 112.64 | 112.57 | 112.57 | 24600.0 |
| 2004-06-03 08:30:00 | SPY | ETF | 112.56 | 112.74 | 112.56 | 112.73 | 30400.0 |
| 2004-06-03 09:00:00 | SPY | ETF | 112.76 | 112.81 | 112.74 | 112.78 | 60700.0 |
| 2004-06-03 09:30:00 | SPY | ETF | 112.81 | 112.88 | 112.67 | 112.8 | 3406700.0 |
| 2004-06-03 10:00:00 | SPY | ETF | 112.8 | 112.82 | 112.51 | 112.65 | 3951200.0 |
| 2004-06-03 10:30:00 | SPY | ETF | 112.65 | 112.93 | 112.61 | 112.7 | 1830900.0 |
| 2004-06-03 11:00:00 | SPY | ETF | 112.69 | 112.89 | 112.62 | 112.85 | 1221300.0 |
| 2004-06-03 11:30:00 | SPY | ETF | 112.83 | 113.11 | 112.8 | 112.99 | 4306400.0 |
| 2004-06-03 12:00:00 | SPY | ETF | 112.99 | 113.08 | 112.93 | 113.06 | 2951000.0 |
| 2004-06-03 12:30:00 | SPY | ETF | 113.06 | 113.19 | 112.95 | 112.95 | 1658400.0 |
| 2004-06-03 13:00:00 | SPY | ETF | 112.95 | 113.07 | 112.94 | 112.98 | 941000.0 |
| 2004-06-03 13:30:00 | SPY | ETF | 112.99 | 112.99 | 112.77 | 112.79 | 1905000.0 |
| 2004-06-03 14:00:00 | SPY | ETF | 112.78 | 112.82 | 112.48 | 112.51 | 1833100.0 |
| 2004-06-03 14:30:00 | SPY | ETF | 112.51 | 112.75 | 112.49 | 112.71 | 1670900.0 |
| 2004-06-03 15:00:00 | SPY | ETF | 112.7 | 112.8 | 112.54 | 112.54 | 1723800.0 |
| 2004-06-03 15:30:00 | SPY | ETF | 112.55 | 112.58 | 112.23 | 112.23 | 3428300.0 |
| 2004-06-03 16:00:00 | SPY | ETF | 112.25 | 113.1163 | 112.07 | 112.28 | 4563300.0 |
| 2004-06-03 16:30:00 | SPY | ETF | 112.28 | 112.521 | 112.18 | 112.18 | 1105100.0 |
| 2004-06-03 17:00:00 | SPY | ETF | 112.2 | 112.28 | 112.17 | 112.23 | 230200.0 |
| 2004-06-03 17:30:00 | SPY | ETF | 112.28 | 112.31 | 112.28 | 112.31 | 17600.0 |
| 2004-06-03 18:00:00 | SPY | ETF | 112.32 | 112.33 | 112.26 | 112.26 | 10600.0 |
| 2004-06-03 18:30:00 | SPY | ETF | 112.28 | 112.28 | 112.21 | 112.23 | 12000.0 |
| 2004-06-03 19:30:00 | SPY | ETF | 112.21 | 112.25 | 112.2 | 112.2 | 800.0 |
| 2004-06-03 08:00:00 | QQQ | ETF | 36.3 | 36.3 | 36.21 | 36.21 | 77900.0 |
| 2004-06-03 08:30:00 | QQQ | ETF | 36.21 | 36.3 | 36.2 | 36.29 | 289300.0 |
| 2004-06-03 09:00:00 | QQQ | ETF | 36.3 | 36.34 | 36.28 | 36.3 | 235100.0 |
| 2004-06-03 09:30:00 | QQQ | ETF | 36.3 | 36.34 | 36.18 | 36.23 | 10093700.0 |
| 2004-06-03 10:00:00 | QQQ | ETF | 36.24 | 36.25 | 36.063 | 36.169 | 12363200.0 |
| 2004-06-03 10:30:00 | QQQ | ETF | 36.17 | 36.29 | 36.08 | 36.13 | 9274600.0 |
| 2004-06-03 11:00:00 | QQQ | ETF | 36.13 | 36.22 | 36.09 | 36.19 | 2897400.0 |
| 2004-06-03 11:30:00 | QQQ | ETF | 36.2 | 36.31 | 36.19 | 36.25 | 5862700.0 |
| 2004-06-03 12:00:00 | QQQ | ETF | 36.24 | 36.3 | 36.2 | 36.26 | 2509600.0 |
| 2004-06-03 12:30:00 | QQQ | ETF | 36.264 | 36.36 | 36.25 | 36.27 | 3524000.0 |
| 2004-06-03 13:00:00 | QQQ | ETF | 36.267 | 36.35 | 36.26 | 36.29 | 6283500.0 |
| 2004-06-03 13:30:00 | QQQ | ETF | 36.29 | 36.3 | 36.2 | 36.22 | 3428400.0 |
| 2004-06-03 14:00:00 | QQQ | ETF | 36.22 | 36.22 | 36.06 | 36.088 | 5631400.0 |
| 2004-06-03 14:30:00 | QQQ | ETF | 36.088 | 36.17 | 36.038 | 36.129 | 7282500.0 |
| 2004-06-03 15:00:00 | QQQ | ETF | 36.128 | 36.2 | 36.06 | 36.07 | 4572100.0 |
| 2004-06-03 15:30:00 | QQQ | ETF | 36.08 | 36.1 | 35.94 | 35.97 | 14692400.0 |
| 2004-06-03 16:00:00 | QQQ | ETF | 35.971 | 36.11 | 35.844 | 36.07 | 5816900.0 |
| 2004-06-03 16:30:00 | QQQ | ETF | 36.07 | 36.07 | 35.972 | 35.975 | 1106500.0 |
| 2004-06-03 17:00:00 | QQQ | ETF | 35.988 | 36.01 | 35.988 | 36.0 | 34800.0 |
| 2004-06-03 17:30:00 | QQQ | ETF | 36.0 | 36.01 | 35.99 | 36.01 | 40500.0 |
| 2004-06-03 18:00:00 | QQQ | ETF | 35.99 | 36.03 | 35.95 | 35.95 | 365600.0 |
| 2004-06-03 18:30:00 | QQQ | ETF | 35.97 | 35.98 | 35.95 | 35.96 | 5800.0 |
| 2004-06-03 19:00:00 | QQQ | ETF | 35.96 | 35.98 | 35.94 | 35.98 | 2200.0 |
| 2004-06-03 19:30:00 | QQQ | ETF | 35.97 | 36.0 | 35.97 | 36.0 | 11200.0 |
| 2004-06-03 08:00:00 | IWM | ETF | 56.85 | 56.85 | 56.785 | 56.785 | 3000.0 |
| 2004-06-03 09:00:00 | IWM | ETF | 56.875 | 56.99 | 56.875 | 56.99 | 21200.0 |
| 2004-06-03 09:30:00 | IWM | ETF | 57.025 | 57.08 | 56.7 | 56.885 | 1662600.0 |
> showing 50 of 1,169 rows — these rows as CSV