PREVIEW / etf_30min / 2004-07-12
file: by_date/etf_30min/2004/2004-07-12.parquet size: 34 KB rows: 1,150
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-07-12 08:00:00 | SPY | ETF | 111.42 | 111.59 | 111.42 | 111.59 | 7700.0 |
| 2004-07-12 08:30:00 | SPY | ETF | 111.56 | 111.63 | 111.54 | 111.57 | 24500.0 |
| 2004-07-12 09:00:00 | SPY | ETF | 111.56 | 111.56 | 111.47 | 111.49 | 8500.0 |
| 2004-07-12 09:30:00 | SPY | ETF | 111.52 | 111.71 | 111.39 | 111.43 | 4000000.0 |
| 2004-07-12 10:00:00 | SPY | ETF | 111.42 | 111.45 | 111.0 | 111.21 | 7119700.0 |
| 2004-07-12 10:30:00 | SPY | ETF | 111.21 | 111.31 | 111.01 | 111.28 | 2086500.0 |
| 2004-07-12 11:00:00 | SPY | ETF | 111.27 | 111.36 | 111.15 | 111.26 | 1425100.0 |
| 2004-07-12 11:30:00 | SPY | ETF | 111.27 | 111.33 | 111.13 | 111.19 | 888600.0 |
| 2004-07-12 12:00:00 | SPY | ETF | 111.19 | 111.3 | 111.11 | 111.25 | 812700.0 |
| 2004-07-12 12:30:00 | SPY | ETF | 111.25 | 111.29 | 111.16 | 111.26 | 2149500.0 |
| 2004-07-12 13:00:00 | SPY | ETF | 111.24 | 111.26 | 111.12 | 111.18 | 733800.0 |
| 2004-07-12 13:30:00 | SPY | ETF | 111.18 | 111.2 | 111.09 | 111.18 | 947700.0 |
| 2004-07-12 14:00:00 | SPY | ETF | 111.18 | 111.83 | 111.15 | 111.68 | 3690600.0 |
| 2004-07-12 14:30:00 | SPY | ETF | 111.67 | 112.04 | 111.64 | 111.76 | 4622500.0 |
| 2004-07-12 15:00:00 | SPY | ETF | 111.76 | 111.88 | 111.68 | 111.8 | 1951100.0 |
| 2004-07-12 15:30:00 | SPY | ETF | 111.79 | 111.91 | 111.66 | 111.78 | 2848500.0 |
| 2004-07-12 16:00:00 | SPY | ETF | 111.8 | 111.84 | 111.64 | 111.7 | 935300.0 |
| 2004-07-12 16:30:00 | SPY | ETF | 111.75 | 111.82 | 111.75 | 111.82 | 136300.0 |
| 2004-07-12 17:00:00 | SPY | ETF | 111.76 | 111.78 | 111.76 | 111.76 | 40100.0 |
| 2004-07-12 17:30:00 | SPY | ETF | 111.79 | 111.79 | 111.79 | 111.79 | 100.0 |
| 2004-07-12 18:00:00 | SPY | ETF | 111.83 | 111.83 | 111.79 | 111.79 | 1600.0 |
| 2004-07-12 18:30:00 | SPY | ETF | 111.85 | 111.85 | 111.85 | 111.85 | 1400.0 |
| 2004-07-12 19:30:00 | SPY | ETF | 111.82 | 111.82 | 111.82 | 111.82 | 300.0 |
| 2004-07-12 08:00:00 | QQQ | ETF | 35.75 | 35.75 | 35.54 | 35.61 | 193800.0 |
| 2004-07-12 08:30:00 | QQQ | ETF | 35.6 | 35.61 | 35.55 | 35.57 | 122500.0 |
| 2004-07-12 09:00:00 | QQQ | ETF | 35.58 | 35.59 | 35.54 | 35.58 | 187100.0 |
| 2004-07-12 09:30:00 | QQQ | ETF | 35.57 | 35.64 | 35.42 | 35.459 | 10795100.0 |
| 2004-07-12 10:00:00 | QQQ | ETF | 35.46 | 35.46 | 35.27 | 35.385 | 10509800.0 |
| 2004-07-12 10:30:00 | QQQ | ETF | 35.39 | 35.39 | 35.26 | 35.379 | 6729700.0 |
| 2004-07-12 11:00:00 | QQQ | ETF | 35.38 | 35.41 | 35.32 | 35.397 | 4029400.0 |
| 2004-07-12 11:30:00 | QQQ | ETF | 35.39 | 35.43 | 35.317 | 35.341 | 3692800.0 |
| 2004-07-12 12:00:00 | QQQ | ETF | 35.34 | 35.37 | 35.3 | 35.346 | 2547400.0 |
| 2004-07-12 12:30:00 | QQQ | ETF | 35.34 | 35.38 | 35.32 | 35.368 | 2504800.0 |
| 2004-07-12 13:00:00 | QQQ | ETF | 35.36 | 35.39 | 35.29 | 35.33 | 1973600.0 |
| 2004-07-12 13:30:00 | QQQ | ETF | 35.29 | 35.32 | 35.24 | 35.314 | 3113700.0 |
| 2004-07-12 14:00:00 | QQQ | ETF | 35.314 | 35.57 | 35.31 | 35.48 | 8208200.0 |
| 2004-07-12 14:30:00 | QQQ | ETF | 35.519 | 35.69 | 35.47 | 35.49 | 9752300.0 |
| 2004-07-12 15:00:00 | QQQ | ETF | 35.499 | 35.62 | 35.47 | 35.56 | 5356500.0 |
| 2004-07-12 15:30:00 | QQQ | ETF | 35.561 | 35.65 | 35.51 | 35.599 | 7547700.0 |
| 2004-07-12 16:00:00 | QQQ | ETF | 35.57 | 35.63 | 35.55 | 35.63 | 3419300.0 |
| 2004-07-12 16:30:00 | QQQ | ETF | 35.61 | 35.621 | 35.57 | 35.58 | 114900.0 |
| 2004-07-12 17:00:00 | QQQ | ETF | 35.58 | 35.59 | 35.567 | 35.57 | 37100.0 |
| 2004-07-12 17:30:00 | QQQ | ETF | 35.57 | 35.6 | 35.57 | 35.6 | 26900.0 |
| 2004-07-12 18:00:00 | QQQ | ETF | 35.6 | 35.62 | 35.6 | 35.6 | 26200.0 |
| 2004-07-12 18:30:00 | QQQ | ETF | 35.59 | 35.62 | 35.59 | 35.62 | 8600.0 |
| 2004-07-12 19:00:00 | QQQ | ETF | 35.62 | 35.62 | 35.62 | 35.62 | 500.0 |
| 2004-07-12 19:30:00 | QQQ | ETF | 35.6 | 35.61 | 35.6 | 35.61 | 2300.0 |
| 2004-07-12 08:00:00 | IWM | ETF | 56.105 | 56.105 | 56.105 | 56.105 | 400.0 |
| 2004-07-12 08:30:00 | IWM | ETF | 56.16 | 56.16 | 56.16 | 56.16 | 400.0 |
| 2004-07-12 09:00:00 | IWM | ETF | 56.125 | 56.125 | 56.125 | 56.125 | 400.0 |
> showing 50 of 1,150 rows — these rows as CSV