PREVIEW / etf_30min / 2006-05-25
file: by_date/etf_30min/2006/2006-05-25.parquet size: 67 KB rows: 2,372
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-25 04:00:00 | SPY | ETF | 125.96 | 125.96 | 125.96 | 125.96 | 100.0 |
| 2006-05-25 05:00:00 | SPY | ETF | 126.19 | 126.19 | 126.19 | 126.19 | 100.0 |
| 2006-05-25 07:00:00 | SPY | ETF | 126.44 | 126.48 | 126.4 | 126.46 | 18800.0 |
| 2006-05-25 07:30:00 | SPY | ETF | 126.5 | 126.76 | 126.49 | 126.7 | 299900.0 |
| 2006-05-25 08:00:00 | SPY | ETF | 126.71 | 126.78 | 126.4 | 126.66 | 2084700.0 |
| 2006-05-25 08:30:00 | SPY | ETF | 126.65 | 127.04 | 126.53 | 126.9 | 2658000.0 |
| 2006-05-25 09:00:00 | SPY | ETF | 126.92 | 127.07 | 125.95 | 126.93 | 917600.0 |
| 2006-05-25 09:30:00 | SPY | ETF | 126.92 | 126.98 | 126.75 | 126.92 | 11206800.0 |
| 2006-05-25 10:00:00 | SPY | ETF | 126.91 | 126.98 | 126.43 | 126.62 | 8127500.0 |
| 2006-05-25 10:30:00 | SPY | ETF | 126.62 | 126.76 | 126.52 | 126.7 | 3944400.0 |
| 2006-05-25 11:00:00 | SPY | ETF | 126.7 | 126.84 | 126.61 | 126.81 | 2788200.0 |
| 2006-05-25 11:30:00 | SPY | ETF | 126.81 | 127.31 | 126.79 | 127.31 | 6559900.0 |
| 2006-05-25 12:00:00 | SPY | ETF | 127.29 | 127.33 | 127.0 | 127.06 | 4824400.0 |
| 2006-05-25 12:30:00 | SPY | ETF | 127.07 | 127.07 | 126.88 | 127.05 | 3235100.0 |
| 2006-05-25 13:00:00 | SPY | ETF | 127.05 | 127.08 | 126.92 | 126.97 | 1956800.0 |
| 2006-05-25 13:30:00 | SPY | ETF | 126.96 | 127.17 | 126.93 | 127.04 | 3059700.0 |
| 2006-05-25 14:00:00 | SPY | ETF | 127.02 | 127.4 | 127.0 | 127.29 | 8373100.0 |
| 2006-05-25 14:30:00 | SPY | ETF | 127.28 | 127.43 | 127.2 | 127.27 | 3472400.0 |
| 2006-05-25 15:00:00 | SPY | ETF | 127.28 | 127.4 | 127.11 | 127.32 | 3026200.0 |
| 2006-05-25 15:30:00 | SPY | ETF | 127.33 | 127.66 | 127.26 | 127.63 | 6785000.0 |
| 2006-05-25 16:00:00 | SPY | ETF | 127.63 | 127.73 | 127.55 | 127.73 | 1183600.0 |
| 2006-05-25 16:30:00 | SPY | ETF | 127.68 | 127.76 | 127.66 | 127.72 | 230000.0 |
| 2006-05-25 17:00:00 | SPY | ETF | 127.71 | 127.71 | 127.62 | 127.62 | 13100.0 |
| 2006-05-25 17:30:00 | SPY | ETF | 127.65 | 127.66 | 127.64 | 127.64 | 4700.0 |
| 2006-05-25 18:00:00 | SPY | ETF | 127.63 | 127.64 | 127.6 | 127.6 | 9700.0 |
| 2006-05-25 18:30:00 | SPY | ETF | 127.64 | 127.66 | 127.64 | 127.66 | 300.0 |
| 2006-05-25 19:00:00 | SPY | ETF | 127.62 | 127.62 | 127.62 | 127.62 | 300.0 |
| 2006-05-25 09:30:00 | QQQ | ETF | 39.08 | 39.19 | 39.03 | 39.11 | 16450800.0 |
| 2006-05-25 10:00:00 | QQQ | ETF | 39.12 | 39.14 | 38.82 | 38.89 | 17173500.0 |
| 2006-05-25 10:30:00 | QQQ | ETF | 38.89 | 38.98 | 38.83 | 38.94 | 8252700.0 |
| 2006-05-25 11:00:00 | QQQ | ETF | 38.94 | 39.02 | 38.89 | 38.98 | 3911000.0 |
| 2006-05-25 11:30:00 | QQQ | ETF | 38.97 | 39.19 | 38.97 | 39.18 | 11827900.0 |
| 2006-05-25 12:00:00 | QQQ | ETF | 39.19 | 39.22 | 39.09 | 39.11 | 10175700.0 |
| 2006-05-25 12:30:00 | QQQ | ETF | 39.1 | 39.12 | 39.0 | 39.11 | 5966800.0 |
| 2006-05-25 13:00:00 | QQQ | ETF | 39.11 | 39.13 | 39.05 | 39.07 | 2256100.0 |
| 2006-05-25 13:30:00 | QQQ | ETF | 39.08 | 39.14 | 39.06 | 39.11 | 3437800.0 |
| 2006-05-25 14:00:00 | QQQ | ETF | 39.1 | 39.24 | 39.09 | 39.17 | 7763800.0 |
| 2006-05-25 14:30:00 | QQQ | ETF | 39.17 | 39.22 | 38.18 | 39.18 | 4676200.0 |
| 2006-05-25 15:00:00 | QQQ | ETF | 39.18 | 39.27 | 39.13 | 39.25 | 6709900.0 |
| 2006-05-25 15:30:00 | QQQ | ETF | 39.25 | 39.37 | 39.23 | 39.37 | 11759300.0 |
| 2006-05-25 08:00:00 | IWM | ETF | 70.95 | 71.08 | 70.93 | 70.96 | 158200.0 |
| 2006-05-25 08:30:00 | IWM | ETF | 71.04 | 71.51 | 71.04 | 71.47 | 1207500.0 |
| 2006-05-25 09:00:00 | IWM | ETF | 71.5 | 71.56 | 71.45 | 71.45 | 703500.0 |
| 2006-05-25 09:30:00 | IWM | ETF | 71.5 | 71.74 | 71.25 | 71.61 | 11908100.0 |
| 2006-05-25 10:00:00 | IWM | ETF | 71.62 | 71.7 | 71.04 | 71.14 | 8155900.0 |
| 2006-05-25 10:30:00 | IWM | ETF | 71.14 | 71.38 | 71.09 | 71.22 | 4566600.0 |
| 2006-05-25 11:00:00 | IWM | ETF | 71.2 | 71.36 | 71.07 | 71.29 | 2139900.0 |
| 2006-05-25 11:30:00 | IWM | ETF | 71.3 | 71.85 | 71.29 | 71.84 | 5300400.0 |
| 2006-05-25 12:00:00 | IWM | ETF | 71.83 | 71.83 | 71.45 | 71.53 | 3552000.0 |
| 2006-05-25 12:30:00 | IWM | ETF | 71.54 | 71.61 | 71.37 | 71.58 | 3159200.0 |
> showing 50 of 2,372 rows — these rows as CSV