PREVIEW / etf_30min / 2002-07-29
file: by_date/etf_30min/2002/2002-07-29.parquet size: 20 KB rows: 568
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-29 09:30:00 | SPY | ETF | 87.5 | 87.85 | 87.3 | 87.4 | 5889700.0 |
| 2002-07-29 10:00:00 | SPY | ETF | 87.4 | 88.55 | 87.32 | 88.5 | 7120600.0 |
| 2002-07-29 10:30:00 | SPY | ETF | 88.5 | 88.85 | 88.3 | 88.55 | 4715600.0 |
| 2002-07-29 11:00:00 | SPY | ETF | 88.5 | 88.63 | 88.1 | 88.31 | 2453800.0 |
| 2002-07-29 11:30:00 | SPY | ETF | 88.38 | 89.09 | 88.32 | 88.94 | 3775700.0 |
| 2002-07-29 12:00:00 | SPY | ETF | 88.94 | 88.99 | 88.57 | 88.77 | 1497500.0 |
| 2002-07-29 12:30:00 | SPY | ETF | 88.75 | 89.18 | 88.68 | 88.98 | 1904700.0 |
| 2002-07-29 13:00:00 | SPY | ETF | 89.0 | 89.15 | 88.76 | 88.86 | 1612300.0 |
| 2002-07-29 13:30:00 | SPY | ETF | 88.85 | 89.46 | 88.66 | 89.24 | 3363300.0 |
| 2002-07-29 14:00:00 | SPY | ETF | 89.29 | 89.49 | 89.02 | 89.3 | 2339400.0 |
| 2002-07-29 14:30:00 | SPY | ETF | 89.31 | 89.66 | 89.24 | 89.32 | 3123900.0 |
| 2002-07-29 15:00:00 | SPY | ETF | 89.3 | 90.0 | 89.26 | 89.72 | 3742600.0 |
| 2002-07-29 15:30:00 | SPY | ETF | 89.75 | 90.34 | 89.45 | 90.23 | 6420300.0 |
| 2002-07-29 16:00:00 | SPY | ETF | 90.29 | 90.33 | 89.7 | 89.77 | 1554500.0 |
| 2002-07-29 09:30:00 | QQQ | ETF | 23.27 | 23.45 | 23.14 | 23.2 | 15534500.0 |
| 2002-07-29 10:00:00 | QQQ | ETF | 23.24 | 23.42 | 23.16 | 23.38 | 7830400.0 |
| 2002-07-29 10:30:00 | QQQ | ETF | 23.39 | 23.58 | 23.35 | 23.43 | 8984000.0 |
| 2002-07-29 11:00:00 | QQQ | ETF | 23.41 | 23.53 | 23.3 | 23.4 | 6015900.0 |
| 2002-07-29 11:30:00 | QQQ | ETF | 23.4 | 23.69 | 23.39 | 23.59 | 5567500.0 |
| 2002-07-29 12:00:00 | QQQ | ETF | 23.6 | 23.68 | 23.55 | 23.64 | 3830200.0 |
| 2002-07-29 12:30:00 | QQQ | ETF | 23.6 | 23.89 | 23.6 | 23.82 | 6139200.0 |
| 2002-07-29 13:00:00 | QQQ | ETF | 23.8 | 23.86 | 23.67 | 23.72 | 4167400.0 |
| 2002-07-29 13:30:00 | QQQ | ETF | 23.72 | 24.02 | 23.65 | 23.92 | 5762400.0 |
| 2002-07-29 14:00:00 | QQQ | ETF | 23.9 | 24.03 | 23.81 | 23.95 | 4770900.0 |
| 2002-07-29 14:30:00 | QQQ | ETF | 23.95 | 24.0 | 23.85 | 23.86 | 4422900.0 |
| 2002-07-29 15:00:00 | QQQ | ETF | 23.85 | 24.12 | 23.83 | 23.98 | 7218800.0 |
| 2002-07-29 15:30:00 | QQQ | ETF | 23.97 | 24.09 | 23.86 | 24.0 | 10137900.0 |
| 2002-07-29 16:00:00 | QQQ | ETF | 24.04 | 24.05 | 23.83 | 23.83 | 1236800.0 |
| 2002-07-29 09:30:00 | IWM | ETF | 39.15 | 39.22 | 38.75 | 38.875 | 258400.0 |
| 2002-07-29 10:00:00 | IWM | ETF | 38.85 | 39.295 | 38.85 | 39.295 | 366400.0 |
| 2002-07-29 10:30:00 | IWM | ETF | 39.305 | 39.465 | 39.265 | 39.45 | 262000.0 |
| 2002-07-29 11:00:00 | IWM | ETF | 39.37 | 39.445 | 39.25 | 39.365 | 72200.0 |
| 2002-07-29 11:30:00 | IWM | ETF | 39.365 | 39.595 | 39.36 | 39.575 | 125800.0 |
| 2002-07-29 12:00:00 | IWM | ETF | 39.51 | 39.615 | 39.4 | 39.525 | 63200.0 |
| 2002-07-29 12:30:00 | IWM | ETF | 39.47 | 39.715 | 39.47 | 39.62 | 59000.0 |
| 2002-07-29 13:00:00 | IWM | ETF | 39.625 | 39.66 | 39.515 | 39.515 | 49000.0 |
| 2002-07-29 13:30:00 | IWM | ETF | 39.56 | 39.75 | 39.5 | 39.74 | 62600.0 |
| 2002-07-29 14:00:00 | IWM | ETF | 39.65 | 39.85 | 39.6 | 39.7 | 32000.0 |
| 2002-07-29 14:30:00 | IWM | ETF | 39.715 | 39.925 | 39.665 | 39.74 | 180200.0 |
| 2002-07-29 15:00:00 | IWM | ETF | 39.75 | 39.965 | 39.715 | 39.875 | 187200.0 |
| 2002-07-29 15:30:00 | IWM | ETF | 39.81 | 40.15 | 39.81 | 40.0 | 416800.0 |
| 2002-07-29 16:00:00 | IWM | ETF | 39.95 | 40.115 | 39.755 | 39.775 | 106400.0 |
| 2002-07-29 09:30:00 | DIA | ETF | 84.4 | 84.74 | 84.3 | 84.37 | 1936200.0 |
| 2002-07-29 10:00:00 | DIA | ETF | 84.37 | 85.75 | 84.28 | 85.68 | 2280800.0 |
| 2002-07-29 10:30:00 | DIA | ETF | 85.68 | 86.05 | 85.42 | 85.66 | 1293500.0 |
| 2002-07-29 11:00:00 | DIA | ETF | 85.65 | 85.7 | 85.2 | 85.4 | 1019300.0 |
| 2002-07-29 11:30:00 | DIA | ETF | 85.44 | 86.15 | 85.37 | 85.92 | 667000.0 |
| 2002-07-29 12:00:00 | DIA | ETF | 85.91 | 85.97 | 85.53 | 85.67 | 465900.0 |
| 2002-07-29 12:30:00 | DIA | ETF | 85.7 | 86.1 | 85.6 | 85.93 | 693700.0 |
| 2002-07-29 13:00:00 | DIA | ETF | 85.92 | 86.05 | 85.7 | 85.84 | 627300.0 |
> showing 50 of 568 rows — these rows as CSV