PREVIEW / etf_30min / 2001-01-11
file: by_date/etf_30min/2001/2001-01-11.parquet size: 12 KB rows: 315
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-11 09:30:00 | SPY | ETF | 131.0938 | 132.0 | 131.0938 | 132.0 | 833900.0 |
| 2001-01-11 10:00:00 | SPY | ETF | 132.0 | 132.3125 | 131.625 | 132.3125 | 298400.0 |
| 2001-01-11 10:30:00 | SPY | ETF | 132.3438 | 132.875 | 131.875 | 132.1562 | 1123900.0 |
| 2001-01-11 11:00:00 | SPY | ETF | 132.1562 | 132.6562 | 132.0625 | 132.3125 | 352500.0 |
| 2001-01-11 11:30:00 | SPY | ETF | 132.375 | 132.7188 | 132.1875 | 132.5 | 243200.0 |
| 2001-01-11 12:00:00 | SPY | ETF | 132.4062 | 132.75 | 132.375 | 132.5 | 290600.0 |
| 2001-01-11 12:30:00 | SPY | ETF | 132.4375 | 132.7812 | 132.25 | 132.375 | 424200.0 |
| 2001-01-11 13:00:00 | SPY | ETF | 132.3125 | 132.5312 | 132.0312 | 132.5 | 291000.0 |
| 2001-01-11 13:30:00 | SPY | ETF | 132.5 | 132.7188 | 132.3125 | 132.5 | 227900.0 |
| 2001-01-11 14:00:00 | SPY | ETF | 132.625 | 133.0625 | 132.5 | 132.9062 | 265500.0 |
| 2001-01-11 14:30:00 | SPY | ETF | 132.9688 | 133.0625 | 132.3125 | 132.9375 | 309400.0 |
| 2001-01-11 15:00:00 | SPY | ETF | 132.8125 | 133.4688 | 132.6875 | 133.1875 | 516300.0 |
| 2001-01-11 15:30:00 | SPY | ETF | 133.2188 | 133.4062 | 132.75 | 132.75 | 735400.0 |
| 2001-01-11 16:00:00 | SPY | ETF | 132.875 | 132.875 | 131.5 | 132.0 | 1047200.0 |
| 2001-01-11 16:30:00 | SPY | ETF | 132.25 | 132.3125 | 132.25 | 132.3125 | 6300.0 |
| 2001-01-11 17:00:00 | SPY | ETF | 132.3125 | 132.3125 | 132.3125 | 132.3125 | 2600.0 |
| 2001-01-11 17:30:00 | SPY | ETF | 132.25 | 132.25 | 132.25 | 132.25 | 2500.0 |
| 2001-01-11 09:30:00 | QQQ | ETF | 59.25 | 60.9375 | 59.25 | 60.1875 | 9382500.0 |
| 2001-01-11 10:00:00 | QQQ | ETF | 60.25 | 60.9062 | 59.75 | 60.875 | 5344900.0 |
| 2001-01-11 10:30:00 | QQQ | ETF | 60.8125 | 61.4375 | 60.625 | 60.75 | 4443400.0 |
| 2001-01-11 11:00:00 | QQQ | ETF | 60.75 | 61.5625 | 60.6562 | 61.4375 | 2781300.0 |
| 2001-01-11 11:30:00 | QQQ | ETF | 61.4375 | 62.1562 | 61.3125 | 61.75 | 5786200.0 |
| 2001-01-11 12:00:00 | QQQ | ETF | 61.75 | 62.125 | 61.5 | 61.8125 | 2601700.0 |
| 2001-01-11 12:30:00 | QQQ | ETF | 61.9062 | 62.25 | 61.75 | 61.8125 | 2584200.0 |
| 2001-01-11 13:00:00 | QQQ | ETF | 61.7812 | 62.0 | 61.375 | 61.9688 | 2589300.0 |
| 2001-01-11 13:30:00 | QQQ | ETF | 62.0 | 62.5312 | 61.875 | 62.375 | 2683600.0 |
| 2001-01-11 14:00:00 | QQQ | ETF | 62.375 | 63.0938 | 62.375 | 62.9375 | 4839200.0 |
| 2001-01-11 14:30:00 | QQQ | ETF | 62.875 | 63.125 | 62.5625 | 62.75 | 4764900.0 |
| 2001-01-11 15:00:00 | QQQ | ETF | 62.6875 | 63.6875 | 62.6875 | 63.3438 | 5037600.0 |
| 2001-01-11 15:30:00 | QQQ | ETF | 63.25 | 63.4062 | 62.75 | 62.875 | 5508400.0 |
| 2001-01-11 16:00:00 | QQQ | ETF | 62.9688 | 62.9688 | 61.5 | 61.875 | 3285900.0 |
| 2001-01-11 16:30:00 | QQQ | ETF | 62.0 | 62.0 | 61.25 | 61.5 | 664000.0 |
| 2001-01-11 17:00:00 | QQQ | ETF | 61.6875 | 62.0 | 61.4375 | 61.9375 | 176300.0 |
| 2001-01-11 17:30:00 | QQQ | ETF | 61.9375 | 62.125 | 61.9375 | 62.0625 | 63000.0 |
| 2001-01-11 18:00:00 | QQQ | ETF | 62.0625 | 62.25 | 62.0 | 62.125 | 101000.0 |
| 2001-01-11 09:30:00 | IWM | ETF | 47.25 | 47.7188 | 47.25 | 47.3438 | 38600.0 |
| 2001-01-11 10:00:00 | IWM | ETF | 47.6875 | 47.6875 | 47.625 | 47.6562 | 24800.0 |
| 2001-01-11 10:30:00 | IWM | ETF | 47.7812 | 47.7812 | 47.6875 | 47.6875 | 12000.0 |
| 2001-01-11 11:00:00 | IWM | ETF | 47.6719 | 47.7969 | 47.6719 | 47.75 | 15800.0 |
| 2001-01-11 11:30:00 | IWM | ETF | 47.7969 | 47.9062 | 47.7969 | 47.8906 | 42000.0 |
| 2001-01-11 12:00:00 | IWM | ETF | 47.8906 | 48.0312 | 47.8438 | 47.9688 | 3000.0 |
| 2001-01-11 12:30:00 | IWM | ETF | 47.875 | 48.0312 | 47.875 | 47.875 | 4200.0 |
| 2001-01-11 13:00:00 | IWM | ETF | 47.9062 | 47.9375 | 47.9062 | 47.9375 | 1200.0 |
| 2001-01-11 13:30:00 | IWM | ETF | 48.0 | 48.0 | 48.0 | 48.0 | 1200.0 |
| 2001-01-11 14:00:00 | IWM | ETF | 48.0 | 48.3125 | 48.0 | 48.2188 | 68600.0 |
| 2001-01-11 14:30:00 | IWM | ETF | 48.2812 | 48.2969 | 48.2188 | 48.2188 | 4200.0 |
| 2001-01-11 15:00:00 | IWM | ETF | 48.2969 | 48.4375 | 48.25 | 48.4375 | 22400.0 |
| 2001-01-11 15:30:00 | IWM | ETF | 48.4062 | 48.4062 | 48.0938 | 48.2344 | 41800.0 |
| 2001-01-11 09:30:00 | DIA | ETF | 106.375 | 106.5312 | 105.6562 | 105.9375 | 60200.0 |
| 2001-01-11 10:00:00 | DIA | ETF | 106.0 | 106.25 | 105.75 | 106.25 | 114900.0 |
> showing 50 of 315 rows — these rows as CSV