PREVIEW / etf_30min / 2007-02-14
file: by_date/etf_30min/2007/2007-02-14.parquet size: 102 KB rows: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-14 06:30:00 | SPY | ETF | 144.71 | 144.71 | 144.71 | 144.71 | 5000.0 |
| 2007-02-14 07:00:00 | SPY | ETF | 144.75 | 144.79 | 144.73 | 144.77 | 20300.0 |
| 2007-02-14 07:30:00 | SPY | ETF | 144.8 | 144.84 | 144.8 | 144.8 | 130040.0 |
| 2007-02-14 08:00:00 | SPY | ETF | 144.8 | 144.9 | 144.8 | 144.87 | 375400.0 |
| 2007-02-14 08:30:00 | SPY | ETF | 144.82 | 144.9 | 144.81 | 144.88 | 303824.0 |
| 2007-02-14 09:00:00 | SPY | ETF | 144.87 | 144.88 | 144.77 | 144.81 | 321677.0 |
| 2007-02-14 09:30:00 | SPY | ETF | 144.8 | 144.91 | 144.78 | 144.88 | 5520562.0 |
| 2007-02-14 10:00:00 | SPY | ETF | 144.89 | 145.76 | 144.84 | 145.48 | 17888384.0 |
| 2007-02-14 10:30:00 | SPY | ETF | 145.48 | 145.53 | 145.41 | 145.48 | 4968608.0 |
| 2007-02-14 11:00:00 | SPY | ETF | 145.49 | 145.72 | 145.45 | 145.58 | 5272976.0 |
| 2007-02-14 11:30:00 | SPY | ETF | 145.59 | 145.66 | 145.54 | 145.55 | 3357048.0 |
| 2007-02-14 12:00:00 | SPY | ETF | 145.55 | 145.59 | 145.41 | 145.46 | 2097566.0 |
| 2007-02-14 12:30:00 | SPY | ETF | 145.46 | 145.57 | 145.43 | 145.55 | 1661050.0 |
| 2007-02-14 13:00:00 | SPY | ETF | 145.55 | 145.64 | 145.51 | 145.56 | 1678918.0 |
| 2007-02-14 13:30:00 | SPY | ETF | 145.56 | 145.81 | 145.56 | 145.72 | 3529046.0 |
| 2007-02-14 14:00:00 | SPY | ETF | 145.73 | 145.87 | 145.71 | 145.74 | 3231567.0 |
| 2007-02-14 14:30:00 | SPY | ETF | 145.735 | 145.84 | 145.73 | 145.82 | 2300968.0 |
| 2007-02-14 15:00:00 | SPY | ETF | 145.83 | 145.9 | 145.73 | 145.77 | 2682991.0 |
| 2007-02-14 15:30:00 | SPY | ETF | 145.7775 | 145.8 | 145.5 | 145.64 | 7945383.0 |
| 2007-02-14 16:00:00 | SPY | ETF | 145.64 | 145.72 | 145.61 | 145.66 | 990724.0 |
| 2007-02-14 16:30:00 | SPY | ETF | 145.66 | 145.66 | 145.56 | 145.56 | 142286.0 |
| 2007-02-14 17:00:00 | SPY | ETF | 145.6 | 145.6 | 145.59 | 145.6 | 32500.0 |
| 2007-02-14 18:00:00 | SPY | ETF | 145.64 | 145.66 | 145.61 | 145.61 | 3000.0 |
| 2007-02-14 18:30:00 | SPY | ETF | 145.61 | 145.61 | 145.6 | 145.6 | 20000.0 |
| 2007-02-14 06:30:00 | QQQ | ETF | 44.0 | 44.0 | 44.0 | 44.0 | 100.0 |
| 2007-02-14 07:00:00 | QQQ | ETF | 44.03 | 44.03 | 44.01 | 44.02 | 22600.0 |
| 2007-02-14 07:30:00 | QQQ | ETF | 44.01 | 44.04 | 44.01 | 44.02 | 139180.0 |
| 2007-02-14 08:00:00 | QQQ | ETF | 44.02 | 44.08 | 44.01 | 44.06 | 711563.0 |
| 2007-02-14 08:30:00 | QQQ | ETF | 44.05 | 44.06 | 44.03 | 44.04 | 363652.0 |
| 2007-02-14 09:00:00 | QQQ | ETF | 44.04 | 44.06 | 44.02 | 44.05 | 511327.0 |
| 2007-02-14 09:30:00 | QQQ | ETF | 44.05 | 44.14 | 44.04 | 44.13 | 10969000.0 |
| 2007-02-14 10:00:00 | QQQ | ETF | 44.12 | 44.5 | 44.1 | 44.45 | 34667200.0 |
| 2007-02-14 10:30:00 | QQQ | ETF | 44.46 | 44.47 | 44.37 | 44.44 | 9282000.0 |
| 2007-02-14 11:00:00 | QQQ | ETF | 44.43 | 44.62 | 44.41 | 44.55 | 16155100.0 |
| 2007-02-14 11:30:00 | QQQ | ETF | 44.54 | 44.58 | 44.5 | 44.52 | 7108400.0 |
| 2007-02-14 12:00:00 | QQQ | ETF | 44.53 | 44.55 | 44.48 | 44.49 | 3793600.0 |
| 2007-02-14 12:30:00 | QQQ | ETF | 44.49 | 44.57 | 44.48 | 44.55 | 2990700.0 |
| 2007-02-14 13:00:00 | QQQ | ETF | 44.56 | 44.6 | 44.53 | 44.53 | 2751800.0 |
| 2007-02-14 13:30:00 | QQQ | ETF | 44.54 | 44.71 | 44.53 | 44.66 | 8690700.0 |
| 2007-02-14 14:00:00 | QQQ | ETF | 44.67 | 44.7 | 44.6 | 44.62 | 6747300.0 |
| 2007-02-14 14:30:00 | QQQ | ETF | 44.62 | 44.65 | 44.55 | 44.62 | 5402300.0 |
| 2007-02-14 15:00:00 | QQQ | ETF | 44.61 | 44.65 | 44.57 | 44.6 | 6315700.0 |
| 2007-02-14 15:30:00 | QQQ | ETF | 44.6 | 44.6 | 44.54 | 44.57 | 10164300.0 |
| 2007-02-14 16:00:00 | QQQ | ETF | 44.59 | 44.66 | 44.57 | 44.63 | 2431875.0 |
| 2007-02-14 16:30:00 | QQQ | ETF | 44.63 | 44.64 | 44.6 | 44.63 | 490872.0 |
| 2007-02-14 17:00:00 | QQQ | ETF | 44.63 | 44.67 | 44.61 | 44.66 | 224804.0 |
| 2007-02-14 17:30:00 | QQQ | ETF | 44.66 | 44.7 | 44.64 | 44.67 | 31246.0 |
| 2007-02-14 18:00:00 | QQQ | ETF | 44.68 | 44.69 | 44.67 | 44.68 | 23122.0 |
| 2007-02-14 18:30:00 | QQQ | ETF | 44.68 | 44.68 | 44.65 | 44.65 | 30400.0 |
| 2007-02-14 19:00:00 | QQQ | ETF | 44.66 | 44.66 | 44.64 | 44.66 | 50349.0 |
> showing 50 of 3,544 rows — these rows as CSV