PREVIEW / etf_30min / 2003-01-13
file: by_date/etf_30min/2003/2003-01-13.parquet size: 21 KB rows: 633
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-01-13 08:00:00 | SPY | ETF | 93.96 | 93.96 | 93.67 | 93.8 | 37200.0 |
| 2003-01-13 08:30:00 | SPY | ETF | 93.8 | 93.89 | 93.7 | 93.8 | 17600.0 |
| 2003-01-13 09:00:00 | SPY | ETF | 93.74 | 93.79 | 93.55 | 93.55 | 11900.0 |
| 2003-01-13 09:30:00 | SPY | ETF | 93.54 | 93.85 | 93.4 | 93.66 | 4661800.0 |
| 2003-01-13 10:00:00 | SPY | ETF | 93.63 | 93.86 | 93.0 | 93.05 | 2842500.0 |
| 2003-01-13 10:30:00 | SPY | ETF | 93.05 | 93.08 | 92.44 | 92.65 | 4863000.0 |
| 2003-01-13 11:00:00 | SPY | ETF | 92.62 | 92.85 | 92.47 | 92.82 | 2098600.0 |
| 2003-01-13 11:30:00 | SPY | ETF | 92.81 | 92.94 | 92.73 | 92.92 | 1114600.0 |
| 2003-01-13 12:00:00 | SPY | ETF | 92.93 | 93.09 | 92.81 | 93.01 | 869000.0 |
| 2003-01-13 12:30:00 | SPY | ETF | 93.0 | 93.14 | 92.87 | 93.05 | 660700.0 |
| 2003-01-13 13:00:00 | SPY | ETF | 93.05 | 93.1 | 92.82 | 92.87 | 871700.0 |
| 2003-01-13 13:30:00 | SPY | ETF | 92.89 | 93.17 | 92.86 | 93.08 | 1007500.0 |
| 2003-01-13 14:00:00 | SPY | ETF | 93.09 | 93.4 | 93.08 | 93.15 | 1475700.0 |
| 2003-01-13 14:30:00 | SPY | ETF | 93.16 | 93.28 | 92.76 | 92.89 | 2243600.0 |
| 2003-01-13 15:00:00 | SPY | ETF | 92.92 | 93.11 | 92.78 | 92.96 | 1655400.0 |
| 2003-01-13 15:30:00 | SPY | ETF | 92.96 | 93.03 | 92.73 | 92.85 | 2593100.0 |
| 2003-01-13 16:00:00 | SPY | ETF | 92.9 | 93.07 | 92.85 | 92.9 | 2235700.0 |
| 2003-01-13 16:30:00 | SPY | ETF | 92.9 | 93.03 | 92.9 | 93.01 | 72000.0 |
| 2003-01-13 17:00:00 | SPY | ETF | 93.03 | 93.05 | 93.0 | 93.03 | 8700.0 |
| 2003-01-13 17:30:00 | SPY | ETF | 93.03 | 93.05 | 92.98 | 93.03 | 17200.0 |
| 2003-01-13 18:00:00 | SPY | ETF | 93.03 | 93.54 | 92.98 | 93.03 | 2200.0 |
| 2003-01-13 18:30:00 | SPY | ETF | 93.01 | 93.01 | 92.97 | 92.97 | 400.0 |
| 2003-01-13 19:30:00 | SPY | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 400.0 |
| 2003-01-13 08:00:00 | QQQ | ETF | 27.39 | 27.45 | 27.36 | 27.45 | 91800.0 |
| 2003-01-13 08:30:00 | QQQ | ETF | 27.46 | 27.5 | 27.45 | 27.47 | 64200.0 |
| 2003-01-13 09:00:00 | QQQ | ETF | 27.47 | 27.47 | 27.36 | 27.36 | 81000.0 |
| 2003-01-13 09:30:00 | QQQ | ETF | 27.36 | 27.47 | 27.21 | 27.34 | 14390000.0 |
| 2003-01-13 10:00:00 | QQQ | ETF | 27.31 | 27.4 | 26.96 | 26.98 | 8164400.0 |
| 2003-01-13 10:30:00 | QQQ | ETF | 26.98 | 27.0 | 26.73 | 26.83 | 12385900.0 |
| 2003-01-13 11:00:00 | QQQ | ETF | 26.83 | 26.94 | 26.73 | 26.92 | 4890400.0 |
| 2003-01-13 11:30:00 | QQQ | ETF | 26.91 | 26.99 | 26.87 | 26.95 | 2353700.0 |
| 2003-01-13 12:00:00 | QQQ | ETF | 26.95 | 27.1 | 26.89 | 27.05 | 2808400.0 |
| 2003-01-13 12:30:00 | QQQ | ETF | 27.05 | 27.08 | 26.98 | 27.01 | 2179900.0 |
| 2003-01-13 13:00:00 | QQQ | ETF | 27.01 | 27.06 | 26.86 | 26.9 | 2863200.0 |
| 2003-01-13 13:30:00 | QQQ | ETF | 26.88 | 27.05 | 26.88 | 27.02 | 1825300.0 |
| 2003-01-13 14:00:00 | QQQ | ETF | 27.0 | 27.09 | 26.92 | 26.96 | 2249300.0 |
| 2003-01-13 14:30:00 | QQQ | ETF | 26.94 | 27.01 | 26.83 | 26.86 | 3693900.0 |
| 2003-01-13 15:00:00 | QQQ | ETF | 26.86 | 27.0 | 26.82 | 26.95 | 2678400.0 |
| 2003-01-13 15:30:00 | QQQ | ETF | 26.92 | 26.95 | 26.83 | 26.88 | 3265300.0 |
| 2003-01-13 16:00:00 | QQQ | ETF | 26.88 | 26.97 | 26.87 | 26.94 | 1971600.0 |
| 2003-01-13 16:30:00 | QQQ | ETF | 26.93 | 26.99 | 26.92 | 26.96 | 210600.0 |
| 2003-01-13 17:00:00 | QQQ | ETF | 26.98 | 27.0 | 26.97 | 26.97 | 48400.0 |
| 2003-01-13 17:30:00 | QQQ | ETF | 26.98 | 27.0 | 26.96 | 27.0 | 23800.0 |
| 2003-01-13 18:00:00 | QQQ | ETF | 27.0 | 27.33 | 26.99 | 27.01 | 47400.0 |
| 2003-01-13 18:30:00 | QQQ | ETF | 27.02 | 27.02 | 26.99 | 27.0 | 7800.0 |
| 2003-01-13 19:00:00 | QQQ | ETF | 26.97 | 26.98 | 26.97 | 26.98 | 1700.0 |
| 2003-01-13 19:30:00 | QQQ | ETF | 26.97 | 27.02 | 26.97 | 27.02 | 3300.0 |
| 2003-01-13 09:30:00 | IWM | ETF | 39.66 | 39.815 | 39.47 | 39.55 | 352200.0 |
| 2003-01-13 10:00:00 | IWM | ETF | 39.585 | 39.665 | 39.32 | 39.32 | 167200.0 |
| 2003-01-13 10:30:00 | IWM | ETF | 39.31 | 39.345 | 39.09 | 39.205 | 254600.0 |
> showing 50 of 633 rows — these rows as CSV