PREVIEW / etf_30min / 2004-12-15
file: by_date/etf_30min/2004/2004-12-15.parquet size: 40 KB rows: 1,360
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-15 08:00:00 | SPY | ETF | 120.85 | 120.91 | 120.83 | 120.85 | 60100.0 |
| 2004-12-15 08:30:00 | SPY | ETF | 120.88 | 120.88 | 120.73 | 120.78 | 32800.0 |
| 2004-12-15 09:00:00 | SPY | ETF | 120.78 | 120.78 | 120.69 | 120.71 | 38800.0 |
| 2004-12-15 09:30:00 | SPY | ETF | 120.7 | 120.95 | 120.6 | 120.73 | 3932500.0 |
| 2004-12-15 10:00:00 | SPY | ETF | 120.73 | 121.03 | 120.73 | 120.98 | 2990300.0 |
| 2004-12-15 10:30:00 | SPY | ETF | 120.97 | 120.98 | 120.74 | 120.75 | 3613400.0 |
| 2004-12-15 11:00:00 | SPY | ETF | 120.75 | 120.77 | 120.31 | 120.42 | 5475600.0 |
| 2004-12-15 11:30:00 | SPY | ETF | 120.42 | 120.58 | 120.37 | 120.48 | 2553500.0 |
| 2004-12-15 12:00:00 | SPY | ETF | 120.48 | 120.65 | 120.48 | 120.54 | 2533900.0 |
| 2004-12-15 12:30:00 | SPY | ETF | 120.53 | 120.64 | 120.5 | 120.59 | 932800.0 |
| 2004-12-15 13:00:00 | SPY | ETF | 120.6 | 120.99 | 120.59 | 120.82 | 4413300.0 |
| 2004-12-15 13:30:00 | SPY | ETF | 120.81 | 120.92 | 120.77 | 120.83 | 1384600.0 |
| 2004-12-15 14:00:00 | SPY | ETF | 120.83 | 120.94 | 120.78 | 120.85 | 1354000.0 |
| 2004-12-15 14:30:00 | SPY | ETF | 120.83 | 120.85 | 120.58 | 120.72 | 2559100.0 |
| 2004-12-15 15:00:00 | SPY | ETF | 120.73 | 120.95 | 120.71 | 120.9 | 2774800.0 |
| 2004-12-15 15:30:00 | SPY | ETF | 120.89 | 121.11 | 120.88 | 120.97 | 5464600.0 |
| 2004-12-15 16:00:00 | SPY | ETF | 120.97 | 120.99 | 120.763 | 120.88 | 1986400.0 |
| 2004-12-15 16:30:00 | SPY | ETF | 120.86 | 120.91 | 120.84 | 120.88 | 61800.0 |
| 2004-12-15 17:00:00 | SPY | ETF | 120.88 | 120.9 | 120.86 | 120.87 | 8100.0 |
| 2004-12-15 18:00:00 | SPY | ETF | 120.88 | 120.91 | 120.88 | 120.91 | 52100.0 |
| 2004-12-15 19:00:00 | SPY | ETF | 120.89 | 120.89 | 120.89 | 120.89 | 400.0 |
| 2004-12-15 19:30:00 | SPY | ETF | 120.86 | 120.86 | 120.86 | 120.86 | 100.0 |
| 2004-12-15 08:00:00 | QQQ | ETF | 40.6 | 40.65 | 40.57 | 40.59 | 754883.0 |
| 2004-12-15 08:30:00 | QQQ | ETF | 40.59 | 40.592 | 40.53 | 40.55 | 605061.0 |
| 2004-12-15 09:00:00 | QQQ | ETF | 40.545 | 40.55 | 40.49 | 40.491 | 558923.0 |
| 2004-12-15 09:30:00 | QQQ | ETF | 40.49 | 40.6 | 40.43 | 40.53 | 7333887.0 |
| 2004-12-15 10:00:00 | QQQ | ETF | 40.52 | 40.68 | 40.51 | 40.635 | 11825476.0 |
| 2004-12-15 10:30:00 | QQQ | ETF | 40.64 | 40.65 | 40.48 | 40.49 | 7662184.0 |
| 2004-12-15 11:00:00 | QQQ | ETF | 40.489 | 40.49 | 40.155 | 40.23 | 11701836.0 |
| 2004-12-15 11:30:00 | QQQ | ETF | 40.235 | 40.331 | 40.21 | 40.28 | 5904899.0 |
| 2004-12-15 12:00:00 | QQQ | ETF | 40.28 | 40.35 | 40.27 | 40.309 | 5700947.0 |
| 2004-12-15 12:30:00 | QQQ | ETF | 40.31 | 40.39 | 40.28 | 40.331 | 2986177.0 |
| 2004-12-15 13:00:00 | QQQ | ETF | 40.33 | 40.46 | 40.31 | 40.37 | 4762879.0 |
| 2004-12-15 13:30:00 | QQQ | ETF | 40.37 | 40.42 | 40.31 | 40.315 | 3080190.0 |
| 2004-12-15 14:00:00 | QQQ | ETF | 40.311 | 40.341 | 40.25 | 40.27 | 5262372.0 |
| 2004-12-15 14:30:00 | QQQ | ETF | 40.28 | 40.28 | 40.19 | 40.27 | 5990638.0 |
| 2004-12-15 15:00:00 | QQQ | ETF | 40.268 | 40.37 | 40.26 | 40.34 | 3720715.0 |
| 2004-12-15 15:30:00 | QQQ | ETF | 40.33 | 40.41 | 40.28 | 40.34 | 7621265.0 |
| 2004-12-15 16:00:00 | QQQ | ETF | 40.34 | 40.3978 | 40.32 | 40.34 | 1319737.0 |
| 2004-12-15 16:30:00 | QQQ | ETF | 40.34 | 40.3978 | 40.33 | 40.33 | 6364455.0 |
| 2004-12-15 17:00:00 | QQQ | ETF | 40.35 | 40.355 | 40.34 | 40.348 | 33305.0 |
| 2004-12-15 17:30:00 | QQQ | ETF | 40.349 | 40.35 | 40.349 | 40.35 | 1250.0 |
| 2004-12-15 18:00:00 | QQQ | ETF | 40.35 | 40.37 | 40.35 | 40.35 | 30250.0 |
| 2004-12-15 08:00:00 | IWM | ETF | 64.32 | 64.32 | 64.32 | 64.32 | 600.0 |
| 2004-12-15 08:30:00 | IWM | ETF | 64.25 | 64.25 | 64.25 | 64.25 | 11600.0 |
| 2004-12-15 09:00:00 | IWM | ETF | 64.185 | 64.205 | 64.185 | 64.205 | 600.0 |
| 2004-12-15 09:30:00 | IWM | ETF | 64.155 | 64.48 | 64.105 | 64.405 | 1659400.0 |
| 2004-12-15 10:00:00 | IWM | ETF | 64.405 | 64.655 | 64.405 | 64.615 | 1366000.0 |
| 2004-12-15 10:30:00 | IWM | ETF | 64.615 | 64.635 | 64.5 | 64.5 | 899800.0 |
| 2004-12-15 11:00:00 | IWM | ETF | 64.515 | 64.515 | 64.155 | 64.275 | 1701600.0 |
> showing 50 of 1,360 rows — these rows as CSV