PREVIEW / etf_30min / 2004-12-07
file: by_date/etf_30min/2004/2004-12-07.parquet size: 42 KB rows: 1,358
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-07 08:00:00 | SPY | ETF | 119.58 | 119.65 | 119.55 | 119.59 | 23700.0 |
| 2004-12-07 08:30:00 | SPY | ETF | 119.59 | 119.59 | 119.52 | 119.58 | 38600.0 |
| 2004-12-07 09:00:00 | SPY | ETF | 119.61 | 119.62 | 119.48 | 119.48 | 57000.0 |
| 2004-12-07 09:30:00 | SPY | ETF | 119.49 | 119.51 | 119.17 | 119.48 | 4631200.0 |
| 2004-12-07 10:00:00 | SPY | ETF | 119.48 | 119.61 | 119.29 | 119.39 | 2588600.0 |
| 2004-12-07 10:30:00 | SPY | ETF | 119.39 | 119.52 | 119.2 | 119.36 | 1379300.0 |
| 2004-12-07 11:00:00 | SPY | ETF | 119.36 | 119.44 | 119.27 | 119.41 | 883800.0 |
| 2004-12-07 11:30:00 | SPY | ETF | 119.41 | 119.52 | 119.37 | 119.42 | 1511800.0 |
| 2004-12-07 12:00:00 | SPY | ETF | 119.42 | 119.57 | 119.39 | 119.44 | 2561300.0 |
| 2004-12-07 12:30:00 | SPY | ETF | 119.44 | 119.52 | 119.21 | 119.21 | 1725700.0 |
| 2004-12-07 13:00:00 | SPY | ETF | 119.21 | 119.24 | 118.6 | 118.79 | 7581100.0 |
| 2004-12-07 13:30:00 | SPY | ETF | 118.77 | 118.8 | 118.45 | 118.7 | 4388000.0 |
| 2004-12-07 14:00:00 | SPY | ETF | 118.68 | 118.73 | 118.37 | 118.58 | 3081700.0 |
| 2004-12-07 14:30:00 | SPY | ETF | 118.58 | 118.65 | 118.39 | 118.4 | 2926600.0 |
| 2004-12-07 15:00:00 | SPY | ETF | 118.41 | 118.53 | 118.18 | 118.22 | 5299200.0 |
| 2004-12-07 15:30:00 | SPY | ETF | 118.22 | 118.35 | 118.05 | 118.08 | 5829400.0 |
| 2004-12-07 16:00:00 | SPY | ETF | 118.09 | 118.21 | 117.98 | 118.0 | 3601200.0 |
| 2004-12-07 16:30:00 | SPY | ETF | 118.06 | 119.38 | 117.96 | 117.97 | 558200.0 |
| 2004-12-07 17:00:00 | SPY | ETF | 118.0 | 118.0 | 117.92 | 117.96 | 60400.0 |
| 2004-12-07 17:30:00 | SPY | ETF | 117.94 | 117.94 | 117.94 | 117.94 | 100.0 |
| 2004-12-07 18:00:00 | SPY | ETF | 118.0 | 118.0 | 117.96 | 117.96 | 1300.0 |
| 2004-12-07 19:30:00 | SPY | ETF | 118.01 | 118.01 | 118.01 | 118.01 | 1000.0 |
| 2004-12-07 08:00:00 | QQQ | ETF | 40.25 | 40.39 | 40.25 | 40.38 | 97180.0 |
| 2004-12-07 08:30:00 | QQQ | ETF | 40.369 | 40.38 | 40.31 | 40.32 | 647619.0 |
| 2004-12-07 09:00:00 | QQQ | ETF | 40.33 | 40.36 | 40.32 | 40.32 | 196179.0 |
| 2004-12-07 09:30:00 | QQQ | ETF | 40.321 | 40.43 | 40.2 | 40.4 | 10461684.0 |
| 2004-12-07 10:00:00 | QQQ | ETF | 40.41 | 40.5 | 40.34 | 40.4 | 6066564.0 |
| 2004-12-07 10:30:00 | QQQ | ETF | 40.4 | 40.47 | 40.26 | 40.32 | 5048164.0 |
| 2004-12-07 11:00:00 | QQQ | ETF | 40.32 | 40.36 | 40.29 | 40.35 | 3999211.0 |
| 2004-12-07 11:30:00 | QQQ | ETF | 40.35 | 40.372 | 40.3 | 40.32 | 3601136.0 |
| 2004-12-07 12:00:00 | QQQ | ETF | 40.32 | 40.42 | 40.31 | 40.38 | 3959657.0 |
| 2004-12-07 12:30:00 | QQQ | ETF | 40.38 | 40.39 | 40.249 | 40.25 | 3072219.0 |
| 2004-12-07 13:00:00 | QQQ | ETF | 40.252 | 40.252 | 39.986 | 40.04 | 10928333.0 |
| 2004-12-07 13:30:00 | QQQ | ETF | 40.04 | 40.05 | 39.86 | 39.96 | 9742832.0 |
| 2004-12-07 14:00:00 | QQQ | ETF | 39.96 | 39.97 | 39.787 | 39.88 | 8843499.0 |
| 2004-12-07 14:30:00 | QQQ | ETF | 39.88 | 39.894 | 39.68 | 39.68 | 6446205.0 |
| 2004-12-07 15:00:00 | QQQ | ETF | 39.68 | 39.74 | 39.608 | 39.62 | 11653187.0 |
| 2004-12-07 15:30:00 | QQQ | ETF | 39.62 | 39.69 | 39.55 | 39.58 | 13516045.0 |
| 2004-12-07 16:00:00 | QQQ | ETF | 39.58 | 39.62 | 39.53 | 39.61 | 1796046.0 |
| 2004-12-07 16:30:00 | QQQ | ETF | 39.606 | 39.62 | 39.532 | 39.56 | 365010.0 |
| 2004-12-07 17:00:00 | QQQ | ETF | 39.56 | 39.57 | 39.52 | 39.53 | 221868.0 |
| 2004-12-07 17:30:00 | QQQ | ETF | 39.54 | 39.6 | 39.52 | 39.59 | 60400.0 |
| 2004-12-07 18:00:00 | QQQ | ETF | 39.56 | 39.58 | 39.5 | 39.52 | 105585.0 |
| 2004-12-07 09:00:00 | IWM | ETF | 63.74 | 63.765 | 63.735 | 63.735 | 2000.0 |
| 2004-12-07 09:30:00 | IWM | ETF | 63.735 | 63.825 | 63.605 | 63.81 | 1803200.0 |
| 2004-12-07 10:00:00 | IWM | ETF | 63.8 | 63.86 | 63.7 | 63.725 | 631800.0 |
| 2004-12-07 10:30:00 | IWM | ETF | 63.72 | 63.785 | 63.54 | 63.62 | 482600.0 |
| 2004-12-07 11:00:00 | IWM | ETF | 63.61 | 63.635 | 63.47 | 63.54 | 458200.0 |
| 2004-12-07 11:30:00 | IWM | ETF | 63.54 | 63.635 | 63.53 | 63.6 | 322200.0 |
| 2004-12-07 12:00:00 | IWM | ETF | 63.605 | 63.665 | 63.565 | 63.57 | 345000.0 |
> showing 50 of 1,358 rows — these rows as CSV