PREVIEW / etf_30min / 2003-10-16
file: by_date/etf_30min/2003/2003-10-16.parquet size: 25 KB rows: 758
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-16 08:00:00 | SPY | ETF | 104.98 | 105.1 | 104.95 | 105.08 | 45000.0 |
| 2003-10-16 08:30:00 | SPY | ETF | 105.08 | 105.1 | 104.74 | 104.74 | 196400.0 |
| 2003-10-16 09:00:00 | SPY | ETF | 104.76 | 104.81 | 104.66 | 104.67 | 85400.0 |
| 2003-10-16 09:30:00 | SPY | ETF | 104.68 | 105.08 | 104.65 | 104.9 | 3765700.0 |
| 2003-10-16 10:00:00 | SPY | ETF | 104.92 | 105.23 | 104.81 | 105.08 | 3341500.0 |
| 2003-10-16 10:30:00 | SPY | ETF | 105.04 | 105.09 | 104.81 | 105.05 | 1914400.0 |
| 2003-10-16 11:00:00 | SPY | ETF | 105.06 | 105.1 | 104.85 | 104.92 | 955700.0 |
| 2003-10-16 11:30:00 | SPY | ETF | 104.93 | 105.17 | 104.9 | 105.13 | 1472800.0 |
| 2003-10-16 12:00:00 | SPY | ETF | 105.13 | 105.341 | 105.05 | 105.28 | 2604800.0 |
| 2003-10-16 12:30:00 | SPY | ETF | 105.29 | 105.65 | 105.25 | 105.613 | 2857100.0 |
| 2003-10-16 13:00:00 | SPY | ETF | 105.6 | 105.73 | 105.41 | 105.43 | 1992000.0 |
| 2003-10-16 13:30:00 | SPY | ETF | 105.45 | 105.51 | 105.31 | 105.37 | 898800.0 |
| 2003-10-16 14:00:00 | SPY | ETF | 105.38 | 105.51 | 105.294 | 105.304 | 596400.0 |
| 2003-10-16 14:30:00 | SPY | ETF | 105.31 | 105.33 | 104.96 | 105.136 | 2428700.0 |
| 2003-10-16 15:00:00 | SPY | ETF | 105.1 | 105.29 | 104.85 | 105.29 | 4958000.0 |
| 2003-10-16 15:30:00 | SPY | ETF | 105.28 | 105.44 | 105.25 | 105.33 | 2064000.0 |
| 2003-10-16 16:00:00 | SPY | ETF | 105.31 | 105.49 | 105.28 | 105.28 | 973200.0 |
| 2003-10-16 16:30:00 | SPY | ETF | 105.2861 | 105.31 | 105.18 | 105.23 | 61900.0 |
| 2003-10-16 17:00:00 | SPY | ETF | 105.28 | 105.31 | 105.25 | 105.25 | 47200.0 |
| 2003-10-16 17:30:00 | SPY | ETF | 105.25 | 105.32 | 105.25 | 105.28 | 3300.0 |
| 2003-10-16 18:00:00 | SPY | ETF | 105.26 | 105.26 | 105.26 | 105.26 | 200.0 |
| 2003-10-16 19:30:00 | SPY | ETF | 105.3 | 105.3 | 105.3 | 105.3 | 500.0 |
| 2003-10-16 08:00:00 | QQQ | ETF | 35.12 | 35.21 | 35.1 | 35.18 | 70800.0 |
| 2003-10-16 08:30:00 | QQQ | ETF | 35.19 | 35.19 | 35.06 | 35.09 | 106100.0 |
| 2003-10-16 09:00:00 | QQQ | ETF | 35.09 | 35.14 | 35.06 | 35.1 | 116100.0 |
| 2003-10-16 09:30:00 | QQQ | ETF | 35.1 | 35.23 | 35.06 | 35.154 | 9603700.0 |
| 2003-10-16 10:00:00 | QQQ | ETF | 35.16 | 35.37 | 35.14 | 35.26 | 6457700.0 |
| 2003-10-16 10:30:00 | QQQ | ETF | 35.259 | 35.294 | 35.12 | 35.23 | 4281400.0 |
| 2003-10-16 11:00:00 | QQQ | ETF | 35.23 | 35.25 | 35.11 | 35.15 | 2800000.0 |
| 2003-10-16 11:30:00 | QQQ | ETF | 35.15 | 35.24 | 35.12 | 35.23 | 3055200.0 |
| 2003-10-16 12:00:00 | QQQ | ETF | 35.23 | 35.33 | 35.19 | 35.3 | 3910400.0 |
| 2003-10-16 12:30:00 | QQQ | ETF | 35.3 | 35.5 | 35.29 | 35.48 | 6536300.0 |
| 2003-10-16 13:00:00 | QQQ | ETF | 35.48 | 35.52 | 35.35 | 35.37 | 4604600.0 |
| 2003-10-16 13:30:00 | QQQ | ETF | 35.36 | 35.41 | 35.3 | 35.344 | 2845900.0 |
| 2003-10-16 14:00:00 | QQQ | ETF | 35.343 | 35.43 | 35.34 | 35.36 | 1242800.0 |
| 2003-10-16 14:30:00 | QQQ | ETF | 35.36 | 35.39 | 35.23 | 35.33 | 4896400.0 |
| 2003-10-16 15:00:00 | QQQ | ETF | 35.32 | 35.39 | 35.2 | 35.389 | 5176100.0 |
| 2003-10-16 15:30:00 | QQQ | ETF | 35.38 | 35.48 | 35.36 | 35.448 | 5715600.0 |
| 2003-10-16 16:00:00 | QQQ | ETF | 35.448 | 35.5 | 35.31 | 35.31 | 5890200.0 |
| 2003-10-16 16:30:00 | QQQ | ETF | 35.323 | 35.48 | 35.26 | 35.32 | 1043800.0 |
| 2003-10-16 17:00:00 | QQQ | ETF | 35.32 | 35.369 | 35.31 | 35.35 | 704300.0 |
| 2003-10-16 17:30:00 | QQQ | ETF | 35.35 | 35.38 | 35.34 | 35.34 | 114000.0 |
| 2003-10-16 18:00:00 | QQQ | ETF | 35.35 | 35.37 | 35.32 | 35.37 | 10200.0 |
| 2003-10-16 18:30:00 | QQQ | ETF | 35.35 | 35.35 | 35.33 | 35.33 | 13900.0 |
| 2003-10-16 19:00:00 | QQQ | ETF | 35.34 | 35.35 | 35.33 | 35.34 | 16300.0 |
| 2003-10-16 19:30:00 | QQQ | ETF | 35.34 | 35.35 | 35.34 | 35.35 | 10500.0 |
| 2003-10-16 08:30:00 | IWM | ETF | 52.395 | 52.395 | 52.395 | 52.395 | 200.0 |
| 2003-10-16 09:00:00 | IWM | ETF | 52.35 | 52.35 | 52.3 | 52.3 | 10200.0 |
| 2003-10-16 09:30:00 | IWM | ETF | 52.405 | 52.66 | 52.375 | 52.475 | 524000.0 |
| 2003-10-16 10:00:00 | IWM | ETF | 52.505 | 52.91 | 52.46 | 52.81 | 283800.0 |
> showing 50 of 758 rows — these rows as CSV