PREVIEW / etf_30min / 2006-06-13
file: by_date/etf_30min/2006/2006-06-13.parquet size: 72 KB rows: 2,477
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-06-13 05:30:00 | SPY | ETF | 123.66 | 123.66 | 123.66 | 123.66 | 100.0 |
| 2006-06-13 06:00:00 | SPY | ETF | 123.56 | 123.56 | 123.48 | 123.49 | 2100.0 |
| 2006-06-13 06:30:00 | SPY | ETF | 123.41 | 123.52 | 123.4 | 123.52 | 9500.0 |
| 2006-06-13 07:00:00 | SPY | ETF | 123.58 | 123.59 | 123.33 | 123.44 | 109400.0 |
| 2006-06-13 07:30:00 | SPY | ETF | 123.39 | 123.44 | 123.3 | 123.41 | 89200.0 |
| 2006-06-13 08:00:00 | SPY | ETF | 123.47 | 124.14 | 123.29 | 123.6 | 4005100.0 |
| 2006-06-13 08:30:00 | SPY | ETF | 123.58 | 123.96 | 123.28 | 123.73 | 3733100.0 |
| 2006-06-13 09:00:00 | SPY | ETF | 123.71 | 123.92 | 123.63 | 123.8 | 1325800.0 |
| 2006-06-13 09:30:00 | SPY | ETF | 123.78 | 124.84 | 123.63 | 124.39 | 23420000.0 |
| 2006-06-13 10:00:00 | SPY | ETF | 124.38 | 124.39 | 123.6 | 124.08 | 16468300.0 |
| 2006-06-13 10:30:00 | SPY | ETF | 124.08 | 124.09 | 123.45 | 123.6 | 7930100.0 |
| 2006-06-13 11:00:00 | SPY | ETF | 123.6 | 124.76 | 123.39 | 123.89 | 14637400.0 |
| 2006-06-13 11:30:00 | SPY | ETF | 123.9 | 124.49 | 123.83 | 124.42 | 13402800.0 |
| 2006-06-13 12:00:00 | SPY | ETF | 124.41 | 124.46 | 123.84 | 123.88 | 8427100.0 |
| 2006-06-13 12:30:00 | SPY | ETF | 123.88 | 124.15 | 123.81 | 124.02 | 3665400.0 |
| 2006-06-13 13:00:00 | SPY | ETF | 124.0 | 124.02 | 123.41 | 123.5 | 7022500.0 |
| 2006-06-13 13:30:00 | SPY | ETF | 123.49 | 123.98 | 123.34 | 123.854 | 8121500.0 |
| 2006-06-13 14:00:00 | SPY | ETF | 123.85 | 123.89 | 123.25 | 123.5 | 10003700.0 |
| 2006-06-13 14:30:00 | SPY | ETF | 123.5 | 123.54 | 122.86 | 123.03 | 13323900.0 |
| 2006-06-13 15:00:00 | SPY | ETF | 123.03 | 123.74 | 122.66 | 123.48 | 18599800.0 |
| 2006-06-13 15:30:00 | SPY | ETF | 123.48 | 123.83 | 122.71 | 122.73 | 18075600.0 |
| 2006-06-13 16:00:00 | SPY | ETF | 122.72 | 123.792 | 122.55 | 122.56 | 3373900.0 |
| 2006-06-13 16:30:00 | SPY | ETF | 122.59 | 122.63 | 121.5928 | 122.58 | 2513300.0 |
| 2006-06-13 17:00:00 | SPY | ETF | 122.58 | 122.61 | 122.54 | 122.56 | 178500.0 |
| 2006-06-13 17:30:00 | SPY | ETF | 122.55 | 122.56 | 122.55 | 122.55 | 7200.0 |
| 2006-06-13 18:00:00 | SPY | ETF | 122.6 | 122.65 | 122.6 | 122.65 | 7100.0 |
| 2006-06-13 18:30:00 | SPY | ETF | 122.68 | 122.68 | 122.59 | 122.59 | 4400.0 |
| 2006-06-13 19:00:00 | SPY | ETF | 122.63 | 122.63 | 122.63 | 122.63 | 400.0 |
| 2006-06-13 19:30:00 | SPY | ETF | 122.63 | 122.63 | 122.59 | 122.59 | 1300.0 |
| 2006-06-13 09:30:00 | QQQ | ETF | 37.52 | 38.2 | 37.31 | 37.62 | 35773200.0 |
| 2006-06-13 10:00:00 | QQQ | ETF | 37.61 | 37.72 | 37.33 | 37.59 | 22094900.0 |
| 2006-06-13 10:30:00 | QQQ | ETF | 37.6 | 37.61 | 37.31 | 37.4 | 13706800.0 |
| 2006-06-13 11:00:00 | QQQ | ETF | 37.4 | 37.65 | 37.33 | 37.58 | 14791400.0 |
| 2006-06-13 11:30:00 | QQQ | ETF | 37.58 | 37.76 | 37.55 | 37.75 | 8765900.0 |
| 2006-06-13 12:00:00 | QQQ | ETF | 37.74 | 37.76 | 37.52 | 37.54 | 12518100.0 |
| 2006-06-13 12:30:00 | QQQ | ETF | 37.53 | 37.65 | 37.52 | 37.57 | 5185600.0 |
| 2006-06-13 13:00:00 | QQQ | ETF | 37.57 | 37.57 | 37.4 | 37.44 | 11282400.0 |
| 2006-06-13 13:30:00 | QQQ | ETF | 37.43 | 37.61 | 37.36 | 37.57 | 8436600.0 |
| 2006-06-13 14:00:00 | QQQ | ETF | 37.57 | 37.57 | 37.36 | 37.43 | 8367300.0 |
| 2006-06-13 14:30:00 | QQQ | ETF | 37.43 | 37.44 | 37.24 | 37.3 | 13928200.0 |
| 2006-06-13 15:00:00 | QQQ | ETF | 37.31 | 37.48 | 37.16 | 37.39 | 16832200.0 |
| 2006-06-13 15:30:00 | QQQ | ETF | 37.4 | 37.61 | 37.26 | 37.27 | 22875700.0 |
| 2006-06-13 07:00:00 | IWM | ETF | 67.5 | 67.5 | 67.5 | 67.5 | 500.0 |
| 2006-06-13 07:30:00 | IWM | ETF | 67.3 | 67.32 | 67.3 | 67.32 | 7100.0 |
| 2006-06-13 08:00:00 | IWM | ETF | 67.6 | 67.95 | 67.32 | 67.87 | 886800.0 |
| 2006-06-13 08:30:00 | IWM | ETF | 67.74 | 68.09 | 67.59 | 67.63 | 1723200.0 |
| 2006-06-13 09:00:00 | IWM | ETF | 67.62 | 67.79 | 67.58 | 67.65 | 807700.0 |
| 2006-06-13 09:30:00 | IWM | ETF | 67.65 | 68.85 | 67.29 | 68.48 | 20953300.0 |
| 2006-06-13 10:00:00 | IWM | ETF | 68.48 | 68.51 | 67.66 | 68.12 | 10570400.0 |
| 2006-06-13 10:30:00 | IWM | ETF | 68.12 | 68.15 | 67.33 | 67.54 | 8275200.0 |
> showing 50 of 2,477 rows — these rows as CSV