PREVIEW / etf_30min / 2006-02-06
file: by_date/etf_30min/2006/2006-02-06.parquet size: 58 KB rows: 2,125
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-06 06:30:00 | SPY | ETF | 126.6 | 126.6 | 126.59 | 126.59 | 2600.0 |
| 2006-02-06 07:00:00 | SPY | ETF | 126.6 | 126.65 | 126.6 | 126.65 | 25500.0 |
| 2006-02-06 07:30:00 | SPY | ETF | 126.47 | 126.55 | 126.45 | 126.51 | 143700.0 |
| 2006-02-06 08:00:00 | SPY | ETF | 126.5 | 126.65 | 126.04 | 126.56 | 700900.0 |
| 2006-02-06 08:30:00 | SPY | ETF | 126.49 | 126.57 | 126.49 | 126.56 | 240000.0 |
| 2006-02-06 09:00:00 | SPY | ETF | 126.54 | 126.54 | 126.43 | 126.43 | 199700.0 |
| 2006-02-06 09:30:00 | SPY | ETF | 126.44 | 126.74 | 126.41 | 126.53 | 5217900.0 |
| 2006-02-06 10:00:00 | SPY | ETF | 126.53 | 126.69 | 126.35 | 126.36 | 4606900.0 |
| 2006-02-06 10:30:00 | SPY | ETF | 126.36 | 126.63 | 126.35 | 126.53 | 4582700.0 |
| 2006-02-06 11:00:00 | SPY | ETF | 126.51 | 126.7 | 126.51 | 126.54 | 2706300.0 |
| 2006-02-06 11:30:00 | SPY | ETF | 126.54 | 126.68 | 126.52 | 126.63 | 824000.0 |
| 2006-02-06 12:00:00 | SPY | ETF | 126.62 | 126.8 | 126.44 | 126.45 | 2770200.0 |
| 2006-02-06 12:30:00 | SPY | ETF | 126.44 | 126.56 | 126.43 | 126.54 | 1102700.0 |
| 2006-02-06 13:00:00 | SPY | ETF | 126.56 | 126.64 | 126.53 | 126.59 | 811700.0 |
| 2006-02-06 13:30:00 | SPY | ETF | 126.59 | 126.68 | 126.38 | 126.48 | 1935900.0 |
| 2006-02-06 14:00:00 | SPY | ETF | 126.47 | 126.56 | 126.17 | 126.33 | 6645300.0 |
| 2006-02-06 14:30:00 | SPY | ETF | 126.34 | 126.47 | 126.31 | 126.41 | 2725500.0 |
| 2006-02-06 15:00:00 | SPY | ETF | 126.4 | 126.62 | 126.37 | 126.55 | 2832000.0 |
| 2006-02-06 15:30:00 | SPY | ETF | 126.55 | 126.73 | 126.45 | 126.56 | 5448000.0 |
| 2006-02-06 16:00:00 | SPY | ETF | 126.55 | 126.71 | 126.4802 | 126.6 | 1404100.0 |
| 2006-02-06 16:30:00 | SPY | ETF | 126.61 | 126.65 | 126.6 | 126.6 | 2600.0 |
| 2006-02-06 17:00:00 | SPY | ETF | 126.61 | 126.61 | 126.6 | 126.6 | 43500.0 |
| 2006-02-06 18:00:00 | SPY | ETF | 126.62 | 126.7 | 126.62 | 126.7 | 1500.0 |
| 2006-02-06 18:30:00 | SPY | ETF | 126.7 | 126.7 | 126.7 | 126.7 | 2100.0 |
| 2006-02-06 09:30:00 | QQQ | ETF | 40.9 | 41.01 | 40.85 | 40.88 | 7609900.0 |
| 2006-02-06 10:00:00 | QQQ | ETF | 40.88 | 40.98 | 40.75 | 40.76 | 6174700.0 |
| 2006-02-06 10:30:00 | QQQ | ETF | 40.76 | 40.88 | 40.76 | 40.83 | 5492400.0 |
| 2006-02-06 11:00:00 | QQQ | ETF | 40.82 | 40.89 | 40.82 | 40.86 | 2947200.0 |
| 2006-02-06 11:30:00 | QQQ | ETF | 40.86 | 40.92 | 40.85 | 40.9 | 2282700.0 |
| 2006-02-06 12:00:00 | QQQ | ETF | 40.9 | 40.95 | 40.82 | 40.83 | 2121500.0 |
| 2006-02-06 12:30:00 | QQQ | ETF | 40.83 | 40.85 | 40.79 | 40.82 | 2155500.0 |
| 2006-02-06 13:00:00 | QQQ | ETF | 40.82 | 40.87 | 40.81 | 40.83 | 1463900.0 |
| 2006-02-06 13:30:00 | QQQ | ETF | 40.83 | 40.86 | 40.7 | 40.75 | 3160100.0 |
| 2006-02-06 14:00:00 | QQQ | ETF | 40.76 | 40.76 | 40.59 | 40.65 | 5830400.0 |
| 2006-02-06 14:30:00 | QQQ | ETF | 40.66 | 40.72 | 40.65 | 40.68 | 3320600.0 |
| 2006-02-06 15:00:00 | QQQ | ETF | 40.68 | 40.8 | 40.68 | 40.79 | 3588400.0 |
| 2006-02-06 15:30:00 | QQQ | ETF | 40.8 | 40.85 | 40.74 | 40.78 | 8706800.0 |
| 2006-02-06 08:00:00 | IWM | ETF | 71.95 | 71.95 | 71.95 | 71.95 | 1300.0 |
| 2006-02-06 09:00:00 | IWM | ETF | 71.89 | 71.93 | 71.88 | 71.93 | 33500.0 |
| 2006-02-06 09:30:00 | IWM | ETF | 71.9 | 72.1 | 71.85 | 71.92 | 2192700.0 |
| 2006-02-06 10:00:00 | IWM | ETF | 71.91 | 71.93 | 71.54 | 71.54 | 4209000.0 |
| 2006-02-06 10:30:00 | IWM | ETF | 71.54 | 71.78 | 71.52 | 71.74 | 1973500.0 |
| 2006-02-06 11:00:00 | IWM | ETF | 71.74 | 71.98 | 71.74 | 71.92 | 3218800.0 |
| 2006-02-06 11:30:00 | IWM | ETF | 71.92 | 72.08 | 71.92 | 72.02 | 909700.0 |
| 2006-02-06 12:00:00 | IWM | ETF | 72.02 | 72.17 | 71.92 | 71.94 | 2400800.0 |
| 2006-02-06 12:30:00 | IWM | ETF | 71.94 | 72.05 | 71.88 | 72.03 | 647200.0 |
| 2006-02-06 13:00:00 | IWM | ETF | 72.03 | 72.13 | 72.02 | 72.12 | 715100.0 |
| 2006-02-06 13:30:00 | IWM | ETF | 72.12 | 72.24 | 71.97 | 72.04 | 1265500.0 |
| 2006-02-06 14:00:00 | IWM | ETF | 72.04 | 72.04 | 71.74 | 71.85 | 1455900.0 |
| 2006-02-06 14:30:00 | IWM | ETF | 71.85 | 72.05 | 71.84 | 71.99 | 1027300.0 |
> showing 50 of 2,125 rows — these rows as CSV