PREVIEW / etf_30min / 2004-11-03
file: by_date/etf_30min/2004/2004-11-03.parquet size: 40 KB rows: 1,349
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-03 08:00:00 | SPY | ETF | 114.78 | 114.98 | 114.75 | 114.94 | 400300.0 |
| 2004-11-03 08:30:00 | SPY | ETF | 114.94 | 115.08 | 114.94 | 115.01 | 459000.0 |
| 2004-11-03 09:00:00 | SPY | ETF | 115.0 | 115.05 | 114.94 | 115.03 | 397200.0 |
| 2004-11-03 09:30:00 | SPY | ETF | 115.03 | 115.36 | 114.94 | 115.09 | 13217200.0 |
| 2004-11-03 10:00:00 | SPY | ETF | 115.09 | 115.19 | 114.7 | 115.0 | 8363600.0 |
| 2004-11-03 10:30:00 | SPY | ETF | 115.01 | 115.3 | 114.88 | 114.93 | 7505000.0 |
| 2004-11-03 11:00:00 | SPY | ETF | 114.94 | 115.25 | 114.8 | 115.2 | 6976400.0 |
| 2004-11-03 11:30:00 | SPY | ETF | 115.2 | 115.28 | 114.93 | 114.96 | 3109500.0 |
| 2004-11-03 12:00:00 | SPY | ETF | 114.96 | 114.99 | 114.8 | 114.86 | 2090400.0 |
| 2004-11-03 12:30:00 | SPY | ETF | 114.81 | 115.08 | 114.81 | 114.94 | 2022100.0 |
| 2004-11-03 13:00:00 | SPY | ETF | 114.93 | 115.17 | 114.92 | 114.93 | 2192100.0 |
| 2004-11-03 13:30:00 | SPY | ETF | 114.93 | 115.11 | 114.91 | 115.04 | 1824500.0 |
| 2004-11-03 14:00:00 | SPY | ETF | 115.03 | 115.05 | 114.62 | 114.83 | 5508800.0 |
| 2004-11-03 14:30:00 | SPY | ETF | 114.83 | 114.88 | 114.62 | 114.74 | 2586700.0 |
| 2004-11-03 15:00:00 | SPY | ETF | 114.75 | 114.87 | 114.24 | 114.44 | 6895600.0 |
| 2004-11-03 15:30:00 | SPY | ETF | 114.46 | 114.81 | 114.45 | 114.77 | 5656500.0 |
| 2004-11-03 16:00:00 | SPY | ETF | 114.77 | 115.04 | 114.6731 | 114.9 | 2151800.0 |
| 2004-11-03 16:30:00 | SPY | ETF | 114.9 | 114.9 | 114.83 | 114.9 | 713600.0 |
| 2004-11-03 17:00:00 | SPY | ETF | 114.89 | 114.94 | 114.89 | 114.89 | 84400.0 |
| 2004-11-03 17:30:00 | SPY | ETF | 114.89 | 114.89 | 114.87 | 114.87 | 400.0 |
| 2004-11-03 18:00:00 | SPY | ETF | 114.9 | 114.97 | 114.89 | 114.96 | 5600.0 |
| 2004-11-03 19:00:00 | SPY | ETF | 114.91 | 114.91 | 114.91 | 114.91 | 200.0 |
| 2004-11-03 08:00:00 | QQQ | ETF | 37.72 | 37.79 | 37.71 | 37.78 | 1107900.0 |
| 2004-11-03 08:30:00 | QQQ | ETF | 37.78 | 37.85 | 37.77 | 37.79 | 569000.0 |
| 2004-11-03 09:00:00 | QQQ | ETF | 37.79 | 37.8 | 37.75 | 37.76 | 992700.0 |
| 2004-11-03 09:30:00 | QQQ | ETF | 37.76 | 37.9 | 37.59 | 37.69 | 24042000.0 |
| 2004-11-03 10:00:00 | QQQ | ETF | 37.69 | 37.75 | 37.45 | 37.64 | 18302500.0 |
| 2004-11-03 10:30:00 | QQQ | ETF | 37.641 | 37.751 | 37.54 | 37.59 | 11441300.0 |
| 2004-11-03 11:00:00 | QQQ | ETF | 37.59 | 37.735 | 37.53 | 37.7 | 11866900.0 |
| 2004-11-03 11:30:00 | QQQ | ETF | 37.68 | 37.78 | 37.514 | 37.52 | 6841100.0 |
| 2004-11-03 12:00:00 | QQQ | ETF | 37.525 | 37.54 | 37.42 | 37.434 | 6978900.0 |
| 2004-11-03 12:30:00 | QQQ | ETF | 37.43 | 37.554 | 37.42 | 37.478 | 4689300.0 |
| 2004-11-03 13:00:00 | QQQ | ETF | 37.479 | 37.62 | 37.46 | 37.48 | 5500700.0 |
| 2004-11-03 13:30:00 | QQQ | ETF | 37.475 | 37.56 | 37.45 | 37.51 | 4037700.0 |
| 2004-11-03 14:00:00 | QQQ | ETF | 37.51 | 37.51 | 37.25 | 37.325 | 10605200.0 |
| 2004-11-03 14:30:00 | QQQ | ETF | 37.325 | 37.38 | 37.24 | 37.35 | 6790500.0 |
| 2004-11-03 15:00:00 | QQQ | ETF | 37.35 | 37.42 | 37.15 | 37.25 | 10176000.0 |
| 2004-11-03 15:30:00 | QQQ | ETF | 37.25 | 37.35 | 37.21 | 37.34 | 9166100.0 |
| 2004-11-03 16:00:00 | QQQ | ETF | 37.35 | 37.45 | 37.26 | 37.31 | 4313300.0 |
| 2004-11-03 16:30:00 | QQQ | ETF | 37.331 | 37.35 | 37.29 | 37.326 | 687100.0 |
| 2004-11-03 17:00:00 | QQQ | ETF | 37.33 | 37.34 | 37.32 | 37.33 | 61700.0 |
| 2004-11-03 17:30:00 | QQQ | ETF | 37.338 | 37.34 | 37.31 | 37.31 | 32600.0 |
| 2004-11-03 18:00:00 | QQQ | ETF | 37.33 | 37.35 | 37.32 | 37.35 | 76800.0 |
| 2004-11-03 18:30:00 | QQQ | ETF | 37.35 | 37.36 | 37.34 | 37.34 | 1200.0 |
| 2004-11-03 19:00:00 | QQQ | ETF | 37.35 | 37.37 | 37.35 | 37.37 | 1100.0 |
| 2004-11-03 19:30:00 | QQQ | ETF | 37.36 | 37.37 | 37.36 | 37.37 | 7100.0 |
| 2004-11-03 08:00:00 | IWM | ETF | 59.05 | 59.17 | 59.05 | 59.15 | 23000.0 |
| 2004-11-03 08:30:00 | IWM | ETF | 59.12 | 59.215 | 59.12 | 59.215 | 13000.0 |
| 2004-11-03 09:00:00 | IWM | ETF | 59.2 | 59.225 | 59.125 | 59.225 | 36800.0 |
| 2004-11-03 09:30:00 | IWM | ETF | 59.19 | 59.51 | 59.175 | 59.3 | 3128200.0 |
> showing 50 of 1,349 rows — these rows as CSV