PREVIEW / etf_30min / 2003-10-24
file: by_date/etf_30min/2003/2003-10-24.parquet size: 26 KB rows: 789
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-24 08:00:00 | SPY | ETF | 103.03 | 103.06 | 102.95 | 102.97 | 67600.0 |
| 2003-10-24 08:30:00 | SPY | ETF | 102.92 | 102.96 | 102.86 | 102.9 | 62300.0 |
| 2003-10-24 09:00:00 | SPY | ETF | 102.91 | 102.91 | 102.8 | 102.88 | 193100.0 |
| 2003-10-24 09:30:00 | SPY | ETF | 102.83 | 103.07 | 102.68 | 103.07 | 4380500.0 |
| 2003-10-24 10:00:00 | SPY | ETF | 103.07 | 103.18 | 102.85 | 102.89 | 2082300.0 |
| 2003-10-24 10:30:00 | SPY | ETF | 102.93 | 103.17 | 102.76 | 103.059 | 1499800.0 |
| 2003-10-24 11:00:00 | SPY | ETF | 103.067 | 103.24 | 102.85 | 102.85 | 2220200.0 |
| 2003-10-24 11:30:00 | SPY | ETF | 102.85 | 102.9 | 102.57 | 102.7 | 5024900.0 |
| 2003-10-24 12:00:00 | SPY | ETF | 102.7 | 102.79 | 102.56 | 102.62 | 2556900.0 |
| 2003-10-24 12:30:00 | SPY | ETF | 102.63 | 102.67 | 102.19 | 102.33 | 3840700.0 |
| 2003-10-24 13:00:00 | SPY | ETF | 102.34 | 102.52 | 102.3 | 102.37 | 2628200.0 |
| 2003-10-24 13:30:00 | SPY | ETF | 102.37 | 102.49 | 102.21 | 102.25 | 2648200.0 |
| 2003-10-24 14:00:00 | SPY | ETF | 102.25 | 102.5 | 102.18 | 102.48 | 3918900.0 |
| 2003-10-24 14:30:00 | SPY | ETF | 102.48 | 102.71 | 102.39 | 102.48 | 2141800.0 |
| 2003-10-24 15:00:00 | SPY | ETF | 102.45 | 102.94 | 102.39 | 102.84 | 2030000.0 |
| 2003-10-24 15:30:00 | SPY | ETF | 102.83 | 103.29 | 102.74 | 103.28 | 5329900.0 |
| 2003-10-24 16:00:00 | SPY | ETF | 103.25 | 103.58 | 103.23 | 103.49 | 1828200.0 |
| 2003-10-24 16:30:00 | SPY | ETF | 103.42 | 103.5 | 103.33 | 103.34 | 176100.0 |
| 2003-10-24 17:00:00 | SPY | ETF | 103.35 | 103.37 | 103.3 | 103.34 | 11200.0 |
| 2003-10-24 17:30:00 | SPY | ETF | 103.37 | 103.4 | 103.35 | 103.35 | 1200.0 |
| 2003-10-24 18:00:00 | SPY | ETF | 103.34 | 103.57 | 103.34 | 103.34 | 3400.0 |
| 2003-10-24 18:30:00 | SPY | ETF | 103.35 | 103.4 | 103.35 | 103.39 | 2300.0 |
| 2003-10-24 19:00:00 | SPY | ETF | 103.39 | 103.39 | 103.38 | 103.38 | 700.0 |
| 2003-10-24 19:30:00 | SPY | ETF | 103.38 | 103.38 | 103.34 | 103.34 | 1000.0 |
| 2003-10-24 08:00:00 | QQQ | ETF | 33.83 | 33.87 | 33.78 | 33.83 | 124300.0 |
| 2003-10-24 08:30:00 | QQQ | ETF | 33.81 | 33.84 | 33.79 | 33.83 | 112900.0 |
| 2003-10-24 09:00:00 | QQQ | ETF | 33.83 | 33.83 | 33.78 | 33.79 | 138100.0 |
| 2003-10-24 09:30:00 | QQQ | ETF | 33.79 | 33.97 | 33.72 | 33.95 | 16175200.0 |
| 2003-10-24 10:00:00 | QQQ | ETF | 33.95 | 33.99 | 33.82 | 33.87 | 7418900.0 |
| 2003-10-24 10:30:00 | QQQ | ETF | 33.86 | 33.89 | 33.78 | 33.89 | 4783800.0 |
| 2003-10-24 11:00:00 | QQQ | ETF | 33.887 | 33.98 | 33.83 | 33.842 | 3721300.0 |
| 2003-10-24 11:30:00 | QQQ | ETF | 33.85 | 33.85 | 33.71 | 33.76 | 6447000.0 |
| 2003-10-24 12:00:00 | QQQ | ETF | 33.76 | 33.8 | 33.67 | 33.704 | 2894000.0 |
| 2003-10-24 12:30:00 | QQQ | ETF | 33.706 | 33.73 | 33.501 | 33.58 | 10518900.0 |
| 2003-10-24 13:00:00 | QQQ | ETF | 33.58 | 33.64 | 33.54 | 33.59 | 5045300.0 |
| 2003-10-24 13:30:00 | QQQ | ETF | 33.589 | 33.65 | 33.495 | 33.5 | 4394200.0 |
| 2003-10-24 14:00:00 | QQQ | ETF | 33.5 | 33.649 | 33.49 | 33.62 | 6270800.0 |
| 2003-10-24 14:30:00 | QQQ | ETF | 33.61 | 33.69 | 33.59 | 33.62 | 4388400.0 |
| 2003-10-24 15:00:00 | QQQ | ETF | 33.62 | 33.82 | 33.6 | 33.74 | 4174000.0 |
| 2003-10-24 15:30:00 | QQQ | ETF | 33.75 | 34.09 | 33.73 | 34.08 | 11647900.0 |
| 2003-10-24 16:00:00 | QQQ | ETF | 34.07 | 34.23 | 34.03 | 34.18 | 5232200.0 |
| 2003-10-24 16:30:00 | QQQ | ETF | 34.179 | 34.2 | 34.12 | 34.14 | 98400.0 |
| 2003-10-24 17:00:00 | QQQ | ETF | 34.14 | 34.18 | 34.1 | 34.135 | 37400.0 |
| 2003-10-24 17:30:00 | QQQ | ETF | 34.14 | 34.17 | 34.12 | 34.14 | 25600.0 |
| 2003-10-24 18:00:00 | QQQ | ETF | 34.14 | 34.14 | 34.13 | 34.13 | 16100.0 |
| 2003-10-24 18:30:00 | QQQ | ETF | 34.13 | 34.13 | 34.09 | 34.09 | 5300.0 |
| 2003-10-24 19:00:00 | QQQ | ETF | 34.12 | 34.12 | 34.1 | 34.1 | 3000.0 |
| 2003-10-24 19:30:00 | QQQ | ETF | 34.1 | 34.13 | 34.1 | 34.12 | 10900.0 |
| 2003-10-24 09:30:00 | IWM | ETF | 50.425 | 50.605 | 50.305 | 50.576 | 1105800.0 |
| 2003-10-24 10:00:00 | IWM | ETF | 50.555 | 50.625 | 50.455 | 50.56 | 273000.0 |
> showing 50 of 789 rows — these rows as CSV