PREVIEW / etf_30min / 2003-11-06
file: by_date/etf_30min/2003/2003-11-06.parquet size: 26 KB rows: 787
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-06 08:00:00 | SPY | ETF | 105.7 | 105.71 | 105.55 | 105.64 | 17800.0 |
| 2003-11-06 08:30:00 | SPY | ETF | 105.75 | 105.9 | 105.5 | 105.72 | 174700.0 |
| 2003-11-06 09:00:00 | SPY | ETF | 105.7 | 105.79 | 105.6 | 105.6 | 25200.0 |
| 2003-11-06 09:30:00 | SPY | ETF | 105.6 | 105.66 | 105.25 | 105.4 | 3247200.0 |
| 2003-11-06 10:00:00 | SPY | ETF | 105.37 | 105.55 | 105.17 | 105.32 | 2246400.0 |
| 2003-11-06 10:30:00 | SPY | ETF | 105.31 | 105.5 | 105.17 | 105.3 | 1463600.0 |
| 2003-11-06 11:00:00 | SPY | ETF | 105.3 | 105.34 | 105.12 | 105.32 | 1073400.0 |
| 2003-11-06 11:30:00 | SPY | ETF | 105.31 | 105.43 | 105.24 | 105.39 | 1012200.0 |
| 2003-11-06 12:00:00 | SPY | ETF | 105.41 | 105.44 | 105.31 | 105.39 | 1083300.0 |
| 2003-11-06 12:30:00 | SPY | ETF | 105.42 | 105.74 | 105.38 | 105.66 | 1983200.0 |
| 2003-11-06 13:00:00 | SPY | ETF | 105.64 | 105.75 | 105.61 | 105.65 | 1066100.0 |
| 2003-11-06 13:30:00 | SPY | ETF | 105.66 | 105.79 | 105.58 | 105.79 | 1157300.0 |
| 2003-11-06 14:00:00 | SPY | ETF | 105.78 | 105.93 | 105.72 | 105.85 | 1701000.0 |
| 2003-11-06 14:30:00 | SPY | ETF | 105.84 | 105.85 | 105.64 | 105.76 | 1415400.0 |
| 2003-11-06 15:00:00 | SPY | ETF | 105.75 | 106.27 | 105.73 | 106.26 | 3006000.0 |
| 2003-11-06 15:30:00 | SPY | ETF | 106.25 | 106.39 | 106.11 | 106.26 | 2403400.0 |
| 2003-11-06 16:00:00 | SPY | ETF | 106.26 | 106.49 | 106.22 | 106.4 | 1492800.0 |
| 2003-11-06 16:30:00 | SPY | ETF | 106.43 | 106.44 | 106.26 | 106.42 | 79600.0 |
| 2003-11-06 17:00:00 | SPY | ETF | 106.4146 | 106.42 | 106.38 | 106.42 | 10400.0 |
| 2003-11-06 17:30:00 | SPY | ETF | 106.41 | 106.43 | 106.37 | 106.43 | 6100.0 |
| 2003-11-06 18:00:00 | SPY | ETF | 106.43 | 106.47 | 106.43 | 106.47 | 4300.0 |
| 2003-11-06 18:30:00 | SPY | ETF | 106.45 | 106.46 | 106.45 | 106.46 | 1200.0 |
| 2003-11-06 19:00:00 | SPY | ETF | 106.43 | 106.48 | 106.43 | 106.44 | 3100.0 |
| 2003-11-06 19:30:00 | SPY | ETF | 106.43 | 106.43 | 106.43 | 106.43 | 500.0 |
| 2003-11-06 08:00:00 | QQQ | ETF | 35.79 | 35.79 | 35.73 | 35.76 | 50100.0 |
| 2003-11-06 08:30:00 | QQQ | ETF | 35.76 | 35.9 | 35.68 | 35.81 | 388200.0 |
| 2003-11-06 09:00:00 | QQQ | ETF | 35.82 | 35.87 | 35.76 | 35.77 | 374200.0 |
| 2003-11-06 09:30:00 | QQQ | ETF | 35.79 | 35.8 | 35.48 | 35.58 | 14509700.0 |
| 2003-11-06 10:00:00 | QQQ | ETF | 35.57 | 35.63 | 35.44 | 35.51 | 7715900.0 |
| 2003-11-06 10:30:00 | QQQ | ETF | 35.51 | 35.6 | 35.37 | 35.429 | 3786500.0 |
| 2003-11-06 11:00:00 | QQQ | ETF | 35.42 | 35.48 | 35.34 | 35.45 | 3164400.0 |
| 2003-11-06 11:30:00 | QQQ | ETF | 35.461 | 35.54 | 35.42 | 35.53 | 4368800.0 |
| 2003-11-06 12:00:00 | QQQ | ETF | 35.52 | 35.55 | 35.47 | 35.508 | 1820700.0 |
| 2003-11-06 12:30:00 | QQQ | ETF | 35.52 | 35.69 | 35.5 | 35.65 | 4658500.0 |
| 2003-11-06 13:00:00 | QQQ | ETF | 35.65 | 35.69 | 35.61 | 35.65 | 3221400.0 |
| 2003-11-06 13:30:00 | QQQ | ETF | 35.647 | 35.73 | 35.59 | 35.71 | 4493400.0 |
| 2003-11-06 14:00:00 | QQQ | ETF | 35.716 | 35.78 | 35.67 | 35.7 | 4568400.0 |
| 2003-11-06 14:30:00 | QQQ | ETF | 35.72 | 35.73 | 35.59 | 35.639 | 3488900.0 |
| 2003-11-06 15:00:00 | QQQ | ETF | 35.639 | 35.85 | 35.63 | 35.84 | 9237600.0 |
| 2003-11-06 15:30:00 | QQQ | ETF | 35.839 | 35.9 | 35.74 | 35.819 | 9734700.0 |
| 2003-11-06 16:00:00 | QQQ | ETF | 35.82 | 35.99 | 35.79 | 35.95 | 3638600.0 |
| 2003-11-06 16:30:00 | QQQ | ETF | 35.94 | 35.96 | 35.92 | 35.941 | 170300.0 |
| 2003-11-06 17:00:00 | QQQ | ETF | 35.94 | 35.96 | 35.924 | 35.94 | 47700.0 |
| 2003-11-06 17:30:00 | QQQ | ETF | 35.93 | 35.93 | 35.91 | 35.93 | 27200.0 |
| 2003-11-06 18:00:00 | QQQ | ETF | 35.93 | 35.95 | 35.93 | 35.93 | 14000.0 |
| 2003-11-06 18:30:00 | QQQ | ETF | 35.94 | 35.95 | 35.94 | 35.95 | 12800.0 |
| 2003-11-06 19:00:00 | QQQ | ETF | 35.95 | 35.96 | 35.93 | 35.96 | 8400.0 |
| 2003-11-06 19:30:00 | QQQ | ETF | 35.95 | 35.95 | 35.91 | 35.92 | 11400.0 |
| 2003-11-06 09:30:00 | IWM | ETF | 54.02 | 54.075 | 53.585 | 53.73 | 1211600.0 |
| 2003-11-06 10:00:00 | IWM | ETF | 53.747 | 53.86 | 53.59 | 53.75 | 293200.0 |
> showing 50 of 787 rows — these rows as CSV