PREVIEW / etf_30min / 2005-10-20
file: by_date/etf_30min/2005/2005-10-20.parquet size: 52 KB rows: 1,732
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-20 04:30:00 | SPY | ETF | 119.39 | 119.39 | 119.39 | 119.39 | 500.0 |
| 2005-10-20 06:30:00 | SPY | ETF | 119.54 | 119.54 | 119.54 | 119.54 | 1000.0 |
| 2005-10-20 07:00:00 | SPY | ETF | 119.56 | 119.56 | 119.46 | 119.47 | 6400.0 |
| 2005-10-20 07:30:00 | SPY | ETF | 119.5 | 119.61 | 119.46 | 119.58 | 47600.0 |
| 2005-10-20 08:00:00 | SPY | ETF | 119.5 | 119.6 | 119.46 | 119.54 | 1186500.0 |
| 2005-10-20 08:30:00 | SPY | ETF | 119.54 | 119.58 | 119.4 | 119.5 | 1131300.0 |
| 2005-10-20 09:00:00 | SPY | ETF | 119.52 | 119.55 | 119.46 | 119.52 | 480000.0 |
| 2005-10-20 09:30:00 | SPY | ETF | 119.49 | 119.81 | 119.46 | 119.53 | 11726500.0 |
| 2005-10-20 10:00:00 | SPY | ETF | 119.53 | 119.63 | 119.28 | 119.36 | 6092000.0 |
| 2005-10-20 10:30:00 | SPY | ETF | 119.37 | 119.63 | 119.3 | 119.47 | 6865700.0 |
| 2005-10-20 11:00:00 | SPY | ETF | 119.46 | 119.5 | 119.02 | 119.28 | 9070400.0 |
| 2005-10-20 11:30:00 | SPY | ETF | 119.27 | 119.644 | 119.05 | 119.13 | 8653500.0 |
| 2005-10-20 12:00:00 | SPY | ETF | 119.14 | 119.29 | 118.85 | 119.03 | 8912800.0 |
| 2005-10-20 12:30:00 | SPY | ETF | 119.04 | 119.16 | 118.9 | 119.01 | 2933800.0 |
| 2005-10-20 13:00:00 | SPY | ETF | 119.0 | 119.53 | 118.93 | 118.97 | 5387200.0 |
| 2005-10-20 13:30:00 | SPY | ETF | 118.97 | 119.13 | 118.75 | 118.86 | 4092800.0 |
| 2005-10-20 14:00:00 | SPY | ETF | 118.86 | 118.92 | 118.35 | 118.51 | 7567500.0 |
| 2005-10-20 14:30:00 | SPY | ETF | 118.51 | 118.63 | 118.44 | 118.5 | 7155300.0 |
| 2005-10-20 15:00:00 | SPY | ETF | 118.5 | 118.6 | 117.3 | 117.48 | 13679300.0 |
| 2005-10-20 15:30:00 | SPY | ETF | 117.49 | 118.24 | 117.41 | 117.74 | 23695100.0 |
| 2005-10-20 16:00:00 | SPY | ETF | 117.71 | 118.01 | 117.58 | 117.71 | 3502100.0 |
| 2005-10-20 16:30:00 | SPY | ETF | 117.73 | 117.76 | 117.47 | 117.52 | 999100.0 |
| 2005-10-20 17:00:00 | SPY | ETF | 117.53 | 117.56 | 117.44 | 117.46 | 138400.0 |
| 2005-10-20 17:30:00 | SPY | ETF | 117.45 | 117.83 | 117.45 | 117.55 | 74900.0 |
| 2005-10-20 18:00:00 | SPY | ETF | 117.52 | 117.52 | 117.37 | 117.38 | 80600.0 |
| 2005-10-20 18:30:00 | SPY | ETF | 117.43 | 117.49 | 117.43 | 117.47 | 2500.0 |
| 2005-10-20 19:00:00 | SPY | ETF | 117.47 | 117.53 | 117.45 | 117.47 | 5200.0 |
| 2005-10-20 19:30:00 | SPY | ETF | 117.48 | 117.52 | 117.46 | 117.48 | 23300.0 |
| 2005-10-20 09:30:00 | QQQ | ETF | 38.67 | 38.85 | 38.63 | 38.69 | 23917200.0 |
| 2005-10-20 10:00:00 | QQQ | ETF | 38.69 | 38.73 | 38.58 | 38.63 | 10096300.0 |
| 2005-10-20 10:30:00 | QQQ | ETF | 38.62 | 38.75 | 38.6 | 38.66 | 9103500.0 |
| 2005-10-20 11:00:00 | QQQ | ETF | 38.66 | 38.68 | 38.52 | 38.64 | 7811400.0 |
| 2005-10-20 11:30:00 | QQQ | ETF | 38.65 | 38.7 | 38.6 | 38.63 | 3824400.0 |
| 2005-10-20 12:00:00 | QQQ | ETF | 38.63 | 38.7 | 38.51 | 38.64 | 7208900.0 |
| 2005-10-20 12:30:00 | QQQ | ETF | 38.64 | 38.69 | 38.6 | 38.63 | 3391200.0 |
| 2005-10-20 13:00:00 | QQQ | ETF | 38.63 | 38.72 | 38.59 | 38.6 | 6219800.0 |
| 2005-10-20 13:30:00 | QQQ | ETF | 38.61 | 38.65 | 38.55 | 38.6 | 3938200.0 |
| 2005-10-20 14:00:00 | QQQ | ETF | 38.6 | 38.61 | 38.43 | 38.49 | 7702500.0 |
| 2005-10-20 14:30:00 | QQQ | ETF | 38.49 | 38.54 | 38.45 | 38.47 | 4759300.0 |
| 2005-10-20 15:00:00 | QQQ | ETF | 38.47 | 38.5 | 38.1 | 38.18 | 16304200.0 |
| 2005-10-20 15:30:00 | QQQ | ETF | 38.18 | 38.41 | 38.13 | 38.31 | 18674300.0 |
| 2005-10-20 07:30:00 | IWM | ETF | 63.33 | 63.33 | 63.33 | 63.33 | 1900.0 |
| 2005-10-20 08:00:00 | IWM | ETF | 63.37 | 63.43 | 63.33 | 63.38 | 448100.0 |
| 2005-10-20 08:30:00 | IWM | ETF | 63.37 | 63.41 | 63.32 | 63.33 | 79000.0 |
| 2005-10-20 09:00:00 | IWM | ETF | 63.33 | 63.4 | 63.33 | 63.39 | 37500.0 |
| 2005-10-20 09:30:00 | IWM | ETF | 63.4 | 63.65 | 63.17 | 63.27 | 3846100.0 |
| 2005-10-20 10:00:00 | IWM | ETF | 63.27 | 63.41 | 63.05 | 63.19 | 3692300.0 |
| 2005-10-20 10:30:00 | IWM | ETF | 63.19 | 63.34 | 62.98 | 63.28 | 2638600.0 |
| 2005-10-20 11:00:00 | IWM | ETF | 63.29 | 63.29 | 62.89 | 63.009 | 5087800.0 |
| 2005-10-20 11:30:00 | IWM | ETF | 63.01 | 63.11 | 62.74 | 62.89 | 2507700.0 |
> showing 50 of 1,732 rows — these rows as CSV