PREVIEW / etf_30min / 2004-08-04
file: by_date/etf_30min/2004/2004-08-04.parquet size: 35 KB rows: 1,126
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-08-04 08:00:00 | SPY | ETF | 109.82 | 109.84 | 109.75 | 109.75 | 31200.0 |
| 2004-08-04 08:30:00 | SPY | ETF | 109.75 | 109.8 | 109.71 | 109.79 | 44600.0 |
| 2004-08-04 09:00:00 | SPY | ETF | 109.8 | 109.91 | 109.8 | 109.9 | 78600.0 |
| 2004-08-04 09:30:00 | SPY | ETF | 109.89 | 110.11 | 109.78 | 110.01 | 4614000.0 |
| 2004-08-04 10:00:00 | SPY | ETF | 110.01 | 110.13 | 109.7 | 109.87 | 5278500.0 |
| 2004-08-04 10:30:00 | SPY | ETF | 109.86 | 110.25 | 109.83 | 109.86 | 4814900.0 |
| 2004-08-04 11:00:00 | SPY | ETF | 109.82 | 109.95 | 109.64 | 109.93 | 3059900.0 |
| 2004-08-04 11:30:00 | SPY | ETF | 109.92 | 110.04 | 109.74 | 109.94 | 1997400.0 |
| 2004-08-04 12:00:00 | SPY | ETF | 109.95 | 110.03 | 109.85 | 109.93 | 820600.0 |
| 2004-08-04 12:30:00 | SPY | ETF | 109.94 | 109.98 | 109.82 | 109.87 | 824500.0 |
| 2004-08-04 13:00:00 | SPY | ETF | 109.87 | 109.96 | 109.75 | 109.85 | 1311700.0 |
| 2004-08-04 13:30:00 | SPY | ETF | 109.85 | 110.34 | 109.83 | 110.26 | 3275700.0 |
| 2004-08-04 14:00:00 | SPY | ETF | 110.25 | 110.56 | 110.24 | 110.53 | 3846200.0 |
| 2004-08-04 14:30:00 | SPY | ETF | 110.53 | 110.75 | 110.47 | 110.61 | 2513100.0 |
| 2004-08-04 15:00:00 | SPY | ETF | 110.61 | 110.71 | 110.38 | 110.39 | 2612800.0 |
| 2004-08-04 15:30:00 | SPY | ETF | 110.39 | 110.47 | 110.25 | 110.28 | 3062800.0 |
| 2004-08-04 16:00:00 | SPY | ETF | 110.28 | 110.3 | 110.13 | 110.17 | 1059300.0 |
| 2004-08-04 16:30:00 | SPY | ETF | 110.19 | 110.21 | 110.0 | 110.05 | 230700.0 |
| 2004-08-04 17:00:00 | SPY | ETF | 110.05 | 110.14 | 110.05 | 110.09 | 45500.0 |
| 2004-08-04 17:30:00 | SPY | ETF | 110.12 | 110.12 | 110.08 | 110.11 | 5000.0 |
| 2004-08-04 18:00:00 | SPY | ETF | 110.15 | 110.16 | 110.1 | 110.15 | 4500.0 |
| 2004-08-04 18:30:00 | SPY | ETF | 110.17 | 110.19 | 110.16 | 110.19 | 3500.0 |
| 2004-08-04 19:00:00 | SPY | ETF | 110.18 | 110.2 | 110.16 | 110.17 | 50100.0 |
| 2004-08-04 19:30:00 | SPY | ETF | 110.14 | 110.14 | 110.14 | 110.14 | 1900.0 |
| 2004-08-04 08:00:00 | QQQ | ETF | 34.1 | 34.1 | 34.07 | 34.08 | 57200.0 |
| 2004-08-04 08:30:00 | QQQ | ETF | 34.07 | 34.08 | 34.05 | 34.07 | 61100.0 |
| 2004-08-04 09:00:00 | QQQ | ETF | 34.08 | 34.16 | 34.07 | 34.15 | 116000.0 |
| 2004-08-04 09:30:00 | QQQ | ETF | 34.15 | 34.31 | 34.14 | 34.29 | 9648400.0 |
| 2004-08-04 10:00:00 | QQQ | ETF | 34.283 | 34.34 | 34.16 | 34.187 | 9370900.0 |
| 2004-08-04 10:30:00 | QQQ | ETF | 34.19 | 34.35 | 34.086 | 34.09 | 10450900.0 |
| 2004-08-04 11:00:00 | QQQ | ETF | 34.09 | 34.16 | 34.01 | 34.14 | 8588500.0 |
| 2004-08-04 11:30:00 | QQQ | ETF | 34.139 | 34.23 | 34.055 | 34.2 | 4503800.0 |
| 2004-08-04 12:00:00 | QQQ | ETF | 34.21 | 34.23 | 34.16 | 34.2 | 3835100.0 |
| 2004-08-04 12:30:00 | QQQ | ETF | 34.194 | 34.22 | 34.09 | 34.12 | 2239800.0 |
| 2004-08-04 13:00:00 | QQQ | ETF | 34.12 | 34.16 | 34.055 | 34.099 | 2826900.0 |
| 2004-08-04 13:30:00 | QQQ | ETF | 34.09 | 34.33 | 34.06 | 34.3 | 7319900.0 |
| 2004-08-04 14:00:00 | QQQ | ETF | 34.3 | 34.4 | 34.29 | 34.382 | 7127500.0 |
| 2004-08-04 14:30:00 | QQQ | ETF | 34.382 | 34.461 | 34.35 | 34.405 | 6707400.0 |
| 2004-08-04 15:00:00 | QQQ | ETF | 34.409 | 34.45 | 34.3 | 34.316 | 4897200.0 |
| 2004-08-04 15:30:00 | QQQ | ETF | 34.31 | 34.35 | 34.24 | 34.27 | 5708700.0 |
| 2004-08-04 16:00:00 | QQQ | ETF | 34.26 | 34.29 | 34.23 | 34.24 | 1273900.0 |
| 2004-08-04 16:30:00 | QQQ | ETF | 34.24 | 34.3 | 34.174 | 34.21 | 168900.0 |
| 2004-08-04 17:00:00 | QQQ | ETF | 34.227 | 34.25 | 34.2 | 34.22 | 198300.0 |
| 2004-08-04 17:30:00 | QQQ | ETF | 34.23 | 34.28 | 34.22 | 34.26 | 112100.0 |
| 2004-08-04 18:00:00 | QQQ | ETF | 34.26 | 34.29 | 34.26 | 34.29 | 27700.0 |
| 2004-08-04 18:30:00 | QQQ | ETF | 34.3 | 34.3 | 34.28 | 34.29 | 12100.0 |
| 2004-08-04 19:00:00 | QQQ | ETF | 34.28 | 34.28 | 34.27 | 34.27 | 9800.0 |
| 2004-08-04 19:30:00 | QQQ | ETF | 34.27 | 34.28 | 34.27 | 34.28 | 2500.0 |
| 2004-08-04 08:30:00 | IWM | ETF | 53.695 | 53.695 | 53.695 | 53.695 | 2000.0 |
| 2004-08-04 09:00:00 | IWM | ETF | 53.665 | 53.75 | 53.665 | 53.7 | 40600.0 |
> showing 50 of 1,126 rows — these rows as CSV