PREVIEW / etf_30min / 2005-03-08
file: by_date/etf_30min/2005/2005-03-08.parquet size: 42 KB rows: 1,489
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-08 08:00:00 | SPY | ETF | 122.65 | 122.72 | 122.65 | 122.71 | 8800.0 |
| 2005-03-08 08:30:00 | SPY | ETF | 122.65 | 122.72 | 122.65 | 122.71 | 11100.0 |
| 2005-03-08 09:00:00 | SPY | ETF | 122.72 | 122.73 | 122.62 | 122.64 | 51700.0 |
| 2005-03-08 09:30:00 | SPY | ETF | 122.67 | 123.0 | 122.58 | 122.59 | 5479300.0 |
| 2005-03-08 10:00:00 | SPY | ETF | 122.59 | 122.61 | 122.34 | 122.41 | 5041800.0 |
| 2005-03-08 10:30:00 | SPY | ETF | 122.41 | 122.63 | 122.31 | 122.51 | 3613500.0 |
| 2005-03-08 11:00:00 | SPY | ETF | 122.51 | 122.59 | 122.39 | 122.48 | 2825400.0 |
| 2005-03-08 11:30:00 | SPY | ETF | 122.48 | 122.63 | 122.45 | 122.5 | 1902600.0 |
| 2005-03-08 12:00:00 | SPY | ETF | 122.5 | 122.55 | 122.39 | 122.51 | 2124800.0 |
| 2005-03-08 12:30:00 | SPY | ETF | 122.51 | 122.58 | 122.4 | 122.48 | 1505600.0 |
| 2005-03-08 13:00:00 | SPY | ETF | 122.48 | 122.74 | 122.47 | 122.61 | 2659100.0 |
| 2005-03-08 13:30:00 | SPY | ETF | 122.6 | 122.73 | 122.35 | 122.39 | 2865400.0 |
| 2005-03-08 14:00:00 | SPY | ETF | 122.4 | 122.59 | 122.36 | 122.57 | 1679000.0 |
| 2005-03-08 14:30:00 | SPY | ETF | 122.58 | 122.66 | 122.41 | 122.55 | 1989700.0 |
| 2005-03-08 15:00:00 | SPY | ETF | 122.55 | 122.55 | 122.4 | 122.44 | 1035800.0 |
| 2005-03-08 15:30:00 | SPY | ETF | 122.44 | 122.53 | 122.11 | 122.2 | 10011900.0 |
| 2005-03-08 16:00:00 | SPY | ETF | 122.22 | 122.42 | 122.2 | 122.34 | 421700.0 |
| 2005-03-08 16:30:00 | SPY | ETF | 122.35 | 122.37 | 122.3 | 122.31 | 30300.0 |
| 2005-03-08 17:00:00 | SPY | ETF | 122.34 | 122.34 | 122.27 | 122.27 | 46700.0 |
| 2005-03-08 17:30:00 | SPY | ETF | 122.29 | 122.32 | 122.28 | 122.32 | 700.0 |
| 2005-03-08 18:00:00 | SPY | ETF | 122.31 | 122.33 | 122.26 | 122.28 | 6400.0 |
| 2005-03-08 18:30:00 | SPY | ETF | 122.27 | 122.27 | 122.27 | 122.27 | 500.0 |
| 2005-03-08 19:00:00 | SPY | ETF | 122.27 | 122.27 | 122.26 | 122.26 | 1300.0 |
| 2005-03-08 19:30:00 | SPY | ETF | 122.3 | 122.31 | 122.3 | 122.31 | 1300.0 |
| 2005-03-08 09:30:00 | QQQ | ETF | 37.98 | 38.21 | 37.95 | 38.05 | 12952500.0 |
| 2005-03-08 10:00:00 | QQQ | ETF | 38.06 | 38.08 | 37.9 | 37.92 | 11206700.0 |
| 2005-03-08 10:30:00 | QQQ | ETF | 37.92 | 37.98 | 37.86 | 37.92 | 7131100.0 |
| 2005-03-08 11:00:00 | QQQ | ETF | 37.92 | 37.93 | 37.8 | 37.84 | 5839000.0 |
| 2005-03-08 11:30:00 | QQQ | ETF | 37.84 | 37.92 | 37.82 | 37.86 | 3216900.0 |
| 2005-03-08 12:00:00 | QQQ | ETF | 37.86 | 37.91 | 37.82 | 37.89 | 2652500.0 |
| 2005-03-08 12:30:00 | QQQ | ETF | 37.9 | 37.91 | 37.83 | 37.86 | 3060600.0 |
| 2005-03-08 13:00:00 | QQQ | ETF | 37.86 | 37.97 | 37.85 | 37.9 | 4529900.0 |
| 2005-03-08 13:30:00 | QQQ | ETF | 37.91 | 37.94 | 37.75 | 37.76 | 5086200.0 |
| 2005-03-08 14:00:00 | QQQ | ETF | 37.76 | 37.9 | 37.74 | 37.86 | 4931300.0 |
| 2005-03-08 14:30:00 | QQQ | ETF | 37.87 | 37.92 | 37.8 | 37.84 | 3536700.0 |
| 2005-03-08 15:00:00 | QQQ | ETF | 37.85 | 37.85 | 37.76 | 37.77 | 2922700.0 |
| 2005-03-08 15:30:00 | QQQ | ETF | 37.77 | 37.77 | 37.65 | 37.69 | 10859100.0 |
| 2005-03-08 08:30:00 | IWM | ETF | 64.15 | 64.17 | 64.13 | 64.17 | 14200.0 |
| 2005-03-08 09:00:00 | IWM | ETF | 64.12 | 64.14 | 64.1 | 64.1 | 9800.0 |
| 2005-03-08 09:30:00 | IWM | ETF | 64.19 | 64.335 | 64.06 | 64.06 | 943800.0 |
| 2005-03-08 10:00:00 | IWM | ETF | 64.06 | 64.075 | 63.825 | 63.92 | 1809800.0 |
| 2005-03-08 10:30:00 | IWM | ETF | 63.92 | 64.05 | 63.84 | 63.895 | 998200.0 |
| 2005-03-08 11:00:00 | IWM | ETF | 63.895 | 63.9 | 63.65 | 63.7 | 1441400.0 |
| 2005-03-08 11:30:00 | IWM | ETF | 63.695 | 63.85 | 63.675 | 63.78 | 632400.0 |
| 2005-03-08 12:00:00 | IWM | ETF | 63.78 | 63.835 | 63.72 | 63.83 | 832200.0 |
| 2005-03-08 12:30:00 | IWM | ETF | 63.825 | 63.91 | 63.755 | 63.8 | 385400.0 |
| 2005-03-08 13:00:00 | IWM | ETF | 63.795 | 63.96 | 63.795 | 63.92 | 892400.0 |
| 2005-03-08 13:30:00 | IWM | ETF | 63.92 | 63.96 | 63.745 | 63.79 | 954400.0 |
| 2005-03-08 14:00:00 | IWM | ETF | 63.8 | 63.94 | 63.74 | 63.89 | 652800.0 |
| 2005-03-08 14:30:00 | IWM | ETF | 63.895 | 64.02 | 63.78 | 63.86 | 383800.0 |
> showing 50 of 1,489 rows — these rows as CSV