PREVIEW / etf_30min / 2003-08-22
file: by_date/etf_30min/2003/2003-08-22.parquet size: 24 KB rows: 719
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-22 08:00:00 | SPY | ETF | 100.75 | 100.78 | 100.72 | 100.75 | 6400.0 |
| 2003-08-22 08:30:00 | SPY | ETF | 100.78 | 101.6 | 100.78 | 101.54 | 134800.0 |
| 2003-08-22 09:00:00 | SPY | ETF | 101.52 | 101.73 | 101.52 | 101.73 | 61200.0 |
| 2003-08-22 09:30:00 | SPY | ETF | 101.75 | 101.818 | 101.4 | 101.62 | 4595100.0 |
| 2003-08-22 10:00:00 | SPY | ETF | 101.619 | 101.64 | 100.85 | 100.95 | 5284100.0 |
| 2003-08-22 10:30:00 | SPY | ETF | 100.93 | 101.11 | 100.65 | 100.84 | 4879400.0 |
| 2003-08-22 11:00:00 | SPY | ETF | 100.83 | 100.94 | 100.62 | 100.66 | 1885500.0 |
| 2003-08-22 11:30:00 | SPY | ETF | 100.669 | 100.71 | 100.27 | 100.42 | 3799200.0 |
| 2003-08-22 12:00:00 | SPY | ETF | 100.43 | 100.57 | 100.4 | 100.46 | 1771500.0 |
| 2003-08-22 12:30:00 | SPY | ETF | 100.47 | 100.55 | 100.33 | 100.5 | 1182400.0 |
| 2003-08-22 13:00:00 | SPY | ETF | 100.48 | 100.53 | 100.27 | 100.45 | 1263400.0 |
| 2003-08-22 13:30:00 | SPY | ETF | 100.46 | 100.52 | 100.28 | 100.39 | 1252300.0 |
| 2003-08-22 14:00:00 | SPY | ETF | 100.37 | 100.38 | 99.87 | 99.91 | 4353000.0 |
| 2003-08-22 14:30:00 | SPY | ETF | 99.88 | 100.1 | 99.87 | 99.96 | 2065500.0 |
| 2003-08-22 15:00:00 | SPY | ETF | 99.98 | 100.15 | 99.9 | 100.05 | 1808100.0 |
| 2003-08-22 15:30:00 | SPY | ETF | 100.06 | 100.1 | 99.74 | 99.77 | 5725000.0 |
| 2003-08-22 16:00:00 | SPY | ETF | 99.75 | 99.86 | 99.71 | 99.75 | 1701900.0 |
| 2003-08-22 16:30:00 | SPY | ETF | 99.73 | 99.8 | 99.72 | 99.72 | 19700.0 |
| 2003-08-22 17:00:00 | SPY | ETF | 99.74 | 99.76 | 99.7 | 99.7 | 9200.0 |
| 2003-08-22 17:30:00 | SPY | ETF | 99.7 | 99.71 | 99.7 | 99.71 | 900.0 |
| 2003-08-22 18:00:00 | SPY | ETF | 99.71 | 99.73 | 99.71 | 99.73 | 600.0 |
| 2003-08-22 18:30:00 | SPY | ETF | 99.73 | 99.73 | 99.72 | 99.72 | 1100.0 |
| 2003-08-22 19:00:00 | SPY | ETF | 99.72 | 99.72 | 99.7 | 99.7 | 600.0 |
| 2003-08-22 08:00:00 | QQQ | ETF | 32.7 | 32.71 | 32.65 | 32.67 | 28800.0 |
| 2003-08-22 08:30:00 | QQQ | ETF | 32.7 | 33.3 | 32.7 | 33.25 | 508000.0 |
| 2003-08-22 09:00:00 | QQQ | ETF | 33.25 | 33.31 | 33.22 | 33.26 | 577500.0 |
| 2003-08-22 09:30:00 | QQQ | ETF | 33.26 | 33.37 | 33.16 | 33.35 | 12754500.0 |
| 2003-08-22 10:00:00 | QQQ | ETF | 33.34 | 33.36 | 32.94 | 33.01 | 12970500.0 |
| 2003-08-22 10:30:00 | QQQ | ETF | 33.01 | 33.09 | 32.859 | 32.94 | 9721700.0 |
| 2003-08-22 11:00:00 | QQQ | ETF | 32.93 | 32.99 | 32.83 | 32.87 | 4618300.0 |
| 2003-08-22 11:30:00 | QQQ | ETF | 32.86 | 32.913 | 32.74 | 32.79 | 4737800.0 |
| 2003-08-22 12:00:00 | QQQ | ETF | 32.79 | 32.87 | 32.77 | 32.82 | 2751300.0 |
| 2003-08-22 12:30:00 | QQQ | ETF | 32.82 | 32.85 | 32.73 | 32.78 | 3319600.0 |
| 2003-08-22 13:00:00 | QQQ | ETF | 32.78 | 32.813 | 32.67 | 32.769 | 3126100.0 |
| 2003-08-22 13:30:00 | QQQ | ETF | 32.77 | 32.85 | 32.72 | 32.78 | 3227300.0 |
| 2003-08-22 14:00:00 | QQQ | ETF | 32.8 | 32.8 | 32.447 | 32.496 | 7778600.0 |
| 2003-08-22 14:30:00 | QQQ | ETF | 32.492 | 32.58 | 32.45 | 32.476 | 6363100.0 |
| 2003-08-22 15:00:00 | QQQ | ETF | 32.47 | 32.69 | 32.45 | 32.614 | 4291600.0 |
| 2003-08-22 15:30:00 | QQQ | ETF | 32.62 | 32.65 | 32.44 | 32.47 | 4116800.0 |
| 2003-08-22 16:00:00 | QQQ | ETF | 32.47 | 32.49 | 32.38 | 32.42 | 2798300.0 |
| 2003-08-22 16:30:00 | QQQ | ETF | 32.42 | 32.44 | 32.4 | 32.42 | 54700.0 |
| 2003-08-22 17:00:00 | QQQ | ETF | 32.43 | 32.44 | 32.41 | 32.41 | 14300.0 |
| 2003-08-22 17:30:00 | QQQ | ETF | 32.44 | 32.48 | 32.43 | 32.45 | 34700.0 |
| 2003-08-22 18:00:00 | QQQ | ETF | 32.45 | 32.46 | 32.43 | 32.46 | 7400.0 |
| 2003-08-22 18:30:00 | QQQ | ETF | 32.43 | 32.45 | 32.43 | 32.45 | 4300.0 |
| 2003-08-22 19:00:00 | QQQ | ETF | 32.45 | 32.45 | 32.45 | 32.45 | 1000.0 |
| 2003-08-22 19:30:00 | QQQ | ETF | 32.44 | 32.45 | 32.44 | 32.44 | 2000.0 |
| 2003-08-22 09:00:00 | IWM | ETF | 49.72 | 49.72 | 49.72 | 49.72 | 1000.0 |
| 2003-08-22 09:30:00 | IWM | ETF | 49.895 | 49.895 | 49.5 | 49.645 | 423200.0 |
| 2003-08-22 10:00:00 | IWM | ETF | 49.685 | 49.725 | 49.03 | 49.03 | 576800.0 |
> showing 50 of 719 rows — these rows as CSV