PREVIEW / etf_30min / 2005-05-03
file: by_date/etf_30min/2005/2005-05-03.parquet size: 42 KB rows: 1,460
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-05-03 07:00:00 | SPY | ETF | 116.21 | 116.21 | 116.21 | 116.21 | 3000.0 |
| 2005-05-03 07:30:00 | SPY | ETF | 116.17 | 116.17 | 116.08 | 116.08 | 45200.0 |
| 2005-05-03 08:00:00 | SPY | ETF | 116.11 | 116.16 | 116.06 | 116.12 | 11900.0 |
| 2005-05-03 08:30:00 | SPY | ETF | 116.08 | 116.12 | 116.07 | 116.09 | 49400.0 |
| 2005-05-03 09:00:00 | SPY | ETF | 116.08 | 116.13 | 116.04 | 116.05 | 47400.0 |
| 2005-05-03 09:30:00 | SPY | ETF | 116.07 | 116.34 | 116.02 | 116.32 | 5729200.0 |
| 2005-05-03 10:00:00 | SPY | ETF | 116.32 | 116.43 | 116.18 | 116.25 | 5593200.0 |
| 2005-05-03 10:30:00 | SPY | ETF | 116.26 | 116.41 | 116.21 | 116.26 | 2576700.0 |
| 2005-05-03 11:00:00 | SPY | ETF | 116.26 | 116.38 | 116.24 | 116.34 | 1106100.0 |
| 2005-05-03 11:30:00 | SPY | ETF | 116.35 | 116.41 | 116.25 | 116.27 | 1338400.0 |
| 2005-05-03 12:00:00 | SPY | ETF | 116.27 | 116.27 | 116.18 | 116.22 | 973600.0 |
| 2005-05-03 12:30:00 | SPY | ETF | 116.22 | 116.24 | 116.14 | 116.19 | 1720600.0 |
| 2005-05-03 13:00:00 | SPY | ETF | 116.2 | 116.26 | 116.16 | 116.22 | 2190800.0 |
| 2005-05-03 13:30:00 | SPY | ETF | 116.22 | 116.27 | 116.14 | 116.26 | 1431800.0 |
| 2005-05-03 14:00:00 | SPY | ETF | 116.26 | 116.45 | 115.83 | 116.14 | 16528600.0 |
| 2005-05-03 14:30:00 | SPY | ETF | 116.14 | 116.85 | 116.12 | 116.55 | 14777200.0 |
| 2005-05-03 15:00:00 | SPY | ETF | 116.55 | 116.58 | 115.69 | 116.08 | 12885500.0 |
| 2005-05-03 15:30:00 | SPY | ETF | 116.09 | 116.3 | 115.69 | 116.25 | 8467800.0 |
| 2005-05-03 16:00:00 | SPY | ETF | 116.28 | 116.6 | 115.94 | 116.55 | 2337300.0 |
| 2005-05-03 16:30:00 | SPY | ETF | 116.55 | 116.62 | 116.52 | 116.57 | 513400.0 |
| 2005-05-03 17:00:00 | SPY | ETF | 116.58 | 116.68 | 116.58 | 116.62 | 181800.0 |
| 2005-05-03 17:30:00 | SPY | ETF | 116.65 | 116.65 | 116.58 | 116.58 | 62100.0 |
| 2005-05-03 18:00:00 | SPY | ETF | 116.58 | 116.68 | 116.55 | 116.6 | 62400.0 |
| 2005-05-03 18:30:00 | SPY | ETF | 116.6 | 116.62 | 116.58 | 116.62 | 2000.0 |
| 2005-05-03 19:00:00 | SPY | ETF | 116.65 | 116.65 | 116.61 | 116.61 | 1400.0 |
| 2005-05-03 19:30:00 | SPY | ETF | 116.63 | 116.63 | 116.57 | 116.57 | 87700.0 |
| 2005-05-03 09:30:00 | QQQ | ETF | 35.04 | 35.21 | 35.03 | 35.16 | 8360300.0 |
| 2005-05-03 10:00:00 | QQQ | ETF | 35.16 | 35.22 | 35.13 | 35.16 | 6425400.0 |
| 2005-05-03 10:30:00 | QQQ | ETF | 35.16 | 35.3 | 35.16 | 35.22 | 10336300.0 |
| 2005-05-03 11:00:00 | QQQ | ETF | 35.22 | 35.25 | 35.18 | 35.25 | 3622700.0 |
| 2005-05-03 11:30:00 | QQQ | ETF | 35.25 | 35.25 | 35.19 | 35.21 | 1557300.0 |
| 2005-05-03 12:00:00 | QQQ | ETF | 35.2 | 35.21 | 35.18 | 35.19 | 1492200.0 |
| 2005-05-03 12:30:00 | QQQ | ETF | 35.19 | 35.22 | 35.17 | 35.21 | 1803800.0 |
| 2005-05-03 13:00:00 | QQQ | ETF | 35.22 | 35.25 | 35.18 | 35.21 | 1593200.0 |
| 2005-05-03 13:30:00 | QQQ | ETF | 35.22 | 35.22 | 35.17 | 35.22 | 3239600.0 |
| 2005-05-03 14:00:00 | QQQ | ETF | 35.22 | 35.24 | 35.03 | 35.17 | 13851900.0 |
| 2005-05-03 14:30:00 | QQQ | ETF | 35.17 | 36.0 | 35.16 | 35.34 | 19484500.0 |
| 2005-05-03 15:00:00 | QQQ | ETF | 35.34 | 35.36 | 35.05 | 35.18 | 12548500.0 |
| 2005-05-03 15:30:00 | QQQ | ETF | 35.18 | 35.26 | 35.09 | 35.23 | 9036400.0 |
| 2005-05-03 08:00:00 | IWM | ETF | 58.12 | 58.12 | 58.12 | 58.12 | 800.0 |
| 2005-05-03 09:00:00 | IWM | ETF | 58.1 | 58.12 | 58.065 | 58.12 | 26400.0 |
| 2005-05-03 09:30:00 | IWM | ETF | 58.185 | 58.42 | 58.1 | 58.38 | 2301600.0 |
| 2005-05-03 10:00:00 | IWM | ETF | 58.38 | 58.48 | 58.18 | 58.24 | 2261200.0 |
| 2005-05-03 10:30:00 | IWM | ETF | 58.23 | 58.425 | 58.23 | 58.335 | 1505400.0 |
| 2005-05-03 11:00:00 | IWM | ETF | 58.335 | 58.36 | 58.265 | 58.325 | 713600.0 |
| 2005-05-03 11:30:00 | IWM | ETF | 58.335 | 58.345 | 58.24 | 58.255 | 474400.0 |
| 2005-05-03 12:00:00 | IWM | ETF | 58.25 | 58.28 | 58.18 | 58.26 | 873200.0 |
| 2005-05-03 12:30:00 | IWM | ETF | 58.26 | 58.295 | 58.185 | 58.28 | 1284200.0 |
| 2005-05-03 13:00:00 | IWM | ETF | 58.285 | 58.32 | 58.24 | 58.3 | 697200.0 |
| 2005-05-03 13:30:00 | IWM | ETF | 58.31 | 58.355 | 58.265 | 58.355 | 987600.0 |
> showing 50 of 1,460 rows — these rows as CSV