PREVIEW / etf_30min / 2000-01-25
file: by_date/etf_30min/2000/2000-01-25.parquet size: 10 KB rows: 226
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-25 09:30:00 | SPY | ETF | 140.5 | 140.75 | 139.7812 | 140.75 | 1155600.0 |
| 2000-01-25 10:00:00 | SPY | ETF | 140.75 | 141.4688 | 140.625 | 141.0625 | 1559900.0 |
| 2000-01-25 10:30:00 | SPY | ETF | 140.9375 | 141.125 | 140.1562 | 140.6875 | 545700.0 |
| 2000-01-25 11:00:00 | SPY | ETF | 140.6875 | 141.4688 | 140.5938 | 140.8438 | 329200.0 |
| 2000-01-25 11:30:00 | SPY | ETF | 141.0 | 141.1562 | 140.5 | 140.5625 | 191200.0 |
| 2000-01-25 12:00:00 | SPY | ETF | 140.5312 | 141.0 | 140.125 | 140.25 | 737900.0 |
| 2000-01-25 12:30:00 | SPY | ETF | 140.125 | 140.3125 | 139.75 | 139.9375 | 1007500.0 |
| 2000-01-25 13:00:00 | SPY | ETF | 140.0 | 140.4062 | 139.625 | 139.75 | 398500.0 |
| 2000-01-25 13:30:00 | SPY | ETF | 139.75 | 140.0625 | 139.0 | 139.0938 | 872600.0 |
| 2000-01-25 14:00:00 | SPY | ETF | 139.0 | 140.0938 | 139.0 | 139.625 | 1320400.0 |
| 2000-01-25 14:30:00 | SPY | ETF | 139.7188 | 140.625 | 139.625 | 140.125 | 487100.0 |
| 2000-01-25 15:00:00 | SPY | ETF | 140.1875 | 141.1875 | 139.7812 | 140.8438 | 284500.0 |
| 2000-01-25 15:30:00 | SPY | ETF | 140.875 | 141.625 | 140.875 | 141.0 | 471100.0 |
| 2000-01-25 16:00:00 | SPY | ETF | 141.1875 | 141.1875 | 140.75 | 141.1562 | 564100.0 |
| 2000-01-25 16:30:00 | SPY | ETF | 141.9375 | 141.9375 | 141.9375 | 141.9375 | 4000.0 |
| 2000-01-25 09:30:00 | QQQ | ETF | 91.875 | 91.9688 | 89.4062 | 91.0 | 5562600.0 |
| 2000-01-25 10:00:00 | QQQ | ETF | 91.0 | 92.5 | 90.7812 | 91.875 | 4452000.0 |
| 2000-01-25 10:30:00 | QQQ | ETF | 91.9062 | 92.0 | 90.5625 | 91.5 | 1562800.0 |
| 2000-01-25 11:00:00 | QQQ | ETF | 91.5 | 92.5 | 91.3438 | 92.0 | 1374200.0 |
| 2000-01-25 11:30:00 | QQQ | ETF | 91.9688 | 92.4375 | 91.375 | 91.4844 | 1159400.0 |
| 2000-01-25 12:00:00 | QQQ | ETF | 91.5312 | 92.1875 | 91.1562 | 91.1719 | 1578600.0 |
| 2000-01-25 12:30:00 | QQQ | ETF | 91.1562 | 91.4688 | 90.75 | 91.25 | 1336000.0 |
| 2000-01-25 13:00:00 | QQQ | ETF | 91.1406 | 91.6875 | 90.875 | 91.1562 | 1296400.0 |
| 2000-01-25 13:30:00 | QQQ | ETF | 91.25 | 91.4219 | 89.75 | 90.0625 | 2252200.0 |
| 2000-01-25 14:00:00 | QQQ | ETF | 89.75 | 91.25 | 89.625 | 90.625 | 2965200.0 |
| 2000-01-25 14:30:00 | QQQ | ETF | 90.5938 | 92.1875 | 90.5938 | 91.75 | 2229600.0 |
| 2000-01-25 15:00:00 | QQQ | ETF | 91.8125 | 92.875 | 91.25 | 92.75 | 2904400.0 |
| 2000-01-25 15:30:00 | QQQ | ETF | 92.75 | 93.875 | 92.5625 | 93.625 | 3624800.0 |
| 2000-01-25 16:00:00 | QQQ | ETF | 93.7031 | 94.1094 | 93.25 | 94.0 | 857000.0 |
| 2000-01-25 16:30:00 | QQQ | ETF | 94.0 | 94.0 | 93.0 | 93.125 | 10000.0 |
| 2000-01-25 17:00:00 | QQQ | ETF | 93.1562 | 93.1562 | 93.0 | 93.0625 | 6800.0 |
| 2000-01-25 17:30:00 | QQQ | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 400.0 |
| 2000-01-25 09:30:00 | DIA | ETF | 110.5938 | 110.75 | 110.0625 | 110.5312 | 252700.0 |
| 2000-01-25 10:00:00 | DIA | ETF | 110.625 | 110.875 | 110.0625 | 110.5 | 133100.0 |
| 2000-01-25 10:30:00 | DIA | ETF | 110.4375 | 110.4375 | 109.7188 | 110.1875 | 72600.0 |
| 2000-01-25 11:00:00 | DIA | ETF | 110.1875 | 110.6562 | 110.0312 | 110.125 | 92800.0 |
| 2000-01-25 11:30:00 | DIA | ETF | 110.25 | 110.3125 | 109.8125 | 109.9375 | 28500.0 |
| 2000-01-25 12:00:00 | DIA | ETF | 109.9375 | 110.1562 | 109.6875 | 109.8438 | 25600.0 |
| 2000-01-25 12:30:00 | DIA | ETF | 109.7188 | 109.8125 | 109.25 | 109.5625 | 88000.0 |
| 2000-01-25 13:00:00 | DIA | ETF | 109.625 | 109.875 | 109.3125 | 109.5 | 53300.0 |
| 2000-01-25 13:30:00 | DIA | ETF | 109.5 | 109.5938 | 108.75 | 108.75 | 214400.0 |
| 2000-01-25 14:00:00 | DIA | ETF | 108.75 | 109.625 | 108.75 | 109.25 | 150200.0 |
| 2000-01-25 14:30:00 | DIA | ETF | 109.25 | 110.125 | 109.25 | 109.9062 | 141600.0 |
| 2000-01-25 15:00:00 | DIA | ETF | 109.9062 | 110.625 | 109.4375 | 110.3125 | 255100.0 |
| 2000-01-25 15:30:00 | DIA | ETF | 110.25 | 110.7812 | 110.1562 | 110.375 | 140800.0 |
| 2000-01-25 16:00:00 | DIA | ETF | 110.3438 | 110.3438 | 110.0938 | 110.3438 | 57600.0 |
> showing 46 of 226 rows — these rows as CSV