PREVIEW / etf_30min / 2004-04-08
file: by_date/etf_30min/2004/2004-04-08.parquet size: 35 KB rows: 1,181
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-04-08 08:00:00 | SPY | ETF | 115.29 | 115.3 | 115.19 | 115.21 | 27100.0 |
| 2004-04-08 08:30:00 | SPY | ETF | 115.27 | 115.4 | 115.27 | 115.31 | 66000.0 |
| 2004-04-08 09:00:00 | SPY | ETF | 115.31 | 115.43 | 115.31 | 115.37 | 65600.0 |
| 2004-04-08 09:30:00 | SPY | ETF | 115.41 | 115.41 | 114.99 | 115.01 | 4558300.0 |
| 2004-04-08 10:00:00 | SPY | ETF | 115.02 | 115.1 | 114.58 | 114.82 | 4649700.0 |
| 2004-04-08 10:30:00 | SPY | ETF | 114.83 | 114.94 | 114.72 | 114.75 | 1913200.0 |
| 2004-04-08 11:00:00 | SPY | ETF | 114.76 | 114.79 | 114.39 | 114.47 | 2710400.0 |
| 2004-04-08 11:30:00 | SPY | ETF | 114.48 | 114.72 | 114.43 | 114.69 | 1699000.0 |
| 2004-04-08 12:00:00 | SPY | ETF | 114.7 | 114.8 | 114.61 | 114.63 | 1617100.0 |
| 2004-04-08 12:30:00 | SPY | ETF | 114.65 | 114.75 | 114.51 | 114.54 | 1127200.0 |
| 2004-04-08 13:00:00 | SPY | ETF | 114.54 | 114.76 | 114.5 | 114.59 | 1141900.0 |
| 2004-04-08 13:30:00 | SPY | ETF | 114.58 | 114.63 | 114.46 | 114.51 | 780100.0 |
| 2004-04-08 14:00:00 | SPY | ETF | 114.49 | 114.54 | 114.01 | 114.17 | 4632800.0 |
| 2004-04-08 14:30:00 | SPY | ETF | 114.13 | 114.27 | 113.91 | 114.1 | 5948300.0 |
| 2004-04-08 15:00:00 | SPY | ETF | 114.1 | 114.18 | 113.74 | 113.96 | 5778000.0 |
| 2004-04-08 15:30:00 | SPY | ETF | 113.92 | 114.35 | 113.84 | 114.23 | 5337200.0 |
| 2004-04-08 16:00:00 | SPY | ETF | 114.25 | 114.4 | 114.14 | 114.33 | 1543200.0 |
| 2004-04-08 16:30:00 | SPY | ETF | 114.33 | 114.42 | 114.33 | 114.42 | 7800.0 |
| 2004-04-08 17:00:00 | SPY | ETF | 114.35 | 114.35 | 114.31 | 114.31 | 1400.0 |
| 2004-04-08 17:30:00 | SPY | ETF | 114.39 | 114.39 | 114.36 | 114.36 | 600.0 |
| 2004-04-08 19:00:00 | SPY | ETF | 114.36 | 114.36 | 114.31 | 114.31 | 900.0 |
| 2004-04-08 08:00:00 | QQQ | ETF | 37.32 | 37.36 | 37.29 | 37.3 | 82300.0 |
| 2004-04-08 08:30:00 | QQQ | ETF | 37.32 | 37.38 | 37.32 | 37.34 | 175100.0 |
| 2004-04-08 09:00:00 | QQQ | ETF | 37.35 | 37.42 | 37.34 | 37.35 | 581500.0 |
| 2004-04-08 09:30:00 | QQQ | ETF | 37.35 | 37.37 | 37.18 | 37.2 | 10741600.0 |
| 2004-04-08 10:00:00 | QQQ | ETF | 37.201 | 37.22 | 37.02 | 37.14 | 8581000.0 |
| 2004-04-08 10:30:00 | QQQ | ETF | 37.138 | 37.2 | 37.05 | 37.136 | 4301100.0 |
| 2004-04-08 11:00:00 | QQQ | ETF | 37.14 | 37.15 | 36.93 | 37.0 | 9676700.0 |
| 2004-04-08 11:30:00 | QQQ | ETF | 37.0 | 37.09 | 36.97 | 37.07 | 2856300.0 |
| 2004-04-08 12:00:00 | QQQ | ETF | 37.07 | 37.14 | 37.03 | 37.06 | 3003400.0 |
| 2004-04-08 12:30:00 | QQQ | ETF | 37.06 | 37.17 | 37.03 | 37.051 | 4728200.0 |
| 2004-04-08 13:00:00 | QQQ | ETF | 37.05 | 37.14 | 37.05 | 37.088 | 1994200.0 |
| 2004-04-08 13:30:00 | QQQ | ETF | 37.089 | 37.1 | 37.03 | 37.04 | 1564200.0 |
| 2004-04-08 14:00:00 | QQQ | ETF | 37.041 | 37.06 | 36.83 | 36.91 | 6536400.0 |
| 2004-04-08 14:30:00 | QQQ | ETF | 36.903 | 36.97 | 36.81 | 36.89 | 4928100.0 |
| 2004-04-08 15:00:00 | QQQ | ETF | 36.89 | 36.93 | 36.74 | 36.839 | 6815800.0 |
| 2004-04-08 15:30:00 | QQQ | ETF | 36.84 | 37.021 | 36.79 | 36.99 | 7409900.0 |
| 2004-04-08 16:00:00 | QQQ | ETF | 36.98 | 37.0 | 36.9 | 36.95 | 1635100.0 |
| 2004-04-08 16:30:00 | QQQ | ETF | 36.95 | 36.96 | 36.91 | 36.94 | 61900.0 |
| 2004-04-08 17:00:00 | QQQ | ETF | 36.95 | 36.97 | 36.9 | 36.9 | 52100.0 |
| 2004-04-08 17:30:00 | QQQ | ETF | 36.9 | 36.97 | 36.9 | 36.96 | 50900.0 |
| 2004-04-08 18:00:00 | QQQ | ETF | 36.95 | 36.99 | 36.93 | 36.93 | 34400.0 |
| 2004-04-08 18:30:00 | QQQ | ETF | 36.94 | 36.99 | 36.91 | 36.91 | 3200.0 |
| 2004-04-08 19:00:00 | QQQ | ETF | 36.91 | 36.91 | 36.85 | 36.85 | 5400.0 |
| 2004-04-08 19:30:00 | QQQ | ETF | 36.87 | 36.9 | 36.85 | 36.9 | 1400.0 |
| 2004-04-08 08:00:00 | IWM | ETF | 60.55 | 60.55 | 60.55 | 60.55 | 200.0 |
| 2004-04-08 08:30:00 | IWM | ETF | 60.615 | 60.615 | 60.595 | 60.595 | 10200.0 |
| 2004-04-08 09:00:00 | IWM | ETF | 60.55 | 60.55 | 60.5 | 60.5 | 8200.0 |
| 2004-04-08 09:30:00 | IWM | ETF | 60.545 | 60.575 | 60.105 | 60.14 | 1170400.0 |
| 2004-04-08 10:00:00 | IWM | ETF | 60.145 | 60.18 | 59.905 | 60.05 | 919400.0 |
> showing 50 of 1,181 rows — these rows as CSV