PREVIEW / etf_30min / 2007-02-12
file: by_date/etf_30min/2007/2007-02-12.parquet size: 103 KB rows: 3,603
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-12 05:00:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 5900.0 |
| 2007-02-12 07:00:00 | SPY | ETF | 143.9 | 143.91 | 143.9 | 143.91 | 300.0 |
| 2007-02-12 07:30:00 | SPY | ETF | 143.9 | 144.06 | 143.9 | 144.01 | 227296.0 |
| 2007-02-12 08:00:00 | SPY | ETF | 143.99 | 144.11 | 143.98 | 144.03 | 131388.0 |
| 2007-02-12 08:30:00 | SPY | ETF | 144.03 | 144.03 | 143.9 | 143.92 | 1003413.0 |
| 2007-02-12 09:00:00 | SPY | ETF | 143.93 | 143.96 | 143.86 | 143.91 | 392403.0 |
| 2007-02-12 09:30:00 | SPY | ETF | 143.94 | 144.04 | 143.64 | 143.65 | 6173017.0 |
| 2007-02-12 10:00:00 | SPY | ETF | 143.65 | 143.74 | 143.5 | 143.71 | 5036474.0 |
| 2007-02-12 10:30:00 | SPY | ETF | 143.64 | 144.01 | 143.55 | 143.61 | 2048027.0 |
| 2007-02-12 11:00:00 | SPY | ETF | 143.6 | 143.72 | 143.47 | 143.5 | 3895398.0 |
| 2007-02-12 11:30:00 | SPY | ETF | 143.49 | 143.7 | 143.45 | 143.62 | 4281833.0 |
| 2007-02-12 12:00:00 | SPY | ETF | 143.62 | 143.67 | 143.56 | 143.62 | 1526331.0 |
| 2007-02-12 12:30:00 | SPY | ETF | 143.62 | 143.76 | 143.61 | 143.64 | 2067626.0 |
| 2007-02-12 13:00:00 | SPY | ETF | 143.63 | 143.67 | 143.5 | 143.6302 | 2665788.0 |
| 2007-02-12 13:30:00 | SPY | ETF | 143.63 | 143.68 | 143.26 | 143.34 | 7406987.0 |
| 2007-02-12 14:00:00 | SPY | ETF | 143.34 | 143.72 | 143.25 | 143.25 | 3889221.0 |
| 2007-02-12 14:30:00 | SPY | ETF | 143.26 | 143.77 | 143.19 | 143.38 | 6053267.0 |
| 2007-02-12 15:00:00 | SPY | ETF | 143.38 | 143.69 | 143.31 | 143.41 | 3257181.0 |
| 2007-02-12 15:30:00 | SPY | ETF | 143.41 | 143.58 | 143.33 | 143.42 | 3171673.0 |
| 2007-02-12 16:00:00 | SPY | ETF | 143.43 | 143.73 | 143.4 | 143.68 | 1104610.0 |
| 2007-02-12 16:30:00 | SPY | ETF | 143.68 | 143.73 | 143.47 | 143.64 | 1035487.0 |
| 2007-02-12 17:00:00 | SPY | ETF | 143.63 | 143.72 | 143.33 | 143.46 | 6303778.0 |
| 2007-02-12 17:30:00 | SPY | ETF | 143.46 | 143.47 | 143.41 | 143.44 | 2219262.0 |
| 2007-02-12 19:00:00 | SPY | ETF | 143.5 | 143.5 | 143.5 | 143.5 | 100.0 |
| 2007-02-12 19:30:00 | SPY | ETF | 143.5 | 143.5 | 143.48 | 143.5 | 6050.0 |
| 2007-02-12 04:30:00 | QQQ | ETF | 43.87 | 43.87 | 43.87 | 43.87 | 300.0 |
| 2007-02-12 07:00:00 | QQQ | ETF | 43.81 | 43.84 | 43.8 | 43.84 | 56300.0 |
| 2007-02-12 07:30:00 | QQQ | ETF | 43.85 | 43.89 | 43.82 | 43.87 | 84586.0 |
| 2007-02-12 08:00:00 | QQQ | ETF | 43.86 | 43.92 | 43.85 | 43.89 | 581516.0 |
| 2007-02-12 08:30:00 | QQQ | ETF | 43.88 | 43.89 | 43.86 | 43.86 | 171574.0 |
| 2007-02-12 09:00:00 | QQQ | ETF | 43.86 | 43.89 | 43.86 | 43.87 | 420203.0 |
| 2007-02-12 09:30:00 | QQQ | ETF | 43.88 | 43.89 | 43.67 | 43.71 | 32140100.0 |
| 2007-02-12 10:00:00 | QQQ | ETF | 43.72 | 43.79 | 43.63 | 43.74 | 17163500.0 |
| 2007-02-12 10:30:00 | QQQ | ETF | 43.74 | 43.79 | 43.68 | 43.72 | 9343100.0 |
| 2007-02-12 11:00:00 | QQQ | ETF | 43.72 | 43.81 | 43.65 | 43.68 | 9291900.0 |
| 2007-02-12 11:30:00 | QQQ | ETF | 43.68 | 43.75 | 43.65 | 43.71 | 5254400.0 |
| 2007-02-12 12:00:00 | QQQ | ETF | 43.7 | 43.74 | 43.69 | 43.71 | 3141900.0 |
| 2007-02-12 12:30:00 | QQQ | ETF | 43.71 | 43.81 | 43.7 | 43.75 | 4097100.0 |
| 2007-02-12 13:00:00 | QQQ | ETF | 43.75 | 43.76 | 43.68 | 43.74 | 4127500.0 |
| 2007-02-12 13:30:00 | QQQ | ETF | 43.74 | 43.75 | 43.61 | 43.66 | 6928300.0 |
| 2007-02-12 14:00:00 | QQQ | ETF | 43.65 | 43.72 | 43.63 | 43.63 | 5711200.0 |
| 2007-02-12 14:30:00 | QQQ | ETF | 43.64 | 43.72 | 43.59 | 43.69 | 8007700.0 |
| 2007-02-12 15:00:00 | QQQ | ETF | 43.68 | 43.76 | 43.65 | 43.7 | 5786900.0 |
| 2007-02-12 15:30:00 | QQQ | ETF | 43.71 | 43.77 | 43.67 | 43.71 | 10935800.0 |
| 2007-02-12 16:00:00 | QQQ | ETF | 43.71 | 43.71 | 43.67 | 43.69 | 1530299.0 |
| 2007-02-12 16:30:00 | QQQ | ETF | 43.69 | 43.71 | 43.69 | 43.69 | 83826.0 |
| 2007-02-12 17:00:00 | QQQ | ETF | 43.7 | 43.7 | 43.69 | 43.69 | 12836.0 |
| 2007-02-12 17:30:00 | QQQ | ETF | 43.7 | 43.7 | 43.68 | 43.69 | 21300.0 |
| 2007-02-12 18:00:00 | QQQ | ETF | 43.69 | 43.7 | 43.69 | 43.7 | 3330.0 |
| 2007-02-12 18:30:00 | QQQ | ETF | 43.7 | 43.71 | 43.69 | 43.71 | 3300.0 |
> showing 50 of 3,603 rows — these rows as CSV