PREVIEW / etf_30min / 2004-08-26
file: by_date/etf_30min/2004/2004-08-26.parquet size: 33 KB rows: 1,143
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-26 08:00:00 | SPY | ETF | 111.1 | 111.1 | 111.06 | 111.06 | 21900.0 |
| 2004-08-26 08:30:00 | SPY | ETF | 111.07 | 111.07 | 110.96 | 110.99 | 90100.0 |
| 2004-08-26 09:00:00 | SPY | ETF | 111.0 | 111.03 | 110.95 | 110.98 | 24500.0 |
| 2004-08-26 09:30:00 | SPY | ETF | 110.96 | 111.19 | 110.85 | 111.1 | 3546400.0 |
| 2004-08-26 10:00:00 | SPY | ETF | 111.1 | 111.25 | 111.04 | 111.12 | 2528300.0 |
| 2004-08-26 10:30:00 | SPY | ETF | 111.12 | 111.12 | 110.98 | 111.08 | 2559000.0 |
| 2004-08-26 11:00:00 | SPY | ETF | 111.09 | 111.17 | 111.02 | 111.1 | 1326800.0 |
| 2004-08-26 11:30:00 | SPY | ETF | 111.1 | 111.12 | 110.97 | 111.01 | 1821200.0 |
| 2004-08-26 12:00:00 | SPY | ETF | 111.0 | 111.19 | 110.97 | 111.15 | 1457100.0 |
| 2004-08-26 12:30:00 | SPY | ETF | 111.16 | 111.19 | 111.11 | 111.13 | 595300.0 |
| 2004-08-26 13:00:00 | SPY | ETF | 111.13 | 111.13 | 111.0 | 111.05 | 744700.0 |
| 2004-08-26 13:30:00 | SPY | ETF | 111.05 | 111.11 | 110.97 | 111.03 | 964400.0 |
| 2004-08-26 14:00:00 | SPY | ETF | 111.03 | 111.18 | 110.89 | 111.12 | 2813300.0 |
| 2004-08-26 14:30:00 | SPY | ETF | 111.12 | 111.18 | 111.04 | 111.1 | 1088400.0 |
| 2004-08-26 15:00:00 | SPY | ETF | 111.09 | 111.29 | 111.07 | 111.29 | 2256000.0 |
| 2004-08-26 15:30:00 | SPY | ETF | 111.28 | 111.31 | 111.13 | 111.16 | 2501800.0 |
| 2004-08-26 16:00:00 | SPY | ETF | 111.15 | 111.16 | 111.01 | 111.1 | 1211200.0 |
| 2004-08-26 16:30:00 | SPY | ETF | 111.03 | 111.12 | 110.99 | 111.12 | 146300.0 |
| 2004-08-26 17:00:00 | SPY | ETF | 111.16 | 111.18 | 111.1 | 111.13 | 110400.0 |
| 2004-08-26 18:00:00 | SPY | ETF | 111.14 | 111.14 | 111.14 | 111.14 | 1000.0 |
| 2004-08-26 08:00:00 | QQQ | ETF | 34.53 | 34.53 | 34.52 | 34.52 | 19400.0 |
| 2004-08-26 08:30:00 | QQQ | ETF | 34.5 | 34.5 | 34.44 | 34.47 | 137100.0 |
| 2004-08-26 09:00:00 | QQQ | ETF | 34.47 | 34.47 | 34.44 | 34.45 | 124700.0 |
| 2004-08-26 09:30:00 | QQQ | ETF | 34.46 | 34.54 | 34.39 | 34.486 | 9163000.0 |
| 2004-08-26 10:00:00 | QQQ | ETF | 34.485 | 34.55 | 34.43 | 34.45 | 5298600.0 |
| 2004-08-26 10:30:00 | QQQ | ETF | 34.45 | 34.47 | 34.33 | 34.38 | 7209400.0 |
| 2004-08-26 11:00:00 | QQQ | ETF | 34.384 | 34.47 | 34.38 | 34.43 | 3232600.0 |
| 2004-08-26 11:30:00 | QQQ | ETF | 34.434 | 34.44 | 34.36 | 34.38 | 3072500.0 |
| 2004-08-26 12:00:00 | QQQ | ETF | 34.37 | 34.49 | 34.37 | 34.47 | 2671300.0 |
| 2004-08-26 12:30:00 | QQQ | ETF | 34.46 | 34.48 | 34.44 | 34.44 | 1441300.0 |
| 2004-08-26 13:00:00 | QQQ | ETF | 34.444 | 34.45 | 34.35 | 34.395 | 2225700.0 |
| 2004-08-26 13:30:00 | QQQ | ETF | 34.39 | 34.41 | 34.337 | 34.36 | 2981200.0 |
| 2004-08-26 14:00:00 | QQQ | ETF | 34.36 | 34.45 | 34.31 | 34.43 | 4014500.0 |
| 2004-08-26 14:30:00 | QQQ | ETF | 34.43 | 34.468 | 34.4 | 34.42 | 2211600.0 |
| 2004-08-26 15:00:00 | QQQ | ETF | 34.42 | 34.52 | 34.41 | 34.5 | 3816300.0 |
| 2004-08-26 15:30:00 | QQQ | ETF | 34.5 | 34.54 | 34.394 | 34.4 | 5235200.0 |
| 2004-08-26 16:00:00 | QQQ | ETF | 34.41 | 34.43 | 34.37 | 34.38 | 948400.0 |
| 2004-08-26 16:30:00 | QQQ | ETF | 34.38 | 34.51 | 34.311 | 34.5 | 1281500.0 |
| 2004-08-26 17:00:00 | QQQ | ETF | 34.49 | 34.51 | 33.49 | 34.51 | 1035100.0 |
| 2004-08-26 17:30:00 | QQQ | ETF | 34.5 | 34.5 | 34.47 | 34.47 | 17600.0 |
| 2004-08-26 18:00:00 | QQQ | ETF | 34.471 | 34.48 | 34.47 | 34.47 | 21900.0 |
| 2004-08-26 18:30:00 | QQQ | ETF | 34.47 | 34.48 | 34.46 | 34.48 | 20700.0 |
| 2004-08-26 19:00:00 | QQQ | ETF | 34.48 | 34.49 | 34.48 | 34.48 | 4700.0 |
| 2004-08-26 19:30:00 | QQQ | ETF | 34.48 | 34.49 | 34.47 | 34.47 | 8300.0 |
| 2004-08-26 08:30:00 | IWM | ETF | 54.685 | 54.705 | 54.685 | 54.705 | 1600.0 |
| 2004-08-26 09:00:00 | IWM | ETF | 54.655 | 54.655 | 54.635 | 54.64 | 3000.0 |
| 2004-08-26 09:30:00 | IWM | ETF | 54.675 | 54.78 | 54.56 | 54.755 | 3068800.0 |
| 2004-08-26 10:00:00 | IWM | ETF | 54.775 | 54.865 | 54.655 | 54.745 | 731200.0 |
| 2004-08-26 10:30:00 | IWM | ETF | 54.74 | 54.745 | 54.635 | 54.7 | 785800.0 |
| 2004-08-26 11:00:00 | IWM | ETF | 54.71 | 54.74 | 54.665 | 54.71 | 330600.0 |
> showing 50 of 1,143 rows — these rows as CSV