PREVIEW / etf_30min / 2002-07-15
file: by_date/etf_30min/2002/2002-07-15.parquet size: 20 KB rows: 551
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-15 09:30:00 | SPY | ETF | 91.64 | 91.64 | 90.56 | 90.8 | 7749900.0 |
| 2002-07-15 10:00:00 | SPY | ETF | 90.74 | 91.15 | 90.12 | 90.5 | 5533800.0 |
| 2002-07-15 10:30:00 | SPY | ETF | 90.5 | 91.07 | 90.2 | 90.51 | 3617700.0 |
| 2002-07-15 11:00:00 | SPY | ETF | 90.49 | 90.73 | 89.7 | 89.8 | 6156500.0 |
| 2002-07-15 11:30:00 | SPY | ETF | 89.84 | 90.34 | 89.57 | 90.0 | 3887700.0 |
| 2002-07-15 12:00:00 | SPY | ETF | 90.0 | 90.01 | 89.15 | 89.44 | 3958600.0 |
| 2002-07-15 12:30:00 | SPY | ETF | 89.45 | 89.88 | 89.4 | 89.62 | 2321800.0 |
| 2002-07-15 13:00:00 | SPY | ETF | 89.62 | 89.77 | 89.3 | 89.51 | 1409500.0 |
| 2002-07-15 13:30:00 | SPY | ETF | 89.55 | 89.6 | 88.94 | 89.3 | 2806700.0 |
| 2002-07-15 14:00:00 | SPY | ETF | 89.34 | 89.37 | 88.5 | 88.6 | 3858200.0 |
| 2002-07-15 14:30:00 | SPY | ETF | 88.58 | 89.2 | 87.89 | 89.06 | 7272200.0 |
| 2002-07-15 15:00:00 | SPY | ETF | 89.1 | 91.45 | 89.0 | 91.41 | 7607100.0 |
| 2002-07-15 15:30:00 | SPY | ETF | 91.36 | 92.2 | 90.9 | 92.1 | 9891700.0 |
| 2002-07-15 16:00:00 | SPY | ETF | 92.01 | 92.4 | 91.9 | 92.34 | 1745100.0 |
| 2002-07-15 09:30:00 | QQQ | ETF | 24.68 | 24.7 | 24.32 | 24.56 | 13654700.0 |
| 2002-07-15 10:00:00 | QQQ | ETF | 24.56 | 24.75 | 24.36 | 24.61 | 11282300.0 |
| 2002-07-15 10:30:00 | QQQ | ETF | 24.57 | 24.89 | 24.49 | 24.68 | 11180200.0 |
| 2002-07-15 11:00:00 | QQQ | ETF | 24.65 | 24.76 | 24.46 | 24.5 | 6356600.0 |
| 2002-07-15 11:30:00 | QQQ | ETF | 24.51 | 24.82 | 24.5 | 24.74 | 9072100.0 |
| 2002-07-15 12:00:00 | QQQ | ETF | 24.7 | 24.76 | 24.4 | 24.51 | 5765200.0 |
| 2002-07-15 12:30:00 | QQQ | ETF | 24.55 | 24.74 | 24.52 | 24.58 | 4968200.0 |
| 2002-07-15 13:00:00 | QQQ | ETF | 24.58 | 24.64 | 24.46 | 24.57 | 4520100.0 |
| 2002-07-15 13:30:00 | QQQ | ETF | 24.57 | 24.59 | 24.25 | 24.4 | 7600400.0 |
| 2002-07-15 14:00:00 | QQQ | ETF | 24.39 | 24.42 | 23.96 | 24.12 | 11794200.0 |
| 2002-07-15 14:30:00 | QQQ | ETF | 24.09 | 24.31 | 23.75 | 24.18 | 15240400.0 |
| 2002-07-15 15:00:00 | QQQ | ETF | 24.18 | 24.8 | 24.15 | 24.79 | 11684500.0 |
| 2002-07-15 15:30:00 | QQQ | ETF | 24.79 | 25.44 | 24.61 | 25.41 | 20624200.0 |
| 2002-07-15 16:00:00 | QQQ | ETF | 25.41 | 25.64 | 25.24 | 25.57 | 1377100.0 |
| 2002-07-15 09:30:00 | IWM | ETF | 40.95 | 40.95 | 40.735 | 40.735 | 456800.0 |
| 2002-07-15 10:00:00 | IWM | ETF | 40.72 | 40.735 | 40.55 | 40.62 | 288800.0 |
| 2002-07-15 10:30:00 | IWM | ETF | 40.625 | 40.655 | 40.5 | 40.5 | 193600.0 |
| 2002-07-15 11:00:00 | IWM | ETF | 40.5 | 40.57 | 40.075 | 40.19 | 281200.0 |
| 2002-07-15 11:30:00 | IWM | ETF | 40.125 | 40.31 | 40.08 | 40.175 | 340200.0 |
| 2002-07-15 12:00:00 | IWM | ETF | 40.15 | 40.22 | 39.88 | 39.905 | 69600.0 |
| 2002-07-15 12:30:00 | IWM | ETF | 40.0 | 40.135 | 40.0 | 40.01 | 38200.0 |
| 2002-07-15 13:00:00 | IWM | ETF | 40.09 | 40.09 | 40.0 | 40.01 | 43600.0 |
| 2002-07-15 13:30:00 | IWM | ETF | 40.045 | 40.045 | 39.865 | 40.04 | 36200.0 |
| 2002-07-15 14:00:00 | IWM | ETF | 39.96 | 39.96 | 39.65 | 39.705 | 115400.0 |
| 2002-07-15 14:30:00 | IWM | ETF | 39.75 | 39.85 | 39.425 | 39.665 | 198200.0 |
| 2002-07-15 15:00:00 | IWM | ETF | 39.665 | 40.425 | 39.665 | 40.4 | 506200.0 |
| 2002-07-15 15:30:00 | IWM | ETF | 40.5 | 40.91 | 40.465 | 40.85 | 811400.0 |
| 2002-07-15 16:00:00 | IWM | ETF | 40.755 | 40.85 | 40.755 | 40.77 | 13400.0 |
| 2002-07-15 09:30:00 | DIA | ETF | 86.41 | 86.41 | 85.19 | 85.53 | 1437200.0 |
| 2002-07-15 10:00:00 | DIA | ETF | 85.53 | 85.95 | 84.9 | 85.3 | 1192700.0 |
| 2002-07-15 10:30:00 | DIA | ETF | 85.25 | 85.77 | 85.1 | 85.33 | 697300.0 |
| 2002-07-15 11:00:00 | DIA | ETF | 85.16 | 85.41 | 84.2 | 84.34 | 942900.0 |
| 2002-07-15 11:30:00 | DIA | ETF | 84.35 | 84.84 | 84.03 | 84.46 | 1974300.0 |
| 2002-07-15 12:00:00 | DIA | ETF | 84.41 | 84.5 | 83.6 | 83.97 | 919300.0 |
| 2002-07-15 12:30:00 | DIA | ETF | 83.96 | 84.39 | 83.87 | 84.08 | 780600.0 |
| 2002-07-15 13:00:00 | DIA | ETF | 84.09 | 84.18 | 83.71 | 84.0 | 583800.0 |
> showing 50 of 551 rows — these rows as CSV