PREVIEW / etf_30min / 2004-01-12
file: by_date/etf_30min/2004/2004-01-12.parquet size: 34 KB rows: 1,154
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-01-12 08:00:00 | SPY | ETF | 112.62 | 112.64 | 112.6 | 112.63 | 18800.0 |
| 2004-01-12 08:30:00 | SPY | ETF | 112.65 | 112.66 | 112.6 | 112.66 | 24800.0 |
| 2004-01-12 09:00:00 | SPY | ETF | 112.64 | 112.65 | 112.56 | 112.57 | 17900.0 |
| 2004-01-12 09:30:00 | SPY | ETF | 112.53 | 112.81 | 112.42 | 112.53 | 7180500.0 |
| 2004-01-12 10:00:00 | SPY | ETF | 112.55 | 112.71 | 112.36 | 112.68 | 3598900.0 |
| 2004-01-12 10:30:00 | SPY | ETF | 112.68 | 112.84 | 112.51 | 112.62 | 2238200.0 |
| 2004-01-12 11:00:00 | SPY | ETF | 112.62 | 112.75 | 112.46 | 112.64 | 968500.0 |
| 2004-01-12 11:30:00 | SPY | ETF | 112.63 | 112.82 | 112.55 | 112.73 | 1039700.0 |
| 2004-01-12 12:00:00 | SPY | ETF | 112.73 | 112.82 | 112.69 | 112.8 | 653800.0 |
| 2004-01-12 12:30:00 | SPY | ETF | 112.8 | 112.82 | 112.54 | 112.6 | 1068700.0 |
| 2004-01-12 13:00:00 | SPY | ETF | 112.6 | 112.66 | 112.49 | 112.66 | 709300.0 |
| 2004-01-12 13:30:00 | SPY | ETF | 112.65 | 112.85 | 112.59 | 112.83 | 1670400.0 |
| 2004-01-12 14:00:00 | SPY | ETF | 112.83 | 112.9 | 112.71 | 112.78 | 1102200.0 |
| 2004-01-12 14:30:00 | SPY | ETF | 112.78 | 112.95 | 112.63 | 112.95 | 1286600.0 |
| 2004-01-12 15:00:00 | SPY | ETF | 112.94 | 112.97 | 112.84 | 112.96 | 1402000.0 |
| 2004-01-12 15:30:00 | SPY | ETF | 112.95 | 113.12 | 112.86 | 113.09 | 5081500.0 |
| 2004-01-12 16:00:00 | SPY | ETF | 113.1 | 113.25 | 113.01 | 113.22 | 1655700.0 |
| 2004-01-12 16:30:00 | SPY | ETF | 113.22 | 113.27 | 113.21 | 113.25 | 24400.0 |
| 2004-01-12 17:00:00 | SPY | ETF | 113.28 | 113.34 | 113.23 | 113.23 | 45200.0 |
| 2004-01-12 17:30:00 | SPY | ETF | 113.01 | 113.01 | 113.01 | 113.01 | 2000000.0 |
| 2004-01-12 18:00:00 | SPY | ETF | 113.26 | 113.28 | 113.26 | 113.28 | 2400.0 |
| 2004-01-12 18:30:00 | SPY | ETF | 113.28 | 113.28 | 113.28 | 113.28 | 500.0 |
| 2004-01-12 19:00:00 | SPY | ETF | 113.28 | 113.28 | 113.21 | 113.21 | 1400.0 |
| 2004-01-12 19:30:00 | SPY | ETF | 113.24 | 113.24 | 113.23 | 113.23 | 300.0 |
| 2004-01-12 08:00:00 | QQQ | ETF | 37.82 | 37.85 | 37.8 | 37.82 | 20400.0 |
| 2004-01-12 08:30:00 | QQQ | ETF | 37.83 | 37.85 | 37.81 | 37.84 | 22400.0 |
| 2004-01-12 09:00:00 | QQQ | ETF | 37.84 | 37.91 | 37.83 | 37.87 | 133800.0 |
| 2004-01-12 09:30:00 | QQQ | ETF | 37.85 | 37.96 | 37.735 | 37.805 | 10904900.0 |
| 2004-01-12 10:00:00 | QQQ | ETF | 37.809 | 37.91 | 37.68 | 37.87 | 6626200.0 |
| 2004-01-12 10:30:00 | QQQ | ETF | 37.874 | 37.98 | 37.79 | 37.879 | 5915900.0 |
| 2004-01-12 11:00:00 | QQQ | ETF | 37.88 | 37.96 | 37.84 | 37.9 | 3836300.0 |
| 2004-01-12 11:30:00 | QQQ | ETF | 37.91 | 38.04 | 37.88 | 38.0 | 4959000.0 |
| 2004-01-12 12:00:00 | QQQ | ETF | 38.01 | 38.1 | 37.99 | 38.06 | 4150100.0 |
| 2004-01-12 12:30:00 | QQQ | ETF | 38.06 | 38.07 | 37.92 | 37.99 | 2863800.0 |
| 2004-01-12 13:00:00 | QQQ | ETF | 37.98 | 38.0 | 37.86 | 37.96 | 2277100.0 |
| 2004-01-12 13:30:00 | QQQ | ETF | 37.96 | 38.084 | 37.94 | 38.07 | 3949900.0 |
| 2004-01-12 14:00:00 | QQQ | ETF | 38.08 | 38.11 | 37.99 | 38.04 | 3781800.0 |
| 2004-01-12 14:30:00 | QQQ | ETF | 38.04 | 38.134 | 38.0 | 38.12 | 3727800.0 |
| 2004-01-12 15:00:00 | QQQ | ETF | 38.13 | 38.21 | 38.09 | 38.194 | 6922700.0 |
| 2004-01-12 15:30:00 | QQQ | ETF | 38.19 | 38.319 | 38.155 | 38.31 | 8297700.0 |
| 2004-01-12 16:00:00 | QQQ | ETF | 38.3 | 38.36 | 38.28 | 38.35 | 2161500.0 |
| 2004-01-12 16:30:00 | QQQ | ETF | 38.35 | 38.4 | 38.28 | 38.39 | 2711400.0 |
| 2004-01-12 17:00:00 | QQQ | ETF | 38.391 | 38.41 | 38.36 | 38.39 | 105200.0 |
| 2004-01-12 17:30:00 | QQQ | ETF | 38.38 | 38.4 | 38.37 | 38.39 | 10300.0 |
| 2004-01-12 18:00:00 | QQQ | ETF | 38.39 | 38.42 | 38.38 | 38.4 | 18900.0 |
| 2004-01-12 18:30:00 | QQQ | ETF | 38.4 | 38.42 | 38.4 | 38.4 | 12600.0 |
| 2004-01-12 19:00:00 | QQQ | ETF | 38.4 | 38.41 | 38.4 | 38.41 | 13800.0 |
| 2004-01-12 19:30:00 | QQQ | ETF | 38.4 | 38.4 | 38.4 | 38.4 | 1500.0 |
| 2004-01-12 09:30:00 | IWM | ETF | 57.44 | 57.795 | 57.3155 | 57.415 | 636200.0 |
| 2004-01-12 10:00:00 | IWM | ETF | 57.41 | 57.585 | 57.25 | 57.54 | 637400.0 |
> showing 50 of 1,154 rows — these rows as CSV