PREVIEW / etf_30min / 2000-11-16
file: by_date/etf_30min/2000/2000-11-16.parquet size: 11 KB rows: 260
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-11-16 09:30:00 | SPY | ETF | 138.5625 | 139.375 | 138.4375 | 138.75 | 1146300.0 |
| 2000-11-16 10:00:00 | SPY | ETF | 138.875 | 139.5625 | 138.875 | 139.1875 | 174000.0 |
| 2000-11-16 10:30:00 | SPY | ETF | 139.1562 | 139.875 | 139.0938 | 139.375 | 955400.0 |
| 2000-11-16 11:00:00 | SPY | ETF | 139.625 | 139.625 | 138.6875 | 138.9688 | 389900.0 |
| 2000-11-16 11:30:00 | SPY | ETF | 138.875 | 139.125 | 138.5625 | 139.125 | 498500.0 |
| 2000-11-16 12:00:00 | SPY | ETF | 139.125 | 139.1562 | 138.5625 | 138.6875 | 81600.0 |
| 2000-11-16 12:30:00 | SPY | ETF | 138.6875 | 138.9062 | 138.5938 | 138.9062 | 151000.0 |
| 2000-11-16 13:00:00 | SPY | ETF | 138.9062 | 138.9375 | 138.0 | 138.125 | 277400.0 |
| 2000-11-16 13:30:00 | SPY | ETF | 138.125 | 138.5 | 138.0938 | 138.3125 | 440800.0 |
| 2000-11-16 14:00:00 | SPY | ETF | 138.4375 | 138.8125 | 138.25 | 138.6875 | 554400.0 |
| 2000-11-16 14:30:00 | SPY | ETF | 138.75 | 138.75 | 137.8438 | 137.9375 | 324800.0 |
| 2000-11-16 15:00:00 | SPY | ETF | 138.0938 | 138.375 | 137.75 | 137.75 | 272400.0 |
| 2000-11-16 15:30:00 | SPY | ETF | 137.75 | 138.0 | 137.3125 | 137.75 | 772500.0 |
| 2000-11-16 16:00:00 | SPY | ETF | 137.75 | 137.75 | 137.375 | 137.375 | 466300.0 |
| 2000-11-16 16:30:00 | SPY | ETF | 137.375 | 137.375 | 137.375 | 137.375 | 200.0 |
| 2000-11-16 09:30:00 | QQQ | ETF | 75.375 | 76.25 | 74.875 | 75.4375 | 6357500.0 |
| 2000-11-16 10:00:00 | QQQ | ETF | 75.375 | 76.3125 | 75.2812 | 75.9375 | 1956700.0 |
| 2000-11-16 10:30:00 | QQQ | ETF | 75.875 | 77.0 | 75.75 | 76.25 | 2959500.0 |
| 2000-11-16 11:00:00 | QQQ | ETF | 76.3125 | 76.5 | 75.375 | 75.6562 | 2324200.0 |
| 2000-11-16 11:30:00 | QQQ | ETF | 75.625 | 76.125 | 75.5 | 76.0625 | 1568700.0 |
| 2000-11-16 12:00:00 | QQQ | ETF | 76.0625 | 76.2188 | 75.375 | 75.4375 | 865400.0 |
| 2000-11-16 12:30:00 | QQQ | ETF | 75.4062 | 75.5625 | 75.0625 | 75.375 | 1671300.0 |
| 2000-11-16 13:00:00 | QQQ | ETF | 75.3125 | 75.4688 | 74.0625 | 74.3438 | 1602500.0 |
| 2000-11-16 13:30:00 | QQQ | ETF | 74.3438 | 74.875 | 74.25 | 74.75 | 1447100.0 |
| 2000-11-16 14:00:00 | QQQ | ETF | 74.75 | 75.25 | 74.5 | 75.0625 | 1540600.0 |
| 2000-11-16 14:30:00 | QQQ | ETF | 75.0625 | 75.125 | 73.75 | 73.875 | 1958200.0 |
| 2000-11-16 15:00:00 | QQQ | ETF | 73.8438 | 74.375 | 73.625 | 73.75 | 2770400.0 |
| 2000-11-16 15:30:00 | QQQ | ETF | 73.6875 | 74.0 | 73.0 | 73.0 | 4457100.0 |
| 2000-11-16 16:00:00 | QQQ | ETF | 73.0 | 73.25 | 72.4062 | 72.9375 | 910700.0 |
| 2000-11-16 16:30:00 | QQQ | ETF | 72.9375 | 73.25 | 72.75 | 73.0 | 11500.0 |
| 2000-11-16 17:00:00 | QQQ | ETF | 73.0 | 73.625 | 72.875 | 73.0 | 65700.0 |
| 2000-11-16 17:30:00 | QQQ | ETF | 73.1875 | 73.25 | 73.0 | 73.0625 | 7800.0 |
| 2000-11-16 18:00:00 | QQQ | ETF | 73.0 | 73.0625 | 72.875 | 73.0 | 17900.0 |
| 2000-11-16 09:30:00 | IWM | ETF | 48.8438 | 49.1562 | 48.7812 | 49.0 | 42000.0 |
| 2000-11-16 10:00:00 | IWM | ETF | 48.875 | 49.0312 | 48.875 | 49.0312 | 3400.0 |
| 2000-11-16 10:30:00 | IWM | ETF | 49.2188 | 49.2344 | 49.2188 | 49.2344 | 20200.0 |
| 2000-11-16 11:00:00 | IWM | ETF | 48.9688 | 48.9688 | 48.9688 | 48.9688 | 600.0 |
| 2000-11-16 11:30:00 | IWM | ETF | 49.0 | 49.0 | 49.0 | 49.0 | 200.0 |
| 2000-11-16 12:00:00 | IWM | ETF | 48.9688 | 48.9688 | 48.875 | 48.875 | 1200.0 |
| 2000-11-16 12:30:00 | IWM | ETF | 48.7188 | 48.9688 | 48.7188 | 48.9688 | 3800.0 |
| 2000-11-16 13:00:00 | IWM | ETF | 48.8438 | 48.8438 | 48.5625 | 48.5625 | 11000.0 |
| 2000-11-16 13:30:00 | IWM | ETF | 48.5625 | 48.5625 | 48.5312 | 48.5312 | 7600.0 |
| 2000-11-16 14:00:00 | IWM | ETF | 48.7812 | 48.7812 | 48.7812 | 48.7812 | 2200.0 |
| 2000-11-16 14:30:00 | IWM | ETF | 48.7969 | 48.7969 | 48.5625 | 48.5625 | 4200.0 |
| 2000-11-16 15:00:00 | IWM | ETF | 48.6875 | 48.6875 | 48.375 | 48.375 | 41400.0 |
| 2000-11-16 15:30:00 | IWM | ETF | 48.4062 | 48.4062 | 48.1562 | 48.1875 | 7000.0 |
| 2000-11-16 16:00:00 | IWM | ETF | 47.9531 | 48.0 | 47.8438 | 47.8438 | 7400.0 |
| 2000-11-16 09:30:00 | DIA | ETF | 106.7812 | 107.4688 | 106.7812 | 107.125 | 107700.0 |
| 2000-11-16 10:00:00 | DIA | ETF | 107.0625 | 107.75 | 107.0625 | 107.5 | 32800.0 |
| 2000-11-16 10:30:00 | DIA | ETF | 107.4688 | 107.8438 | 107.3125 | 107.3125 | 41900.0 |
> showing 50 of 260 rows — these rows as CSV