PREVIEW / etf_30min / 2005-11-15
file: by_date/etf_30min/2005/2005-11-15.parquet size: 53 KB rows: 1,861
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-11-15 07:00:00 | SPY | ETF | 123.43 | 123.47 | 123.43 | 123.46 | 2000.0 |
| 2005-11-15 07:30:00 | SPY | ETF | 123.46 | 123.46 | 123.44 | 123.44 | 1100.0 |
| 2005-11-15 08:00:00 | SPY | ETF | 123.47 | 123.5 | 123.4 | 123.47 | 309500.0 |
| 2005-11-15 08:30:00 | SPY | ETF | 123.49 | 123.74 | 123.44 | 123.54 | 2294800.0 |
| 2005-11-15 09:00:00 | SPY | ETF | 123.58 | 123.58 | 123.5 | 123.57 | 371400.0 |
| 2005-11-15 09:30:00 | SPY | ETF | 123.58 | 123.65 | 123.3 | 123.36 | 9416800.0 |
| 2005-11-15 10:00:00 | SPY | ETF | 123.37 | 123.58 | 123.32 | 123.5 | 4885800.0 |
| 2005-11-15 10:30:00 | SPY | ETF | 123.51 | 123.89 | 123.42 | 123.76 | 5625700.0 |
| 2005-11-15 11:00:00 | SPY | ETF | 123.77 | 123.86 | 123.65 | 123.8 | 1924300.0 |
| 2005-11-15 11:30:00 | SPY | ETF | 123.77 | 123.91 | 123.69 | 123.89 | 1912700.0 |
| 2005-11-15 12:00:00 | SPY | ETF | 123.88 | 124.09 | 123.85 | 124.01 | 4441400.0 |
| 2005-11-15 12:30:00 | SPY | ETF | 124.01 | 124.03 | 123.91 | 124.02 | 2581800.0 |
| 2005-11-15 13:00:00 | SPY | ETF | 124.02 | 124.05 | 123.83 | 123.87 | 2132500.0 |
| 2005-11-15 13:30:00 | SPY | ETF | 123.87 | 123.9 | 123.44 | 123.53 | 7055000.0 |
| 2005-11-15 14:00:00 | SPY | ETF | 123.53 | 123.6 | 123.16 | 123.27 | 9474900.0 |
| 2005-11-15 14:30:00 | SPY | ETF | 123.29 | 123.34 | 122.95 | 122.95 | 4543500.0 |
| 2005-11-15 15:00:00 | SPY | ETF | 122.95 | 123.18 | 122.86 | 123.06 | 5244100.0 |
| 2005-11-15 15:30:00 | SPY | ETF | 123.06 | 123.43 | 123.01 | 123.15 | 4997800.0 |
| 2005-11-15 16:00:00 | SPY | ETF | 123.15 | 123.473 | 123.14 | 123.25 | 937400.0 |
| 2005-11-15 16:30:00 | SPY | ETF | 123.25 | 123.28 | 123.2 | 123.25 | 107400.0 |
| 2005-11-15 17:00:00 | SPY | ETF | 123.25 | 123.26 | 123.22 | 123.26 | 20500.0 |
| 2005-11-15 17:30:00 | SPY | ETF | 123.27 | 123.3 | 123.27 | 123.29 | 2500.0 |
| 2005-11-15 18:00:00 | SPY | ETF | 123.22 | 123.22 | 123.22 | 123.22 | 2500.0 |
| 2005-11-15 19:00:00 | SPY | ETF | 123.2 | 123.2 | 123.2 | 123.2 | 500.0 |
| 2005-11-15 09:30:00 | QQQ | ETF | 40.73 | 40.79 | 40.62 | 40.69 | 9232100.0 |
| 2005-11-15 10:00:00 | QQQ | ETF | 40.69 | 40.76 | 40.63 | 40.69 | 6460100.0 |
| 2005-11-15 10:30:00 | QQQ | ETF | 40.7 | 40.78 | 40.65 | 40.74 | 4087100.0 |
| 2005-11-15 11:00:00 | QQQ | ETF | 40.73 | 40.76 | 40.69 | 40.75 | 1966600.0 |
| 2005-11-15 11:30:00 | QQQ | ETF | 40.74 | 40.8 | 40.71 | 40.8 | 1675100.0 |
| 2005-11-15 12:00:00 | QQQ | ETF | 40.8 | 40.9 | 40.76 | 40.84 | 6915200.0 |
| 2005-11-15 12:30:00 | QQQ | ETF | 40.84 | 40.85 | 40.8 | 40.83 | 1919100.0 |
| 2005-11-15 13:00:00 | QQQ | ETF | 40.83 | 40.85 | 40.73 | 40.75 | 2990300.0 |
| 2005-11-15 13:30:00 | QQQ | ETF | 40.75 | 40.77 | 40.6 | 40.62 | 7232800.0 |
| 2005-11-15 14:00:00 | QQQ | ETF | 40.63 | 40.64 | 40.52 | 40.59 | 13740800.0 |
| 2005-11-15 14:30:00 | QQQ | ETF | 40.59 | 40.59 | 40.41 | 40.41 | 5777700.0 |
| 2005-11-15 15:00:00 | QQQ | ETF | 40.42 | 40.49 | 40.38 | 40.45 | 7899600.0 |
| 2005-11-15 15:30:00 | QQQ | ETF | 40.44 | 40.55 | 40.43 | 40.52 | 6899100.0 |
| 2005-11-15 08:00:00 | IWM | ETF | 66.09 | 66.09 | 66.02 | 66.03 | 5300.0 |
| 2005-11-15 08:30:00 | IWM | ETF | 66.07 | 66.18 | 66.05 | 66.07 | 45100.0 |
| 2005-11-15 09:00:00 | IWM | ETF | 66.04 | 66.08 | 66.03 | 66.08 | 46700.0 |
| 2005-11-15 09:30:00 | IWM | ETF | 66.09 | 66.16 | 65.65 | 65.67 | 4994400.0 |
| 2005-11-15 10:00:00 | IWM | ETF | 65.67 | 65.75 | 65.54 | 65.59 | 2198100.0 |
| 2005-11-15 10:30:00 | IWM | ETF | 65.6 | 65.88 | 65.47 | 65.78 | 4725500.0 |
| 2005-11-15 11:00:00 | IWM | ETF | 65.79 | 65.85 | 65.69 | 65.82 | 835100.0 |
| 2005-11-15 11:30:00 | IWM | ETF | 65.82 | 66.08 | 65.75 | 66.06 | 3254400.0 |
| 2005-11-15 12:00:00 | IWM | ETF | 66.07 | 66.24 | 66.02 | 66.15 | 1737600.0 |
| 2005-11-15 12:30:00 | IWM | ETF | 66.15 | 66.18 | 65.99 | 66.16 | 702600.0 |
| 2005-11-15 13:00:00 | IWM | ETF | 66.16 | 66.21 | 65.89 | 65.89 | 1394400.0 |
| 2005-11-15 13:30:00 | IWM | ETF | 65.89 | 65.92 | 65.48 | 65.52 | 3231400.0 |
| 2005-11-15 14:00:00 | IWM | ETF | 65.52 | 65.53 | 65.29 | 65.44 | 2223500.0 |
> showing 50 of 1,861 rows — these rows as CSV