PREVIEW / etf_30min / 2000-03-28
file: by_date/etf_30min/2000/2000-03-28.parquet size: 9 KB rows: 200
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-03-28 09:30:00 | SPY | ETF | 151.25 | 152.5 | 151.25 | 152.1875 | 1428900.0 |
| 2000-03-28 10:00:00 | SPY | ETF | 152.25 | 152.3125 | 151.0 | 151.6562 | 775800.0 |
| 2000-03-28 10:30:00 | SPY | ETF | 151.5312 | 152.9688 | 151.4062 | 152.8125 | 636900.0 |
| 2000-03-28 11:00:00 | SPY | ETF | 152.8125 | 152.9688 | 152.4375 | 152.625 | 375900.0 |
| 2000-03-28 11:30:00 | SPY | ETF | 152.625 | 152.8125 | 152.2188 | 152.25 | 308400.0 |
| 2000-03-28 12:00:00 | SPY | ETF | 152.2188 | 152.4688 | 151.9375 | 152.125 | 121500.0 |
| 2000-03-28 12:30:00 | SPY | ETF | 152.0312 | 152.0312 | 151.5 | 151.7188 | 210400.0 |
| 2000-03-28 13:00:00 | SPY | ETF | 151.6562 | 152.2188 | 151.6562 | 151.875 | 51300.0 |
| 2000-03-28 13:30:00 | SPY | ETF | 151.75 | 152.5 | 151.6875 | 152.1875 | 450800.0 |
| 2000-03-28 14:00:00 | SPY | ETF | 152.2188 | 152.3125 | 151.6875 | 152.125 | 98800.0 |
| 2000-03-28 14:30:00 | SPY | ETF | 152.0 | 152.5938 | 151.75 | 152.0312 | 298700.0 |
| 2000-03-28 15:00:00 | SPY | ETF | 152.125 | 152.25 | 150.7812 | 151.125 | 684200.0 |
| 2000-03-28 15:30:00 | SPY | ETF | 151.3438 | 151.6875 | 151.0 | 151.0 | 293500.0 |
| 2000-03-28 16:00:00 | SPY | ETF | 151.0 | 151.1562 | 150.5938 | 151.0625 | 517200.0 |
| 2000-03-28 17:00:00 | SPY | ETF | 151.0625 | 151.0625 | 151.0625 | 151.0625 | 100.0 |
| 2000-03-28 09:30:00 | QQQ | ETF | 116.9688 | 117.8125 | 116.25 | 117.125 | 2859400.0 |
| 2000-03-28 10:00:00 | QQQ | ETF | 117.125 | 117.25 | 114.625 | 115.75 | 2949900.0 |
| 2000-03-28 10:30:00 | QQQ | ETF | 115.75 | 117.25 | 115.5625 | 117.1875 | 2182200.0 |
| 2000-03-28 11:00:00 | QQQ | ETF | 117.1562 | 117.3125 | 116.3125 | 116.9375 | 1235800.0 |
| 2000-03-28 11:30:00 | QQQ | ETF | 116.9375 | 116.9375 | 116.0 | 116.5625 | 514100.0 |
| 2000-03-28 12:00:00 | QQQ | ETF | 116.5 | 116.875 | 116.2188 | 116.25 | 530100.0 |
| 2000-03-28 12:30:00 | QQQ | ETF | 116.375 | 116.4688 | 115.625 | 116.1875 | 1185000.0 |
| 2000-03-28 13:00:00 | QQQ | ETF | 116.2188 | 116.625 | 116.0 | 116.1875 | 355700.0 |
| 2000-03-28 13:30:00 | QQQ | ETF | 116.1875 | 117.0312 | 116.0938 | 116.5625 | 852900.0 |
| 2000-03-28 14:00:00 | QQQ | ETF | 116.5625 | 116.8438 | 115.75 | 116.1875 | 806800.0 |
| 2000-03-28 14:30:00 | QQQ | ETF | 116.125 | 116.9375 | 116.0 | 116.3438 | 900800.0 |
| 2000-03-28 15:00:00 | QQQ | ETF | 116.375 | 116.5938 | 114.6875 | 115.0 | 1936200.0 |
| 2000-03-28 15:30:00 | QQQ | ETF | 115.0625 | 115.75 | 114.5312 | 114.9375 | 1334300.0 |
| 2000-03-28 16:00:00 | QQQ | ETF | 114.9375 | 115.0 | 114.375 | 114.9375 | 607700.0 |
| 2000-03-28 16:30:00 | QQQ | ETF | 114.5 | 115.0 | 114.5 | 115.0 | 5400.0 |
| 2000-03-28 17:00:00 | QQQ | ETF | 115.0 | 115.0 | 114.6875 | 114.6875 | 2000.0 |
| 2000-03-28 17:30:00 | QQQ | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 100.0 |
| 2000-03-28 18:00:00 | QQQ | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 100.0 |
| 2000-03-28 09:30:00 | DIA | ETF | 109.125 | 110.4688 | 109.125 | 110.1562 | 304800.0 |
| 2000-03-28 10:00:00 | DIA | ETF | 110.1875 | 110.3438 | 109.5625 | 109.9375 | 287000.0 |
| 2000-03-28 10:30:00 | DIA | ETF | 110.0 | 110.9375 | 109.75 | 110.875 | 352700.0 |
| 2000-03-28 11:00:00 | DIA | ETF | 110.9375 | 110.9688 | 110.5 | 110.625 | 43100.0 |
| 2000-03-28 11:30:00 | DIA | ETF | 110.625 | 110.8125 | 110.5 | 110.625 | 30700.0 |
| 2000-03-28 12:00:00 | DIA | ETF | 110.75 | 110.75 | 110.25 | 110.3125 | 69500.0 |
| 2000-03-28 12:30:00 | DIA | ETF | 110.3125 | 110.375 | 109.9375 | 110.1562 | 74000.0 |
| 2000-03-28 13:00:00 | DIA | ETF | 110.25 | 110.4688 | 110.0625 | 110.0938 | 9300.0 |
| 2000-03-28 13:30:00 | DIA | ETF | 110.0938 | 110.625 | 110.0312 | 110.25 | 27500.0 |
| 2000-03-28 14:00:00 | DIA | ETF | 110.0938 | 110.2812 | 109.875 | 110.0938 | 57400.0 |
| 2000-03-28 14:30:00 | DIA | ETF | 110.0 | 110.5625 | 110.0 | 110.125 | 14500.0 |
| 2000-03-28 15:00:00 | DIA | ETF | 110.125 | 110.1562 | 109.5 | 109.625 | 137200.0 |
| 2000-03-28 15:30:00 | DIA | ETF | 109.5625 | 109.9375 | 109.375 | 109.375 | 87700.0 |
| 2000-03-28 16:00:00 | DIA | ETF | 109.375 | 109.5 | 109.1562 | 109.375 | 72800.0 |
> showing 47 of 200 rows — these rows as CSV