PREVIEW / etf_30min / 2004-07-28
file: by_date/etf_30min/2004/2004-07-28.parquet size: 35 KB rows: 1,124
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-07-28 08:00:00 | SPY | ETF | 109.73 | 109.73 | 109.59 | 109.64 | 28200.0 |
| 2004-07-28 08:30:00 | SPY | ETF | 109.55 | 109.6 | 109.5 | 109.56 | 167400.0 |
| 2004-07-28 09:00:00 | SPY | ETF | 109.55 | 109.61 | 109.55 | 109.58 | 10700.0 |
| 2004-07-28 09:30:00 | SPY | ETF | 109.55 | 109.87 | 109.54 | 109.8 | 4722500.0 |
| 2004-07-28 10:00:00 | SPY | ETF | 109.79 | 109.84 | 109.12 | 109.24 | 8049700.0 |
| 2004-07-28 10:30:00 | SPY | ETF | 109.24 | 109.33 | 108.86 | 108.99 | 7414200.0 |
| 2004-07-28 11:00:00 | SPY | ETF | 108.96 | 109.07 | 108.66 | 109.0 | 5274300.0 |
| 2004-07-28 11:30:00 | SPY | ETF | 109.01 | 109.04 | 108.81 | 108.99 | 2189500.0 |
| 2004-07-28 12:00:00 | SPY | ETF | 108.99 | 108.99 | 108.59 | 108.69 | 3456800.0 |
| 2004-07-28 12:30:00 | SPY | ETF | 108.69 | 108.9 | 108.62 | 108.79 | 1593500.0 |
| 2004-07-28 13:00:00 | SPY | ETF | 108.78 | 109.01 | 108.76 | 108.93 | 2422900.0 |
| 2004-07-28 13:30:00 | SPY | ETF | 108.93 | 109.05 | 108.87 | 108.9 | 1695800.0 |
| 2004-07-28 14:00:00 | SPY | ETF | 108.88 | 109.22 | 108.75 | 109.12 | 4361000.0 |
| 2004-07-28 14:30:00 | SPY | ETF | 109.14 | 109.54 | 109.03 | 109.49 | 3687200.0 |
| 2004-07-28 15:00:00 | SPY | ETF | 109.5 | 110.04 | 109.4 | 109.96 | 8076600.0 |
| 2004-07-28 15:30:00 | SPY | ETF | 109.95 | 110.37 | 109.92 | 110.03 | 7972100.0 |
| 2004-07-28 16:00:00 | SPY | ETF | 110.01 | 110.18 | 109.94 | 110.11 | 1196200.0 |
| 2004-07-28 16:30:00 | SPY | ETF | 110.08 | 110.1 | 110.05 | 110.05 | 59300.0 |
| 2004-07-28 17:00:00 | SPY | ETF | 110.1 | 110.17 | 110.1 | 110.1 | 358100.0 |
| 2004-07-28 17:30:00 | SPY | ETF | 110.08 | 110.17 | 110.08 | 110.17 | 3500.0 |
| 2004-07-28 18:00:00 | SPY | ETF | 110.13 | 110.16 | 110.12 | 110.12 | 26600.0 |
| 2004-07-28 19:00:00 | SPY | ETF | 110.12 | 110.12 | 110.12 | 110.12 | 200.0 |
| 2004-07-28 08:00:00 | QQQ | ETF | 34.48 | 34.48 | 34.45 | 34.48 | 12000.0 |
| 2004-07-28 08:30:00 | QQQ | ETF | 34.44 | 34.45 | 34.41 | 34.43 | 124700.0 |
| 2004-07-28 09:00:00 | QQQ | ETF | 34.43 | 34.43 | 34.39 | 34.4 | 36600.0 |
| 2004-07-28 09:30:00 | QQQ | ETF | 34.41 | 34.51 | 34.32 | 34.439 | 12336600.0 |
| 2004-07-28 10:00:00 | QQQ | ETF | 34.439 | 34.44 | 34.1 | 34.14 | 21328200.0 |
| 2004-07-28 10:30:00 | QQQ | ETF | 34.142 | 34.18 | 33.92 | 33.994 | 14530300.0 |
| 2004-07-28 11:00:00 | QQQ | ETF | 33.994 | 34.12 | 33.87 | 34.06 | 15488500.0 |
| 2004-07-28 11:30:00 | QQQ | ETF | 34.066 | 34.071 | 33.94 | 34.03 | 4130800.0 |
| 2004-07-28 12:00:00 | QQQ | ETF | 34.03 | 34.03 | 33.83 | 33.85 | 7223300.0 |
| 2004-07-28 12:30:00 | QQQ | ETF | 33.85 | 33.93 | 33.81 | 33.88 | 8541100.0 |
| 2004-07-28 13:00:00 | QQQ | ETF | 33.89 | 34.01 | 33.88 | 33.95 | 5822100.0 |
| 2004-07-28 13:30:00 | QQQ | ETF | 33.951 | 34.0 | 33.874 | 33.88 | 3123200.0 |
| 2004-07-28 14:00:00 | QQQ | ETF | 33.89 | 34.04 | 33.83 | 33.99 | 7893900.0 |
| 2004-07-28 14:30:00 | QQQ | ETF | 33.99 | 34.23 | 33.97 | 34.198 | 9573000.0 |
| 2004-07-28 15:00:00 | QQQ | ETF | 34.18 | 34.455 | 34.15 | 34.4 | 14555700.0 |
| 2004-07-28 15:30:00 | QQQ | ETF | 34.4 | 34.626 | 34.38 | 34.398 | 15635500.0 |
| 2004-07-28 16:00:00 | QQQ | ETF | 34.39 | 34.44 | 34.36 | 34.37 | 3381400.0 |
| 2004-07-28 16:30:00 | QQQ | ETF | 34.385 | 34.43 | 34.38 | 34.43 | 148700.0 |
| 2004-07-28 17:00:00 | QQQ | ETF | 34.43 | 34.47 | 34.4 | 34.42 | 604600.0 |
| 2004-07-28 17:30:00 | QQQ | ETF | 34.42 | 34.44 | 34.41 | 34.43 | 6800.0 |
| 2004-07-28 18:00:00 | QQQ | ETF | 34.417 | 34.44 | 34.41 | 34.41 | 26000.0 |
| 2004-07-28 18:30:00 | QQQ | ETF | 34.43 | 34.43 | 34.43 | 34.43 | 2600.0 |
| 2004-07-28 19:00:00 | QQQ | ETF | 34.4 | 34.42 | 34.4 | 34.41 | 2500.0 |
| 2004-07-28 19:30:00 | QQQ | ETF | 34.41 | 34.42 | 34.41 | 34.42 | 2900.0 |
| 2004-07-28 08:00:00 | IWM | ETF | 54.1 | 54.115 | 54.1 | 54.115 | 6000.0 |
| 2004-07-28 08:30:00 | IWM | ETF | 54.1 | 54.1 | 54.05 | 54.06 | 53200.0 |
| 2004-07-28 09:00:00 | IWM | ETF | 54.07 | 54.07 | 54.05 | 54.05 | 24400.0 |
| 2004-07-28 09:30:00 | IWM | ETF | 54.01 | 54.025 | 53.75 | 53.9507 | 1574400.0 |
> showing 50 of 1,124 rows — these rows as CSV