PREVIEW / etf_30min / 2003-11-03
file: by_date/etf_30min/2003/2003-11-03.parquet size: 26 KB rows: 826
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-11-03 08:00:00 | SPY | ETF | 105.91 | 105.94 | 105.83 | 105.85 | 9600.0 |
| 2003-11-03 08:30:00 | SPY | ETF | 105.87 | 105.87 | 105.73 | 105.76 | 21200.0 |
| 2003-11-03 09:00:00 | SPY | ETF | 105.77 | 105.87 | 105.75 | 105.75 | 17000.0 |
| 2003-11-03 09:30:00 | SPY | ETF | 105.75 | 106.28 | 105.71 | 106.22 | 5462960.0 |
| 2003-11-03 10:00:00 | SPY | ETF | 106.28 | 106.53 | 106.2 | 106.44 | 5438806.0 |
| 2003-11-03 10:30:00 | SPY | ETF | 106.439 | 106.45 | 106.27 | 106.35 | 2500227.0 |
| 2003-11-03 11:00:00 | SPY | ETF | 106.34 | 106.48 | 106.25 | 106.36 | 2969137.0 |
| 2003-11-03 11:30:00 | SPY | ETF | 106.33 | 106.44 | 106.28 | 106.37 | 756946.0 |
| 2003-11-03 12:00:00 | SPY | ETF | 106.35 | 106.53 | 106.18 | 106.43 | 1601705.0 |
| 2003-11-03 12:30:00 | SPY | ETF | 106.43 | 106.52 | 106.4 | 106.49 | 1430763.0 |
| 2003-11-03 13:00:00 | SPY | ETF | 106.48 | 106.53 | 106.38 | 106.4 | 1056948.0 |
| 2003-11-03 13:30:00 | SPY | ETF | 106.4 | 106.43 | 106.25 | 106.39 | 1078988.0 |
| 2003-11-03 14:00:00 | SPY | ETF | 106.38 | 106.39 | 106.14 | 106.28 | 1132189.0 |
| 2003-11-03 14:30:00 | SPY | ETF | 106.24 | 106.56 | 106.14 | 106.51 | 1498269.0 |
| 2003-11-03 15:00:00 | SPY | ETF | 106.52 | 106.61 | 106.45 | 106.51 | 2880097.0 |
| 2003-11-03 15:30:00 | SPY | ETF | 106.48 | 106.51 | 106.22 | 106.32 | 2984895.0 |
| 2003-11-03 16:00:00 | SPY | ETF | 106.33 | 106.37 | 105.92 | 106.02 | 1515603.0 |
| 2003-11-03 16:30:00 | SPY | ETF | 105.99 | 106.07 | 105.99 | 106.06 | 59110.0 |
| 2003-11-03 17:00:00 | SPY | ETF | 106.07 | 106.09 | 105.98 | 106.08 | 29500.0 |
| 2003-11-03 17:30:00 | SPY | ETF | 106.08 | 106.15 | 106.05 | 106.07 | 3000.0 |
| 2003-11-03 18:00:00 | SPY | ETF | 106.07 | 106.12 | 106.06 | 106.06 | 8600.0 |
| 2003-11-03 18:30:00 | SPY | ETF | 106.06 | 106.06 | 106.06 | 106.06 | 1000.0 |
| 2003-11-03 19:00:00 | SPY | ETF | 106.09 | 106.09 | 106.09 | 106.09 | 500.0 |
| 2003-11-03 19:30:00 | SPY | ETF | 106.12 | 106.12 | 106.11 | 106.11 | 5100.0 |
| 2003-11-03 08:00:00 | QQQ | ETF | 35.39 | 35.53 | 35.39 | 35.48 | 39700.0 |
| 2003-11-03 08:30:00 | QQQ | ETF | 35.47 | 35.48 | 35.42 | 35.45 | 46900.0 |
| 2003-11-03 09:00:00 | QQQ | ETF | 35.44 | 35.47 | 35.41 | 35.42 | 191700.0 |
| 2003-11-03 09:30:00 | QQQ | ETF | 35.43 | 35.721 | 35.36 | 35.71 | 10140501.0 |
| 2003-11-03 10:00:00 | QQQ | ETF | 35.728 | 35.81 | 35.67 | 35.79 | 9305622.0 |
| 2003-11-03 10:30:00 | QQQ | ETF | 35.78 | 35.8 | 35.71 | 35.75 | 4711714.0 |
| 2003-11-03 11:00:00 | QQQ | ETF | 35.747 | 35.83 | 35.67 | 35.72 | 3698864.0 |
| 2003-11-03 11:30:00 | QQQ | ETF | 35.719 | 35.754 | 35.69 | 35.74 | 1914254.0 |
| 2003-11-03 12:00:00 | QQQ | ETF | 35.74 | 35.82 | 35.68 | 35.78 | 2869460.0 |
| 2003-11-03 12:30:00 | QQQ | ETF | 35.78 | 35.843 | 35.77 | 35.826 | 2414887.0 |
| 2003-11-03 13:00:00 | QQQ | ETF | 35.82 | 35.905 | 35.81 | 35.87 | 5059067.0 |
| 2003-11-03 13:30:00 | QQQ | ETF | 35.87 | 35.88 | 35.8 | 35.87 | 2366289.0 |
| 2003-11-03 14:00:00 | QQQ | ETF | 35.87 | 35.88 | 35.75 | 35.83 | 2656552.0 |
| 2003-11-03 14:30:00 | QQQ | ETF | 35.83 | 35.91 | 35.74 | 35.88 | 3155144.0 |
| 2003-11-03 15:00:00 | QQQ | ETF | 35.88 | 35.98 | 35.86 | 35.91 | 4922006.0 |
| 2003-11-03 15:30:00 | QQQ | ETF | 35.91 | 35.95 | 35.8 | 35.87 | 5872705.0 |
| 2003-11-03 16:00:00 | QQQ | ETF | 35.873 | 35.92 | 35.75 | 35.77 | 2564724.0 |
| 2003-11-03 16:30:00 | QQQ | ETF | 35.77 | 35.9 | 35.75 | 35.79 | 342142.0 |
| 2003-11-03 17:00:00 | QQQ | ETF | 35.79 | 35.804 | 35.78 | 35.8 | 28000.0 |
| 2003-11-03 17:30:00 | QQQ | ETF | 35.8 | 35.83 | 35.8 | 35.82 | 17501.0 |
| 2003-11-03 18:00:00 | QQQ | ETF | 35.81 | 35.82 | 35.78 | 35.81 | 27600.0 |
| 2003-11-03 18:30:00 | QQQ | ETF | 35.8 | 35.82 | 35.8 | 35.81 | 6500.0 |
| 2003-11-03 19:00:00 | QQQ | ETF | 35.81 | 35.82 | 35.8 | 35.8 | 6000.0 |
| 2003-11-03 19:30:00 | QQQ | ETF | 35.8 | 35.82 | 35.8 | 35.8 | 14000.0 |
| 2003-11-03 09:30:00 | IWM | ETF | 53.095 | 53.565 | 53.094 | 53.541 | 1323570.0 |
| 2003-11-03 10:00:00 | IWM | ETF | 53.614 | 53.751 | 53.52 | 53.7 | 939920.0 |
> showing 50 of 826 rows — these rows as CSV