PREVIEW / etf_30min / 2003-05-14
file: by_date/etf_30min/2003/2003-05-14.parquet size: 22 KB rows: 667
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-05-14 08:00:00 | SPY | ETF | 94.98 | 95.14 | 94.98 | 95.0 | 53100.0 |
| 2003-05-14 08:30:00 | SPY | ETF | 94.96 | 95.18 | 94.85 | 95.1 | 74100.0 |
| 2003-05-14 09:00:00 | SPY | ETF | 95.08 | 95.2 | 95.08 | 95.13 | 20600.0 |
| 2003-05-14 09:30:00 | SPY | ETF | 95.09 | 95.24 | 94.5 | 94.55 | 4047200.0 |
| 2003-05-14 10:00:00 | SPY | ETF | 94.53 | 94.57 | 93.94 | 94.08 | 4755500.0 |
| 2003-05-14 10:30:00 | SPY | ETF | 94.07 | 94.35 | 94.03 | 94.11 | 1942100.0 |
| 2003-05-14 11:00:00 | SPY | ETF | 94.11 | 94.31 | 94.07 | 94.12 | 2170600.0 |
| 2003-05-14 11:30:00 | SPY | ETF | 94.11 | 94.33 | 94.07 | 94.32 | 717100.0 |
| 2003-05-14 12:00:00 | SPY | ETF | 94.31 | 94.41 | 94.23 | 94.4 | 1225200.0 |
| 2003-05-14 12:30:00 | SPY | ETF | 94.41 | 94.46 | 94.28 | 94.31 | 643900.0 |
| 2003-05-14 13:00:00 | SPY | ETF | 94.3 | 94.43 | 94.18 | 94.41 | 804900.0 |
| 2003-05-14 13:30:00 | SPY | ETF | 94.43 | 94.56 | 94.32 | 94.34 | 1295500.0 |
| 2003-05-14 14:00:00 | SPY | ETF | 94.34 | 94.39 | 94.06 | 94.08 | 1684400.0 |
| 2003-05-14 14:30:00 | SPY | ETF | 94.07 | 94.21 | 93.91 | 94.2 | 2532300.0 |
| 2003-05-14 15:00:00 | SPY | ETF | 94.2 | 94.39 | 94.02 | 94.3 | 1520900.0 |
| 2003-05-14 15:30:00 | SPY | ETF | 94.3 | 94.5 | 94.24 | 94.36 | 2590900.0 |
| 2003-05-14 16:00:00 | SPY | ETF | 94.35 | 94.55 | 94.33 | 94.45 | 1034200.0 |
| 2003-05-14 16:30:00 | SPY | ETF | 94.44 | 94.5 | 94.44 | 94.45 | 32500.0 |
| 2003-05-14 17:00:00 | SPY | ETF | 94.46 | 94.47 | 94.41 | 94.45 | 32600.0 |
| 2003-05-14 17:30:00 | SPY | ETF | 94.43 | 94.43 | 94.43 | 94.43 | 4700.0 |
| 2003-05-14 18:00:00 | SPY | ETF | 94.44 | 94.49 | 94.44 | 94.49 | 500.0 |
| 2003-05-14 18:30:00 | SPY | ETF | 94.45 | 94.45 | 94.42 | 94.42 | 2100.0 |
| 2003-05-14 19:00:00 | SPY | ETF | 94.43 | 94.43 | 94.43 | 94.43 | 1000.0 |
| 2003-05-14 19:30:00 | SPY | ETF | 94.49 | 94.5 | 94.42 | 94.5 | 1500.0 |
| 2003-05-14 08:00:00 | QQQ | ETF | 28.79 | 28.84 | 28.77 | 28.78 | 59800.0 |
| 2003-05-14 08:30:00 | QQQ | ETF | 28.79 | 28.89 | 28.7 | 28.84 | 145300.0 |
| 2003-05-14 09:00:00 | QQQ | ETF | 28.84 | 28.89 | 28.84 | 28.86 | 64200.0 |
| 2003-05-14 09:30:00 | QQQ | ETF | 28.87 | 28.97 | 28.59 | 28.65 | 10878900.0 |
| 2003-05-14 10:00:00 | QQQ | ETF | 28.65 | 28.67 | 28.38 | 28.46 | 11166700.0 |
| 2003-05-14 10:30:00 | QQQ | ETF | 28.45 | 28.52 | 28.36 | 28.36 | 5911600.0 |
| 2003-05-14 11:00:00 | QQQ | ETF | 28.37 | 28.45 | 28.36 | 28.38 | 3765300.0 |
| 2003-05-14 11:30:00 | QQQ | ETF | 28.37 | 28.5 | 28.36 | 28.49 | 2905500.0 |
| 2003-05-14 12:00:00 | QQQ | ETF | 28.49 | 28.55 | 28.48 | 28.53 | 3480500.0 |
| 2003-05-14 12:30:00 | QQQ | ETF | 28.52 | 28.55 | 28.46 | 28.49 | 901300.0 |
| 2003-05-14 13:00:00 | QQQ | ETF | 28.49 | 28.5 | 28.44 | 28.5 | 833000.0 |
| 2003-05-14 13:30:00 | QQQ | ETF | 28.51 | 28.58 | 28.49 | 28.5 | 1917300.0 |
| 2003-05-14 14:00:00 | QQQ | ETF | 28.52 | 28.55 | 28.42 | 28.43 | 1701300.0 |
| 2003-05-14 14:30:00 | QQQ | ETF | 28.42 | 28.5 | 28.38 | 28.48 | 1796300.0 |
| 2003-05-14 15:00:00 | QQQ | ETF | 28.47 | 28.58 | 28.4 | 28.54 | 2182400.0 |
| 2003-05-14 15:30:00 | QQQ | ETF | 28.53 | 28.63 | 28.49 | 28.55 | 3270800.0 |
| 2003-05-14 16:00:00 | QQQ | ETF | 28.53 | 28.62 | 28.4 | 28.59 | 1710700.0 |
| 2003-05-14 16:30:00 | QQQ | ETF | 28.59 | 28.64 | 28.59 | 28.61 | 654500.0 |
| 2003-05-14 17:00:00 | QQQ | ETF | 28.62 | 28.63 | 28.58 | 28.61 | 388200.0 |
| 2003-05-14 17:30:00 | QQQ | ETF | 28.6 | 28.61 | 28.59 | 28.59 | 8500.0 |
| 2003-05-14 18:00:00 | QQQ | ETF | 28.59 | 28.62 | 28.59 | 28.62 | 35400.0 |
| 2003-05-14 18:30:00 | QQQ | ETF | 28.62 | 28.64 | 28.62 | 28.62 | 10200.0 |
| 2003-05-14 19:00:00 | QQQ | ETF | 28.63 | 28.65 | 28.62 | 28.63 | 14400.0 |
| 2003-05-14 19:30:00 | QQQ | ETF | 28.65 | 28.67 | 28.62 | 28.64 | 9700.0 |
| 2003-05-14 09:30:00 | IWM | ETF | 42.045 | 42.05 | 41.84 | 41.84 | 623400.0 |
| 2003-05-14 10:00:00 | IWM | ETF | 41.82 | 41.83 | 41.705 | 41.74 | 421600.0 |
> showing 50 of 667 rows — these rows as CSV