PREVIEW / etf_30min / 2006-02-10
file: by_date/etf_30min/2006/2006-02-10.parquet size: 61 KB rows: 2,131
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-10 07:00:00 | SPY | ETF | 126.51 | 126.51 | 126.51 | 126.51 | 500.0 |
| 2006-02-10 07:30:00 | SPY | ETF | 126.57 | 126.57 | 126.57 | 126.57 | 2500.0 |
| 2006-02-10 08:00:00 | SPY | ETF | 126.55 | 126.67 | 126.49 | 126.49 | 266700.0 |
| 2006-02-10 08:30:00 | SPY | ETF | 126.46 | 126.63 | 126.37 | 126.42 | 416700.0 |
| 2006-02-10 09:00:00 | SPY | ETF | 126.42 | 126.46 | 126.36 | 126.44 | 193300.0 |
| 2006-02-10 09:30:00 | SPY | ETF | 126.43 | 126.6 | 126.28 | 126.5 | 5896200.0 |
| 2006-02-10 10:00:00 | SPY | ETF | 126.5 | 126.56 | 125.92 | 126.06 | 5012800.0 |
| 2006-02-10 10:30:00 | SPY | ETF | 126.06 | 126.08 | 125.58 | 125.74 | 7418900.0 |
| 2006-02-10 11:00:00 | SPY | ETF | 125.73 | 125.95 | 125.63 | 125.81 | 4817800.0 |
| 2006-02-10 11:30:00 | SPY | ETF | 125.81 | 126.1 | 125.75 | 125.95 | 3207400.0 |
| 2006-02-10 12:00:00 | SPY | ETF | 125.95 | 126.34 | 125.89 | 126.2 | 5326100.0 |
| 2006-02-10 12:30:00 | SPY | ETF | 126.2 | 126.32 | 126.02 | 126.06 | 3473700.0 |
| 2006-02-10 13:00:00 | SPY | ETF | 126.05 | 126.3 | 125.9 | 126.0 | 1893700.0 |
| 2006-02-10 13:30:00 | SPY | ETF | 126.0 | 126.28 | 125.97 | 126.28 | 2022900.0 |
| 2006-02-10 14:00:00 | SPY | ETF | 126.27 | 126.63 | 126.2 | 126.43 | 4901000.0 |
| 2006-02-10 14:30:00 | SPY | ETF | 126.45 | 126.84 | 126.41 | 126.74 | 5336000.0 |
| 2006-02-10 15:00:00 | SPY | ETF | 126.74 | 127.13 | 126.73 | 126.93 | 5978900.0 |
| 2006-02-10 15:30:00 | SPY | ETF | 126.93 | 126.96 | 126.74 | 126.82 | 3641700.0 |
| 2006-02-10 16:00:00 | SPY | ETF | 126.82 | 126.87 | 126.15 | 126.7 | 2068700.0 |
| 2006-02-10 16:30:00 | SPY | ETF | 126.7 | 126.7 | 126.63 | 126.65 | 199000.0 |
| 2006-02-10 17:00:00 | SPY | ETF | 126.64 | 126.64 | 126.61 | 126.64 | 2600.0 |
| 2006-02-10 17:30:00 | SPY | ETF | 126.62 | 126.66 | 126.59 | 126.59 | 5600.0 |
| 2006-02-10 18:00:00 | SPY | ETF | 126.57 | 126.57 | 126.57 | 126.57 | 400.0 |
| 2006-02-10 19:30:00 | SPY | ETF | 126.56 | 126.56 | 126.56 | 126.56 | 200.0 |
| 2006-02-10 09:30:00 | QQQ | ETF | 40.68 | 40.72 | 40.46 | 40.56 | 13928600.0 |
| 2006-02-10 10:00:00 | QQQ | ETF | 40.55 | 40.56 | 40.4 | 40.52 | 7815600.0 |
| 2006-02-10 10:30:00 | QQQ | ETF | 40.52 | 40.52 | 40.26 | 40.37 | 13739400.0 |
| 2006-02-10 11:00:00 | QQQ | ETF | 40.37 | 40.49 | 40.33 | 40.42 | 8351600.0 |
| 2006-02-10 11:30:00 | QQQ | ETF | 40.42 | 40.53 | 40.37 | 40.47 | 4104700.0 |
| 2006-02-10 12:00:00 | QQQ | ETF | 40.47 | 40.6 | 40.44 | 40.52 | 5119000.0 |
| 2006-02-10 12:30:00 | QQQ | ETF | 40.52 | 40.56 | 40.46 | 40.48 | 3012400.0 |
| 2006-02-10 13:00:00 | QQQ | ETF | 40.48 | 40.58 | 40.45 | 40.48 | 3252000.0 |
| 2006-02-10 13:30:00 | QQQ | ETF | 40.49 | 40.56 | 40.47 | 40.55 | 2266600.0 |
| 2006-02-10 14:00:00 | QQQ | ETF | 40.56 | 40.66 | 40.5 | 40.62 | 6995500.0 |
| 2006-02-10 14:30:00 | QQQ | ETF | 40.61 | 40.92 | 40.6 | 40.86 | 11337000.0 |
| 2006-02-10 15:00:00 | QQQ | ETF | 40.86 | 41.06 | 40.84 | 40.97 | 10101900.0 |
| 2006-02-10 15:30:00 | QQQ | ETF | 40.97 | 41.01 | 40.87 | 40.95 | 7495900.0 |
| 2006-02-10 08:00:00 | IWM | ETF | 71.32 | 71.32 | 71.32 | 71.32 | 100000.0 |
| 2006-02-10 08:30:00 | IWM | ETF | 71.25 | 71.27 | 71.25 | 71.25 | 48000.0 |
| 2006-02-10 09:00:00 | IWM | ETF | 71.27 | 71.27 | 71.19 | 71.19 | 270200.0 |
| 2006-02-10 09:30:00 | IWM | ETF | 71.18 | 71.25 | 70.67 | 70.93 | 3017200.0 |
| 2006-02-10 10:00:00 | IWM | ETF | 70.93 | 70.93 | 70.6 | 70.63 | 4232500.0 |
| 2006-02-10 10:30:00 | IWM | ETF | 70.64 | 70.64 | 70.37 | 70.52 | 3451900.0 |
| 2006-02-10 11:00:00 | IWM | ETF | 70.51 | 70.6 | 70.43 | 70.48 | 2845400.0 |
| 2006-02-10 11:30:00 | IWM | ETF | 70.48 | 70.72 | 70.44 | 70.66 | 2200000.0 |
| 2006-02-10 12:00:00 | IWM | ETF | 70.66 | 70.93 | 70.63 | 70.81 | 1059900.0 |
| 2006-02-10 12:30:00 | IWM | ETF | 70.81 | 70.82 | 70.63 | 70.64 | 848100.0 |
| 2006-02-10 13:00:00 | IWM | ETF | 70.64 | 70.77 | 70.59 | 70.62 | 1711800.0 |
| 2006-02-10 13:30:00 | IWM | ETF | 70.62 | 70.87 | 70.62 | 70.86 | 936100.0 |
| 2006-02-10 14:00:00 | IWM | ETF | 70.88 | 71.0 | 70.76 | 70.89 | 1596100.0 |
> showing 50 of 2,131 rows — these rows as CSV