PREVIEW / etf_30min / 2006-07-24
file: by_date/etf_30min/2006/2006-07-24.parquet size: 77 KB rows: 2,656
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-07-24 04:00:00 | SPY | ETF | 124.18 | 124.18 | 124.18 | 124.18 | 100.0 |
| 2006-07-24 05:00:00 | SPY | ETF | 124.31 | 124.48 | 124.31 | 124.41 | 2100.0 |
| 2006-07-24 05:30:00 | SPY | ETF | 124.5 | 124.5 | 124.5 | 124.5 | 500.0 |
| 2006-07-24 06:00:00 | SPY | ETF | 124.53 | 124.53 | 124.53 | 124.53 | 25000.0 |
| 2006-07-24 06:30:00 | SPY | ETF | 124.54 | 124.54 | 124.45 | 124.45 | 25800.0 |
| 2006-07-24 07:00:00 | SPY | ETF | 124.43 | 124.49 | 124.23 | 124.23 | 71600.0 |
| 2006-07-24 07:30:00 | SPY | ETF | 124.35 | 124.39 | 124.33 | 124.35 | 71000.0 |
| 2006-07-24 08:00:00 | SPY | ETF | 124.33 | 124.49 | 124.24 | 124.49 | 602500.0 |
| 2006-07-24 08:30:00 | SPY | ETF | 124.5 | 124.61 | 124.36 | 124.58 | 1696600.0 |
| 2006-07-24 09:00:00 | SPY | ETF | 124.56 | 124.6 | 124.47 | 124.47 | 691000.0 |
| 2006-07-24 09:30:00 | SPY | ETF | 124.44 | 125.04 | 124.44 | 124.84 | 11169300.0 |
| 2006-07-24 10:00:00 | SPY | ETF | 124.84 | 125.38 | 124.71 | 125.2 | 7388200.0 |
| 2006-07-24 10:30:00 | SPY | ETF | 125.2 | 125.74 | 125.2 | 125.62 | 10029100.0 |
| 2006-07-24 11:00:00 | SPY | ETF | 125.63 | 125.8 | 125.52 | 125.71 | 6749700.0 |
| 2006-07-24 11:30:00 | SPY | ETF | 125.72 | 126.09 | 125.7 | 125.9 | 5828500.0 |
| 2006-07-24 12:00:00 | SPY | ETF | 125.91 | 125.94 | 125.7 | 125.82 | 3352300.0 |
| 2006-07-24 12:30:00 | SPY | ETF | 125.81 | 125.83 | 125.57 | 125.64 | 3794000.0 |
| 2006-07-24 13:00:00 | SPY | ETF | 125.63 | 125.71 | 125.54 | 125.62 | 4397100.0 |
| 2006-07-24 13:30:00 | SPY | ETF | 125.62 | 125.8 | 125.57 | 125.65 | 3201600.0 |
| 2006-07-24 14:00:00 | SPY | ETF | 125.65 | 125.7 | 125.5 | 125.61 | 4415800.0 |
| 2006-07-24 14:30:00 | SPY | ETF | 125.61 | 125.93 | 125.56 | 125.87 | 6166200.0 |
| 2006-07-24 15:00:00 | SPY | ETF | 125.86 | 126.28 | 125.83 | 126.26 | 5513300.0 |
| 2006-07-24 15:30:00 | SPY | ETF | 126.2612 | 126.32 | 126.04 | 126.13 | 10959600.0 |
| 2006-07-24 16:00:00 | SPY | ETF | 126.16 | 126.25 | 125.3964 | 126.21 | 1501000.0 |
| 2006-07-24 16:30:00 | SPY | ETF | 126.2 | 126.25 | 126.15 | 126.25 | 1166700.0 |
| 2006-07-24 17:00:00 | SPY | ETF | 126.23 | 126.26 | 126.21 | 126.21 | 61700.0 |
| 2006-07-24 17:30:00 | SPY | ETF | 126.25 | 126.27 | 126.25 | 126.27 | 1800.0 |
| 2006-07-24 18:00:00 | SPY | ETF | 126.22 | 126.24 | 126.21 | 126.24 | 5900.0 |
| 2006-07-24 19:00:00 | SPY | ETF | 126.23 | 126.23 | 126.2 | 126.2 | 2800.0 |
| 2006-07-24 09:30:00 | QQQ | ETF | 35.85 | 36.02 | 35.84 | 35.89 | 18858000.0 |
| 2006-07-24 10:00:00 | QQQ | ETF | 35.88 | 36.11 | 35.8 | 36.03 | 14308800.0 |
| 2006-07-24 10:30:00 | QQQ | ETF | 36.04 | 36.25 | 36.03 | 36.21 | 10866500.0 |
| 2006-07-24 11:00:00 | QQQ | ETF | 36.21 | 36.27 | 36.17 | 36.24 | 5210300.0 |
| 2006-07-24 11:30:00 | QQQ | ETF | 36.24 | 36.37 | 36.23 | 36.28 | 8392300.0 |
| 2006-07-24 12:00:00 | QQQ | ETF | 36.28 | 36.3 | 36.21 | 36.24 | 4353600.0 |
| 2006-07-24 12:30:00 | QQQ | ETF | 36.24 | 36.25 | 36.08 | 36.09 | 6881500.0 |
| 2006-07-24 13:00:00 | QQQ | ETF | 36.09 | 36.1 | 36.03 | 36.08 | 5181100.0 |
| 2006-07-24 13:30:00 | QQQ | ETF | 36.08 | 36.2 | 36.03 | 36.14 | 8190700.0 |
| 2006-07-24 14:00:00 | QQQ | ETF | 36.14 | 36.19 | 36.12 | 36.15 | 3745500.0 |
| 2006-07-24 14:30:00 | QQQ | ETF | 36.16 | 36.29 | 36.15 | 36.28 | 7780000.0 |
| 2006-07-24 15:00:00 | QQQ | ETF | 36.28 | 36.43 | 36.27 | 36.41 | 11680600.0 |
| 2006-07-24 15:30:00 | QQQ | ETF | 36.41 | 36.43 | 36.35 | 36.39 | 13610800.0 |
| 2006-07-24 06:30:00 | IWM | ETF | 67.0 | 67.0 | 67.0 | 67.0 | 400.0 |
| 2006-07-24 08:00:00 | IWM | ETF | 67.2 | 67.2 | 67.1 | 67.13 | 63500.0 |
| 2006-07-24 08:30:00 | IWM | ETF | 67.15 | 67.21 | 67.15 | 67.21 | 134200.0 |
| 2006-07-24 09:00:00 | IWM | ETF | 67.22 | 67.3 | 67.2 | 67.25 | 464200.0 |
| 2006-07-24 09:30:00 | IWM | ETF | 67.26 | 67.99 | 67.25 | 67.66 | 13915100.0 |
| 2006-07-24 10:00:00 | IWM | ETF | 67.65 | 68.15 | 67.53 | 67.99 | 9289300.0 |
| 2006-07-24 10:30:00 | IWM | ETF | 68.0 | 68.5 | 67.98 | 68.37 | 10278100.0 |
| 2006-07-24 11:00:00 | IWM | ETF | 68.37 | 68.48 | 68.26 | 68.37 | 3074700.0 |
> showing 50 of 2,656 rows — these rows as CSV