PREVIEW / etf_30min / 2004-10-12
file: by_date/etf_30min/2004/2004-10-12.parquet size: 36 KB rows: 1,201
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-10-12 08:00:00 | SPY | ETF | 112.07 | 112.21 | 112.07 | 112.17 | 165300.0 |
| 2004-10-12 08:30:00 | SPY | ETF | 112.18 | 112.25 | 112.17 | 112.22 | 30100.0 |
| 2004-10-12 09:00:00 | SPY | ETF | 112.23 | 112.24 | 112.17 | 112.19 | 134200.0 |
| 2004-10-12 09:30:00 | SPY | ETF | 112.2 | 112.32 | 112.02 | 112.06 | 4635300.0 |
| 2004-10-12 10:00:00 | SPY | ETF | 112.06 | 112.1 | 111.94 | 112.09 | 3639100.0 |
| 2004-10-12 10:30:00 | SPY | ETF | 112.09 | 112.25 | 112.0 | 112.08 | 3598400.0 |
| 2004-10-12 11:00:00 | SPY | ETF | 112.07 | 112.34 | 112.05 | 112.24 | 3741700.0 |
| 2004-10-12 11:30:00 | SPY | ETF | 112.26 | 112.42 | 112.2 | 112.36 | 2156400.0 |
| 2004-10-12 12:00:00 | SPY | ETF | 112.36 | 112.39 | 112.06 | 112.11 | 2551700.0 |
| 2004-10-12 12:30:00 | SPY | ETF | 112.11 | 112.19 | 112.05 | 112.17 | 1486300.0 |
| 2004-10-12 13:00:00 | SPY | ETF | 112.17 | 112.24 | 112.11 | 112.14 | 1026200.0 |
| 2004-10-12 13:30:00 | SPY | ETF | 112.15 | 112.33 | 112.1 | 112.27 | 1214500.0 |
| 2004-10-12 14:00:00 | SPY | ETF | 112.28 | 112.53 | 112.14 | 112.5 | 2490600.0 |
| 2004-10-12 14:30:00 | SPY | ETF | 112.5 | 112.83 | 112.44 | 112.8 | 3189200.0 |
| 2004-10-12 15:00:00 | SPY | ETF | 112.8 | 112.82 | 112.66 | 112.75 | 2356200.0 |
| 2004-10-12 15:30:00 | SPY | ETF | 112.75 | 112.79 | 112.52 | 112.53 | 3795300.0 |
| 2004-10-12 16:00:00 | SPY | ETF | 112.53 | 112.89 | 112.46 | 112.75 | 2826100.0 |
| 2004-10-12 16:30:00 | SPY | ETF | 112.75 | 112.92 | 112.66 | 112.81 | 1090300.0 |
| 2004-10-12 17:00:00 | SPY | ETF | 112.82 | 112.86 | 112.56 | 112.85 | 162600.0 |
| 2004-10-12 17:30:00 | SPY | ETF | 112.87 | 112.88 | 112.81 | 112.88 | 19200.0 |
| 2004-10-12 18:00:00 | SPY | ETF | 112.84 | 112.91 | 112.84 | 112.88 | 46100.0 |
| 2004-10-12 18:30:00 | SPY | ETF | 112.9 | 112.94 | 112.9 | 112.94 | 4100.0 |
| 2004-10-12 19:00:00 | SPY | ETF | 112.92 | 112.93 | 112.92 | 112.93 | 1900.0 |
| 2004-10-12 19:30:00 | SPY | ETF | 112.93 | 112.93 | 112.9 | 112.9 | 5000.0 |
| 2004-10-12 08:00:00 | QQQ | ETF | 35.39 | 35.43 | 35.39 | 35.41 | 146200.0 |
| 2004-10-12 08:30:00 | QQQ | ETF | 35.41 | 35.43 | 35.4 | 35.42 | 154000.0 |
| 2004-10-12 09:00:00 | QQQ | ETF | 35.42 | 35.47 | 35.41 | 35.44 | 488400.0 |
| 2004-10-12 09:30:00 | QQQ | ETF | 35.43 | 35.55 | 35.3 | 35.33 | 12106600.0 |
| 2004-10-12 10:00:00 | QQQ | ETF | 35.32 | 35.332 | 35.2 | 35.31 | 10783800.0 |
| 2004-10-12 10:30:00 | QQQ | ETF | 35.3 | 35.45 | 35.29 | 35.35 | 8806400.0 |
| 2004-10-12 11:00:00 | QQQ | ETF | 35.36 | 35.54 | 35.35 | 35.5 | 8464100.0 |
| 2004-10-12 11:30:00 | QQQ | ETF | 35.5 | 35.59 | 35.47 | 35.54 | 4486500.0 |
| 2004-10-12 12:00:00 | QQQ | ETF | 35.531 | 35.54 | 35.39 | 35.4 | 4779100.0 |
| 2004-10-12 12:30:00 | QQQ | ETF | 35.41 | 35.46 | 35.37 | 35.4577 | 4745700.0 |
| 2004-10-12 13:00:00 | QQQ | ETF | 35.45 | 35.49 | 35.406 | 35.429 | 3014900.0 |
| 2004-10-12 13:30:00 | QQQ | ETF | 35.42 | 35.54 | 35.4 | 35.51 | 3403500.0 |
| 2004-10-12 14:00:00 | QQQ | ETF | 35.51 | 35.62 | 35.46 | 35.59 | 3972600.0 |
| 2004-10-12 14:30:00 | QQQ | ETF | 35.58 | 35.75 | 35.55 | 35.732 | 8110000.0 |
| 2004-10-12 15:00:00 | QQQ | ETF | 35.74 | 35.78 | 35.674 | 35.771 | 6348200.0 |
| 2004-10-12 15:30:00 | QQQ | ETF | 35.771 | 35.8 | 35.66 | 35.71 | 9523000.0 |
| 2004-10-12 16:00:00 | QQQ | ETF | 35.7 | 35.9 | 35.66 | 35.82 | 3108600.0 |
| 2004-10-12 16:30:00 | QQQ | ETF | 35.81 | 35.968 | 35.74 | 35.9 | 2896200.0 |
| 2004-10-12 17:00:00 | QQQ | ETF | 35.902 | 35.943 | 35.89 | 35.93 | 164700.0 |
| 2004-10-12 17:30:00 | QQQ | ETF | 35.939 | 35.95 | 35.9 | 35.93 | 81900.0 |
| 2004-10-12 18:00:00 | QQQ | ETF | 35.93 | 35.95 | 35.92 | 35.94 | 261100.0 |
| 2004-10-12 18:30:00 | QQQ | ETF | 35.94 | 35.96 | 35.91 | 35.95 | 22300.0 |
| 2004-10-12 19:00:00 | QQQ | ETF | 35.96 | 35.97 | 35.96 | 35.97 | 5900.0 |
| 2004-10-12 19:30:00 | QQQ | ETF | 35.95 | 35.97 | 35.95 | 35.95 | 11500.0 |
| 2004-10-12 08:00:00 | IWM | ETF | 57.115 | 57.125 | 57.105 | 57.105 | 9000.0 |
| 2004-10-12 08:30:00 | IWM | ETF | 57.07 | 57.145 | 57.07 | 57.145 | 1400.0 |
> showing 50 of 1,201 rows — these rows as CSV