PREVIEW / etf_30min / 2004-08-18
file: by_date/etf_30min/2004/2004-08-18.parquet size: 36 KB rows: 1,153
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-08-18 08:00:00 | SPY | ETF | 108.52 | 108.54 | 108.45 | 108.53 | 17200.0 |
| 2004-08-18 08:30:00 | SPY | ETF | 108.5 | 108.58 | 108.5 | 108.52 | 32400.0 |
| 2004-08-18 09:00:00 | SPY | ETF | 108.51 | 108.53 | 108.45 | 108.53 | 66000.0 |
| 2004-08-18 09:30:00 | SPY | ETF | 108.52 | 108.84 | 108.49 | 108.75 | 5641600.0 |
| 2004-08-18 10:00:00 | SPY | ETF | 108.75 | 109.22 | 108.74 | 109.13 | 3982900.0 |
| 2004-08-18 10:30:00 | SPY | ETF | 109.15 | 109.52 | 108.96 | 109.34 | 4958700.0 |
| 2004-08-18 11:00:00 | SPY | ETF | 109.3316 | 109.4 | 109.1 | 109.3 | 2694200.0 |
| 2004-08-18 11:30:00 | SPY | ETF | 109.3 | 109.37 | 109.19 | 109.32 | 1753300.0 |
| 2004-08-18 12:00:00 | SPY | ETF | 109.31 | 109.36 | 109.22 | 109.34 | 841700.0 |
| 2004-08-18 12:30:00 | SPY | ETF | 109.34 | 109.4 | 109.27 | 109.29 | 719100.0 |
| 2004-08-18 13:00:00 | SPY | ETF | 109.28 | 109.38 | 109.15 | 109.24 | 1647900.0 |
| 2004-08-18 13:30:00 | SPY | ETF | 109.23 | 109.47 | 109.2 | 109.38 | 1156200.0 |
| 2004-08-18 14:00:00 | SPY | ETF | 109.38 | 109.86 | 109.38 | 109.77 | 3802000.0 |
| 2004-08-18 14:30:00 | SPY | ETF | 109.77 | 109.87 | 109.64 | 109.83 | 2204200.0 |
| 2004-08-18 15:00:00 | SPY | ETF | 109.83 | 109.89 | 109.7 | 109.88 | 1724700.0 |
| 2004-08-18 15:30:00 | SPY | ETF | 109.88 | 110.13 | 109.78 | 110.09 | 5177200.0 |
| 2004-08-18 16:00:00 | SPY | ETF | 110.09 | 110.17 | 109.98 | 110.05 | 2428500.0 |
| 2004-08-18 16:30:00 | SPY | ETF | 110.05 | 110.05 | 109.95 | 110.03 | 67500.0 |
| 2004-08-18 17:00:00 | SPY | ETF | 110.02 | 110.02 | 109.98 | 110.01 | 11300.0 |
| 2004-08-18 17:30:00 | SPY | ETF | 110.0 | 110.02 | 109.95 | 109.99 | 19400.0 |
| 2004-08-18 18:00:00 | SPY | ETF | 109.98 | 110.0 | 109.98 | 109.98 | 15200.0 |
| 2004-08-18 18:30:00 | SPY | ETF | 110.01 | 110.02 | 110.01 | 110.02 | 26700.0 |
| 2004-08-18 19:00:00 | SPY | ETF | 110.01 | 110.01 | 110.01 | 110.01 | 500.0 |
| 2004-08-18 08:00:00 | QQQ | ETF | 33.12 | 33.15 | 33.1 | 33.12 | 45800.0 |
| 2004-08-18 08:30:00 | QQQ | ETF | 33.12 | 33.15 | 33.1 | 33.11 | 84000.0 |
| 2004-08-18 09:00:00 | QQQ | ETF | 33.12 | 33.12 | 33.06 | 33.07 | 575200.0 |
| 2004-08-18 09:30:00 | QQQ | ETF | 33.06 | 33.22 | 33.01 | 33.17 | 9896100.0 |
| 2004-08-18 10:00:00 | QQQ | ETF | 33.19 | 33.45 | 33.15 | 33.4 | 9637900.0 |
| 2004-08-18 10:30:00 | QQQ | ETF | 33.415 | 33.642 | 33.34 | 33.57 | 13704400.0 |
| 2004-08-18 11:00:00 | QQQ | ETF | 33.579 | 33.59 | 33.45 | 33.52 | 6638100.0 |
| 2004-08-18 11:30:00 | QQQ | ETF | 33.521 | 33.56 | 33.47 | 33.54 | 3822900.0 |
| 2004-08-18 12:00:00 | QQQ | ETF | 33.55 | 33.57 | 33.49 | 33.56 | 3585600.0 |
| 2004-08-18 12:30:00 | QQQ | ETF | 33.562 | 33.62 | 33.529 | 33.529 | 4892200.0 |
| 2004-08-18 13:00:00 | QQQ | ETF | 33.53 | 33.67 | 33.449 | 33.49 | 6908500.0 |
| 2004-08-18 13:30:00 | QQQ | ETF | 33.49 | 33.61 | 33.48 | 33.591 | 4463400.0 |
| 2004-08-18 14:00:00 | QQQ | ETF | 33.591 | 33.77 | 33.59 | 33.73 | 9479600.0 |
| 2004-08-18 14:30:00 | QQQ | ETF | 33.72 | 33.78 | 33.68 | 33.75 | 6437200.0 |
| 2004-08-18 15:00:00 | QQQ | ETF | 33.75 | 33.78 | 33.68 | 33.78 | 4542700.0 |
| 2004-08-18 15:30:00 | QQQ | ETF | 33.78 | 33.9 | 33.72 | 33.89 | 10704400.0 |
| 2004-08-18 16:00:00 | QQQ | ETF | 33.88 | 33.91 | 33.8 | 33.81 | 3888100.0 |
| 2004-08-18 16:30:00 | QQQ | ETF | 33.81 | 33.84 | 33.79 | 33.81 | 136800.0 |
| 2004-08-18 17:00:00 | QQQ | ETF | 33.83 | 33.849 | 33.79 | 33.82 | 290100.0 |
| 2004-08-18 17:30:00 | QQQ | ETF | 33.82 | 33.85 | 33.81 | 33.84 | 1269400.0 |
| 2004-08-18 18:00:00 | QQQ | ETF | 33.83 | 33.84 | 33.82 | 33.82 | 21400.0 |
| 2004-08-18 18:30:00 | QQQ | ETF | 33.83 | 33.85 | 33.83 | 33.84 | 72100.0 |
| 2004-08-18 19:00:00 | QQQ | ETF | 33.84 | 33.85 | 33.81 | 33.82 | 9700.0 |
| 2004-08-18 19:30:00 | QQQ | ETF | 33.84 | 33.84 | 33.81 | 33.81 | 1800.0 |
| 2004-08-18 08:30:00 | IWM | ETF | 52.595 | 52.64 | 52.595 | 52.64 | 1400.0 |
| 2004-08-18 09:00:00 | IWM | ETF | 52.595 | 52.6 | 52.585 | 52.6 | 22800.0 |
| 2004-08-18 09:30:00 | IWM | ETF | 52.575 | 52.835 | 52.5 | 52.835 | 1231400.0 |
> showing 50 of 1,153 rows — these rows as CSV