PREVIEW / etf_30min / 2005-10-19
file: by_date/etf_30min/2005/2005-10-19.parquet size: 52 KB rows: 1,736
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-19 04:30:00 | SPY | ETF | 117.36 | 117.36 | 117.36 | 117.36 | 800.0 |
| 2005-10-19 06:00:00 | SPY | ETF | 117.51 | 117.52 | 117.5 | 117.5 | 25000.0 |
| 2005-10-19 06:30:00 | SPY | ETF | 117.4 | 117.4 | 117.4 | 117.4 | 1000.0 |
| 2005-10-19 07:00:00 | SPY | ETF | 117.38 | 117.38 | 117.15 | 117.15 | 62400.0 |
| 2005-10-19 07:30:00 | SPY | ETF | 117.15 | 117.3 | 117.14 | 117.28 | 70200.0 |
| 2005-10-19 08:00:00 | SPY | ETF | 117.33 | 117.43 | 117.11 | 117.41 | 928700.0 |
| 2005-10-19 08:30:00 | SPY | ETF | 117.41 | 117.47 | 117.36 | 117.39 | 491800.0 |
| 2005-10-19 09:00:00 | SPY | ETF | 117.37 | 117.56 | 117.36 | 117.54 | 955700.0 |
| 2005-10-19 09:30:00 | SPY | ETF | 117.56 | 117.75 | 117.12 | 117.42 | 11916800.0 |
| 2005-10-19 10:00:00 | SPY | ETF | 117.43 | 117.66 | 117.28 | 117.41 | 11824400.0 |
| 2005-10-19 10:30:00 | SPY | ETF | 117.42 | 118.08 | 117.31 | 117.82 | 18071100.0 |
| 2005-10-19 11:00:00 | SPY | ETF | 117.853 | 117.96 | 117.31 | 117.41 | 10533000.0 |
| 2005-10-19 11:30:00 | SPY | ETF | 117.41 | 117.58 | 117.3 | 117.39 | 3471900.0 |
| 2005-10-19 12:00:00 | SPY | ETF | 117.4 | 117.73 | 117.37 | 117.69 | 3886600.0 |
| 2005-10-19 12:30:00 | SPY | ETF | 117.68 | 117.96 | 117.6 | 117.75 | 6077700.0 |
| 2005-10-19 13:00:00 | SPY | ETF | 117.74 | 118.03 | 117.54 | 117.87 | 3716600.0 |
| 2005-10-19 13:30:00 | SPY | ETF | 117.9 | 118.22 | 117.79 | 118.17 | 4759700.0 |
| 2005-10-19 14:00:00 | SPY | ETF | 118.18 | 118.67 | 118.1 | 118.67 | 8991200.0 |
| 2005-10-19 14:30:00 | SPY | ETF | 118.67 | 119.02 | 118.59 | 118.92 | 6108200.0 |
| 2005-10-19 15:00:00 | SPY | ETF | 118.92 | 119.15 | 118.9 | 119.12 | 7507400.0 |
| 2005-10-19 15:30:00 | SPY | ETF | 119.12 | 119.66 | 119.05 | 119.62 | 8102500.0 |
| 2005-10-19 16:00:00 | SPY | ETF | 119.61 | 119.79 | 119.6 | 119.61 | 1339300.0 |
| 2005-10-19 16:30:00 | SPY | ETF | 119.61 | 119.74 | 119.61 | 119.65 | 3638400.0 |
| 2005-10-19 17:00:00 | SPY | ETF | 119.66 | 119.71 | 119.66 | 119.69 | 114800.0 |
| 2005-10-19 17:30:00 | SPY | ETF | 119.69 | 119.73 | 119.61 | 119.64 | 16300.0 |
| 2005-10-19 18:00:00 | SPY | ETF | 119.7 | 119.73 | 119.7 | 119.71 | 3900.0 |
| 2005-10-19 18:30:00 | SPY | ETF | 119.71 | 119.71 | 119.66 | 119.71 | 4500.0 |
| 2005-10-19 19:00:00 | SPY | ETF | 119.66 | 119.66 | 119.64 | 119.64 | 1500.0 |
| 2005-10-19 19:30:00 | SPY | ETF | 119.67 | 119.71 | 119.67 | 119.69 | 3400.0 |
| 2005-10-19 09:30:00 | QQQ | ETF | 37.75 | 37.79 | 37.61 | 37.76 | 14891600.0 |
| 2005-10-19 10:00:00 | QQQ | ETF | 37.76 | 37.87 | 37.68 | 37.72 | 12726600.0 |
| 2005-10-19 10:30:00 | QQQ | ETF | 37.73 | 38.05 | 37.72 | 37.86 | 18016000.0 |
| 2005-10-19 11:00:00 | QQQ | ETF | 37.86 | 37.9 | 37.72 | 37.76 | 6535400.0 |
| 2005-10-19 11:30:00 | QQQ | ETF | 37.76 | 37.87 | 37.72 | 37.75 | 4585900.0 |
| 2005-10-19 12:00:00 | QQQ | ETF | 37.76 | 37.91 | 37.74 | 37.89 | 3646300.0 |
| 2005-10-19 12:30:00 | QQQ | ETF | 37.9 | 38.01 | 37.86 | 37.91 | 8375400.0 |
| 2005-10-19 13:00:00 | QQQ | ETF | 37.91 | 37.97 | 37.81 | 37.95 | 3876300.0 |
| 2005-10-19 13:30:00 | QQQ | ETF | 37.94 | 38.03 | 37.94 | 38.03 | 5169600.0 |
| 2005-10-19 14:00:00 | QQQ | ETF | 38.03 | 38.35 | 37.98 | 38.34 | 15399200.0 |
| 2005-10-19 14:30:00 | QQQ | ETF | 38.35 | 38.44 | 38.3 | 38.39 | 12174600.0 |
| 2005-10-19 15:00:00 | QQQ | ETF | 38.38 | 38.5 | 38.38 | 38.48 | 6584400.0 |
| 2005-10-19 15:30:00 | QQQ | ETF | 38.47 | 38.67 | 38.42 | 38.67 | 11745300.0 |
| 2005-10-19 07:00:00 | IWM | ETF | 61.78 | 61.78 | 61.78 | 61.78 | 5000.0 |
| 2005-10-19 07:30:00 | IWM | ETF | 61.81 | 61.81 | 61.8 | 61.8 | 2900.0 |
| 2005-10-19 08:00:00 | IWM | ETF | 61.89 | 61.9 | 61.78 | 61.9 | 42400.0 |
| 2005-10-19 08:30:00 | IWM | ETF | 61.9 | 61.98 | 61.69 | 61.82 | 76000.0 |
| 2005-10-19 09:00:00 | IWM | ETF | 61.9 | 61.93 | 61.87 | 61.91 | 65600.0 |
| 2005-10-19 09:30:00 | IWM | ETF | 61.91 | 62.05 | 61.51 | 61.64 | 4489600.0 |
| 2005-10-19 10:00:00 | IWM | ETF | 61.62 | 61.8 | 61.38 | 61.5 | 3933700.0 |
| 2005-10-19 10:30:00 | IWM | ETF | 61.52 | 62.06 | 61.51 | 61.81 | 6397200.0 |
> showing 50 of 1,736 rows — these rows as CSV