PREVIEW / etf_30min / 2004-05-13
file: by_date/etf_30min/2004/2004-05-13.parquet size: 35 KB rows: 1,152
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-05-13 08:00:00 | SPY | ETF | 110.12 | 110.18 | 110.0 | 110.03 | 44900.0 |
| 2004-05-13 08:30:00 | SPY | ETF | 110.0 | 110.07 | 109.81 | 109.91 | 167000.0 |
| 2004-05-13 09:00:00 | SPY | ETF | 109.93 | 109.93 | 109.78 | 109.78 | 114700.0 |
| 2004-05-13 09:30:00 | SPY | ETF | 109.76 | 110.27 | 109.73 | 109.99 | 5826700.0 |
| 2004-05-13 10:00:00 | SPY | ETF | 109.96 | 110.35 | 109.63 | 110.19 | 6456700.0 |
| 2004-05-13 10:30:00 | SPY | ETF | 110.2 | 110.39 | 109.89 | 110.33 | 4864300.0 |
| 2004-05-13 11:00:00 | SPY | ETF | 110.36 | 110.44 | 110.14 | 110.25 | 2869800.0 |
| 2004-05-13 11:30:00 | SPY | ETF | 110.25 | 110.81 | 110.19 | 110.68 | 6729800.0 |
| 2004-05-13 12:00:00 | SPY | ETF | 110.69 | 110.79 | 110.3 | 110.36 | 3192800.0 |
| 2004-05-13 12:30:00 | SPY | ETF | 110.36 | 110.51 | 110.1 | 110.19 | 2272500.0 |
| 2004-05-13 13:00:00 | SPY | ETF | 110.21 | 110.39 | 110.17 | 110.25 | 1433400.0 |
| 2004-05-13 13:30:00 | SPY | ETF | 110.22 | 110.25 | 109.88 | 110.02 | 2136300.0 |
| 2004-05-13 14:00:00 | SPY | ETF | 110.03 | 110.12 | 109.67 | 109.9 | 2726900.0 |
| 2004-05-13 14:30:00 | SPY | ETF | 109.92 | 110.15 | 109.81 | 109.9 | 1852000.0 |
| 2004-05-13 15:00:00 | SPY | ETF | 109.88 | 110.38 | 109.86 | 110.21 | 3872800.0 |
| 2004-05-13 15:30:00 | SPY | ETF | 110.21 | 110.39 | 109.94 | 110.15 | 3353300.0 |
| 2004-05-13 16:00:00 | SPY | ETF | 110.14 | 110.31 | 109.87 | 109.89 | 3131900.0 |
| 2004-05-13 16:30:00 | SPY | ETF | 109.91 | 110.02 | 109.89 | 110.0 | 52100.0 |
| 2004-05-13 17:00:00 | SPY | ETF | 110.0 | 110.05 | 110.0 | 110.04 | 52000.0 |
| 2004-05-13 17:30:00 | SPY | ETF | 110.05 | 110.06 | 110.0 | 110.0 | 109700.0 |
| 2004-05-13 18:00:00 | SPY | ETF | 110.02 | 110.06 | 110.02 | 110.04 | 900.0 |
| 2004-05-13 18:30:00 | SPY | ETF | 110.03 | 110.03 | 110.03 | 110.03 | 400.0 |
| 2004-05-13 19:00:00 | SPY | ETF | 110.03 | 110.03 | 110.03 | 110.03 | 200.0 |
| 2004-05-13 19:30:00 | SPY | ETF | 110.04 | 110.05 | 110.0 | 110.0 | 9000.0 |
| 2004-05-13 08:00:00 | QQQ | ETF | 35.18 | 35.19 | 35.11 | 35.13 | 157700.0 |
| 2004-05-13 08:30:00 | QQQ | ETF | 35.11 | 35.17 | 35.05 | 35.1 | 236400.0 |
| 2004-05-13 09:00:00 | QQQ | ETF | 35.09 | 35.09 | 35.05 | 35.05 | 189500.0 |
| 2004-05-13 09:30:00 | QQQ | ETF | 35.06 | 35.24 | 35.03 | 35.15 | 15020300.0 |
| 2004-05-13 10:00:00 | QQQ | ETF | 35.13 | 35.251 | 34.92 | 35.18 | 14799200.0 |
| 2004-05-13 10:30:00 | QQQ | ETF | 35.183 | 35.32 | 35.11 | 35.281 | 9672900.0 |
| 2004-05-13 11:00:00 | QQQ | ETF | 35.281 | 35.31 | 35.169 | 35.179 | 7435900.0 |
| 2004-05-13 11:30:00 | QQQ | ETF | 35.18 | 35.443 | 35.17 | 35.39 | 10429300.0 |
| 2004-05-13 12:00:00 | QQQ | ETF | 35.39 | 35.45 | 35.26 | 35.269 | 6216900.0 |
| 2004-05-13 12:30:00 | QQQ | ETF | 35.26 | 35.35 | 35.16 | 35.2 | 7058300.0 |
| 2004-05-13 13:00:00 | QQQ | ETF | 35.2 | 35.3 | 35.18 | 35.233 | 8930800.0 |
| 2004-05-13 13:30:00 | QQQ | ETF | 35.23 | 35.23 | 35.07 | 35.16 | 5449900.0 |
| 2004-05-13 14:00:00 | QQQ | ETF | 35.17 | 35.2 | 35.01 | 35.11 | 10583000.0 |
| 2004-05-13 14:30:00 | QQQ | ETF | 35.11 | 35.26 | 35.1 | 35.17 | 9357000.0 |
| 2004-05-13 15:00:00 | QQQ | ETF | 35.18 | 35.35 | 35.16 | 35.267 | 7473700.0 |
| 2004-05-13 15:30:00 | QQQ | ETF | 35.27 | 35.36 | 35.17 | 35.22 | 12577400.0 |
| 2004-05-13 16:00:00 | QQQ | ETF | 35.226 | 35.25 | 34.99 | 34.99 | 5248700.0 |
| 2004-05-13 16:30:00 | QQQ | ETF | 35.013 | 35.07 | 35.01 | 35.07 | 829100.0 |
| 2004-05-13 17:00:00 | QQQ | ETF | 35.07 | 35.09 | 35.05 | 35.09 | 319700.0 |
| 2004-05-13 17:30:00 | QQQ | ETF | 35.07 | 35.1 | 35.03 | 35.07 | 507700.0 |
| 2004-05-13 18:00:00 | QQQ | ETF | 35.09 | 35.09 | 35.05 | 35.08 | 49200.0 |
| 2004-05-13 18:30:00 | QQQ | ETF | 35.08 | 35.09 | 35.06 | 35.08 | 2000.0 |
| 2004-05-13 19:00:00 | QQQ | ETF | 35.07 | 35.09 | 35.06 | 35.06 | 4500.0 |
| 2004-05-13 19:30:00 | QQQ | ETF | 35.08 | 35.09 | 35.07 | 35.07 | 5100.0 |
| 2004-05-13 08:30:00 | IWM | ETF | 54.95 | 54.97 | 54.54 | 54.63 | 59200.0 |
| 2004-05-13 09:00:00 | IWM | ETF | 54.6 | 54.68 | 54.56 | 54.66 | 23600.0 |
> showing 50 of 1,152 rows — these rows as CSV