PREVIEW / etf_30min / 2004-03-18
file: by_date/etf_30min/2004/2004-03-18.parquet size: 36 KB rows: 1,178
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-03-18 08:00:00 | SPY | ETF | 112.71 | 112.73 | 112.65 | 112.65 | 102900.0 |
| 2004-03-18 08:30:00 | SPY | ETF | 112.66 | 112.78 | 112.59 | 112.59 | 174700.0 |
| 2004-03-18 09:00:00 | SPY | ETF | 112.58 | 112.68 | 112.58 | 112.68 | 30800.0 |
| 2004-03-18 09:30:00 | SPY | ETF | 112.7 | 112.83 | 112.6 | 112.77 | 4214300.0 |
| 2004-03-18 10:00:00 | SPY | ETF | 112.78 | 112.8 | 112.35 | 112.58 | 4593000.0 |
| 2004-03-18 10:30:00 | SPY | ETF | 112.58 | 112.61 | 112.25 | 112.36 | 1958000.0 |
| 2004-03-18 11:00:00 | SPY | ETF | 112.36 | 112.36 | 112.09 | 112.22 | 1967200.0 |
| 2004-03-18 11:30:00 | SPY | ETF | 112.22 | 112.39 | 112.2 | 112.36 | 2716000.0 |
| 2004-03-18 12:00:00 | SPY | ETF | 112.33 | 112.37 | 111.97 | 112.01 | 3412500.0 |
| 2004-03-18 12:30:00 | SPY | ETF | 112.02 | 112.65 | 111.93 | 112.44 | 5686300.0 |
| 2004-03-18 13:00:00 | SPY | ETF | 112.44 | 113.25 | 112.37 | 112.87 | 10556800.0 |
| 2004-03-18 13:30:00 | SPY | ETF | 112.87 | 113.02 | 112.52 | 112.608 | 4353400.0 |
| 2004-03-18 14:00:00 | SPY | ETF | 112.6 | 112.82 | 112.46 | 112.48 | 2421100.0 |
| 2004-03-18 14:30:00 | SPY | ETF | 112.46 | 112.71 | 112.42 | 112.66 | 1665200.0 |
| 2004-03-18 15:00:00 | SPY | ETF | 112.65 | 113.2 | 112.65 | 113.2 | 4137200.0 |
| 2004-03-18 15:30:00 | SPY | ETF | 113.2 | 113.25 | 112.85 | 112.91 | 3909200.0 |
| 2004-03-18 16:00:00 | SPY | ETF | 112.9 | 113.15 | 112.88 | 113.1 | 2292600.0 |
| 2004-03-18 16:30:00 | SPY | ETF | 113.08 | 113.085 | 113.06 | 113.07 | 35400.0 |
| 2004-03-18 17:00:00 | SPY | ETF | 113.07 | 113.16 | 113.0 | 113.13 | 77500.0 |
| 2004-03-18 17:30:00 | SPY | ETF | 113.11 | 113.2 | 113.11 | 113.13 | 3300.0 |
| 2004-03-18 18:00:00 | SPY | ETF | 113.13 | 113.18 | 113.08 | 113.17 | 1400.0 |
| 2004-03-18 18:30:00 | SPY | ETF | 113.17 | 113.2 | 113.13 | 113.18 | 5400.0 |
| 2004-03-18 19:00:00 | SPY | ETF | 113.18 | 113.18 | 113.18 | 113.18 | 400.0 |
| 2004-03-18 19:30:00 | SPY | ETF | 113.16 | 113.16 | 113.16 | 113.16 | 3000.0 |
| 2004-03-18 08:00:00 | QQQ | ETF | 35.36 | 35.4 | 35.34 | 35.35 | 166900.0 |
| 2004-03-18 08:30:00 | QQQ | ETF | 35.35 | 35.43 | 35.32 | 35.33 | 362900.0 |
| 2004-03-18 09:00:00 | QQQ | ETF | 35.33 | 35.37 | 35.28 | 35.37 | 344400.0 |
| 2004-03-18 09:30:00 | QQQ | ETF | 35.37 | 35.46 | 35.31 | 35.379 | 11267600.0 |
| 2004-03-18 10:00:00 | QQQ | ETF | 35.38 | 35.39 | 35.23 | 35.31 | 9657000.0 |
| 2004-03-18 10:30:00 | QQQ | ETF | 35.32 | 35.33 | 35.15 | 35.23 | 5473400.0 |
| 2004-03-18 11:00:00 | QQQ | ETF | 35.23 | 35.23 | 35.11 | 35.159 | 6091900.0 |
| 2004-03-18 11:30:00 | QQQ | ETF | 35.15 | 35.24 | 35.15 | 35.19 | 5987500.0 |
| 2004-03-18 12:00:00 | QQQ | ETF | 35.19 | 35.2 | 34.97 | 35.015 | 9281500.0 |
| 2004-03-18 12:30:00 | QQQ | ETF | 35.015 | 35.2 | 34.98 | 35.11 | 9470100.0 |
| 2004-03-18 13:00:00 | QQQ | ETF | 35.103 | 35.4 | 35.08 | 35.31 | 16785700.0 |
| 2004-03-18 13:30:00 | QQQ | ETF | 35.291 | 35.35 | 35.15 | 35.22 | 5580800.0 |
| 2004-03-18 14:00:00 | QQQ | ETF | 35.231 | 35.29 | 35.117 | 35.13 | 5232500.0 |
| 2004-03-18 14:30:00 | QQQ | ETF | 35.13 | 35.219 | 35.09 | 35.17 | 3185900.0 |
| 2004-03-18 15:00:00 | QQQ | ETF | 35.18 | 35.44 | 35.17 | 35.419 | 6532200.0 |
| 2004-03-18 15:30:00 | QQQ | ETF | 35.419 | 35.445 | 35.26 | 35.292 | 9700100.0 |
| 2004-03-18 16:00:00 | QQQ | ETF | 35.29 | 35.38 | 35.27 | 35.36 | 1822200.0 |
| 2004-03-18 16:30:00 | QQQ | ETF | 35.36 | 35.41 | 35.34 | 35.36 | 807800.0 |
| 2004-03-18 17:00:00 | QQQ | ETF | 35.36 | 35.398 | 35.36 | 35.37 | 31700.0 |
| 2004-03-18 17:30:00 | QQQ | ETF | 35.37 | 35.39 | 35.36 | 35.39 | 42900.0 |
| 2004-03-18 18:00:00 | QQQ | ETF | 35.39 | 35.4 | 35.35 | 35.4 | 45000.0 |
| 2004-03-18 18:30:00 | QQQ | ETF | 35.39 | 35.41 | 35.38 | 35.4 | 17800.0 |
| 2004-03-18 19:00:00 | QQQ | ETF | 35.4 | 35.42 | 35.37 | 35.38 | 5800.0 |
| 2004-03-18 19:30:00 | QQQ | ETF | 35.38 | 35.4 | 35.37 | 35.4 | 3600.0 |
| 2004-03-18 08:30:00 | IWM | ETF | 57.48 | 57.48 | 57.46 | 57.46 | 3200.0 |
| 2004-03-18 09:30:00 | IWM | ETF | 57.47 | 57.55 | 57.24 | 57.465 | 2537800.0 |
> showing 50 of 1,178 rows — these rows as CSV