PREVIEW / etf_30min / 2005-02-03
file: by_date/etf_30min/2005/2005-02-03.parquet size: 40 KB rows: 1,423
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-02-03 08:00:00 | SPY | ETF | 119.24 | 119.29 | 119.22 | 119.29 | 29400.0 |
| 2005-02-03 08:30:00 | SPY | ETF | 119.28 | 119.32 | 119.07 | 119.07 | 123400.0 |
| 2005-02-03 09:00:00 | SPY | ETF | 119.07 | 119.08 | 119.03 | 119.05 | 55900.0 |
| 2005-02-03 09:30:00 | SPY | ETF | 119.06 | 119.15 | 118.9 | 119.14 | 5936900.0 |
| 2005-02-03 10:00:00 | SPY | ETF | 119.14 | 119.15 | 118.85 | 118.9 | 5662700.0 |
| 2005-02-03 10:30:00 | SPY | ETF | 118.9 | 119.11 | 118.78 | 118.85 | 4739100.0 |
| 2005-02-03 11:00:00 | SPY | ETF | 118.84 | 118.9 | 118.74 | 118.85 | 3141100.0 |
| 2005-02-03 11:30:00 | SPY | ETF | 118.84 | 118.92 | 118.77 | 118.79 | 1384700.0 |
| 2005-02-03 12:00:00 | SPY | ETF | 118.79 | 118.89 | 118.77 | 118.85 | 1436500.0 |
| 2005-02-03 12:30:00 | SPY | ETF | 118.85 | 118.9 | 118.57 | 118.68 | 4215700.0 |
| 2005-02-03 13:00:00 | SPY | ETF | 118.68 | 118.8 | 118.61 | 118.78 | 2292400.0 |
| 2005-02-03 13:30:00 | SPY | ETF | 118.8 | 118.9 | 118.77 | 118.88 | 2135100.0 |
| 2005-02-03 14:00:00 | SPY | ETF | 118.86 | 119.04 | 118.84 | 118.85 | 3318600.0 |
| 2005-02-03 14:30:00 | SPY | ETF | 118.85 | 118.92 | 118.76 | 118.85 | 1864100.0 |
| 2005-02-03 15:00:00 | SPY | ETF | 118.86 | 118.92 | 118.7 | 118.91 | 5133200.0 |
| 2005-02-03 15:30:00 | SPY | ETF | 118.9 | 119.16 | 118.78 | 119.05 | 4831700.0 |
| 2005-02-03 16:00:00 | SPY | ETF | 119.05 | 119.12 | 118.84 | 119.03 | 1902300.0 |
| 2005-02-03 16:30:00 | SPY | ETF | 119.01 | 119.09 | 118.99 | 119.08 | 276900.0 |
| 2005-02-03 17:00:00 | SPY | ETF | 119.07 | 119.1 | 119.05 | 119.07 | 5000.0 |
| 2005-02-03 17:30:00 | SPY | ETF | 119.09 | 119.1 | 119.06 | 119.06 | 3700.0 |
| 2005-02-03 18:00:00 | SPY | ETF | 119.06 | 119.11 | 119.05 | 119.11 | 1000.0 |
| 2005-02-03 09:30:00 | QQQ | ETF | 37.39 | 37.42 | 37.29 | 37.4 | 12051800.0 |
| 2005-02-03 10:00:00 | QQQ | ETF | 37.41 | 37.41 | 37.21 | 37.21 | 10768000.0 |
| 2005-02-03 10:30:00 | QQQ | ETF | 37.21 | 37.25 | 37.11 | 37.12 | 9737900.0 |
| 2005-02-03 11:00:00 | QQQ | ETF | 37.11 | 37.13 | 37.02 | 37.06 | 9310400.0 |
| 2005-02-03 11:30:00 | QQQ | ETF | 37.06 | 37.12 | 37.02 | 37.05 | 6816200.0 |
| 2005-02-03 12:00:00 | QQQ | ETF | 37.06 | 37.1 | 37.05 | 37.1 | 3207500.0 |
| 2005-02-03 12:30:00 | QQQ | ETF | 37.1 | 37.1 | 37.0 | 37.05 | 4629300.0 |
| 2005-02-03 13:00:00 | QQQ | ETF | 37.06 | 37.08 | 37.03 | 37.08 | 1985800.0 |
| 2005-02-03 13:30:00 | QQQ | ETF | 37.08 | 37.17 | 37.08 | 37.16 | 5301700.0 |
| 2005-02-03 14:00:00 | QQQ | ETF | 37.15 | 37.21 | 37.12 | 37.12 | 4376400.0 |
| 2005-02-03 14:30:00 | QQQ | ETF | 37.12 | 37.15 | 37.07 | 37.11 | 3641900.0 |
| 2005-02-03 15:00:00 | QQQ | ETF | 37.12 | 37.15 | 37.05 | 37.14 | 6615500.0 |
| 2005-02-03 15:30:00 | QQQ | ETF | 37.15 | 37.23 | 37.15 | 37.17 | 7198400.0 |
| 2005-02-03 08:00:00 | IWM | ETF | 62.83 | 62.86 | 62.81 | 62.81 | 4400.0 |
| 2005-02-03 09:00:00 | IWM | ETF | 62.71 | 62.76 | 62.71 | 62.76 | 2600.0 |
| 2005-02-03 09:30:00 | IWM | ETF | 62.78 | 62.85 | 62.53 | 62.71 | 2910200.0 |
| 2005-02-03 10:00:00 | IWM | ETF | 62.71 | 62.715 | 62.44 | 62.495 | 1931000.0 |
| 2005-02-03 10:30:00 | IWM | ETF | 62.49 | 62.545 | 62.38 | 62.395 | 1578000.0 |
| 2005-02-03 11:00:00 | IWM | ETF | 62.39 | 62.4 | 62.25 | 62.3447 | 1302000.0 |
| 2005-02-03 11:30:00 | IWM | ETF | 62.335 | 62.45 | 62.325 | 62.405 | 815800.0 |
| 2005-02-03 12:00:00 | IWM | ETF | 62.41 | 62.445 | 62.34 | 62.435 | 432400.0 |
| 2005-02-03 12:30:00 | IWM | ETF | 62.43 | 62.475 | 62.125 | 62.271 | 1246800.0 |
| 2005-02-03 13:00:00 | IWM | ETF | 62.275 | 62.39 | 62.27 | 62.355 | 365600.0 |
| 2005-02-03 13:30:00 | IWM | ETF | 62.36 | 62.54 | 62.355 | 62.535 | 602400.0 |
| 2005-02-03 14:00:00 | IWM | ETF | 62.535 | 62.65 | 62.495 | 62.495 | 918600.0 |
| 2005-02-03 14:30:00 | IWM | ETF | 62.49 | 62.57 | 62.44 | 62.525 | 556800.0 |
| 2005-02-03 15:00:00 | IWM | ETF | 62.52 | 62.62 | 62.4 | 62.565 | 607000.0 |
| 2005-02-03 15:30:00 | IWM | ETF | 62.575 | 62.69 | 62.465 | 62.68 | 1204800.0 |
| 2005-02-03 16:00:00 | IWM | ETF | 62.69 | 62.725 | 62.55 | 62.575 | 274600.0 |
> showing 50 of 1,423 rows — these rows as CSV