PREVIEW / etf_30min / 2004-10-21
file: by_date/etf_30min/2004/2004-10-21.parquet size: 38 KB rows: 1,255
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-10-21 08:00:00 | SPY | ETF | 110.53 | 110.54 | 110.46 | 110.52 | 4100.0 |
| 2004-10-21 08:30:00 | SPY | ETF | 110.52 | 110.86 | 110.52 | 110.84 | 435600.0 |
| 2004-10-21 09:00:00 | SPY | ETF | 110.86 | 110.87 | 110.77 | 110.77 | 49100.0 |
| 2004-10-21 09:30:00 | SPY | ETF | 110.79 | 110.99 | 110.58 | 110.87 | 5236900.0 |
| 2004-10-21 10:00:00 | SPY | ETF | 110.88 | 110.96 | 110.54 | 110.73 | 3105800.0 |
| 2004-10-21 10:30:00 | SPY | ETF | 110.72 | 111.22 | 110.57 | 111.18 | 3874000.0 |
| 2004-10-21 11:00:00 | SPY | ETF | 111.17 | 111.29 | 111.04 | 111.11 | 3648200.0 |
| 2004-10-21 11:30:00 | SPY | ETF | 111.12 | 111.15 | 110.95 | 111.01 | 1678000.0 |
| 2004-10-21 12:00:00 | SPY | ETF | 110.99 | 111.16 | 110.68 | 110.71 | 4632600.0 |
| 2004-10-21 12:30:00 | SPY | ETF | 110.7 | 110.72 | 110.32 | 110.49 | 4198000.0 |
| 2004-10-21 13:00:00 | SPY | ETF | 110.49 | 110.6 | 110.21 | 110.37 | 2099000.0 |
| 2004-10-21 13:30:00 | SPY | ETF | 110.36 | 110.56 | 110.29 | 110.35 | 1273900.0 |
| 2004-10-21 14:00:00 | SPY | ETF | 110.36 | 110.99 | 110.36 | 110.96 | 3345300.0 |
| 2004-10-21 14:30:00 | SPY | ETF | 110.98 | 111.17 | 110.87 | 111.12 | 3972900.0 |
| 2004-10-21 15:00:00 | SPY | ETF | 111.12 | 111.32 | 111.05 | 111.13 | 4503200.0 |
| 2004-10-21 15:30:00 | SPY | ETF | 111.14 | 111.18 | 110.94 | 111.04 | 4616500.0 |
| 2004-10-21 16:00:00 | SPY | ETF | 111.06 | 111.24 | 110.75 | 111.02 | 3177000.0 |
| 2004-10-21 16:30:00 | SPY | ETF | 111.02 | 111.07 | 110.85 | 110.99 | 1194900.0 |
| 2004-10-21 17:00:00 | SPY | ETF | 110.92 | 111.0 | 110.91 | 110.96 | 18400.0 |
| 2004-10-21 17:30:00 | SPY | ETF | 110.97 | 110.99 | 110.87 | 110.99 | 21300.0 |
| 2004-10-21 18:00:00 | SPY | ETF | 110.98 | 111.0 | 110.96 | 110.98 | 12200.0 |
| 2004-10-21 18:30:00 | SPY | ETF | 110.99 | 110.99 | 110.98 | 110.98 | 1600.0 |
| 2004-10-21 19:00:00 | SPY | ETF | 111.04 | 111.08 | 111.04 | 111.08 | 11900.0 |
| 2004-10-21 19:30:00 | SPY | ETF | 111.08 | 111.08 | 111.08 | 111.08 | 2000.0 |
| 2004-10-21 08:00:00 | QQQ | ETF | 36.11 | 36.18 | 36.11 | 36.16 | 118000.0 |
| 2004-10-21 08:30:00 | QQQ | ETF | 36.18 | 36.33 | 36.18 | 36.31 | 192900.0 |
| 2004-10-21 09:00:00 | QQQ | ETF | 36.32 | 36.34 | 36.24 | 36.24 | 393000.0 |
| 2004-10-21 09:30:00 | QQQ | ETF | 36.24 | 36.33 | 36.15 | 36.25 | 12592500.0 |
| 2004-10-21 10:00:00 | QQQ | ETF | 36.25 | 36.31 | 36.11 | 36.251 | 8510900.0 |
| 2004-10-21 10:30:00 | QQQ | ETF | 36.25 | 36.411 | 36.21 | 36.4 | 10966900.0 |
| 2004-10-21 11:00:00 | QQQ | ETF | 36.4 | 36.46 | 36.34 | 36.37 | 6897700.0 |
| 2004-10-21 11:30:00 | QQQ | ETF | 36.36 | 36.37 | 36.28 | 36.31 | 3984700.0 |
| 2004-10-21 12:00:00 | QQQ | ETF | 36.3 | 36.4 | 36.243 | 36.26 | 9179900.0 |
| 2004-10-21 12:30:00 | QQQ | ETF | 36.259 | 36.28 | 36.16 | 36.23 | 7156500.0 |
| 2004-10-21 13:00:00 | QQQ | ETF | 36.233 | 36.288 | 36.15 | 36.208 | 4194300.0 |
| 2004-10-21 13:30:00 | QQQ | ETF | 36.21 | 36.3 | 36.199 | 36.236 | 4000400.0 |
| 2004-10-21 14:00:00 | QQQ | ETF | 36.24 | 36.53 | 36.24 | 36.5 | 10359300.0 |
| 2004-10-21 14:30:00 | QQQ | ETF | 36.5 | 36.64 | 36.48 | 36.64 | 11453600.0 |
| 2004-10-21 15:00:00 | QQQ | ETF | 36.64 | 36.77 | 36.61 | 36.657 | 11667500.0 |
| 2004-10-21 15:30:00 | QQQ | ETF | 36.657 | 36.7 | 36.56 | 36.64 | 8603300.0 |
| 2004-10-21 16:00:00 | QQQ | ETF | 36.63 | 36.68 | 36.4 | 36.42 | 6293300.0 |
| 2004-10-21 16:30:00 | QQQ | ETF | 36.42 | 36.49 | 36.34 | 36.46 | 2181900.0 |
| 2004-10-21 17:00:00 | QQQ | ETF | 36.46 | 36.46 | 36.4 | 36.44 | 778400.0 |
| 2004-10-21 17:30:00 | QQQ | ETF | 36.45 | 36.52 | 36.45 | 36.52 | 241300.0 |
| 2004-10-21 18:00:00 | QQQ | ETF | 36.479 | 36.6 | 36.479 | 36.54 | 493700.0 |
| 2004-10-21 18:30:00 | QQQ | ETF | 36.56 | 36.58 | 36.54 | 36.58 | 104000.0 |
| 2004-10-21 19:00:00 | QQQ | ETF | 36.54 | 36.54 | 36.54 | 36.54 | 600.0 |
| 2004-10-21 19:30:00 | QQQ | ETF | 36.56 | 36.58 | 36.56 | 36.58 | 1700.0 |
| 2004-10-21 08:30:00 | IWM | ETF | 56.86 | 56.9 | 56.86 | 56.9 | 18000.0 |
| 2004-10-21 09:30:00 | IWM | ETF | 56.835 | 56.9 | 56.565 | 56.8 | 876800.0 |
> showing 50 of 1,255 rows — these rows as CSV