PREVIEW / etf_30min / 2005-11-28
file: by_date/etf_30min/2005/2005-11-28.parquet size: 52 KB rows: 1,834
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-28 07:00:00 | SPY | ETF | 127.39 | 127.44 | 127.39 | 127.44 | 12000.0 |
| 2005-11-28 07:30:00 | SPY | ETF | 127.39 | 127.44 | 127.39 | 127.42 | 13500.0 |
| 2005-11-28 08:00:00 | SPY | ETF | 127.4 | 127.44 | 127.32 | 127.33 | 259700.0 |
| 2005-11-28 08:30:00 | SPY | ETF | 127.35 | 127.36 | 127.33 | 127.34 | 72800.0 |
| 2005-11-28 09:00:00 | SPY | ETF | 127.35 | 127.36 | 127.2 | 127.24 | 470000.0 |
| 2005-11-28 09:30:00 | SPY | ETF | 127.25 | 127.27 | 126.6 | 126.65 | 9107600.0 |
| 2005-11-28 10:00:00 | SPY | ETF | 126.63 | 126.81 | 126.48 | 126.5 | 5047400.0 |
| 2005-11-28 10:30:00 | SPY | ETF | 126.5 | 126.77 | 126.47 | 126.63 | 4364900.0 |
| 2005-11-28 11:00:00 | SPY | ETF | 126.63 | 126.75 | 126.58 | 126.66 | 2462900.0 |
| 2005-11-28 11:30:00 | SPY | ETF | 126.66 | 126.8 | 126.61 | 126.69 | 2926800.0 |
| 2005-11-28 12:00:00 | SPY | ETF | 126.69 | 126.71 | 126.5 | 126.6 | 2113600.0 |
| 2005-11-28 12:30:00 | SPY | ETF | 126.61 | 126.65 | 126.35 | 126.36 | 2610800.0 |
| 2005-11-28 13:00:00 | SPY | ETF | 126.37 | 126.47 | 126.31 | 126.47 | 2163500.0 |
| 2005-11-28 13:30:00 | SPY | ETF | 126.44 | 126.46 | 126.31 | 126.39 | 2443500.0 |
| 2005-11-28 14:00:00 | SPY | ETF | 126.35 | 126.44 | 126.22 | 126.4 | 2913100.0 |
| 2005-11-28 14:30:00 | SPY | ETF | 126.36 | 126.42 | 126.25 | 126.33 | 2619400.0 |
| 2005-11-28 15:00:00 | SPY | ETF | 126.32 | 126.38 | 126.05 | 126.13 | 5625600.0 |
| 2005-11-28 15:30:00 | SPY | ETF | 126.12 | 126.25 | 126.04 | 126.15 | 4646400.0 |
| 2005-11-28 16:00:00 | SPY | ETF | 126.16 | 126.26 | 126.06 | 126.22 | 1310100.0 |
| 2005-11-28 16:30:00 | SPY | ETF | 126.23 | 126.25 | 126.21 | 126.22 | 69800.0 |
| 2005-11-28 17:00:00 | SPY | ETF | 126.21 | 126.24 | 126.21 | 126.24 | 78400.0 |
| 2005-11-28 17:30:00 | SPY | ETF | 126.25 | 126.27 | 126.24 | 126.24 | 3200.0 |
| 2005-11-28 18:00:00 | SPY | ETF | 126.23 | 126.24 | 126.22 | 126.22 | 7600.0 |
| 2005-11-28 18:30:00 | SPY | ETF | 126.25 | 126.25 | 126.25 | 126.25 | 3100.0 |
| 2005-11-28 19:00:00 | SPY | ETF | 126.25 | 126.3 | 126.25 | 126.3 | 6100.0 |
| 2005-11-28 19:30:00 | SPY | ETF | 126.29 | 126.31 | 126.29 | 126.31 | 3200.0 |
| 2005-11-28 09:30:00 | QQQ | ETF | 41.97 | 42.0 | 41.69 | 41.7 | 12054000.0 |
| 2005-11-28 10:00:00 | QQQ | ETF | 41.7 | 41.74 | 41.57 | 41.59 | 10297500.0 |
| 2005-11-28 10:30:00 | QQQ | ETF | 41.6 | 41.68 | 41.58 | 41.59 | 5464900.0 |
| 2005-11-28 11:00:00 | QQQ | ETF | 41.58 | 41.67 | 41.57 | 41.61 | 5252000.0 |
| 2005-11-28 11:30:00 | QQQ | ETF | 41.61 | 41.75 | 41.6 | 41.68 | 5181100.0 |
| 2005-11-28 12:00:00 | QQQ | ETF | 41.69 | 41.74 | 41.63 | 41.66 | 2543500.0 |
| 2005-11-28 12:30:00 | QQQ | ETF | 41.66 | 41.7 | 41.51 | 41.52 | 5200800.0 |
| 2005-11-28 13:00:00 | QQQ | ETF | 41.52 | 41.6 | 41.5 | 41.58 | 3851200.0 |
| 2005-11-28 13:30:00 | QQQ | ETF | 41.58 | 41.61 | 41.53 | 41.58 | 3773900.0 |
| 2005-11-28 14:00:00 | QQQ | ETF | 41.58 | 41.65 | 41.54 | 41.62 | 2660800.0 |
| 2005-11-28 14:30:00 | QQQ | ETF | 41.63 | 41.64 | 41.56 | 41.61 | 2936800.0 |
| 2005-11-28 15:00:00 | QQQ | ETF | 41.59 | 41.63 | 41.5 | 41.53 | 4994500.0 |
| 2005-11-28 15:30:00 | QQQ | ETF | 41.53 | 41.59 | 41.5 | 41.55 | 6221100.0 |
| 2005-11-28 08:00:00 | IWM | ETF | 68.09 | 68.09 | 68.02 | 68.05 | 44800.0 |
| 2005-11-28 08:30:00 | IWM | ETF | 68.07 | 68.1 | 68.07 | 68.1 | 4100.0 |
| 2005-11-28 09:00:00 | IWM | ETF | 68.1 | 68.15 | 68.07 | 68.09 | 27300.0 |
| 2005-11-28 09:30:00 | IWM | ETF | 68.12 | 68.15 | 67.48 | 67.48 | 3319000.0 |
| 2005-11-28 10:00:00 | IWM | ETF | 67.48 | 67.58 | 67.25 | 67.26 | 2183600.0 |
| 2005-11-28 10:30:00 | IWM | ETF | 67.26 | 67.35 | 67.22 | 67.28 | 1298600.0 |
| 2005-11-28 11:00:00 | IWM | ETF | 67.28 | 67.34 | 67.2 | 67.24 | 1345100.0 |
| 2005-11-28 11:30:00 | IWM | ETF | 67.25 | 67.4 | 67.19 | 67.24 | 985300.0 |
| 2005-11-28 12:00:00 | IWM | ETF | 67.25 | 67.27 | 67.08 | 67.12 | 1111500.0 |
| 2005-11-28 12:30:00 | IWM | ETF | 67.13 | 67.15 | 66.91 | 66.92 | 4247400.0 |
| 2005-11-28 13:00:00 | IWM | ETF | 66.93 | 66.96 | 66.85 | 66.94 | 1035300.0 |
> showing 50 of 1,834 rows — these rows as CSV