PREVIEW / etf_30min / 2000-04-13
file: by_date/etf_30min/2000/2000-04-13.parquet size: 10 KB rows: 206
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-04-13 09:30:00 | SPY | ETF | 147.4688 | 147.5625 | 145.1562 | 146.7188 | 2586000.0 |
| 2000-04-13 10:00:00 | SPY | ETF | 146.9375 | 147.9688 | 146.75 | 146.9062 | 1316100.0 |
| 2000-04-13 10:30:00 | SPY | ETF | 146.875 | 147.0 | 145.6562 | 146.5 | 1383800.0 |
| 2000-04-13 11:00:00 | SPY | ETF | 146.5625 | 147.2188 | 145.9375 | 147.2188 | 580800.0 |
| 2000-04-13 11:30:00 | SPY | ETF | 147.0625 | 147.5 | 146.8125 | 147.0938 | 516800.0 |
| 2000-04-13 12:00:00 | SPY | ETF | 147.0938 | 147.9688 | 146.875 | 147.4688 | 407900.0 |
| 2000-04-13 12:30:00 | SPY | ETF | 147.7188 | 148.1562 | 147.0625 | 147.125 | 397400.0 |
| 2000-04-13 13:00:00 | SPY | ETF | 147.25 | 147.6562 | 146.875 | 147.0 | 245200.0 |
| 2000-04-13 13:30:00 | SPY | ETF | 147.0 | 147.75 | 146.75 | 147.75 | 142700.0 |
| 2000-04-13 14:00:00 | SPY | ETF | 147.7812 | 147.7812 | 146.5625 | 146.625 | 237200.0 |
| 2000-04-13 14:30:00 | SPY | ETF | 146.7812 | 147.0625 | 145.3438 | 145.7812 | 760100.0 |
| 2000-04-13 15:00:00 | SPY | ETF | 146.0 | 147.3125 | 145.9062 | 146.75 | 1728300.0 |
| 2000-04-13 15:30:00 | SPY | ETF | 146.7812 | 146.7812 | 143.7812 | 144.0 | 1378100.0 |
| 2000-04-13 16:00:00 | SPY | ETF | 144.0 | 144.375 | 143.8438 | 144.25 | 500100.0 |
| 2000-04-13 09:30:00 | QQQ | ETF | 92.8125 | 93.0 | 88.6875 | 91.75 | 8510700.0 |
| 2000-04-13 10:00:00 | QQQ | ETF | 91.8125 | 95.0 | 91.25 | 93.0625 | 6282300.0 |
| 2000-04-13 10:30:00 | QQQ | ETF | 93.125 | 93.5312 | 90.625 | 92.4688 | 3498200.0 |
| 2000-04-13 11:00:00 | QQQ | ETF | 92.375 | 93.375 | 91.625 | 93.25 | 2545200.0 |
| 2000-04-13 11:30:00 | QQQ | ETF | 93.375 | 94.0 | 92.3125 | 93.6875 | 3772200.0 |
| 2000-04-13 12:00:00 | QQQ | ETF | 93.6875 | 95.5 | 93.4375 | 95.4062 | 3957100.0 |
| 2000-04-13 12:30:00 | QQQ | ETF | 95.4062 | 96.0 | 94.4062 | 94.6875 | 2874100.0 |
| 2000-04-13 13:00:00 | QQQ | ETF | 94.5 | 94.875 | 93.125 | 93.5938 | 1419600.0 |
| 2000-04-13 13:30:00 | QQQ | ETF | 93.75 | 94.4688 | 93.25 | 94.4375 | 1257700.0 |
| 2000-04-13 14:00:00 | QQQ | ETF | 94.5 | 94.625 | 92.75 | 92.75 | 1119500.0 |
| 2000-04-13 14:30:00 | QQQ | ETF | 92.75 | 93.5 | 90.5625 | 90.75 | 3065400.0 |
| 2000-04-13 15:00:00 | QQQ | ETF | 90.625 | 93.4688 | 90.5625 | 92.375 | 3349800.0 |
| 2000-04-13 15:30:00 | QQQ | ETF | 92.25 | 92.4375 | 88.3438 | 89.0 | 3486800.0 |
| 2000-04-13 16:00:00 | QQQ | ETF | 89.0 | 89.125 | 88.25 | 88.5 | 943100.0 |
| 2000-04-13 16:30:00 | QQQ | ETF | 88.5625 | 89.4375 | 88.5 | 88.5 | 4700.0 |
| 2000-04-13 17:00:00 | QQQ | ETF | 89.0 | 89.5 | 88.5 | 89.0 | 3800.0 |
| 2000-04-13 17:30:00 | QQQ | ETF | 88.375 | 88.75 | 88.3125 | 88.5 | 2100.0 |
| 2000-04-13 18:00:00 | QQQ | ETF | 88.5 | 88.5 | 88.0 | 88.0 | 2600.0 |
| 2000-04-13 09:30:00 | DIA | ETF | 111.3438 | 111.4375 | 109.7812 | 110.9375 | 534100.0 |
| 2000-04-13 10:00:00 | DIA | ETF | 110.9375 | 111.5625 | 110.625 | 110.625 | 339500.0 |
| 2000-04-13 10:30:00 | DIA | ETF | 110.5625 | 110.6875 | 109.5312 | 110.0938 | 954000.0 |
| 2000-04-13 11:00:00 | DIA | ETF | 110.0625 | 110.5 | 109.8125 | 110.3438 | 621400.0 |
| 2000-04-13 11:30:00 | DIA | ETF | 110.4062 | 110.9062 | 110.1875 | 110.5312 | 284000.0 |
| 2000-04-13 12:00:00 | DIA | ETF | 110.2188 | 110.875 | 110.2188 | 110.5312 | 162800.0 |
| 2000-04-13 12:30:00 | DIA | ETF | 110.4375 | 110.9375 | 110.25 | 110.3125 | 64500.0 |
| 2000-04-13 13:00:00 | DIA | ETF | 110.5 | 110.75 | 110.25 | 110.25 | 349200.0 |
| 2000-04-13 13:30:00 | DIA | ETF | 110.5312 | 110.9688 | 110.25 | 110.9688 | 92300.0 |
| 2000-04-13 14:00:00 | DIA | ETF | 111.0938 | 111.0938 | 110.0 | 110.0 | 55400.0 |
| 2000-04-13 14:30:00 | DIA | ETF | 110.0 | 110.4062 | 109.2188 | 109.5938 | 196000.0 |
| 2000-04-13 15:00:00 | DIA | ETF | 109.5938 | 110.7188 | 109.5938 | 110.3125 | 185200.0 |
| 2000-04-13 15:30:00 | DIA | ETF | 110.4688 | 110.4688 | 109.0 | 109.0 | 417900.0 |
| 2000-04-13 16:00:00 | DIA | ETF | 108.75 | 109.0625 | 108.75 | 109.0312 | 67200.0 |
> showing 46 of 206 rows — these rows as CSV