PREVIEW / etf_30min / 2003-03-17
file: by_date/etf_30min/2003/2003-03-17.parquet size: 24 KB rows: 709
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-03-17 08:00:00 | SPY | ETF | 83.65 | 83.75 | 83.37 | 83.53 | 66600.0 |
| 2003-03-17 08:30:00 | SPY | ETF | 83.55 | 83.63 | 83.45 | 83.5 | 66500.0 |
| 2003-03-17 09:00:00 | SPY | ETF | 83.55 | 83.63 | 83.41 | 83.43 | 102300.0 |
| 2003-03-17 09:30:00 | SPY | ETF | 83.4 | 84.48 | 83.22 | 84.46 | 10956800.0 |
| 2003-03-17 10:00:00 | SPY | ETF | 84.46 | 85.0 | 83.25 | 84.91 | 9635600.0 |
| 2003-03-17 10:30:00 | SPY | ETF | 84.88 | 86.5 | 84.85 | 85.72 | 9966400.0 |
| 2003-03-17 11:00:00 | SPY | ETF | 85.68 | 86.39 | 85.61 | 85.72 | 6996300.0 |
| 2003-03-17 11:30:00 | SPY | ETF | 85.72 | 86.1 | 85.6 | 85.95 | 4483800.0 |
| 2003-03-17 12:00:00 | SPY | ETF | 85.88 | 86.24 | 85.7 | 86.15 | 4219200.0 |
| 2003-03-17 12:30:00 | SPY | ETF | 86.14 | 86.37 | 85.99 | 86.11 | 2088500.0 |
| 2003-03-17 13:00:00 | SPY | ETF | 86.12 | 86.17 | 85.81 | 85.96 | 3110900.0 |
| 2003-03-17 13:30:00 | SPY | ETF | 86.0 | 86.18 | 85.91 | 85.96 | 1739000.0 |
| 2003-03-17 14:00:00 | SPY | ETF | 85.96 | 86.54 | 85.91 | 86.41 | 5268100.0 |
| 2003-03-17 14:30:00 | SPY | ETF | 86.49 | 86.56 | 86.23 | 86.48 | 3310300.0 |
| 2003-03-17 15:00:00 | SPY | ETF | 86.5 | 86.75 | 86.29 | 86.5 | 5381300.0 |
| 2003-03-17 15:30:00 | SPY | ETF | 86.53 | 86.95 | 86.46 | 86.83 | 8060200.0 |
| 2003-03-17 16:00:00 | SPY | ETF | 86.82 | 86.91 | 86.6 | 86.62 | 4451200.0 |
| 2003-03-17 16:30:00 | SPY | ETF | 86.62 | 86.79 | 86.4 | 86.79 | 2071700.0 |
| 2003-03-17 17:00:00 | SPY | ETF | 86.79 | 86.88 | 86.79 | 86.86 | 83900.0 |
| 2003-03-17 17:30:00 | SPY | ETF | 86.85 | 86.9 | 86.79 | 86.85 | 62400.0 |
| 2003-03-17 18:00:00 | SPY | ETF | 86.86 | 86.87 | 86.84 | 86.85 | 6100.0 |
| 2003-03-17 18:30:00 | SPY | ETF | 86.92 | 86.98 | 86.86 | 86.98 | 9700.0 |
| 2003-03-17 19:00:00 | SPY | ETF | 86.92 | 86.97 | 86.83 | 86.83 | 19900.0 |
| 2003-03-17 19:30:00 | SPY | ETF | 86.8 | 86.8 | 86.75 | 86.75 | 1300.0 |
| 2003-03-17 08:00:00 | QQQ | ETF | 25.53 | 25.55 | 25.47 | 25.5 | 41000.0 |
| 2003-03-17 08:30:00 | QQQ | ETF | 25.5 | 25.51 | 25.43 | 25.45 | 80000.0 |
| 2003-03-17 09:00:00 | QQQ | ETF | 25.44 | 25.5 | 25.41 | 25.42 | 77300.0 |
| 2003-03-17 09:30:00 | QQQ | ETF | 25.43 | 25.9 | 25.35 | 25.9 | 13502200.0 |
| 2003-03-17 10:00:00 | QQQ | ETF | 25.88 | 26.17 | 25.72 | 26.13 | 16786800.0 |
| 2003-03-17 10:30:00 | QQQ | ETF | 26.12 | 26.75 | 26.03 | 26.49 | 21696100.0 |
| 2003-03-17 11:00:00 | QQQ | ETF | 26.5 | 26.78 | 26.35 | 26.38 | 17802500.0 |
| 2003-03-17 11:30:00 | QQQ | ETF | 26.38 | 26.65 | 26.35 | 26.57 | 7132600.0 |
| 2003-03-17 12:00:00 | QQQ | ETF | 26.61 | 26.63 | 26.44 | 26.58 | 7520800.0 |
| 2003-03-17 12:30:00 | QQQ | ETF | 26.59 | 26.69 | 26.38 | 26.58 | 6405500.0 |
| 2003-03-17 13:00:00 | QQQ | ETF | 26.58 | 26.58 | 26.41 | 26.49 | 5697400.0 |
| 2003-03-17 13:30:00 | QQQ | ETF | 26.53 | 26.62 | 26.48 | 26.54 | 5670900.0 |
| 2003-03-17 14:00:00 | QQQ | ETF | 26.53 | 26.74 | 26.51 | 26.73 | 5503500.0 |
| 2003-03-17 14:30:00 | QQQ | ETF | 26.72 | 26.78 | 26.6 | 26.66 | 4718800.0 |
| 2003-03-17 15:00:00 | QQQ | ETF | 26.65 | 26.76 | 26.56 | 26.66 | 6672400.0 |
| 2003-03-17 15:30:00 | QQQ | ETF | 26.65 | 26.77 | 26.61 | 26.76 | 10157600.0 |
| 2003-03-17 16:00:00 | QQQ | ETF | 26.76 | 26.8 | 26.58 | 26.6 | 3429500.0 |
| 2003-03-17 16:30:00 | QQQ | ETF | 26.6 | 26.64 | 26.6 | 26.64 | 155500.0 |
| 2003-03-17 17:00:00 | QQQ | ETF | 26.67 | 26.7 | 26.65 | 26.66 | 151800.0 |
| 2003-03-17 17:30:00 | QQQ | ETF | 26.66 | 26.69 | 26.62 | 26.65 | 97800.0 |
| 2003-03-17 18:00:00 | QQQ | ETF | 26.66 | 26.68 | 26.61 | 26.65 | 47500.0 |
| 2003-03-17 18:30:00 | QQQ | ETF | 26.65 | 26.68 | 26.64 | 26.68 | 30300.0 |
| 2003-03-17 19:00:00 | QQQ | ETF | 26.67 | 26.67 | 26.65 | 26.65 | 5300.0 |
| 2003-03-17 19:30:00 | QQQ | ETF | 26.69 | 26.69 | 26.65 | 26.67 | 7600.0 |
| 2003-03-17 09:30:00 | IWM | ETF | 35.275 | 35.495 | 35.09 | 35.495 | 409000.0 |
| 2003-03-17 10:00:00 | IWM | ETF | 35.495 | 35.63 | 35.36 | 35.63 | 246600.0 |
> showing 50 of 709 rows — these rows as CSV