PREVIEW / stock_30min / 2008-03-27
file: by_date/stock_30min/2008/2008-03-27.parquet size: 1.2 MB rows: 67,495 symbols: 3,275
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-27 06:00:00 | AAPL | Stock | 5.1775 | 5.1786 | 5.1639 | 5.1639 | 23576.0 |
| 2008-03-27 06:30:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1375 | 5.1489 | 140000.0 |
| 2008-03-27 07:00:00 | AAPL | Stock | 5.1489 | 5.1714 | 5.1482 | 5.1646 | 302120.0 |
| 2008-03-27 07:30:00 | AAPL | Stock | 5.1643 | 5.1643 | 5.15 | 5.1507 | 312956.0 |
| 2008-03-27 08:00:00 | AAPL | Stock | 5.15 | 5.15 | 5.125 | 5.1371 | 946400.0 |
| 2008-03-27 08:30:00 | AAPL | Stock | 5.1407 | 5.1786 | 5.1407 | 5.1732 | 2648660.0 |
| 2008-03-27 09:00:00 | AAPL | Stock | 5.1736 | 5.1779 | 5.1429 | 5.1779 | 3791900.0 |
| 2008-03-27 09:30:00 | AAPL | Stock | 5.1768 | 5.1896 | 5.125 | 5.1736 | 125680184.0 |
| 2008-03-27 10:00:00 | AAPL | Stock | 5.1736 | 5.1875 | 5.1346 | 5.1368 | 92028776.0 |
| 2008-03-27 10:30:00 | AAPL | Stock | 5.1368 | 5.1461 | 5.0943 | 5.1189 | 98866460.0 |
| 2008-03-27 11:00:00 | AAPL | Stock | 5.1186 | 5.1318 | 5.0921 | 5.11 | 56247744.0 |
| 2008-03-27 11:30:00 | AAPL | Stock | 5.1111 | 5.1496 | 5.1039 | 5.1368 | 60220216.0 |
| 2008-03-27 12:00:00 | AAPL | Stock | 5.1368 | 5.1493 | 5.1182 | 5.1332 | 48501460.0 |
| 2008-03-27 12:30:00 | AAPL | Stock | 5.1314 | 5.1397 | 5.0896 | 5.0929 | 55888308.0 |
| 2008-03-27 13:00:00 | AAPL | Stock | 5.0936 | 5.11 | 5.0764 | 5.0786 | 47940676.0 |
| 2008-03-27 13:30:00 | AAPL | Stock | 5.0789 | 5.0811 | 5.0407 | 5.0639 | 81905124.0 |
| 2008-03-27 14:00:00 | AAPL | Stock | 5.0639 | 5.0818 | 5.0482 | 5.0603 | 62927760.0 |
| 2008-03-27 14:30:00 | AAPL | Stock | 5.06 | 5.0814 | 5.0504 | 5.0618 | 62095460.0 |
| 2008-03-27 15:00:00 | AAPL | Stock | 5.0629 | 5.0682 | 5.0218 | 5.0349 | 72464224.0 |
| 2008-03-27 15:30:00 | AAPL | Stock | 5.0339 | 5.0396 | 4.9996 | 5.0104 | 102288060.0 |
| 2008-03-27 16:00:00 | AAPL | Stock | 5.0086 | 5.0987 | 5.0086 | 5.0179 | 9898588.0 |
| 2008-03-27 16:30:00 | AAPL | Stock | 5.0179 | 5.081 | 5.0089 | 5.0114 | 365232.0 |
| 2008-03-27 17:00:00 | AAPL | Stock | 5.0168 | 5.0264 | 5.0107 | 5.0264 | 923104.0 |
| 2008-03-27 17:30:00 | AAPL | Stock | 5.0214 | 5.0321 | 5.0196 | 5.0304 | 520716.0 |
| 2008-03-27 18:00:00 | AAPL | Stock | 5.0304 | 5.0304 | 5.0214 | 5.0214 | 125048.0 |
| 2008-03-27 18:30:00 | AAPL | Stock | 5.0246 | 5.0264 | 5.0089 | 5.0264 | 2142924.0 |
| 2008-03-27 19:00:00 | AAPL | Stock | 5.0268 | 5.0268 | 5.0264 | 5.0264 | 39676.0 |
| 2008-03-27 19:30:00 | AAPL | Stock | 5.0264 | 5.0264 | 5.0214 | 5.0243 | 72800.0 |
| 2008-03-27 07:00:00 | MSFT | Stock | 28.46 | 28.46 | 28.32 | 28.32 | 1900.0 |
| 2008-03-27 08:00:00 | MSFT | Stock | 28.41 | 28.45 | 28.33 | 28.37 | 5705.0 |
| 2008-03-27 08:30:00 | MSFT | Stock | 28.41 | 28.5 | 28.41 | 28.45 | 25715.0 |
| 2008-03-27 09:00:00 | MSFT | Stock | 28.5 | 28.5 | 28.45 | 28.48 | 22625.0 |
| 2008-03-27 09:30:00 | MSFT | Stock | 28.49 | 28.49 | 28.2 | 28.26 | 3901886.0 |
| 2008-03-27 10:00:00 | MSFT | Stock | 28.26 | 28.273 | 28.02 | 28.049 | 4526638.0 |
| 2008-03-27 10:30:00 | MSFT | Stock | 28.049 | 28.16 | 28.0 | 28.148 | 4735038.0 |
| 2008-03-27 11:00:00 | MSFT | Stock | 28.14 | 28.18 | 28.04 | 28.1 | 2596705.0 |
| 2008-03-27 11:30:00 | MSFT | Stock | 28.1 | 28.26 | 28.06 | 28.22 | 1994079.0 |
| 2008-03-27 12:00:00 | MSFT | Stock | 28.22 | 28.27 | 28.18 | 28.27 | 1908929.0 |
| 2008-03-27 12:30:00 | MSFT | Stock | 28.27 | 28.35 | 28.25 | 28.29 | 1729371.0 |
| 2008-03-27 13:00:00 | MSFT | Stock | 28.29 | 28.3 | 28.2 | 28.27 | 1774880.0 |
| 2008-03-27 13:30:00 | MSFT | Stock | 28.28 | 28.29 | 28.12 | 28.2 | 2087383.0 |
| 2008-03-27 14:00:00 | MSFT | Stock | 28.19 | 28.19 | 28.1 | 28.17 | 1877520.0 |
| 2008-03-27 14:30:00 | MSFT | Stock | 28.172 | 28.28 | 28.17 | 28.19 | 2418304.0 |
| 2008-03-27 15:00:00 | MSFT | Stock | 28.2 | 28.27 | 28.12 | 28.16 | 3139723.0 |
| 2008-03-27 15:30:00 | MSFT | Stock | 28.16 | 28.19 | 28.02 | 28.05 | 5562871.0 |
| 2008-03-27 16:00:00 | MSFT | Stock | 28.05 | 28.57 | 28.04 | 28.05 | 7556989.0 |
| 2008-03-27 16:30:00 | MSFT | Stock | 28.151 | 28.224 | 28.05 | 28.12 | 5738.0 |
| 2008-03-27 17:00:00 | MSFT | Stock | 28.12 | 28.12 | 28.11 | 28.12 | 2581.0 |
| 2008-03-27 17:30:00 | MSFT | Stock | 28.12 | 28.12 | 28.1 | 28.1 | 3569.0 |
| 2008-03-27 18:00:00 | MSFT | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 1398.0 |
> showing 50 of 67,495 rows — these rows as CSV