PREVIEW / etf_30min / 2003-01-30
file: by_date/etf_30min/2003/2003-01-30.parquet size: 22 KB rows: 627
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-01-30 08:00:00 | SPY | ETF | 86.7 | 86.8 | 86.65 | 86.8 | 14100.0 |
| 2003-01-30 08:30:00 | SPY | ETF | 86.7 | 87.1 | 86.4 | 87.0 | 54000.0 |
| 2003-01-30 09:00:00 | SPY | ETF | 87.0 | 87.05 | 86.8 | 86.8 | 22900.0 |
| 2003-01-30 09:30:00 | SPY | ETF | 86.79 | 86.88 | 86.25 | 86.26 | 4892900.0 |
| 2003-01-30 10:00:00 | SPY | ETF | 86.26 | 86.7 | 86.04 | 86.6 | 3584000.0 |
| 2003-01-30 10:30:00 | SPY | ETF | 86.61 | 86.87 | 86.2 | 86.35 | 3422500.0 |
| 2003-01-30 11:00:00 | SPY | ETF | 86.35 | 86.44 | 86.04 | 86.3 | 2295000.0 |
| 2003-01-30 11:30:00 | SPY | ETF | 86.3 | 86.4 | 85.76 | 85.8 | 2502100.0 |
| 2003-01-30 12:00:00 | SPY | ETF | 85.78 | 85.84 | 85.58 | 85.82 | 3945200.0 |
| 2003-01-30 12:30:00 | SPY | ETF | 85.79 | 85.98 | 85.56 | 85.89 | 2723900.0 |
| 2003-01-30 13:00:00 | SPY | ETF | 85.91 | 85.98 | 85.78 | 85.88 | 1214400.0 |
| 2003-01-30 13:30:00 | SPY | ETF | 85.88 | 85.97 | 85.66 | 85.77 | 1450600.0 |
| 2003-01-30 14:00:00 | SPY | ETF | 85.76 | 85.88 | 85.44 | 85.48 | 1867400.0 |
| 2003-01-30 14:30:00 | SPY | ETF | 85.51 | 85.57 | 85.27 | 85.36 | 2730800.0 |
| 2003-01-30 15:00:00 | SPY | ETF | 85.32 | 85.45 | 84.88 | 84.93 | 4450200.0 |
| 2003-01-30 15:30:00 | SPY | ETF | 84.94 | 85.0 | 84.63 | 84.77 | 4528800.0 |
| 2003-01-30 16:00:00 | SPY | ETF | 84.77 | 84.85 | 84.38 | 84.4 | 2662700.0 |
| 2003-01-30 16:30:00 | SPY | ETF | 84.39 | 84.5 | 84.2 | 84.3 | 139700.0 |
| 2003-01-30 17:00:00 | SPY | ETF | 84.3 | 84.3 | 84.22 | 84.23 | 137400.0 |
| 2003-01-30 17:30:00 | SPY | ETF | 84.2 | 84.72 | 84.14 | 84.72 | 17200.0 |
| 2003-01-30 18:00:00 | SPY | ETF | 84.18 | 84.32 | 84.15 | 84.32 | 13600.0 |
| 2003-01-30 18:30:00 | SPY | ETF | 84.24 | 84.34 | 84.24 | 84.34 | 300.0 |
| 2003-01-30 19:00:00 | SPY | ETF | 84.22 | 84.31 | 84.22 | 84.31 | 200.0 |
| 2003-01-30 19:30:00 | SPY | ETF | 84.3 | 84.39 | 84.25 | 84.39 | 2200.0 |
| 2003-01-30 08:00:00 | QQQ | ETF | 25.35 | 25.35 | 25.26 | 25.31 | 31800.0 |
| 2003-01-30 08:30:00 | QQQ | ETF | 25.28 | 25.48 | 25.16 | 25.43 | 116300.0 |
| 2003-01-30 09:00:00 | QQQ | ETF | 25.45 | 25.45 | 25.35 | 25.35 | 31700.0 |
| 2003-01-30 09:30:00 | QQQ | ETF | 25.32 | 25.38 | 25.02 | 25.2 | 8593500.0 |
| 2003-01-30 10:00:00 | QQQ | ETF | 25.2 | 25.37 | 25.08 | 25.28 | 5616100.0 |
| 2003-01-30 10:30:00 | QQQ | ETF | 25.32 | 25.42 | 25.13 | 25.19 | 5147000.0 |
| 2003-01-30 11:00:00 | QQQ | ETF | 25.18 | 25.23 | 25.07 | 25.15 | 3440600.0 |
| 2003-01-30 11:30:00 | QQQ | ETF | 25.15 | 25.18 | 24.89 | 24.92 | 3358400.0 |
| 2003-01-30 12:00:00 | QQQ | ETF | 24.91 | 24.95 | 24.82 | 24.94 | 4612700.0 |
| 2003-01-30 12:30:00 | QQQ | ETF | 24.94 | 25.03 | 24.83 | 25.0 | 2825400.0 |
| 2003-01-30 13:00:00 | QQQ | ETF | 24.98 | 25.01 | 24.9 | 24.97 | 1872500.0 |
| 2003-01-30 13:30:00 | QQQ | ETF | 24.99 | 24.99 | 24.86 | 24.9 | 2136300.0 |
| 2003-01-30 14:00:00 | QQQ | ETF | 24.9 | 24.96 | 24.75 | 24.76 | 4113000.0 |
| 2003-01-30 14:30:00 | QQQ | ETF | 24.76 | 24.79 | 24.67 | 24.68 | 4252600.0 |
| 2003-01-30 15:00:00 | QQQ | ETF | 24.71 | 24.74 | 24.57 | 24.62 | 5390800.0 |
| 2003-01-30 15:30:00 | QQQ | ETF | 24.62 | 24.66 | 24.49 | 24.54 | 7147400.0 |
| 2003-01-30 16:00:00 | QQQ | ETF | 24.51 | 24.56 | 24.49 | 24.49 | 1743600.0 |
| 2003-01-30 16:30:00 | QQQ | ETF | 24.49 | 24.51 | 24.38 | 24.39 | 432800.0 |
| 2003-01-30 17:00:00 | QQQ | ETF | 24.39 | 24.46 | 24.34 | 24.36 | 649700.0 |
| 2003-01-30 17:30:00 | QQQ | ETF | 24.34 | 24.37 | 24.25 | 24.3 | 124500.0 |
| 2003-01-30 18:00:00 | QQQ | ETF | 24.3 | 24.43 | 24.29 | 24.42 | 85500.0 |
| 2003-01-30 18:30:00 | QQQ | ETF | 24.39 | 24.43 | 24.37 | 24.4 | 8400.0 |
| 2003-01-30 19:00:00 | QQQ | ETF | 24.39 | 24.4 | 24.36 | 24.4 | 8800.0 |
| 2003-01-30 19:30:00 | QQQ | ETF | 24.38 | 24.43 | 24.37 | 24.41 | 7600.0 |
| 2003-01-30 20:00:00 | QQQ | ETF | 24.41 | 24.41 | 24.4 | 24.4 | 1100.0 |
| 2003-01-30 09:30:00 | IWM | ETF | 37.335 | 37.405 | 37.205 | 37.275 | 716200.0 |
> showing 50 of 627 rows — these rows as CSV