PREVIEW / stock_30min / 2007-02-12
file: by_date/stock_30min/2007/2007-02-12.parquet size: 1.0 MB rows: 55,550 symbols: 2,527
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 07:00:00 | AAPL | Stock | 2.9804 | 3.0307 | 2.9804 | 3.0268 | 809760.0 |
| 2007-02-12 07:30:00 | AAPL | Stock | 3.0275 | 3.0275 | 3.0146 | 3.0161 | 866600.0 |
| 2007-02-12 08:00:00 | AAPL | Stock | 3.0179 | 3.025 | 3.0086 | 3.0182 | 3850476.0 |
| 2007-02-12 08:30:00 | AAPL | Stock | 3.0179 | 3.0239 | 3.0111 | 3.0136 | 2480688.0 |
| 2007-02-12 09:00:00 | AAPL | Stock | 3.0143 | 3.0179 | 3.0136 | 3.0168 | 2378124.0 |
| 2007-02-12 09:30:00 | AAPL | Stock | 3.0154 | 3.0189 | 2.9868 | 3.013 | 138877284.0 |
| 2007-02-12 10:00:00 | AAPL | Stock | 3.0135 | 3.0286 | 2.9929 | 3.0129 | 98774116.0 |
| 2007-02-12 10:30:00 | AAPL | Stock | 3.0129 | 3.0189 | 3.0071 | 3.0136 | 46685128.0 |
| 2007-02-12 11:00:00 | AAPL | Stock | 3.0136 | 3.0211 | 3.0121 | 3.0143 | 46064424.0 |
| 2007-02-12 11:30:00 | AAPL | Stock | 3.0143 | 3.0204 | 3.0093 | 3.0118 | 35982464.0 |
| 2007-02-12 12:00:00 | AAPL | Stock | 3.0118 | 3.0161 | 3.0114 | 3.0142 | 23280936.0 |
| 2007-02-12 12:30:00 | AAPL | Stock | 3.0143 | 3.03 | 3.0118 | 3.0254 | 42498680.0 |
| 2007-02-12 13:00:00 | AAPL | Stock | 3.0254 | 3.0336 | 3.0207 | 3.0329 | 35998648.0 |
| 2007-02-12 13:30:00 | AAPL | Stock | 3.0332 | 3.035 | 3.0189 | 3.0236 | 54215196.0 |
| 2007-02-12 14:00:00 | AAPL | Stock | 3.0232 | 3.0329 | 3.0179 | 3.0179 | 23260412.0 |
| 2007-02-12 14:30:00 | AAPL | Stock | 3.0179 | 3.0336 | 3.0161 | 3.0332 | 41269424.0 |
| 2007-02-12 15:00:00 | AAPL | Stock | 3.0321 | 3.0421 | 3.0271 | 3.0321 | 66973872.0 |
| 2007-02-12 15:30:00 | AAPL | Stock | 3.0321 | 3.0379 | 3.0282 | 3.0333 | 51485644.0 |
| 2007-02-12 16:00:00 | AAPL | Stock | 3.0339 | 3.0411 | 3.0314 | 3.0375 | 1722252.0 |
| 2007-02-12 16:30:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 50820.0 |
| 2007-02-12 17:00:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0339 | 3.0354 | 151256.0 |
| 2007-02-12 17:30:00 | AAPL | Stock | 3.0354 | 3.0354 | 3.0354 | 3.0354 | 28000.0 |
| 2007-02-12 18:00:00 | AAPL | Stock | 3.0354 | 3.0354 | 3.0329 | 3.0354 | 129752.0 |
| 2007-02-12 18:30:00 | AAPL | Stock | 3.035 | 3.0354 | 3.035 | 3.035 | 85400.0 |
| 2007-02-12 19:00:00 | AAPL | Stock | 3.0354 | 3.0354 | 3.0339 | 3.035 | 44800.0 |
| 2007-02-12 19:30:00 | AAPL | Stock | 3.0339 | 3.0354 | 3.0332 | 3.0354 | 119140.0 |
| 2007-02-12 07:00:00 | MSFT | Stock | 28.89 | 28.94 | 28.89 | 28.94 | 4760.0 |
| 2007-02-12 07:30:00 | MSFT | Stock | 28.92 | 28.92 | 28.92 | 28.92 | 100.0 |
| 2007-02-12 08:00:00 | MSFT | Stock | 28.9 | 28.97 | 28.86 | 28.91 | 10475.0 |
| 2007-02-12 08:30:00 | MSFT | Stock | 28.91 | 28.97 | 28.9 | 28.9 | 15298.0 |
| 2007-02-12 09:00:00 | MSFT | Stock | 28.91 | 28.95 | 28.85 | 28.9 | 132888.0 |
| 2007-02-12 09:30:00 | MSFT | Stock | 28.89 | 28.94 | 28.83 | 28.92 | 7623480.0 |
| 2007-02-12 10:00:00 | MSFT | Stock | 28.92 | 29.04 | 28.84 | 29.03 | 6889926.0 |
| 2007-02-12 10:30:00 | MSFT | Stock | 29.03 | 29.09 | 28.94 | 28.96 | 5726629.0 |
| 2007-02-12 11:00:00 | MSFT | Stock | 28.96 | 29.0 | 28.92 | 28.92 | 2666914.0 |
| 2007-02-12 11:30:00 | MSFT | Stock | 28.93 | 28.96 | 28.92 | 28.93 | 1828074.0 |
| 2007-02-12 12:00:00 | MSFT | Stock | 28.94 | 28.96 | 28.92 | 28.92 | 1615834.0 |
| 2007-02-12 12:30:00 | MSFT | Stock | 28.92 | 29.0 | 28.92 | 29.0 | 1902258.0 |
| 2007-02-12 13:00:00 | MSFT | Stock | 29.0 | 29.0 | 28.94 | 28.95 | 1161878.0 |
| 2007-02-12 13:30:00 | MSFT | Stock | 28.94 | 28.98 | 28.89 | 28.9 | 2750249.0 |
| 2007-02-12 14:00:00 | MSFT | Stock | 28.9 | 28.95 | 28.87 | 28.87 | 2369468.0 |
| 2007-02-12 14:30:00 | MSFT | Stock | 28.87 | 28.95 | 28.86 | 28.91 | 3512383.0 |
| 2007-02-12 15:00:00 | MSFT | Stock | 28.9 | 28.93 | 28.88 | 28.921 | 3854934.0 |
| 2007-02-12 15:30:00 | MSFT | Stock | 28.92 | 28.96 | 28.91 | 28.94 | 4128039.0 |
| 2007-02-12 16:00:00 | MSFT | Stock | 28.95 | 28.99 | 28.92 | 28.94 | 1964834.0 |
| 2007-02-12 16:30:00 | MSFT | Stock | 28.94 | 28.96 | 28.94 | 28.96 | 7383.0 |
| 2007-02-12 17:00:00 | MSFT | Stock | 28.94 | 28.95 | 28.93 | 28.94 | 1137200.0 |
| 2007-02-12 17:30:00 | MSFT | Stock | 28.94 | 28.94 | 28.94 | 28.94 | 2000.0 |
| 2007-02-12 18:00:00 | MSFT | Stock | 28.93 | 28.93 | 28.93 | 28.93 | 4284.0 |
| 2007-02-12 18:30:00 | MSFT | Stock | 28.95 | 28.97 | 28.95 | 28.97 | 17219.0 |
> showing 50 of 55,550 rows — these rows as CSV