PREVIEW / etf_30min / 2004-05-12
file: by_date/etf_30min/2004/2004-05-12.parquet size: 38 KB rows: 1,219
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-12 08:00:00 | SPY | ETF | 109.75 | 109.77 | 109.62 | 109.62 | 18900.0 |
| 2004-05-12 08:30:00 | SPY | ETF | 109.6 | 109.68 | 109.52 | 109.66 | 51600.0 |
| 2004-05-12 09:00:00 | SPY | ETF | 109.69 | 109.72 | 109.59 | 109.59 | 40500.0 |
| 2004-05-12 09:30:00 | SPY | ETF | 109.57 | 109.66 | 109.36 | 109.52 | 3497200.0 |
| 2004-05-12 10:00:00 | SPY | ETF | 109.52 | 109.54 | 108.79 | 108.8 | 5928700.0 |
| 2004-05-12 10:30:00 | SPY | ETF | 108.79 | 108.99 | 108.66 | 108.92 | 7220700.0 |
| 2004-05-12 11:00:00 | SPY | ETF | 108.94 | 108.94 | 108.41 | 108.55 | 5105300.0 |
| 2004-05-12 11:30:00 | SPY | ETF | 108.53 | 108.81 | 108.42 | 108.45 | 3974700.0 |
| 2004-05-12 12:00:00 | SPY | ETF | 108.44 | 108.55 | 108.2 | 108.36 | 8918900.0 |
| 2004-05-12 12:30:00 | SPY | ETF | 108.34 | 108.62 | 108.3 | 108.46 | 4445500.0 |
| 2004-05-12 13:00:00 | SPY | ETF | 108.45 | 108.64 | 108.34 | 108.36 | 2834600.0 |
| 2004-05-12 13:30:00 | SPY | ETF | 108.35 | 108.5 | 108.06 | 108.28 | 4912600.0 |
| 2004-05-12 14:00:00 | SPY | ETF | 108.26 | 108.59 | 108.22 | 108.56 | 4394000.0 |
| 2004-05-12 14:30:00 | SPY | ETF | 108.54 | 109.04 | 108.37 | 108.84 | 6139100.0 |
| 2004-05-12 15:00:00 | SPY | ETF | 108.84 | 109.89 | 108.77 | 109.73 | 10596800.0 |
| 2004-05-12 15:30:00 | SPY | ETF | 109.73 | 110.3 | 109.52 | 110.3 | 8945800.0 |
| 2004-05-12 16:00:00 | SPY | ETF | 110.3 | 110.53 | 110.1 | 110.42 | 4040000.0 |
| 2004-05-12 16:30:00 | SPY | ETF | 110.42 | 110.5 | 108.12 | 110.48 | 227600.0 |
| 2004-05-12 17:00:00 | SPY | ETF | 110.45 | 110.5 | 110.42 | 110.45 | 34800.0 |
| 2004-05-12 17:30:00 | SPY | ETF | 110.47 | 110.5 | 108.77 | 110.5 | 56100.0 |
| 2004-05-12 18:00:00 | SPY | ETF | 110.45 | 110.48 | 110.43 | 110.48 | 11400.0 |
| 2004-05-12 18:30:00 | SPY | ETF | 110.48 | 110.48 | 110.45 | 110.48 | 700.0 |
| 2004-05-12 19:00:00 | SPY | ETF | 110.45 | 110.45 | 110.4 | 110.4 | 1100.0 |
| 2004-05-12 19:30:00 | SPY | ETF | 110.46 | 110.46 | 110.46 | 110.46 | 900.0 |
| 2004-05-12 08:00:00 | QQQ | ETF | 35.25 | 35.29 | 35.2 | 35.2 | 99000.0 |
| 2004-05-12 08:30:00 | QQQ | ETF | 35.19 | 35.24 | 35.13 | 35.16 | 192700.0 |
| 2004-05-12 09:00:00 | QQQ | ETF | 35.16 | 35.17 | 35.12 | 35.13 | 193500.0 |
| 2004-05-12 09:30:00 | QQQ | ETF | 35.12 | 35.17 | 35.02 | 35.058 | 13307100.0 |
| 2004-05-12 10:00:00 | QQQ | ETF | 35.06 | 35.08 | 34.647 | 34.652 | 16328800.0 |
| 2004-05-12 10:30:00 | QQQ | ETF | 34.67 | 34.76 | 34.49 | 34.63 | 18264200.0 |
| 2004-05-12 11:00:00 | QQQ | ETF | 34.62 | 34.63 | 34.42 | 34.454 | 15332000.0 |
| 2004-05-12 11:30:00 | QQQ | ETF | 34.453 | 34.59 | 34.423 | 34.43 | 9434100.0 |
| 2004-05-12 12:00:00 | QQQ | ETF | 34.42 | 34.5 | 34.321 | 34.41 | 13582600.0 |
| 2004-05-12 12:30:00 | QQQ | ETF | 34.412 | 34.572 | 34.41 | 34.46 | 9721400.0 |
| 2004-05-12 13:00:00 | QQQ | ETF | 34.46 | 34.56 | 34.408 | 34.449 | 5959000.0 |
| 2004-05-12 13:30:00 | QQQ | ETF | 34.435 | 34.52 | 34.27 | 34.34 | 9545000.0 |
| 2004-05-12 14:00:00 | QQQ | ETF | 34.34 | 34.524 | 34.31 | 34.48 | 10635500.0 |
| 2004-05-12 14:30:00 | QQQ | ETF | 34.5 | 34.72 | 34.446 | 34.596 | 15586800.0 |
| 2004-05-12 15:00:00 | QQQ | ETF | 34.6 | 35.044 | 34.588 | 34.952 | 20776600.0 |
| 2004-05-12 15:30:00 | QQQ | ETF | 34.93 | 35.25 | 34.91 | 35.217 | 24045200.0 |
| 2004-05-12 16:00:00 | QQQ | ETF | 35.217 | 35.29 | 35.2 | 35.23 | 4556300.0 |
| 2004-05-12 16:30:00 | QQQ | ETF | 35.24 | 35.3 | 35.24 | 35.26 | 1587100.0 |
| 2004-05-12 17:00:00 | QQQ | ETF | 35.3 | 35.302 | 35.25 | 35.3 | 137100.0 |
| 2004-05-12 17:30:00 | QQQ | ETF | 35.3 | 35.31 | 35.25 | 35.3 | 93400.0 |
| 2004-05-12 18:00:00 | QQQ | ETF | 35.3 | 35.311 | 35.29 | 35.311 | 33000.0 |
| 2004-05-12 18:30:00 | QQQ | ETF | 35.3 | 35.3 | 35.3 | 35.3 | 4300.0 |
| 2004-05-12 19:00:00 | QQQ | ETF | 35.3 | 35.3 | 35.29 | 35.3 | 8800.0 |
| 2004-05-12 19:30:00 | QQQ | ETF | 35.29 | 35.3 | 35.25 | 35.25 | 14200.0 |
| 2004-05-12 08:30:00 | IWM | ETF | 54.525 | 54.525 | 54.465 | 54.465 | 21600.0 |
| 2004-05-12 09:00:00 | IWM | ETF | 54.56 | 54.7 | 54.555 | 54.57 | 14000.0 |
> showing 50 of 1,219 rows — these rows as CSV