PREVIEW / etf_30min / 2005-03-24
file: by_date/etf_30min/2005/2005-03-24.parquet size: 43 KB rows: 1,475
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-03-24 08:00:00 | SPY | ETF | 117.54 | 117.57 | 117.45 | 117.46 | 37900.0 |
| 2005-03-24 08:30:00 | SPY | ETF | 117.49 | 117.62 | 117.45 | 117.58 | 273900.0 |
| 2005-03-24 09:00:00 | SPY | ETF | 117.57 | 117.57 | 117.45 | 117.46 | 49300.0 |
| 2005-03-24 09:30:00 | SPY | ETF | 117.46 | 117.72 | 117.34 | 117.68 | 6752800.0 |
| 2005-03-24 10:00:00 | SPY | ETF | 117.68 | 117.82 | 117.53 | 117.72 | 4603300.0 |
| 2005-03-24 10:30:00 | SPY | ETF | 117.73 | 117.82 | 117.61 | 117.63 | 2307700.0 |
| 2005-03-24 11:00:00 | SPY | ETF | 117.63 | 117.66 | 117.35 | 117.48 | 3230800.0 |
| 2005-03-24 11:30:00 | SPY | ETF | 117.48 | 117.67 | 117.45 | 117.53 | 1663000.0 |
| 2005-03-24 12:00:00 | SPY | ETF | 117.53 | 117.77 | 117.52 | 117.74 | 1713300.0 |
| 2005-03-24 12:30:00 | SPY | ETF | 117.73 | 117.99 | 117.69 | 117.8 | 2496400.0 |
| 2005-03-24 13:00:00 | SPY | ETF | 117.79 | 117.93 | 117.65 | 117.7 | 2847200.0 |
| 2005-03-24 13:30:00 | SPY | ETF | 117.7 | 117.78 | 117.52 | 117.61 | 1443200.0 |
| 2005-03-24 14:00:00 | SPY | ETF | 117.6 | 117.86 | 117.6 | 117.71 | 1763400.0 |
| 2005-03-24 14:30:00 | SPY | ETF | 117.72 | 117.73 | 117.55 | 117.68 | 2628400.0 |
| 2005-03-24 15:00:00 | SPY | ETF | 117.69 | 117.71 | 117.37 | 117.41 | 5267200.0 |
| 2005-03-24 15:30:00 | SPY | ETF | 117.42 | 117.82 | 117.11 | 117.14 | 10070300.0 |
| 2005-03-24 16:00:00 | SPY | ETF | 117.14 | 117.2 | 117.06 | 117.18 | 957700.0 |
| 2005-03-24 16:30:00 | SPY | ETF | 117.15 | 117.26 | 117.12 | 117.17 | 57500.0 |
| 2005-03-24 17:00:00 | SPY | ETF | 117.16 | 117.16 | 117.1 | 117.15 | 20600.0 |
| 2005-03-24 17:30:00 | SPY | ETF | 117.14 | 117.2 | 117.14 | 117.2 | 4900.0 |
| 2005-03-24 18:00:00 | SPY | ETF | 117.16 | 117.21 | 117.15 | 117.15 | 2800.0 |
| 2005-03-24 18:30:00 | SPY | ETF | 117.12 | 117.12 | 117.12 | 117.12 | 800.0 |
| 2005-03-24 19:30:00 | SPY | ETF | 117.13 | 117.13 | 117.12 | 117.13 | 500.0 |
| 2005-03-24 09:30:00 | QQQ | ETF | 36.4 | 36.46 | 36.29 | 36.46 | 12283900.0 |
| 2005-03-24 10:00:00 | QQQ | ETF | 36.46 | 36.53 | 36.39 | 36.53 | 8873800.0 |
| 2005-03-24 10:30:00 | QQQ | ETF | 36.53 | 36.61 | 36.49 | 36.51 | 7387000.0 |
| 2005-03-24 11:00:00 | QQQ | ETF | 36.51 | 36.52 | 36.35 | 36.42 | 6936900.0 |
| 2005-03-24 11:30:00 | QQQ | ETF | 36.42 | 36.49 | 36.4 | 36.46 | 3379700.0 |
| 2005-03-24 12:00:00 | QQQ | ETF | 36.46 | 36.55 | 36.46 | 36.53 | 2784700.0 |
| 2005-03-24 12:30:00 | QQQ | ETF | 36.53 | 38.62 | 36.52 | 36.57 | 6224900.0 |
| 2005-03-24 13:00:00 | QQQ | ETF | 36.57 | 36.57 | 36.52 | 36.54 | 2164600.0 |
| 2005-03-24 13:30:00 | QQQ | ETF | 36.54 | 36.57 | 36.5 | 36.52 | 2667200.0 |
| 2005-03-24 14:00:00 | QQQ | ETF | 36.52 | 36.58 | 36.51 | 36.52 | 2554100.0 |
| 2005-03-24 14:30:00 | QQQ | ETF | 36.52 | 36.53 | 36.47 | 36.51 | 2979700.0 |
| 2005-03-24 15:00:00 | QQQ | ETF | 36.52 | 36.54 | 36.41 | 36.44 | 4230300.0 |
| 2005-03-24 15:30:00 | QQQ | ETF | 36.44 | 36.44 | 36.28 | 36.28 | 9593400.0 |
| 2005-03-24 08:00:00 | IWM | ETF | 61.1 | 61.135 | 61.1 | 61.105 | 15800.0 |
| 2005-03-24 08:30:00 | IWM | ETF | 61.135 | 61.16 | 61.09 | 61.15 | 16800.0 |
| 2005-03-24 09:00:00 | IWM | ETF | 61.175 | 61.175 | 61.125 | 61.17 | 67800.0 |
| 2005-03-24 09:30:00 | IWM | ETF | 61.15 | 61.4 | 61.005 | 61.375 | 2578600.0 |
| 2005-03-24 10:00:00 | IWM | ETF | 61.38 | 61.495 | 61.33 | 61.38 | 1363600.0 |
| 2005-03-24 10:30:00 | IWM | ETF | 61.375 | 61.435 | 61.335 | 61.38 | 1086800.0 |
| 2005-03-24 11:00:00 | IWM | ETF | 61.375 | 61.38 | 61.2 | 61.275 | 606000.0 |
| 2005-03-24 11:30:00 | IWM | ETF | 61.265 | 61.375 | 61.25 | 61.36 | 1475000.0 |
| 2005-03-24 12:00:00 | IWM | ETF | 61.365 | 61.415 | 61.35 | 61.38 | 408000.0 |
| 2005-03-24 12:30:00 | IWM | ETF | 61.385 | 61.625 | 61.385 | 61.5 | 922400.0 |
| 2005-03-24 13:00:00 | IWM | ETF | 61.505 | 61.505 | 61.35 | 61.44 | 422400.0 |
| 2005-03-24 13:30:00 | IWM | ETF | 61.44 | 61.475 | 61.36 | 61.425 | 428000.0 |
| 2005-03-24 14:00:00 | IWM | ETF | 61.42 | 61.535 | 61.42 | 61.49 | 621400.0 |
| 2005-03-24 14:30:00 | IWM | ETF | 61.49 | 61.5 | 61.4 | 61.46 | 641000.0 |
> showing 50 of 1,475 rows — these rows as CSV