PREVIEW / etf_30min / 2004-03-03
file: by_date/etf_30min/2004/2004-03-03.parquet size: 35 KB rows: 1,168
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-03-03 08:00:00 | SPY | ETF | 115.27 | 115.27 | 115.21 | 115.21 | 7700.0 |
| 2004-03-03 08:30:00 | SPY | ETF | 115.19 | 115.21 | 115.15 | 115.2 | 45700.0 |
| 2004-03-03 09:00:00 | SPY | ETF | 115.21 | 115.25 | 115.18 | 115.25 | 13700.0 |
| 2004-03-03 09:30:00 | SPY | ETF | 115.2 | 115.37 | 115.14 | 115.28 | 1913200.0 |
| 2004-03-03 10:00:00 | SPY | ETF | 115.27 | 115.47 | 114.99 | 115.02 | 4582400.0 |
| 2004-03-03 10:30:00 | SPY | ETF | 115.02 | 115.11 | 114.92 | 115.09 | 2049000.0 |
| 2004-03-03 11:00:00 | SPY | ETF | 115.1 | 115.4 | 115.01 | 115.21 | 1262300.0 |
| 2004-03-03 11:30:00 | SPY | ETF | 115.21 | 115.3 | 115.06 | 115.29 | 815100.0 |
| 2004-03-03 12:00:00 | SPY | ETF | 115.29 | 115.32 | 115.07 | 115.2 | 936200.0 |
| 2004-03-03 12:30:00 | SPY | ETF | 115.19 | 115.25 | 115.09 | 115.22 | 596700.0 |
| 2004-03-03 13:00:00 | SPY | ETF | 115.22 | 115.47 | 115.16 | 115.42 | 1235600.0 |
| 2004-03-03 13:30:00 | SPY | ETF | 115.41 | 115.83 | 115.4 | 115.73 | 3315400.0 |
| 2004-03-03 14:00:00 | SPY | ETF | 115.7 | 115.83 | 115.61 | 115.72 | 1543400.0 |
| 2004-03-03 14:30:00 | SPY | ETF | 115.72 | 115.87 | 115.59 | 115.64 | 1490600.0 |
| 2004-03-03 15:00:00 | SPY | ETF | 115.63 | 115.82 | 115.63 | 115.75 | 867800.0 |
| 2004-03-03 15:30:00 | SPY | ETF | 115.75 | 115.76 | 115.52 | 115.7 | 2054000.0 |
| 2004-03-03 16:00:00 | SPY | ETF | 115.7 | 115.87 | 115.57 | 115.62 | 1267000.0 |
| 2004-03-03 16:30:00 | SPY | ETF | 115.62 | 115.68 | 115.58 | 115.63 | 166000.0 |
| 2004-03-03 17:00:00 | SPY | ETF | 115.59 | 115.6 | 115.56 | 115.56 | 13300.0 |
| 2004-03-03 17:30:00 | SPY | ETF | 115.65 | 115.67 | 115.65 | 115.67 | 200.0 |
| 2004-03-03 18:00:00 | SPY | ETF | 115.58 | 115.58 | 115.55 | 115.55 | 6400.0 |
| 2004-03-03 18:30:00 | SPY | ETF | 115.55 | 115.55 | 115.55 | 115.55 | 2600.0 |
| 2004-03-03 19:00:00 | SPY | ETF | 115.62 | 115.62 | 115.62 | 115.62 | 200.0 |
| 2004-03-03 08:00:00 | QQQ | ETF | 36.52 | 36.54 | 36.52 | 36.53 | 35200.0 |
| 2004-03-03 08:30:00 | QQQ | ETF | 36.54 | 36.54 | 36.49 | 36.5 | 66200.0 |
| 2004-03-03 09:00:00 | QQQ | ETF | 36.5 | 36.54 | 36.5 | 36.52 | 94600.0 |
| 2004-03-03 09:30:00 | QQQ | ETF | 36.51 | 36.57 | 36.35 | 36.45 | 6542700.0 |
| 2004-03-03 10:00:00 | QQQ | ETF | 36.45 | 36.55 | 36.25 | 36.28 | 7152700.0 |
| 2004-03-03 10:30:00 | QQQ | ETF | 36.28 | 36.36 | 36.21 | 36.33 | 8293800.0 |
| 2004-03-03 11:00:00 | QQQ | ETF | 36.332 | 36.45 | 36.28 | 36.367 | 3631400.0 |
| 2004-03-03 11:30:00 | QQQ | ETF | 36.37 | 36.4 | 36.3 | 36.4 | 2023200.0 |
| 2004-03-03 12:00:00 | QQQ | ETF | 36.39 | 36.432 | 36.329 | 36.371 | 2607400.0 |
| 2004-03-03 12:30:00 | QQQ | ETF | 36.372 | 36.39 | 36.31 | 36.35 | 2627000.0 |
| 2004-03-03 13:00:00 | QQQ | ETF | 36.35 | 36.48 | 36.34 | 36.45 | 5040700.0 |
| 2004-03-03 13:30:00 | QQQ | ETF | 36.451 | 36.63 | 36.44 | 36.55 | 7846200.0 |
| 2004-03-03 14:00:00 | QQQ | ETF | 36.55 | 36.62 | 36.459 | 36.53 | 6503900.0 |
| 2004-03-03 14:30:00 | QQQ | ETF | 36.53 | 36.6 | 36.43 | 36.46 | 3713300.0 |
| 2004-03-03 15:00:00 | QQQ | ETF | 36.46 | 36.57 | 36.45 | 36.56 | 2591400.0 |
| 2004-03-03 15:30:00 | QQQ | ETF | 36.543 | 36.56 | 36.43 | 36.48 | 5250800.0 |
| 2004-03-03 16:00:00 | QQQ | ETF | 36.5 | 36.5 | 36.36 | 36.4 | 1158100.0 |
| 2004-03-03 16:30:00 | QQQ | ETF | 36.42 | 36.47 | 36.38 | 36.381 | 51100.0 |
| 2004-03-03 17:00:00 | QQQ | ETF | 36.4 | 36.4 | 36.38 | 36.4 | 18500.0 |
| 2004-03-03 17:30:00 | QQQ | ETF | 36.39 | 36.42 | 36.38 | 36.411 | 32900.0 |
| 2004-03-03 18:00:00 | QQQ | ETF | 36.4 | 36.411 | 36.39 | 36.4 | 48600.0 |
| 2004-03-03 18:30:00 | QQQ | ETF | 36.39 | 36.39 | 36.38 | 36.39 | 14400.0 |
| 2004-03-03 19:00:00 | QQQ | ETF | 36.39 | 36.41 | 36.39 | 36.41 | 8800.0 |
| 2004-03-03 19:30:00 | QQQ | ETF | 36.41 | 36.42 | 36.41 | 36.42 | 1800.0 |
| 2004-03-03 09:00:00 | IWM | ETF | 58.69 | 58.695 | 58.665 | 58.685 | 39000.0 |
| 2004-03-03 09:30:00 | IWM | ETF | 58.695 | 58.755 | 58.325 | 58.43 | 1426000.0 |
| 2004-03-03 10:00:00 | IWM | ETF | 58.425 | 58.505 | 58.315 | 58.315 | 609200.0 |
> showing 50 of 1,168 rows — these rows as CSV