PREVIEW / etf_30min / 2003-09-16
file: by_date/etf_30min/2003/2003-09-16.parquet size: 24 KB rows: 723
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-16 08:00:00 | SPY | ETF | 102.25 | 102.3 | 102.25 | 102.27 | 9600.0 |
| 2003-09-16 08:30:00 | SPY | ETF | 102.25 | 102.3 | 102.25 | 102.25 | 3000.0 |
| 2003-09-16 09:00:00 | SPY | ETF | 102.22 | 102.23 | 102.17 | 102.23 | 7800.0 |
| 2003-09-16 09:30:00 | SPY | ETF | 102.232 | 102.66 | 102.17 | 102.61 | 3000300.0 |
| 2003-09-16 10:00:00 | SPY | ETF | 102.61 | 102.85 | 102.57 | 102.77 | 2243200.0 |
| 2003-09-16 10:30:00 | SPY | ETF | 102.77 | 102.81 | 102.66 | 102.71 | 1334700.0 |
| 2003-09-16 11:00:00 | SPY | ETF | 102.73 | 102.78 | 102.68 | 102.73 | 403000.0 |
| 2003-09-16 11:30:00 | SPY | ETF | 102.73 | 102.77 | 102.65 | 102.77 | 1163600.0 |
| 2003-09-16 12:00:00 | SPY | ETF | 102.76 | 102.84 | 102.65 | 102.7 | 893700.0 |
| 2003-09-16 12:30:00 | SPY | ETF | 102.73 | 102.77 | 102.69 | 102.75 | 454600.0 |
| 2003-09-16 13:00:00 | SPY | ETF | 102.76 | 102.93 | 102.75 | 102.86 | 2564700.0 |
| 2003-09-16 13:30:00 | SPY | ETF | 102.87 | 102.89 | 102.78 | 102.82 | 563200.0 |
| 2003-09-16 14:00:00 | SPY | ETF | 102.79 | 102.93 | 102.63 | 102.69 | 1461400.0 |
| 2003-09-16 14:30:00 | SPY | ETF | 102.67 | 103.25 | 102.56 | 103.19 | 4296900.0 |
| 2003-09-16 15:00:00 | SPY | ETF | 103.18 | 103.48 | 103.12 | 103.46 | 3618400.0 |
| 2003-09-16 15:30:00 | SPY | ETF | 103.44 | 103.64 | 103.41 | 103.55 | 8086300.0 |
| 2003-09-16 16:00:00 | SPY | ETF | 103.55 | 103.7 | 103.52 | 103.54 | 931900.0 |
| 2003-09-16 16:30:00 | SPY | ETF | 103.69 | 103.751 | 103.56 | 103.6 | 385200.0 |
| 2003-09-16 17:00:00 | SPY | ETF | 103.6 | 103.6 | 103.5 | 103.56 | 70800.0 |
| 2003-09-16 17:30:00 | SPY | ETF | 103.56 | 103.62 | 103.56 | 103.62 | 11400.0 |
| 2003-09-16 18:00:00 | SPY | ETF | 103.59 | 103.64 | 103.59 | 103.63 | 24200.0 |
| 2003-09-16 18:30:00 | SPY | ETF | 103.6 | 103.64 | 103.6 | 103.64 | 2300.0 |
| 2003-09-16 19:00:00 | SPY | ETF | 103.62 | 103.63 | 103.62 | 103.63 | 4200.0 |
| 2003-09-16 19:30:00 | SPY | ETF | 103.63 | 103.63 | 103.57 | 103.6 | 3500.0 |
| 2003-09-16 08:00:00 | QQQ | ETF | 33.59 | 33.6 | 33.55 | 33.6 | 79300.0 |
| 2003-09-16 08:30:00 | QQQ | ETF | 33.6 | 33.64 | 33.56 | 33.57 | 82300.0 |
| 2003-09-16 09:00:00 | QQQ | ETF | 33.57 | 33.57 | 33.55 | 33.55 | 91700.0 |
| 2003-09-16 09:30:00 | QQQ | ETF | 33.52 | 33.806 | 33.52 | 33.79 | 12000400.0 |
| 2003-09-16 10:00:00 | QQQ | ETF | 33.79 | 33.94 | 33.73 | 33.91 | 8936900.0 |
| 2003-09-16 10:30:00 | QQQ | ETF | 33.91 | 33.94 | 33.8 | 33.86 | 3576400.0 |
| 2003-09-16 11:00:00 | QQQ | ETF | 33.85 | 33.88 | 33.82 | 33.845 | 1520000.0 |
| 2003-09-16 11:30:00 | QQQ | ETF | 33.845 | 33.91 | 33.83 | 33.9 | 2602100.0 |
| 2003-09-16 12:00:00 | QQQ | ETF | 33.9 | 33.95 | 33.83 | 33.87 | 4080600.0 |
| 2003-09-16 12:30:00 | QQQ | ETF | 33.88 | 33.94 | 33.87 | 33.92 | 3905700.0 |
| 2003-09-16 13:00:00 | QQQ | ETF | 33.9 | 34.0 | 33.9 | 33.96 | 3158700.0 |
| 2003-09-16 13:30:00 | QQQ | ETF | 33.96 | 33.98 | 33.91 | 33.92 | 1029500.0 |
| 2003-09-16 14:00:00 | QQQ | ETF | 33.93 | 33.99 | 33.86 | 33.921 | 3918000.0 |
| 2003-09-16 14:30:00 | QQQ | ETF | 33.92 | 34.19 | 33.82 | 34.14 | 10456400.0 |
| 2003-09-16 15:00:00 | QQQ | ETF | 34.14 | 34.3 | 34.1 | 34.28 | 6768800.0 |
| 2003-09-16 15:30:00 | QQQ | ETF | 34.27 | 34.43 | 34.24 | 34.35 | 11010500.0 |
| 2003-09-16 16:00:00 | QQQ | ETF | 34.35 | 34.44 | 34.32 | 34.43 | 5902900.0 |
| 2003-09-16 16:30:00 | QQQ | ETF | 34.43 | 34.44 | 33.51 | 34.37 | 818800.0 |
| 2003-09-16 17:00:00 | QQQ | ETF | 34.38 | 34.4 | 34.36 | 34.39 | 22000.0 |
| 2003-09-16 17:30:00 | QQQ | ETF | 34.39 | 34.44 | 34.38 | 34.43 | 87000.0 |
| 2003-09-16 18:00:00 | QQQ | ETF | 34.412 | 34.44 | 34.412 | 34.44 | 28300.0 |
| 2003-09-16 18:30:00 | QQQ | ETF | 34.45 | 34.45 | 34.42 | 34.42 | 6900.0 |
| 2003-09-16 19:00:00 | QQQ | ETF | 34.43 | 34.45 | 34.43 | 34.45 | 18900.0 |
| 2003-09-16 19:30:00 | QQQ | ETF | 34.44 | 34.45 | 34.44 | 34.44 | 5900.0 |
| 2003-09-16 20:00:00 | QQQ | ETF | 34.44 | 34.44 | 34.44 | 34.44 | 500.0 |
| 2003-09-16 09:30:00 | IWM | ETF | 50.725 | 50.955 | 50.71 | 50.955 | 814000.0 |
> showing 50 of 723 rows — these rows as CSV