PREVIEW / etf_30min / 2004-11-17
file: by_date/etf_30min/2004/2004-11-17.parquet size: 41 KB rows: 1,351
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-11-17 08:00:00 | SPY | ETF | 118.16 | 118.21 | 118.13 | 118.21 | 24100.0 |
| 2004-11-17 08:30:00 | SPY | ETF | 118.21 | 118.43 | 118.1 | 118.31 | 276300.0 |
| 2004-11-17 09:00:00 | SPY | ETF | 118.35 | 118.37 | 118.3 | 118.35 | 119500.0 |
| 2004-11-17 09:30:00 | SPY | ETF | 118.37 | 118.61 | 118.34 | 118.51 | 5227800.0 |
| 2004-11-17 10:00:00 | SPY | ETF | 118.51 | 119.13 | 118.48 | 119.02 | 5481300.0 |
| 2004-11-17 10:30:00 | SPY | ETF | 119.02 | 119.09 | 118.82 | 118.88 | 5401900.0 |
| 2004-11-17 11:00:00 | SPY | ETF | 118.88 | 119.14 | 118.84 | 119.09 | 2666800.0 |
| 2004-11-17 11:30:00 | SPY | ETF | 119.09 | 119.11 | 119.0 | 119.05 | 2635700.0 |
| 2004-11-17 12:00:00 | SPY | ETF | 119.04 | 119.09 | 118.97 | 119.02 | 1938800.0 |
| 2004-11-17 12:30:00 | SPY | ETF | 119.01 | 119.1 | 118.95 | 119.08 | 1204100.0 |
| 2004-11-17 13:00:00 | SPY | ETF | 119.06 | 119.11 | 118.97 | 119.01 | 1355500.0 |
| 2004-11-17 13:30:00 | SPY | ETF | 118.99 | 118.99 | 118.84 | 118.89 | 2499200.0 |
| 2004-11-17 14:00:00 | SPY | ETF | 118.88 | 118.88 | 118.34 | 118.4 | 6311000.0 |
| 2004-11-17 14:30:00 | SPY | ETF | 118.39 | 118.53 | 118.16 | 118.53 | 3559000.0 |
| 2004-11-17 15:00:00 | SPY | ETF | 118.53 | 118.53 | 118.13 | 118.16 | 5682800.0 |
| 2004-11-17 15:30:00 | SPY | ETF | 118.15 | 118.47 | 118.07 | 118.4 | 5266900.0 |
| 2004-11-17 16:00:00 | SPY | ETF | 118.4 | 118.74 | 118.38 | 118.57 | 2370400.0 |
| 2004-11-17 16:30:00 | SPY | ETF | 118.55 | 118.58 | 118.42 | 118.45 | 190800.0 |
| 2004-11-17 17:00:00 | SPY | ETF | 118.52 | 118.52 | 118.42 | 118.43 | 37600.0 |
| 2004-11-17 17:30:00 | SPY | ETF | 118.44 | 118.48 | 118.41 | 118.45 | 27800.0 |
| 2004-11-17 18:00:00 | SPY | ETF | 118.45 | 118.58 | 118.42 | 118.42 | 393400.0 |
| 2004-11-17 18:30:00 | SPY | ETF | 118.4 | 118.4 | 118.4 | 118.4 | 900.0 |
| 2004-11-17 19:00:00 | SPY | ETF | 118.45 | 118.45 | 118.45 | 118.45 | 3000.0 |
| 2004-11-17 19:30:00 | SPY | ETF | 118.48 | 118.48 | 118.46 | 118.46 | 4700.0 |
| 2004-11-17 08:00:00 | QQQ | ETF | 38.78 | 38.79 | 38.75 | 38.78 | 90100.0 |
| 2004-11-17 08:30:00 | QQQ | ETF | 38.78 | 38.9 | 38.73 | 38.86 | 457600.0 |
| 2004-11-17 09:00:00 | QQQ | ETF | 38.87 | 38.88 | 38.83 | 38.83 | 368500.0 |
| 2004-11-17 09:30:00 | QQQ | ETF | 38.83 | 38.95 | 38.83 | 38.89 | 14411500.0 |
| 2004-11-17 10:00:00 | QQQ | ETF | 38.9 | 39.24 | 38.858 | 39.183 | 17916900.0 |
| 2004-11-17 10:30:00 | QQQ | ETF | 39.183 | 39.243 | 39.07 | 39.17 | 13617900.0 |
| 2004-11-17 11:00:00 | QQQ | ETF | 39.17 | 39.29 | 39.11 | 39.268 | 7363000.0 |
| 2004-11-17 11:30:00 | QQQ | ETF | 39.26 | 39.29 | 39.22 | 39.26 | 5003400.0 |
| 2004-11-17 12:00:00 | QQQ | ETF | 39.26 | 39.32 | 39.25 | 39.26 | 4616300.0 |
| 2004-11-17 12:30:00 | QQQ | ETF | 39.268 | 39.29 | 39.22 | 39.26 | 3053000.0 |
| 2004-11-17 13:00:00 | QQQ | ETF | 39.27 | 39.3 | 39.23 | 39.26 | 3072600.0 |
| 2004-11-17 13:30:00 | QQQ | ETF | 39.258 | 39.27 | 39.15 | 39.17 | 5131900.0 |
| 2004-11-17 14:00:00 | QQQ | ETF | 39.16 | 39.17 | 38.93 | 38.98 | 15270800.0 |
| 2004-11-17 14:30:00 | QQQ | ETF | 38.98 | 39.06 | 38.85 | 39.05 | 9468700.0 |
| 2004-11-17 15:00:00 | QQQ | ETF | 39.05 | 39.1 | 38.9 | 38.92 | 8859800.0 |
| 2004-11-17 15:30:00 | QQQ | ETF | 38.913 | 39.07 | 38.87 | 39.047 | 10836900.0 |
| 2004-11-17 16:00:00 | QQQ | ETF | 39.04 | 39.14 | 38.99 | 39.12 | 2648800.0 |
| 2004-11-17 16:30:00 | QQQ | ETF | 39.12 | 39.128 | 38.93 | 39.026 | 1462400.0 |
| 2004-11-17 17:00:00 | QQQ | ETF | 39.03 | 39.04 | 38.96 | 38.97 | 452700.0 |
| 2004-11-17 17:30:00 | QQQ | ETF | 38.99 | 39.03 | 38.99 | 39.02 | 50700.0 |
| 2004-11-17 18:00:00 | QQQ | ETF | 39.01 | 39.02 | 38.97 | 38.981 | 65700.0 |
| 2004-11-17 18:30:00 | QQQ | ETF | 38.98 | 38.98 | 38.95 | 38.98 | 35100.0 |
| 2004-11-17 19:00:00 | QQQ | ETF | 38.97 | 39.0 | 38.96 | 39.0 | 3400.0 |
| 2004-11-17 19:30:00 | QQQ | ETF | 38.97 | 38.98 | 38.96 | 38.98 | 1200.0 |
| 2004-11-17 08:30:00 | IWM | ETF | 62.0 | 62.02 | 61.94 | 62.0 | 5000.0 |
| 2004-11-17 09:00:00 | IWM | ETF | 62.0 | 62.02 | 61.99 | 61.99 | 58800.0 |
> showing 50 of 1,351 rows — these rows as CSV