PREVIEW / etf_30min / 2004-05-19
file: by_date/etf_30min/2004/2004-05-19.parquet size: 37 KB rows: 1,182
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-19 08:00:00 | SPY | ETF | 110.41 | 110.44 | 110.31 | 110.41 | 91100.0 |
| 2004-05-19 08:30:00 | SPY | ETF | 110.38 | 110.5 | 110.38 | 110.42 | 148500.0 |
| 2004-05-19 09:00:00 | SPY | ETF | 110.43 | 110.5 | 110.38 | 110.5 | 47800.0 |
| 2004-05-19 09:30:00 | SPY | ETF | 110.5 | 110.67 | 110.33 | 110.6 | 5312700.0 |
| 2004-05-19 10:00:00 | SPY | ETF | 110.61 | 111.12 | 110.6 | 111.0 | 6547700.0 |
| 2004-05-19 10:30:00 | SPY | ETF | 110.99 | 111.18 | 110.96 | 110.97 | 3661000.0 |
| 2004-05-19 11:00:00 | SPY | ETF | 110.98 | 111.1 | 110.91 | 110.99 | 1579300.0 |
| 2004-05-19 11:30:00 | SPY | ETF | 110.99 | 111.01 | 110.82 | 110.96 | 3234100.0 |
| 2004-05-19 12:00:00 | SPY | ETF | 110.96 | 111.07 | 110.88 | 111.04 | 967300.0 |
| 2004-05-19 12:30:00 | SPY | ETF | 111.04 | 111.05 | 110.73 | 110.83 | 1425500.0 |
| 2004-05-19 13:00:00 | SPY | ETF | 110.81 | 111.0 | 110.68 | 110.72 | 1755500.0 |
| 2004-05-19 13:30:00 | SPY | ETF | 110.72 | 110.96 | 110.69 | 110.94 | 1697800.0 |
| 2004-05-19 14:00:00 | SPY | ETF | 110.93 | 110.98 | 110.24 | 110.32 | 4305800.0 |
| 2004-05-19 14:30:00 | SPY | ETF | 110.39 | 110.45 | 110.1 | 110.15 | 4302900.0 |
| 2004-05-19 15:00:00 | SPY | ETF | 110.15 | 110.2 | 109.79 | 109.82 | 5611000.0 |
| 2004-05-19 15:30:00 | SPY | ETF | 109.81 | 109.85 | 109.32 | 109.41 | 8014600.0 |
| 2004-05-19 16:00:00 | SPY | ETF | 109.45 | 109.46 | 109.15 | 109.21 | 2495000.0 |
| 2004-05-19 16:30:00 | SPY | ETF | 109.21 | 109.24 | 108.98 | 108.98 | 418800.0 |
| 2004-05-19 17:00:00 | SPY | ETF | 109.02 | 109.08 | 108.98 | 109.08 | 51100.0 |
| 2004-05-19 17:30:00 | SPY | ETF | 109.02 | 109.08 | 109.0 | 109.08 | 6000.0 |
| 2004-05-19 18:00:00 | SPY | ETF | 109.03 | 109.2 | 109.03 | 109.13 | 204300.0 |
| 2004-05-19 18:30:00 | SPY | ETF | 109.13 | 109.13 | 109.13 | 109.13 | 400.0 |
| 2004-05-19 19:00:00 | SPY | ETF | 109.16 | 109.16 | 109.15 | 109.15 | 1300.0 |
| 2004-05-19 19:30:00 | SPY | ETF | 109.15 | 109.16 | 109.1 | 109.12 | 5600.0 |
| 2004-05-19 08:00:00 | QQQ | ETF | 35.15 | 35.16 | 35.09 | 35.12 | 128900.0 |
| 2004-05-19 08:30:00 | QQQ | ETF | 35.12 | 35.13 | 35.1 | 35.1 | 119300.0 |
| 2004-05-19 09:00:00 | QQQ | ETF | 35.1 | 35.16 | 35.1 | 35.16 | 202900.0 |
| 2004-05-19 09:30:00 | QQQ | ETF | 35.16 | 35.22 | 35.08 | 35.179 | 14503900.0 |
| 2004-05-19 10:00:00 | QQQ | ETF | 35.18 | 35.41 | 35.16 | 35.38 | 19496000.0 |
| 2004-05-19 10:30:00 | QQQ | ETF | 35.38 | 35.5 | 35.36 | 35.428 | 13122600.0 |
| 2004-05-19 11:00:00 | QQQ | ETF | 35.43 | 35.477 | 35.39 | 35.402 | 5097200.0 |
| 2004-05-19 11:30:00 | QQQ | ETF | 35.402 | 35.42 | 35.31 | 35.41 | 9150100.0 |
| 2004-05-19 12:00:00 | QQQ | ETF | 35.4 | 35.45 | 35.36 | 35.44 | 3318800.0 |
| 2004-05-19 12:30:00 | QQQ | ETF | 35.44 | 35.46 | 35.329 | 35.38 | 3724600.0 |
| 2004-05-19 13:00:00 | QQQ | ETF | 35.37 | 35.4 | 35.329 | 35.333 | 3592500.0 |
| 2004-05-19 13:30:00 | QQQ | ETF | 35.336 | 35.43 | 35.319 | 35.42 | 3858900.0 |
| 2004-05-19 14:00:00 | QQQ | ETF | 35.421 | 35.44 | 35.22 | 35.238 | 8063900.0 |
| 2004-05-19 14:30:00 | QQQ | ETF | 35.23 | 35.28 | 35.102 | 35.15 | 11233000.0 |
| 2004-05-19 15:00:00 | QQQ | ETF | 35.15 | 35.15 | 34.93 | 34.95 | 15455800.0 |
| 2004-05-19 15:30:00 | QQQ | ETF | 34.95 | 34.961 | 34.71 | 34.75 | 20687800.0 |
| 2004-05-19 16:00:00 | QQQ | ETF | 34.75 | 34.79 | 34.635 | 34.67 | 4284200.0 |
| 2004-05-19 16:30:00 | QQQ | ETF | 34.67 | 34.69 | 34.61 | 34.64 | 516200.0 |
| 2004-05-19 17:00:00 | QQQ | ETF | 34.65 | 34.65 | 34.63 | 34.64 | 104000.0 |
| 2004-05-19 17:30:00 | QQQ | ETF | 34.621 | 34.67 | 34.621 | 34.65 | 47700.0 |
| 2004-05-19 18:00:00 | QQQ | ETF | 34.65 | 34.68 | 34.63 | 34.65 | 38300.0 |
| 2004-05-19 18:30:00 | QQQ | ETF | 34.67 | 34.69 | 34.64 | 34.66 | 10300.0 |
| 2004-05-19 19:00:00 | QQQ | ETF | 34.66 | 34.68 | 34.66 | 34.68 | 3100.0 |
| 2004-05-19 19:30:00 | QQQ | ETF | 34.68 | 34.68 | 34.64 | 34.68 | 11600.0 |
| 2004-05-19 08:30:00 | IWM | ETF | 54.68 | 54.68 | 54.675 | 54.675 | 30000.0 |
| 2004-05-19 09:00:00 | IWM | ETF | 54.65 | 54.67 | 54.6 | 54.6 | 9000.0 |
> showing 50 of 1,182 rows — these rows as CSV