PREVIEW / etf_30min / 2003-08-26
file: by_date/etf_30min/2003/2003-08-26.parquet size: 24 KB rows: 718
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-26 08:00:00 | SPY | ETF | 99.62 | 99.73 | 99.62 | 99.73 | 3700.0 |
| 2003-08-26 08:30:00 | SPY | ETF | 99.74 | 99.8 | 99.55 | 99.6 | 37600.0 |
| 2003-08-26 09:00:00 | SPY | ETF | 99.59 | 99.61 | 99.46 | 99.52 | 61500.0 |
| 2003-08-26 09:30:00 | SPY | ETF | 99.5 | 99.774 | 99.49 | 99.721 | 3153200.0 |
| 2003-08-26 10:00:00 | SPY | ETF | 99.7 | 99.91 | 98.83 | 98.97 | 7237100.0 |
| 2003-08-26 10:30:00 | SPY | ETF | 98.96 | 99.15 | 98.86 | 99.12 | 3568000.0 |
| 2003-08-26 11:00:00 | SPY | ETF | 99.09 | 99.18 | 98.99 | 99.12 | 1535200.0 |
| 2003-08-26 11:30:00 | SPY | ETF | 99.07 | 99.16 | 98.97 | 99.12 | 875700.0 |
| 2003-08-26 12:00:00 | SPY | ETF | 99.12 | 99.2 | 99.04 | 99.1 | 1308000.0 |
| 2003-08-26 12:30:00 | SPY | ETF | 99.09 | 99.14 | 99.02 | 99.05 | 697800.0 |
| 2003-08-26 13:00:00 | SPY | ETF | 99.03 | 99.14 | 98.97 | 99.09 | 868900.0 |
| 2003-08-26 13:30:00 | SPY | ETF | 99.08 | 99.33 | 98.99 | 99.25 | 1674700.0 |
| 2003-08-26 14:00:00 | SPY | ETF | 99.23 | 99.76 | 99.21 | 99.63 | 4049500.0 |
| 2003-08-26 14:30:00 | SPY | ETF | 99.61 | 99.88 | 99.5 | 99.85 | 2891000.0 |
| 2003-08-26 15:00:00 | SPY | ETF | 99.86 | 100.39 | 99.83 | 100.18 | 5790600.0 |
| 2003-08-26 15:30:00 | SPY | ETF | 100.17 | 100.33 | 100.04 | 100.18 | 3208100.0 |
| 2003-08-26 16:00:00 | SPY | ETF | 100.19 | 100.23 | 99.97 | 100.02 | 1416800.0 |
| 2003-08-26 16:30:00 | SPY | ETF | 100.05 | 100.2 | 100.05 | 100.13 | 94200.0 |
| 2003-08-26 17:00:00 | SPY | ETF | 100.13 | 100.18 | 100.13 | 100.18 | 45200.0 |
| 2003-08-26 17:30:00 | SPY | ETF | 100.15 | 100.19 | 100.15 | 100.19 | 5500.0 |
| 2003-08-26 18:00:00 | SPY | ETF | 100.19 | 100.2 | 100.19 | 100.2 | 4500.0 |
| 2003-08-26 18:30:00 | SPY | ETF | 100.21 | 100.21 | 100.21 | 100.21 | 700.0 |
| 2003-08-26 19:00:00 | SPY | ETF | 100.18 | 100.18 | 100.11 | 100.11 | 6300.0 |
| 2003-08-26 19:30:00 | SPY | ETF | 100.18 | 100.19 | 100.18 | 100.19 | 1200.0 |
| 2003-08-26 08:00:00 | QQQ | ETF | 32.35 | 32.37 | 32.33 | 32.33 | 18800.0 |
| 2003-08-26 08:30:00 | QQQ | ETF | 32.37 | 32.5 | 32.29 | 32.31 | 97400.0 |
| 2003-08-26 09:00:00 | QQQ | ETF | 32.31 | 32.33 | 32.27 | 32.29 | 92800.0 |
| 2003-08-26 09:30:00 | QQQ | ETF | 32.28 | 32.4 | 32.16 | 32.22 | 6722400.0 |
| 2003-08-26 10:00:00 | QQQ | ETF | 32.227 | 32.311 | 31.81 | 31.91 | 13846700.0 |
| 2003-08-26 10:30:00 | QQQ | ETF | 31.91 | 32.01 | 31.87 | 31.97 | 6859400.0 |
| 2003-08-26 11:00:00 | QQQ | ETF | 31.97 | 32.04 | 31.9 | 31.97 | 4321100.0 |
| 2003-08-26 11:30:00 | QQQ | ETF | 31.971 | 32.01 | 31.92 | 31.99 | 1978100.0 |
| 2003-08-26 12:00:00 | QQQ | ETF | 31.98 | 32.01 | 31.94 | 31.978 | 2283000.0 |
| 2003-08-26 12:30:00 | QQQ | ETF | 31.98 | 31.98 | 31.92 | 31.94 | 1221300.0 |
| 2003-08-26 13:00:00 | QQQ | ETF | 31.93 | 31.99 | 31.89 | 31.95 | 1899200.0 |
| 2003-08-26 13:30:00 | QQQ | ETF | 31.94 | 32.04 | 31.91 | 31.99 | 1952100.0 |
| 2003-08-26 14:00:00 | QQQ | ETF | 32.0 | 32.25 | 31.977 | 32.19 | 5885500.0 |
| 2003-08-26 14:30:00 | QQQ | ETF | 32.19 | 32.3 | 32.159 | 32.29 | 5053600.0 |
| 2003-08-26 15:00:00 | QQQ | ETF | 32.29 | 32.58 | 32.27 | 32.44 | 13182600.0 |
| 2003-08-26 15:30:00 | QQQ | ETF | 32.44 | 32.59 | 32.39 | 32.51 | 4873500.0 |
| 2003-08-26 16:00:00 | QQQ | ETF | 32.51 | 32.56 | 32.48 | 32.49 | 1143200.0 |
| 2003-08-26 16:30:00 | QQQ | ETF | 32.49 | 32.54 | 32.4 | 32.54 | 94000.0 |
| 2003-08-26 17:00:00 | QQQ | ETF | 32.53 | 32.56 | 32.52 | 32.53 | 56500.0 |
| 2003-08-26 17:30:00 | QQQ | ETF | 32.53 | 32.564 | 32.53 | 32.54 | 55000.0 |
| 2003-08-26 18:00:00 | QQQ | ETF | 32.53 | 32.57 | 32.53 | 32.57 | 12800.0 |
| 2003-08-26 18:30:00 | QQQ | ETF | 32.53 | 32.53 | 32.53 | 32.53 | 1500.0 |
| 2003-08-26 19:00:00 | QQQ | ETF | 32.54 | 32.55 | 32.54 | 32.54 | 3200.0 |
| 2003-08-26 19:30:00 | QQQ | ETF | 32.54 | 32.57 | 32.53 | 32.57 | 8000.0 |
| 2003-08-26 09:30:00 | IWM | ETF | 48.16 | 48.23 | 48.075 | 48.1 | 422000.0 |
| 2003-08-26 10:00:00 | IWM | ETF | 48.105 | 48.15 | 47.625 | 47.625 | 789400.0 |
> showing 50 of 718 rows — these rows as CSV