PREVIEW / etf_30min / 2001-06-13
file: by_date/etf_30min/2001/2001-06-13.parquet size: 14 KB rows: 342
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-13 09:30:00 | SPY | ETF | 126.17 | 126.49 | 125.62 | 126.32 | 1123500.0 |
| 2001-06-13 10:00:00 | SPY | ETF | 126.3 | 126.37 | 125.77 | 125.85 | 953700.0 |
| 2001-06-13 10:30:00 | SPY | ETF | 125.81 | 126.35 | 125.53 | 126.19 | 396700.0 |
| 2001-06-13 11:00:00 | SPY | ETF | 126.19 | 126.43 | 126.12 | 126.38 | 429100.0 |
| 2001-06-13 11:30:00 | SPY | ETF | 126.44 | 126.58 | 126.21 | 126.3 | 370100.0 |
| 2001-06-13 12:00:00 | SPY | ETF | 126.33 | 126.39 | 126.1 | 126.13 | 495400.0 |
| 2001-06-13 12:30:00 | SPY | ETF | 126.11 | 126.25 | 125.95 | 126.03 | 458900.0 |
| 2001-06-13 13:00:00 | SPY | ETF | 126.03 | 126.03 | 125.75 | 125.85 | 334100.0 |
| 2001-06-13 13:30:00 | SPY | ETF | 125.82 | 126.07 | 125.45 | 125.49 | 171100.0 |
| 2001-06-13 14:00:00 | SPY | ETF | 125.5 | 125.55 | 125.22 | 125.47 | 500500.0 |
| 2001-06-13 14:30:00 | SPY | ETF | 125.46 | 125.6 | 125.04 | 125.13 | 551800.0 |
| 2001-06-13 15:00:00 | SPY | ETF | 125.2 | 125.21 | 124.75 | 125.02 | 637300.0 |
| 2001-06-13 15:30:00 | SPY | ETF | 124.98 | 125.22 | 124.67 | 124.74 | 647900.0 |
| 2001-06-13 16:00:00 | SPY | ETF | 124.76 | 124.85 | 124.65 | 124.7 | 371300.0 |
| 2001-06-13 16:30:00 | SPY | ETF | 124.65 | 124.67 | 123.6 | 124.65 | 1600.0 |
| 2001-06-13 17:30:00 | SPY | ETF | 124.95 | 124.95 | 124.95 | 124.95 | 100.0 |
| 2001-06-13 18:00:00 | SPY | ETF | 124.9 | 124.9 | 124.9 | 124.9 | 200.0 |
| 2001-06-13 09:30:00 | QQQ | ETF | 46.27 | 46.75 | 45.72 | 46.6 | 12045800.0 |
| 2001-06-13 10:00:00 | QQQ | ETF | 46.6 | 46.64 | 45.95 | 46.1 | 6744700.0 |
| 2001-06-13 10:30:00 | QQQ | ETF | 46.1 | 46.49 | 45.87 | 46.33 | 5656900.0 |
| 2001-06-13 11:00:00 | QQQ | ETF | 46.35 | 46.55 | 46.24 | 46.45 | 3582600.0 |
| 2001-06-13 11:30:00 | QQQ | ETF | 46.5 | 46.66 | 46.35 | 46.42 | 3671400.0 |
| 2001-06-13 12:00:00 | QQQ | ETF | 46.45 | 46.65 | 46.26 | 46.3 | 1726000.0 |
| 2001-06-13 12:30:00 | QQQ | ETF | 46.3 | 46.45 | 46.0 | 46.07 | 3077700.0 |
| 2001-06-13 13:00:00 | QQQ | ETF | 46.1 | 46.1 | 45.6 | 45.75 | 4225000.0 |
| 2001-06-13 13:30:00 | QQQ | ETF | 45.78 | 45.97 | 45.47 | 45.49 | 3722300.0 |
| 2001-06-13 14:00:00 | QQQ | ETF | 45.47 | 45.51 | 45.07 | 45.3 | 4889200.0 |
| 2001-06-13 14:30:00 | QQQ | ETF | 45.31 | 45.45 | 44.98 | 45.16 | 3403600.0 |
| 2001-06-13 15:00:00 | QQQ | ETF | 45.14 | 45.14 | 44.7 | 44.96 | 7731900.0 |
| 2001-06-13 15:30:00 | QQQ | ETF | 44.94 | 45.16 | 44.55 | 44.58 | 5047100.0 |
| 2001-06-13 16:00:00 | QQQ | ETF | 44.6 | 45.3 | 44.52 | 44.59 | 1075700.0 |
| 2001-06-13 16:30:00 | QQQ | ETF | 44.59 | 44.62 | 44.51 | 44.52 | 33700.0 |
| 2001-06-13 17:00:00 | QQQ | ETF | 44.51 | 44.59 | 44.49 | 44.59 | 46500.0 |
| 2001-06-13 17:30:00 | QQQ | ETF | 44.6 | 44.6 | 44.53 | 44.6 | 17700.0 |
| 2001-06-13 18:00:00 | QQQ | ETF | 44.6 | 44.62 | 44.57 | 44.57 | 8000.0 |
| 2001-06-13 09:30:00 | IWM | ETF | 50.625 | 50.825 | 50.5 | 50.825 | 73400.0 |
| 2001-06-13 10:00:00 | IWM | ETF | 50.825 | 50.875 | 50.65 | 50.8 | 22000.0 |
| 2001-06-13 10:30:00 | IWM | ETF | 50.825 | 50.85 | 50.68 | 50.825 | 11600.0 |
| 2001-06-13 11:00:00 | IWM | ETF | 50.9 | 50.95 | 50.68 | 50.875 | 5200.0 |
| 2001-06-13 11:30:00 | IWM | ETF | 50.92 | 50.995 | 50.75 | 50.8 | 16400.0 |
| 2001-06-13 12:00:00 | IWM | ETF | 50.82 | 51.0 | 50.82 | 50.825 | 117200.0 |
| 2001-06-13 12:30:00 | IWM | ETF | 50.925 | 50.925 | 50.805 | 50.825 | 102400.0 |
| 2001-06-13 13:00:00 | IWM | ETF | 50.825 | 50.825 | 50.77 | 50.78 | 7600.0 |
| 2001-06-13 13:30:00 | IWM | ETF | 50.8 | 50.825 | 50.8 | 50.82 | 2800.0 |
| 2001-06-13 14:00:00 | IWM | ETF | 50.7 | 50.76 | 50.65 | 50.65 | 14200.0 |
| 2001-06-13 14:30:00 | IWM | ETF | 50.65 | 50.67 | 50.56 | 50.595 | 298400.0 |
| 2001-06-13 15:00:00 | IWM | ETF | 50.6 | 50.6 | 50.45 | 50.465 | 15000.0 |
| 2001-06-13 15:30:00 | IWM | ETF | 50.465 | 50.535 | 50.2 | 50.33 | 29600.0 |
| 2001-06-13 16:00:00 | IWM | ETF | 50.37 | 50.37 | 50.3 | 50.33 | 40600.0 |
| 2001-06-13 09:30:00 | DIA | ETF | 109.75 | 110.15 | 109.42 | 109.85 | 388500.0 |
> showing 50 of 342 rows — these rows as CSV