PREVIEW / etf_30min / 2005-08-17
file: by_date/etf_30min/2005/2005-08-17.parquet size: 47 KB rows: 1,665
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-08-17 07:00:00 | SPY | ETF | 122.34 | 122.35 | 122.3 | 122.3 | 4900.0 |
| 2005-08-17 07:30:00 | SPY | ETF | 122.34 | 122.36 | 122.31 | 122.36 | 21500.0 |
| 2005-08-17 08:00:00 | SPY | ETF | 122.43 | 122.45 | 122.34 | 122.38 | 544000.0 |
| 2005-08-17 08:30:00 | SPY | ETF | 122.32 | 122.32 | 121.01 | 122.08 | 969400.0 |
| 2005-08-17 09:00:00 | SPY | ETF | 122.08 | 122.21 | 122.08 | 122.19 | 159700.0 |
| 2005-08-17 09:30:00 | SPY | ETF | 122.19 | 122.44 | 122.1 | 122.27 | 7058200.0 |
| 2005-08-17 10:00:00 | SPY | ETF | 122.27 | 122.44 | 122.13 | 122.36 | 5066400.0 |
| 2005-08-17 10:30:00 | SPY | ETF | 122.35 | 122.57 | 122.03 | 122.45 | 7497000.0 |
| 2005-08-17 11:00:00 | SPY | ETF | 122.46 | 122.69 | 122.35 | 122.52 | 7124100.0 |
| 2005-08-17 11:30:00 | SPY | ETF | 122.52 | 122.55 | 122.39 | 122.51 | 3813100.0 |
| 2005-08-17 12:00:00 | SPY | ETF | 122.51 | 122.74 | 122.47 | 122.65 | 3778200.0 |
| 2005-08-17 12:30:00 | SPY | ETF | 122.65 | 122.8 | 122.64 | 122.69 | 1900800.0 |
| 2005-08-17 13:00:00 | SPY | ETF | 122.7 | 122.87 | 122.68 | 122.799 | 1633100.0 |
| 2005-08-17 13:30:00 | SPY | ETF | 122.79 | 122.8 | 122.58 | 122.63 | 1319600.0 |
| 2005-08-17 14:00:00 | SPY | ETF | 122.65 | 122.83 | 122.4 | 122.59 | 5042200.0 |
| 2005-08-17 14:30:00 | SPY | ETF | 122.57 | 122.62 | 122.24 | 122.38 | 4872000.0 |
| 2005-08-17 15:00:00 | SPY | ETF | 122.39 | 122.71 | 122.34 | 122.44 | 3128300.0 |
| 2005-08-17 15:30:00 | SPY | ETF | 122.42 | 122.58 | 122.23 | 122.29 | 3851600.0 |
| 2005-08-17 16:00:00 | SPY | ETF | 122.3 | 122.445 | 122.15 | 122.22 | 1225800.0 |
| 2005-08-17 16:30:00 | SPY | ETF | 122.22 | 122.25 | 122.19 | 122.25 | 135900.0 |
| 2005-08-17 17:00:00 | SPY | ETF | 122.25 | 122.27 | 122.22 | 122.25 | 162900.0 |
| 2005-08-17 17:30:00 | SPY | ETF | 122.26 | 122.26 | 122.26 | 122.26 | 200.0 |
| 2005-08-17 18:00:00 | SPY | ETF | 122.27 | 122.27 | 122.23 | 122.27 | 4600.0 |
| 2005-08-17 18:30:00 | SPY | ETF | 122.27 | 122.28 | 122.27 | 122.28 | 1100.0 |
| 2005-08-17 19:00:00 | SPY | ETF | 122.3 | 122.3 | 122.3 | 122.3 | 4100.0 |
| 2005-08-17 19:30:00 | SPY | ETF | 122.3 | 122.33 | 122.3 | 122.33 | 2000.0 |
| 2005-08-17 09:30:00 | QQQ | ETF | 38.88 | 39.01 | 38.85 | 38.93 | 10080100.0 |
| 2005-08-17 10:00:00 | QQQ | ETF | 38.93 | 39.0 | 38.88 | 38.96 | 4729300.0 |
| 2005-08-17 10:30:00 | QQQ | ETF | 38.97 | 39.05 | 38.79 | 38.98 | 10243700.0 |
| 2005-08-17 11:00:00 | QQQ | ETF | 38.98 | 39.05 | 38.94 | 38.97 | 6906200.0 |
| 2005-08-17 11:30:00 | QQQ | ETF | 38.97 | 38.99 | 38.94 | 38.98 | 2889700.0 |
| 2005-08-17 12:00:00 | QQQ | ETF | 38.98 | 39.13 | 38.98 | 39.11 | 5554700.0 |
| 2005-08-17 12:30:00 | QQQ | ETF | 39.11 | 39.16 | 39.11 | 39.12 | 3326700.0 |
| 2005-08-17 13:00:00 | QQQ | ETF | 39.12 | 39.17 | 39.1 | 39.11 | 2364400.0 |
| 2005-08-17 13:30:00 | QQQ | ETF | 39.12 | 39.12 | 39.04 | 39.07 | 2468600.0 |
| 2005-08-17 14:00:00 | QQQ | ETF | 39.08 | 39.12 | 39.02 | 39.1 | 2136800.0 |
| 2005-08-17 14:30:00 | QQQ | ETF | 39.1 | 39.12 | 38.99 | 39.04 | 3507100.0 |
| 2005-08-17 15:00:00 | QQQ | ETF | 39.03 | 39.15 | 39.02 | 39.06 | 3462200.0 |
| 2005-08-17 15:30:00 | QQQ | ETF | 39.06 | 39.12 | 39.01 | 39.01 | 4826400.0 |
| 2005-08-17 08:00:00 | IWM | ETF | 65.13 | 65.13 | 65.13 | 65.13 | 600.0 |
| 2005-08-17 08:30:00 | IWM | ETF | 65.14 | 65.14 | 64.85 | 64.93 | 15000.0 |
| 2005-08-17 09:00:00 | IWM | ETF | 64.99 | 65.06 | 64.99 | 65.0 | 35300.0 |
| 2005-08-17 09:30:00 | IWM | ETF | 65.0 | 65.16 | 64.84 | 64.97 | 3860600.0 |
| 2005-08-17 10:00:00 | IWM | ETF | 64.96 | 65.15 | 64.93 | 65.14 | 1728900.0 |
| 2005-08-17 10:30:00 | IWM | ETF | 65.15 | 65.47 | 64.96 | 65.38 | 2337000.0 |
| 2005-08-17 11:00:00 | IWM | ETF | 65.38 | 65.5 | 65.33 | 65.37 | 1717800.0 |
| 2005-08-17 11:30:00 | IWM | ETF | 65.37 | 65.4 | 65.28 | 65.33 | 1118300.0 |
| 2005-08-17 12:00:00 | IWM | ETF | 65.33 | 65.48 | 65.31 | 65.41 | 1156200.0 |
| 2005-08-17 12:30:00 | IWM | ETF | 65.42 | 65.56 | 65.42 | 65.47 | 760800.0 |
| 2005-08-17 13:00:00 | IWM | ETF | 65.46 | 65.59 | 65.44 | 65.57 | 956900.0 |
> showing 50 of 1,665 rows — these rows as CSV