PREVIEW / stock_30min / 2008-03-26
file: by_date/stock_30min/2008/2008-03-26.parquet size: 1.2 MB rows: 68,599 symbols: 3,289
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-26 05:00:00 | AAPL | Stock | 5.02 | 5.02 | 5.02 | 5.02 | 2800.0 |
| 2008-03-26 05:30:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0357 | 5.0357 | 2800.0 |
| 2008-03-26 06:30:00 | AAPL | Stock | 5.0493 | 5.0493 | 5.0493 | 5.0493 | 2800.0 |
| 2008-03-26 07:00:00 | AAPL | Stock | 5.0407 | 5.0464 | 5.0114 | 5.0114 | 100800.0 |
| 2008-03-26 07:30:00 | AAPL | Stock | 5.0207 | 5.0211 | 5.0093 | 5.0146 | 112000.0 |
| 2008-03-26 08:00:00 | AAPL | Stock | 5.0146 | 5.035 | 5.005 | 5.0179 | 8567636.0 |
| 2008-03-26 08:30:00 | AAPL | Stock | 5.0136 | 5.0143 | 4.9993 | 5.0046 | 1576092.0 |
| 2008-03-26 09:00:00 | AAPL | Stock | 5.0011 | 5.035 | 5.0 | 5.0304 | 1656060.0 |
| 2008-03-26 09:30:00 | AAPL | Stock | 5.0307 | 5.1122 | 5.0229 | 5.0764 | 147924784.0 |
| 2008-03-26 10:00:00 | AAPL | Stock | 5.0757 | 5.1454 | 5.0646 | 5.1368 | 130019512.0 |
| 2008-03-26 10:30:00 | AAPL | Stock | 5.1364 | 5.1596 | 5.1036 | 5.1593 | 104825756.0 |
| 2008-03-26 11:00:00 | AAPL | Stock | 5.1582 | 5.17 | 5.1357 | 5.1671 | 79152080.0 |
| 2008-03-26 11:30:00 | AAPL | Stock | 5.1671 | 5.1836 | 5.1451 | 5.1618 | 75396636.0 |
| 2008-03-26 12:00:00 | AAPL | Stock | 5.1607 | 5.1689 | 5.1436 | 5.1614 | 49000448.0 |
| 2008-03-26 12:30:00 | AAPL | Stock | 5.1611 | 5.1864 | 5.1521 | 5.1839 | 60195072.0 |
| 2008-03-26 13:00:00 | AAPL | Stock | 5.1839 | 5.2043 | 5.1766 | 5.185 | 65067800.0 |
| 2008-03-26 13:30:00 | AAPL | Stock | 5.1854 | 5.1879 | 5.1457 | 5.1564 | 64911924.0 |
| 2008-03-26 14:00:00 | AAPL | Stock | 5.1561 | 5.1632 | 5.1261 | 5.16 | 76141520.0 |
| 2008-03-26 14:30:00 | AAPL | Stock | 5.1593 | 5.1961 | 5.1543 | 5.1946 | 65314228.0 |
| 2008-03-26 15:00:00 | AAPL | Stock | 5.195 | 5.205 | 5.1725 | 5.1843 | 86451344.0 |
| 2008-03-26 15:30:00 | AAPL | Stock | 5.1843 | 5.1879 | 5.1425 | 5.1843 | 111480768.0 |
| 2008-03-26 16:00:00 | AAPL | Stock | 5.1807 | 5.1854 | 5.035 | 5.1343 | 25799928.0 |
| 2008-03-26 16:30:00 | AAPL | Stock | 5.1357 | 5.1964 | 5.1275 | 5.1321 | 414064.0 |
| 2008-03-26 17:00:00 | AAPL | Stock | 5.1321 | 5.1807 | 5.1286 | 5.1289 | 11386732.0 |
| 2008-03-26 17:30:00 | AAPL | Stock | 5.1286 | 5.1318 | 5.1196 | 5.125 | 556752.0 |
| 2008-03-26 18:00:00 | AAPL | Stock | 5.125 | 5.1782 | 5.1186 | 5.1186 | 508228.0 |
| 2008-03-26 18:30:00 | AAPL | Stock | 5.1179 | 5.1214 | 5.1179 | 5.1189 | 111860.0 |
| 2008-03-26 19:00:00 | AAPL | Stock | 5.1182 | 5.1243 | 5.1182 | 5.1232 | 44100.0 |
| 2008-03-26 19:30:00 | AAPL | Stock | 5.1214 | 5.1321 | 5.1214 | 5.1321 | 126616.0 |
| 2008-03-26 07:30:00 | MSFT | Stock | 29.07 | 29.07 | 29.06 | 29.06 | 1700.0 |
| 2008-03-26 08:00:00 | MSFT | Stock | 29.04 | 29.14 | 28.99 | 29.04 | 684107.0 |
| 2008-03-26 08:30:00 | MSFT | Stock | 29.0 | 29.08 | 29.0 | 29.08 | 6834.0 |
| 2008-03-26 09:00:00 | MSFT | Stock | 29.1 | 29.15 | 29.03 | 29.03 | 42954.0 |
| 2008-03-26 09:30:00 | MSFT | Stock | 29.03 | 29.07 | 28.81 | 28.86 | 3188759.0 |
| 2008-03-26 10:00:00 | MSFT | Stock | 28.86 | 28.9 | 28.7 | 28.76 | 4967285.0 |
| 2008-03-26 10:30:00 | MSFT | Stock | 28.76 | 28.76 | 28.51 | 28.6 | 4503088.0 |
| 2008-03-26 11:00:00 | MSFT | Stock | 28.6 | 28.6 | 28.38 | 28.45 | 3922618.0 |
| 2008-03-26 11:30:00 | MSFT | Stock | 28.46 | 28.53 | 28.42 | 28.42 | 2574452.0 |
| 2008-03-26 12:00:00 | MSFT | Stock | 28.43 | 28.51 | 28.42 | 28.49 | 1628124.0 |
| 2008-03-26 12:30:00 | MSFT | Stock | 28.495 | 28.5 | 28.43 | 28.442 | 1407892.0 |
| 2008-03-26 13:00:00 | MSFT | Stock | 28.45 | 28.47 | 28.419 | 28.43 | 1743356.0 |
| 2008-03-26 13:30:00 | MSFT | Stock | 28.43 | 28.47 | 28.39 | 28.44 | 2519815.0 |
| 2008-03-26 14:00:00 | MSFT | Stock | 28.448 | 28.53 | 28.42 | 28.52 | 2648351.0 |
| 2008-03-26 14:30:00 | MSFT | Stock | 28.51 | 28.67 | 28.47 | 28.67 | 2293866.0 |
| 2008-03-26 15:00:00 | MSFT | Stock | 28.67 | 28.69 | 28.43 | 28.44 | 4280747.0 |
| 2008-03-26 15:30:00 | MSFT | Stock | 28.44 | 28.59 | 28.42 | 28.56 | 5385821.0 |
| 2008-03-26 16:00:00 | MSFT | Stock | 28.58 | 28.701 | 28.06 | 28.33 | 1939673.0 |
| 2008-03-26 16:30:00 | MSFT | Stock | 28.33 | 28.593 | 28.25 | 28.3 | 92740.0 |
| 2008-03-26 17:00:00 | MSFT | Stock | 28.29 | 28.57 | 28.29 | 28.57 | 88816.0 |
| 2008-03-26 17:30:00 | MSFT | Stock | 28.57 | 28.57 | 28.27 | 28.3 | 1011913.0 |
> showing 50 of 68,599 rows — these rows as CSV