PREVIEW / etf_30min / 2002-07-16
file: by_date/etf_30min/2002/2002-07-16.parquet size: 19 KB rows: 522
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-16 09:30:00 | SPY | ETF | 91.12 | 91.83 | 90.7 | 91.09 | 5466700.0 |
| 2002-07-16 10:00:00 | SPY | ETF | 91.09 | 91.49 | 90.03 | 90.12 | 8456100.0 |
| 2002-07-16 10:30:00 | SPY | ETF | 90.11 | 91.21 | 89.87 | 91.19 | 3794300.0 |
| 2002-07-16 11:00:00 | SPY | ETF | 91.19 | 92.28 | 91.15 | 91.2 | 5860100.0 |
| 2002-07-16 11:30:00 | SPY | ETF | 91.19 | 92.0 | 91.0 | 91.92 | 3937000.0 |
| 2002-07-16 12:00:00 | SPY | ETF | 91.9 | 92.12 | 91.4 | 91.77 | 2475500.0 |
| 2002-07-16 12:30:00 | SPY | ETF | 91.78 | 92.25 | 91.5 | 92.04 | 2010100.0 |
| 2002-07-16 13:00:00 | SPY | ETF | 92.03 | 92.38 | 91.46 | 91.65 | 1915800.0 |
| 2002-07-16 13:30:00 | SPY | ETF | 91.6 | 92.23 | 91.2 | 91.34 | 1936800.0 |
| 2002-07-16 14:00:00 | SPY | ETF | 91.38 | 91.8 | 91.1 | 91.74 | 2522300.0 |
| 2002-07-16 14:30:00 | SPY | ETF | 91.73 | 91.95 | 91.38 | 91.65 | 2505500.0 |
| 2002-07-16 15:00:00 | SPY | ETF | 91.66 | 91.7 | 90.3 | 90.48 | 2970500.0 |
| 2002-07-16 15:30:00 | SPY | ETF | 90.54 | 90.78 | 90.03 | 90.57 | 4688700.0 |
| 2002-07-16 16:00:00 | SPY | ETF | 90.45 | 90.72 | 90.36 | 90.56 | 1271800.0 |
| 2002-07-16 09:30:00 | QQQ | ETF | 25.25 | 25.55 | 25.2 | 25.3 | 18983800.0 |
| 2002-07-16 10:00:00 | QQQ | ETF | 25.28 | 25.45 | 25.05 | 25.19 | 11938200.0 |
| 2002-07-16 10:30:00 | QQQ | ETF | 25.19 | 25.8 | 25.15 | 25.76 | 14094900.0 |
| 2002-07-16 11:00:00 | QQQ | ETF | 25.79 | 26.02 | 25.6 | 25.62 | 17086500.0 |
| 2002-07-16 11:30:00 | QQQ | ETF | 25.63 | 25.9 | 25.47 | 25.87 | 9489000.0 |
| 2002-07-16 12:00:00 | QQQ | ETF | 25.87 | 26.0 | 25.73 | 25.92 | 7747300.0 |
| 2002-07-16 12:30:00 | QQQ | ETF | 25.91 | 26.01 | 25.76 | 25.92 | 6542200.0 |
| 2002-07-16 13:00:00 | QQQ | ETF | 25.95 | 25.99 | 25.6 | 25.65 | 6976600.0 |
| 2002-07-16 13:30:00 | QQQ | ETF | 25.65 | 25.81 | 25.34 | 25.38 | 10470800.0 |
| 2002-07-16 14:00:00 | QQQ | ETF | 25.39 | 25.55 | 25.28 | 25.48 | 7158600.0 |
| 2002-07-16 14:30:00 | QQQ | ETF | 25.49 | 25.65 | 25.36 | 25.47 | 5307500.0 |
| 2002-07-16 15:00:00 | QQQ | ETF | 25.46 | 25.49 | 25.01 | 25.06 | 10726000.0 |
| 2002-07-16 15:30:00 | QQQ | ETF | 25.05 | 25.24 | 24.9 | 25.17 | 10977300.0 |
| 2002-07-16 16:00:00 | QQQ | ETF | 25.17 | 25.3 | 25.1 | 25.19 | 1265900.0 |
| 2002-07-16 09:30:00 | IWM | ETF | 40.475 | 40.75 | 40.475 | 40.53 | 113000.0 |
| 2002-07-16 10:00:00 | IWM | ETF | 40.605 | 40.605 | 40.3 | 40.545 | 122400.0 |
| 2002-07-16 10:30:00 | IWM | ETF | 40.475 | 40.825 | 40.35 | 40.825 | 224200.0 |
| 2002-07-16 11:00:00 | IWM | ETF | 40.765 | 41.065 | 40.765 | 41.0 | 732800.0 |
| 2002-07-16 11:30:00 | IWM | ETF | 40.925 | 41.065 | 40.84 | 41.045 | 169800.0 |
| 2002-07-16 12:00:00 | IWM | ETF | 41.085 | 41.2 | 41.025 | 41.135 | 86400.0 |
| 2002-07-16 12:30:00 | IWM | ETF | 41.125 | 41.215 | 41.095 | 41.155 | 47800.0 |
| 2002-07-16 13:00:00 | IWM | ETF | 41.205 | 41.25 | 41.0 | 41.0 | 148800.0 |
| 2002-07-16 13:30:00 | IWM | ETF | 41.04 | 41.19 | 40.865 | 40.865 | 85000.0 |
| 2002-07-16 14:00:00 | IWM | ETF | 40.875 | 40.955 | 40.84 | 40.9 | 51000.0 |
| 2002-07-16 14:30:00 | IWM | ETF | 40.9 | 41.01 | 40.875 | 40.925 | 48800.0 |
| 2002-07-16 15:00:00 | IWM | ETF | 40.9 | 40.955 | 40.35 | 40.395 | 319400.0 |
| 2002-07-16 15:30:00 | IWM | ETF | 40.395 | 40.57 | 40.22 | 40.57 | 267000.0 |
| 2002-07-16 16:00:00 | IWM | ETF | 40.475 | 40.5 | 40.475 | 40.5 | 30200.0 |
| 2002-07-16 09:30:00 | DIA | ETF | 85.5 | 86.0 | 84.9 | 85.29 | 2225900.0 |
| 2002-07-16 10:00:00 | DIA | ETF | 85.32 | 85.64 | 84.35 | 84.39 | 1262300.0 |
| 2002-07-16 10:30:00 | DIA | ETF | 84.38 | 85.53 | 84.16 | 85.5 | 1160400.0 |
| 2002-07-16 11:00:00 | DIA | ETF | 85.5 | 86.56 | 85.38 | 85.5 | 1054300.0 |
| 2002-07-16 11:30:00 | DIA | ETF | 85.54 | 86.27 | 85.3 | 86.25 | 512000.0 |
| 2002-07-16 12:00:00 | DIA | ETF | 86.23 | 86.48 | 85.63 | 86.1 | 463700.0 |
| 2002-07-16 12:30:00 | DIA | ETF | 86.1 | 86.5 | 85.72 | 86.35 | 619600.0 |
| 2002-07-16 13:00:00 | DIA | ETF | 86.21 | 86.5 | 85.55 | 85.84 | 694000.0 |
> showing 50 of 522 rows — these rows as CSV