PREVIEW / etf_30min / 2006-02-27
file: by_date/etf_30min/2006/2006-02-27.parquet size: 59 KB rows: 2,198
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-02-27 05:30:00 | SPY | ETF | 129.49 | 129.49 | 129.49 | 129.49 | 25000.0 |
| 2006-02-27 06:30:00 | SPY | ETF | 129.41 | 129.41 | 129.39 | 129.39 | 50000.0 |
| 2006-02-27 07:00:00 | SPY | ETF | 129.36 | 129.36 | 129.36 | 129.36 | 2000.0 |
| 2006-02-27 07:30:00 | SPY | ETF | 129.38 | 129.38 | 129.32 | 129.32 | 13000.0 |
| 2006-02-27 08:00:00 | SPY | ETF | 129.35 | 129.41 | 129.33 | 129.41 | 47800.0 |
| 2006-02-27 08:30:00 | SPY | ETF | 129.41 | 129.51 | 129.41 | 129.49 | 151300.0 |
| 2006-02-27 09:00:00 | SPY | ETF | 129.48 | 129.49 | 129.25 | 129.41 | 535600.0 |
| 2006-02-27 09:30:00 | SPY | ETF | 129.4 | 129.71 | 129.28 | 129.68 | 6404100.0 |
| 2006-02-27 10:00:00 | SPY | ETF | 129.67 | 129.85 | 129.41 | 129.57 | 4330100.0 |
| 2006-02-27 10:30:00 | SPY | ETF | 129.57 | 129.61 | 129.48 | 129.55 | 1091800.0 |
| 2006-02-27 11:00:00 | SPY | ETF | 129.55 | 129.93 | 129.52 | 129.9 | 3973100.0 |
| 2006-02-27 11:30:00 | SPY | ETF | 129.89 | 129.94 | 129.79 | 129.84 | 1454000.0 |
| 2006-02-27 12:00:00 | SPY | ETF | 129.84 | 129.9 | 129.8 | 129.88 | 1163100.0 |
| 2006-02-27 12:30:00 | SPY | ETF | 129.88 | 129.89 | 129.77 | 129.83 | 724900.0 |
| 2006-02-27 13:00:00 | SPY | ETF | 129.84 | 129.9 | 129.77 | 129.82 | 929000.0 |
| 2006-02-27 13:30:00 | SPY | ETF | 129.83 | 129.9 | 129.8 | 129.87 | 436300.0 |
| 2006-02-27 14:00:00 | SPY | ETF | 129.88 | 129.98 | 129.67 | 129.84 | 2327000.0 |
| 2006-02-27 14:30:00 | SPY | ETF | 129.83 | 129.97 | 129.81 | 129.93 | 1698500.0 |
| 2006-02-27 15:00:00 | SPY | ETF | 129.93 | 130.04 | 129.89 | 129.95 | 2621400.0 |
| 2006-02-27 15:30:00 | SPY | ETF | 129.95 | 130.04 | 129.63 | 129.69 | 5535700.0 |
| 2006-02-27 16:00:00 | SPY | ETF | 129.68 | 129.7467 | 129.44 | 129.46 | 725400.0 |
| 2006-02-27 16:30:00 | SPY | ETF | 129.49 | 129.64 | 129.49 | 129.64 | 101800.0 |
| 2006-02-27 17:00:00 | SPY | ETF | 129.54 | 129.58 | 129.54 | 129.58 | 58000.0 |
| 2006-02-27 17:30:00 | SPY | ETF | 129.53 | 129.53 | 129.53 | 129.53 | 500.0 |
| 2006-02-27 18:00:00 | SPY | ETF | 129.55 | 129.6 | 129.55 | 129.59 | 21400.0 |
| 2006-02-27 19:30:00 | SPY | ETF | 129.53 | 129.53 | 129.48 | 129.5 | 46000.0 |
| 2006-02-27 09:30:00 | QQQ | ETF | 41.37 | 41.51 | 41.33 | 41.5 | 10095900.0 |
| 2006-02-27 10:00:00 | QQQ | ETF | 41.51 | 41.59 | 41.4 | 41.49 | 5899100.0 |
| 2006-02-27 10:30:00 | QQQ | ETF | 41.49 | 41.57 | 41.48 | 41.5 | 3482500.0 |
| 2006-02-27 11:00:00 | QQQ | ETF | 41.51 | 41.81 | 41.5 | 41.79 | 8636200.0 |
| 2006-02-27 11:30:00 | QQQ | ETF | 41.78 | 41.86 | 41.76 | 41.79 | 5590500.0 |
| 2006-02-27 12:00:00 | QQQ | ETF | 41.79 | 41.82 | 41.77 | 41.79 | 2188000.0 |
| 2006-02-27 12:30:00 | QQQ | ETF | 41.78 | 41.79 | 41.74 | 41.77 | 2668200.0 |
| 2006-02-27 13:00:00 | QQQ | ETF | 41.76 | 41.8 | 41.75 | 41.76 | 1815700.0 |
| 2006-02-27 13:30:00 | QQQ | ETF | 41.76 | 41.8 | 41.76 | 41.78 | 1221000.0 |
| 2006-02-27 14:00:00 | QQQ | ETF | 41.79 | 41.85 | 41.72 | 41.79 | 3541400.0 |
| 2006-02-27 14:30:00 | QQQ | ETF | 41.79 | 41.84 | 41.76 | 41.8 | 3944600.0 |
| 2006-02-27 15:00:00 | QQQ | ETF | 41.81 | 41.87 | 41.79 | 41.79 | 3606000.0 |
| 2006-02-27 15:30:00 | QQQ | ETF | 41.8 | 41.83 | 41.67 | 41.72 | 7961400.0 |
| 2006-02-27 08:00:00 | IWM | ETF | 73.42 | 73.42 | 73.42 | 73.42 | 10000.0 |
| 2006-02-27 08:30:00 | IWM | ETF | 73.47 | 73.48 | 73.45 | 73.46 | 6800.0 |
| 2006-02-27 09:00:00 | IWM | ETF | 73.45 | 73.45 | 73.37 | 73.38 | 15000.0 |
| 2006-02-27 09:30:00 | IWM | ETF | 73.41 | 73.63 | 73.33 | 73.57 | 3838200.0 |
| 2006-02-27 10:00:00 | IWM | ETF | 73.56 | 73.66 | 73.32 | 73.51 | 1897200.0 |
| 2006-02-27 10:30:00 | IWM | ETF | 73.51 | 73.58 | 73.37 | 73.41 | 1071800.0 |
| 2006-02-27 11:00:00 | IWM | ETF | 73.4 | 73.83 | 73.4 | 73.83 | 1971000.0 |
| 2006-02-27 11:30:00 | IWM | ETF | 73.83 | 73.88 | 73.67 | 73.72 | 1840900.0 |
| 2006-02-27 12:00:00 | IWM | ETF | 73.71 | 73.76 | 73.64 | 73.73 | 1208300.0 |
| 2006-02-27 12:30:00 | IWM | ETF | 73.73 | 73.74 | 73.58 | 73.67 | 720100.0 |
| 2006-02-27 13:00:00 | IWM | ETF | 73.67 | 73.74 | 73.66 | 73.7001 | 623100.0 |
> showing 50 of 2,198 rows — these rows as CSV