PREVIEW / etf_30min / 2004-01-13
file: by_date/etf_30min/2004/2004-01-13.parquet size: 35 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-13 08:00:00 | SPY | ETF | 113.25 | 113.29 | 113.19 | 113.19 | 5000.0 |
| 2004-01-13 08:30:00 | SPY | ETF | 113.19 | 113.19 | 113.12 | 113.12 | 10500.0 |
| 2004-01-13 09:00:00 | SPY | ETF | 113.12 | 113.15 | 113.08 | 113.11 | 12500.0 |
| 2004-01-13 09:30:00 | SPY | ETF | 113.06 | 113.23 | 113.02 | 113.1 | 1962800.0 |
| 2004-01-13 10:00:00 | SPY | ETF | 113.09 | 113.21 | 112.91 | 112.97 | 1916500.0 |
| 2004-01-13 10:30:00 | SPY | ETF | 112.97 | 113.04 | 112.65 | 112.68 | 2234700.0 |
| 2004-01-13 11:00:00 | SPY | ETF | 112.68 | 112.83 | 112.64 | 112.73 | 1824000.0 |
| 2004-01-13 11:30:00 | SPY | ETF | 112.74 | 112.8 | 112.0 | 112.02 | 2306900.0 |
| 2004-01-13 12:00:00 | SPY | ETF | 112.1 | 112.28 | 111.82 | 112.26 | 5916900.0 |
| 2004-01-13 12:30:00 | SPY | ETF | 112.22 | 112.35 | 112.16 | 112.2 | 1910600.0 |
| 2004-01-13 13:00:00 | SPY | ETF | 112.2 | 112.3 | 112.08 | 112.28 | 1140300.0 |
| 2004-01-13 13:30:00 | SPY | ETF | 112.28 | 112.34 | 112.13 | 112.17 | 1188300.0 |
| 2004-01-13 14:00:00 | SPY | ETF | 112.16 | 112.39 | 111.96 | 112.0 | 2105600.0 |
| 2004-01-13 14:30:00 | SPY | ETF | 111.99 | 112.13 | 111.76 | 112.13 | 3929800.0 |
| 2004-01-13 15:00:00 | SPY | ETF | 112.11 | 112.32 | 112.0 | 112.26 | 2286600.0 |
| 2004-01-13 15:30:00 | SPY | ETF | 112.27 | 112.48 | 112.16 | 112.47 | 2999900.0 |
| 2004-01-13 16:00:00 | SPY | ETF | 112.44 | 112.56 | 112.26 | 112.26 | 6731700.0 |
| 2004-01-13 16:30:00 | SPY | ETF | 112.53 | 112.55 | 112.41 | 112.52 | 2949600.0 |
| 2004-01-13 17:00:00 | SPY | ETF | 112.54 | 112.54 | 112.51 | 112.51 | 1100.0 |
| 2004-01-13 17:30:00 | SPY | ETF | 112.5 | 112.5 | 112.48 | 112.48 | 1800.0 |
| 2004-01-13 18:00:00 | SPY | ETF | 112.48 | 112.55 | 112.48 | 112.55 | 44800.0 |
| 2004-01-13 19:00:00 | SPY | ETF | 112.46 | 112.46 | 112.41 | 112.41 | 1500.0 |
| 2004-01-13 19:30:00 | SPY | ETF | 112.4 | 112.4 | 112.39 | 112.39 | 5300.0 |
| 2004-01-13 08:00:00 | QQQ | ETF | 38.34 | 38.36 | 38.33 | 38.33 | 14300.0 |
| 2004-01-13 08:30:00 | QQQ | ETF | 38.31 | 38.31 | 38.26 | 38.28 | 50900.0 |
| 2004-01-13 09:00:00 | QQQ | ETF | 38.29 | 38.3 | 38.26 | 38.27 | 157600.0 |
| 2004-01-13 09:30:00 | QQQ | ETF | 38.27 | 38.344 | 38.2 | 38.26 | 10163200.0 |
| 2004-01-13 10:00:00 | QQQ | ETF | 38.25 | 38.33 | 38.1 | 38.121 | 12099200.0 |
| 2004-01-13 10:30:00 | QQQ | ETF | 38.12 | 38.16 | 37.937 | 37.961 | 9253500.0 |
| 2004-01-13 11:00:00 | QQQ | ETF | 37.95 | 38.06 | 37.92 | 37.96 | 5667500.0 |
| 2004-01-13 11:30:00 | QQQ | ETF | 37.97 | 38.0 | 37.68 | 37.71 | 6887400.0 |
| 2004-01-13 12:00:00 | QQQ | ETF | 37.69 | 37.83 | 37.61 | 37.79 | 9989900.0 |
| 2004-01-13 12:30:00 | QQQ | ETF | 37.781 | 37.88 | 37.76 | 37.786 | 3534600.0 |
| 2004-01-13 13:00:00 | QQQ | ETF | 37.77 | 37.82 | 37.729 | 37.808 | 3011100.0 |
| 2004-01-13 13:30:00 | QQQ | ETF | 37.809 | 37.88 | 37.75 | 37.79 | 3238300.0 |
| 2004-01-13 14:00:00 | QQQ | ETF | 37.78 | 37.88 | 37.67 | 37.705 | 4088000.0 |
| 2004-01-13 14:30:00 | QQQ | ETF | 37.709 | 37.78 | 37.62 | 37.76 | 5010600.0 |
| 2004-01-13 15:00:00 | QQQ | ETF | 37.75 | 37.86 | 37.71 | 37.83 | 4931200.0 |
| 2004-01-13 15:30:00 | QQQ | ETF | 37.82 | 37.93 | 37.78 | 37.9 | 5667000.0 |
| 2004-01-13 16:00:00 | QQQ | ETF | 37.916 | 37.969 | 37.88 | 37.93 | 1954700.0 |
| 2004-01-13 16:30:00 | QQQ | ETF | 37.94 | 37.99 | 37.93 | 37.955 | 405200.0 |
| 2004-01-13 17:00:00 | QQQ | ETF | 37.94 | 37.99 | 37.935 | 37.96 | 34000.0 |
| 2004-01-13 17:30:00 | QQQ | ETF | 37.99 | 37.99 | 37.92 | 37.92 | 78500.0 |
| 2004-01-13 18:00:00 | QQQ | ETF | 37.94 | 38.008 | 37.94 | 37.97 | 23400.0 |
| 2004-01-13 18:30:00 | QQQ | ETF | 37.97 | 37.97 | 37.97 | 37.97 | 9900.0 |
| 2004-01-13 19:00:00 | QQQ | ETF | 37.96 | 37.96 | 37.96 | 37.96 | 1200.0 |
| 2004-01-13 19:30:00 | QQQ | ETF | 37.97 | 37.97 | 37.93 | 37.96 | 5000.0 |
| 2004-01-13 08:00:00 | IWM | ETF | 58.255 | 58.255 | 58.255 | 58.255 | 4000.0 |
| 2004-01-13 09:30:00 | IWM | ETF | 58.1535 | 58.16 | 57.98 | 58.02 | 637600.0 |
| 2004-01-13 10:00:00 | IWM | ETF | 58.0705 | 58.125 | 57.9055 | 57.925 | 513800.0 |
> showing 50 of 1,154 rows — these rows as CSV