PREVIEW / etf_30min / 2003-04-10
file: by_date/etf_30min/2003/2003-04-10.parquet size: 21 KB rows: 623
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-04-10 08:00:00 | SPY | ETF | 87.08 | 87.09 | 86.94 | 86.94 | 6200.0 |
| 2003-04-10 08:30:00 | SPY | ETF | 87.01 | 87.2 | 86.97 | 87.2 | 46400.0 |
| 2003-04-10 09:00:00 | SPY | ETF | 87.13 | 87.37 | 87.11 | 87.11 | 18600.0 |
| 2003-04-10 09:30:00 | SPY | ETF | 87.09 | 87.21 | 86.71 | 86.95 | 4319800.0 |
| 2003-04-10 10:00:00 | SPY | ETF | 86.93 | 87.14 | 86.66 | 86.81 | 3400900.0 |
| 2003-04-10 10:30:00 | SPY | ETF | 86.79 | 86.96 | 86.56 | 86.84 | 3867500.0 |
| 2003-04-10 11:00:00 | SPY | ETF | 86.85 | 86.99 | 86.54 | 86.59 | 2292000.0 |
| 2003-04-10 11:30:00 | SPY | ETF | 86.6 | 86.88 | 86.55 | 86.82 | 2230700.0 |
| 2003-04-10 12:00:00 | SPY | ETF | 86.83 | 87.17 | 86.78 | 87.05 | 3039800.0 |
| 2003-04-10 12:30:00 | SPY | ETF | 87.05 | 87.2 | 86.91 | 87.01 | 1631400.0 |
| 2003-04-10 13:00:00 | SPY | ETF | 87.0 | 87.06 | 86.82 | 87.04 | 1007900.0 |
| 2003-04-10 13:30:00 | SPY | ETF | 86.97 | 87.33 | 86.96 | 87.19 | 1923700.0 |
| 2003-04-10 14:00:00 | SPY | ETF | 87.2 | 87.39 | 87.16 | 87.24 | 2344300.0 |
| 2003-04-10 14:30:00 | SPY | ETF | 87.24 | 87.34 | 87.06 | 87.25 | 1620500.0 |
| 2003-04-10 15:00:00 | SPY | ETF | 87.25 | 87.36 | 86.95 | 87.33 | 2247700.0 |
| 2003-04-10 15:30:00 | SPY | ETF | 87.3 | 87.51 | 87.08 | 87.45 | 3580800.0 |
| 2003-04-10 16:00:00 | SPY | ETF | 87.45 | 87.65 | 87.15 | 87.63 | 3881800.0 |
| 2003-04-10 16:30:00 | SPY | ETF | 87.62 | 87.65 | 87.52 | 87.56 | 111000.0 |
| 2003-04-10 17:00:00 | SPY | ETF | 87.55 | 87.6 | 87.55 | 87.58 | 61900.0 |
| 2003-04-10 17:30:00 | SPY | ETF | 87.57 | 87.69 | 87.56 | 87.69 | 258100.0 |
| 2003-04-10 18:00:00 | SPY | ETF | 87.65 | 87.7 | 87.61 | 87.65 | 6700.0 |
| 2003-04-10 18:30:00 | SPY | ETF | 87.66 | 87.66 | 87.63 | 87.66 | 1400.0 |
| 2003-04-10 19:00:00 | SPY | ETF | 87.67 | 87.74 | 87.59 | 87.64 | 20800.0 |
| 2003-04-10 19:30:00 | SPY | ETF | 87.68 | 87.68 | 87.57 | 87.67 | 7000.0 |
| 2003-04-10 08:00:00 | QQQ | ETF | 25.5 | 25.5 | 25.39 | 25.4 | 53200.0 |
| 2003-04-10 08:30:00 | QQQ | ETF | 25.42 | 25.5 | 25.41 | 25.41 | 36400.0 |
| 2003-04-10 09:00:00 | QQQ | ETF | 25.43 | 25.56 | 25.43 | 25.47 | 82500.0 |
| 2003-04-10 09:30:00 | QQQ | ETF | 25.46 | 25.56 | 25.35 | 25.47 | 6987700.0 |
| 2003-04-10 10:00:00 | QQQ | ETF | 25.48 | 25.52 | 25.31 | 25.38 | 5424000.0 |
| 2003-04-10 10:30:00 | QQQ | ETF | 25.36 | 25.51 | 25.3 | 25.44 | 2725800.0 |
| 2003-04-10 11:00:00 | QQQ | ETF | 25.45 | 25.48 | 25.35 | 25.41 | 2601100.0 |
| 2003-04-10 11:30:00 | QQQ | ETF | 25.37 | 25.49 | 25.35 | 25.46 | 2535200.0 |
| 2003-04-10 12:00:00 | QQQ | ETF | 25.46 | 25.63 | 25.45 | 25.59 | 5708100.0 |
| 2003-04-10 12:30:00 | QQQ | ETF | 25.59 | 25.67 | 25.55 | 25.61 | 2909600.0 |
| 2003-04-10 13:00:00 | QQQ | ETF | 25.61 | 25.63 | 25.5 | 25.59 | 2513800.0 |
| 2003-04-10 13:30:00 | QQQ | ETF | 25.57 | 25.75 | 25.56 | 25.67 | 3652500.0 |
| 2003-04-10 14:00:00 | QQQ | ETF | 25.67 | 25.77 | 25.55 | 25.68 | 4130300.0 |
| 2003-04-10 14:30:00 | QQQ | ETF | 25.68 | 25.74 | 25.61 | 25.69 | 3243900.0 |
| 2003-04-10 15:00:00 | QQQ | ETF | 25.7 | 25.74 | 25.58 | 25.66 | 2618900.0 |
| 2003-04-10 15:30:00 | QQQ | ETF | 25.67 | 25.77 | 25.58 | 25.67 | 4512500.0 |
| 2003-04-10 16:00:00 | QQQ | ETF | 25.68 | 25.82 | 25.63 | 25.79 | 3248500.0 |
| 2003-04-10 16:30:00 | QQQ | ETF | 25.79 | 25.85 | 25.75 | 25.77 | 334800.0 |
| 2003-04-10 17:00:00 | QQQ | ETF | 25.77 | 25.81 | 25.76 | 25.78 | 177700.0 |
| 2003-04-10 17:30:00 | QQQ | ETF | 25.79 | 25.8 | 25.76 | 25.8 | 103800.0 |
| 2003-04-10 18:00:00 | QQQ | ETF | 25.79 | 25.79 | 25.76 | 25.79 | 92200.0 |
| 2003-04-10 18:30:00 | QQQ | ETF | 25.79 | 25.79 | 25.76 | 25.79 | 33200.0 |
| 2003-04-10 19:00:00 | QQQ | ETF | 25.79 | 25.79 | 25.76 | 25.77 | 159200.0 |
| 2003-04-10 19:30:00 | QQQ | ETF | 25.8 | 25.8 | 25.76 | 25.79 | 82500.0 |
| 2003-04-10 09:30:00 | IWM | ETF | 37.175 | 37.225 | 37.04 | 37.15 | 224000.0 |
| 2003-04-10 10:00:00 | IWM | ETF | 37.15 | 37.15 | 37.01 | 37.05 | 71000.0 |
> showing 50 of 623 rows — these rows as CSV