PREVIEW / etf_30min / 2004-09-03
file: by_date/etf_30min/2004/2004-09-03.parquet size: 34 KB rows: 1,138
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-09-03 08:00:00 | SPY | ETF | 112.18 | 112.3 | 112.13 | 112.29 | 166300.0 |
| 2004-09-03 08:30:00 | SPY | ETF | 112.19 | 112.52 | 112.14 | 112.48 | 577200.0 |
| 2004-09-03 09:00:00 | SPY | ETF | 112.48 | 112.5 | 112.24 | 112.28 | 65200.0 |
| 2004-09-03 09:30:00 | SPY | ETF | 112.3 | 112.82 | 112.26 | 112.53 | 5762000.0 |
| 2004-09-03 10:00:00 | SPY | ETF | 112.54 | 112.55 | 112.23 | 112.28 | 3202300.0 |
| 2004-09-03 10:30:00 | SPY | ETF | 112.28 | 112.52 | 112.21 | 112.23 | 1994300.0 |
| 2004-09-03 11:00:00 | SPY | ETF | 112.22 | 112.28 | 112.04 | 112.18 | 2873000.0 |
| 2004-09-03 11:30:00 | SPY | ETF | 112.19 | 112.38 | 112.16 | 112.32 | 1073700.0 |
| 2004-09-03 12:00:00 | SPY | ETF | 112.32 | 112.44 | 112.23 | 112.38 | 873000.0 |
| 2004-09-03 12:30:00 | SPY | ETF | 112.38 | 112.38 | 112.19 | 112.23 | 826500.0 |
| 2004-09-03 13:00:00 | SPY | ETF | 112.23 | 112.33 | 112.18 | 112.29 | 810700.0 |
| 2004-09-03 13:30:00 | SPY | ETF | 112.28 | 112.35 | 112.25 | 112.28 | 1162200.0 |
| 2004-09-03 14:00:00 | SPY | ETF | 112.27 | 112.37 | 112.15 | 112.22 | 1266000.0 |
| 2004-09-03 14:30:00 | SPY | ETF | 112.22 | 112.23 | 112.02 | 112.06 | 1698500.0 |
| 2004-09-03 15:00:00 | SPY | ETF | 112.06 | 112.38 | 112.01 | 112.33 | 1617800.0 |
| 2004-09-03 15:30:00 | SPY | ETF | 112.32 | 112.35 | 112.07 | 112.09 | 2244700.0 |
| 2004-09-03 16:00:00 | SPY | ETF | 112.1 | 112.222 | 112.03 | 112.13 | 759700.0 |
| 2004-09-03 16:30:00 | SPY | ETF | 112.11 | 112.15 | 112.11 | 112.15 | 41400.0 |
| 2004-09-03 17:00:00 | SPY | ETF | 112.13 | 112.13 | 112.13 | 112.13 | 2300.0 |
| 2004-09-03 17:30:00 | SPY | ETF | 112.13 | 112.15 | 112.13 | 112.13 | 3600.0 |
| 2004-09-03 18:00:00 | SPY | ETF | 112.13 | 112.13 | 112.1 | 112.1 | 400.0 |
| 2004-09-03 19:30:00 | SPY | ETF | 112.18 | 112.18 | 112.18 | 112.18 | 100.0 |
| 2004-09-03 08:00:00 | QQQ | ETF | 34.46 | 34.49 | 34.42 | 34.47 | 118900.0 |
| 2004-09-03 08:30:00 | QQQ | ETF | 34.49 | 34.59 | 34.41 | 34.54 | 848800.0 |
| 2004-09-03 09:00:00 | QQQ | ETF | 34.53 | 34.54 | 34.42 | 34.45 | 655100.0 |
| 2004-09-03 09:30:00 | QQQ | ETF | 34.44 | 34.67 | 34.36 | 34.569 | 16532600.0 |
| 2004-09-03 10:00:00 | QQQ | ETF | 34.57 | 34.58 | 34.32 | 34.34 | 12427200.0 |
| 2004-09-03 10:30:00 | QQQ | ETF | 34.34 | 34.43 | 34.183 | 34.19 | 8511800.0 |
| 2004-09-03 11:00:00 | QQQ | ETF | 34.19 | 34.21 | 34.05 | 34.142 | 11983100.0 |
| 2004-09-03 11:30:00 | QQQ | ETF | 34.15 | 34.24 | 34.11 | 34.2 | 4911600.0 |
| 2004-09-03 12:00:00 | QQQ | ETF | 34.2 | 34.28 | 34.16 | 34.22 | 3230100.0 |
| 2004-09-03 12:30:00 | QQQ | ETF | 34.229 | 34.26 | 34.13 | 34.14 | 3016500.0 |
| 2004-09-03 13:00:00 | QQQ | ETF | 34.13 | 34.193 | 34.12 | 34.19 | 1725700.0 |
| 2004-09-03 13:30:00 | QQQ | ETF | 34.19 | 34.23 | 34.16 | 34.18 | 2111400.0 |
| 2004-09-03 14:00:00 | QQQ | ETF | 34.18 | 34.23 | 34.15 | 34.184 | 2137700.0 |
| 2004-09-03 14:30:00 | QQQ | ETF | 34.16 | 34.19 | 34.089 | 34.11 | 3124000.0 |
| 2004-09-03 15:00:00 | QQQ | ETF | 34.111 | 34.24 | 34.09 | 34.207 | 3966900.0 |
| 2004-09-03 15:30:00 | QQQ | ETF | 34.207 | 34.23 | 34.129 | 34.133 | 6270600.0 |
| 2004-09-03 16:00:00 | QQQ | ETF | 34.152 | 34.45 | 34.1001 | 34.14 | 2410400.0 |
| 2004-09-03 16:30:00 | QQQ | ETF | 34.14 | 34.16 | 34.14 | 34.16 | 25500.0 |
| 2004-09-03 17:00:00 | QQQ | ETF | 34.14 | 34.16 | 34.13 | 34.16 | 52800.0 |
| 2004-09-03 17:30:00 | QQQ | ETF | 34.15 | 34.16 | 34.14 | 34.14 | 11100.0 |
| 2004-09-03 18:00:00 | QQQ | ETF | 34.14 | 34.16 | 34.14 | 34.15 | 15400.0 |
| 2004-09-03 18:30:00 | QQQ | ETF | 34.16 | 34.16 | 34.16 | 34.16 | 13000.0 |
| 2004-09-03 19:00:00 | QQQ | ETF | 34.16 | 34.16 | 34.16 | 34.16 | 300.0 |
| 2004-09-03 19:30:00 | QQQ | ETF | 34.16 | 34.17 | 34.16 | 34.17 | 3800.0 |
| 2004-09-03 08:00:00 | IWM | ETF | 55.855 | 55.89 | 55.755 | 55.79 | 13600.0 |
| 2004-09-03 08:30:00 | IWM | ETF | 55.795 | 56.075 | 55.795 | 56.005 | 58800.0 |
| 2004-09-03 09:00:00 | IWM | ETF | 55.975 | 56.005 | 55.78 | 55.78 | 5800.0 |
| 2004-09-03 09:30:00 | IWM | ETF | 55.825 | 56.105 | 55.775 | 55.965 | 2342000.0 |
> showing 50 of 1,138 rows — these rows as CSV