PREVIEW / stock_30min / 2011-09-27
file: by_date/stock_30min/2011/2011-09-27.parquet size: 1.4 MB rows: 76,470 symbols: 3,548
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-27 04:00:00 | AAPL | Stock | 14.4854 | 14.5004 | 14.4854 | 14.5004 | 33600.0 |
| 2011-09-27 04:30:00 | AAPL | Stock | 14.53 | 14.5357 | 14.53 | 14.5357 | 47600.0 |
| 2011-09-27 05:30:00 | AAPL | Stock | 14.5179 | 14.535 | 14.5107 | 14.5107 | 28252.0 |
| 2011-09-27 06:00:00 | AAPL | Stock | 14.5179 | 14.5536 | 14.5179 | 14.5482 | 21000.0 |
| 2011-09-27 06:30:00 | AAPL | Stock | 14.5368 | 14.5589 | 14.5357 | 14.5357 | 105588.0 |
| 2011-09-27 07:00:00 | AAPL | Stock | 14.5357 | 14.6068 | 14.5357 | 14.5825 | 354816.0 |
| 2011-09-27 07:30:00 | AAPL | Stock | 14.5893 | 14.6286 | 14.5743 | 14.6193 | 660604.0 |
| 2011-09-27 08:00:00 | AAPL | Stock | 14.6079 | 14.625 | 14.5893 | 14.605 | 3002496.0 |
| 2011-09-27 08:30:00 | AAPL | Stock | 14.6 | 14.6089 | 14.5889 | 14.5982 | 1741236.0 |
| 2011-09-27 09:00:00 | AAPL | Stock | 14.5986 | 14.6214 | 14.5786 | 14.5979 | 4858560.0 |
| 2011-09-27 09:30:00 | AAPL | Stock | 14.6036 | 14.6161 | 14.4821 | 14.5411 | 101132500.0 |
| 2011-09-27 10:00:00 | AAPL | Stock | 14.5411 | 14.5668 | 14.4321 | 14.4903 | 62011572.0 |
| 2011-09-27 10:30:00 | AAPL | Stock | 14.4896 | 14.5661 | 14.4643 | 14.565 | 37825088.0 |
| 2011-09-27 11:00:00 | AAPL | Stock | 14.5621 | 14.5657 | 14.5107 | 14.5197 | 40114228.0 |
| 2011-09-27 11:30:00 | AAPL | Stock | 14.5246 | 14.5318 | 14.4554 | 14.4825 | 26294240.0 |
| 2011-09-27 12:00:00 | AAPL | Stock | 14.4875 | 14.5157 | 14.4464 | 14.4557 | 23827720.0 |
| 2011-09-27 12:30:00 | AAPL | Stock | 14.4543 | 14.4573 | 14.3139 | 14.4057 | 58027788.0 |
| 2011-09-27 13:00:00 | AAPL | Stock | 14.4071 | 14.5089 | 14.3771 | 14.5057 | 36770608.0 |
| 2011-09-27 13:30:00 | AAPL | Stock | 14.5054 | 14.5339 | 14.4518 | 14.5146 | 26917968.0 |
| 2011-09-27 14:00:00 | AAPL | Stock | 14.5143 | 14.525 | 14.4729 | 14.4736 | 23417604.0 |
| 2011-09-27 14:30:00 | AAPL | Stock | 14.4752 | 14.5107 | 14.3968 | 14.4157 | 36225084.0 |
| 2011-09-27 15:00:00 | AAPL | Stock | 14.4157 | 14.4561 | 14.3 | 14.3371 | 54401312.0 |
| 2011-09-27 15:30:00 | AAPL | Stock | 14.3371 | 14.3679 | 14.2164 | 14.2593 | 80832920.0 |
| 2011-09-27 16:00:00 | AAPL | Stock | 14.2764 | 14.4512 | 14.25 | 14.2946 | 9596160.0 |
| 2011-09-27 16:30:00 | AAPL | Stock | 14.2929 | 14.3214 | 14.2871 | 14.3143 | 346164.0 |
| 2011-09-27 17:00:00 | AAPL | Stock | 14.3193 | 14.3193 | 14.2954 | 14.2982 | 269136.0 |
| 2011-09-27 17:30:00 | AAPL | Stock | 14.3007 | 14.3011 | 14.2836 | 14.2861 | 348180.0 |
| 2011-09-27 18:00:00 | AAPL | Stock | 14.2911 | 14.2946 | 14.2593 | 14.2768 | 387072.0 |
| 2011-09-27 18:30:00 | AAPL | Stock | 14.2768 | 14.2768 | 14.2614 | 14.2614 | 295400.0 |
| 2011-09-27 19:00:00 | AAPL | Stock | 14.2625 | 14.2664 | 14.2529 | 14.255 | 206220.0 |
| 2011-09-27 19:30:00 | AAPL | Stock | 14.255 | 14.2618 | 14.2525 | 14.2618 | 216580.0 |
| 2011-09-27 06:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.62 | 25.62 | 950.0 |
| 2011-09-27 07:00:00 | MSFT | Stock | 25.63 | 25.76 | 25.57 | 25.7 | 11173.0 |
| 2011-09-27 07:30:00 | MSFT | Stock | 25.7 | 25.89 | 25.64 | 25.8 | 18025.0 |
| 2011-09-27 08:00:00 | MSFT | Stock | 25.79 | 25.85 | 25.73 | 25.84 | 23350.0 |
| 2011-09-27 08:30:00 | MSFT | Stock | 25.84 | 25.84 | 25.75 | 25.75 | 15055.0 |
| 2011-09-27 09:00:00 | MSFT | Stock | 25.75 | 25.8 | 25.56 | 25.69 | 80034.0 |
| 2011-09-27 09:30:00 | MSFT | Stock | 25.67 | 25.81 | 25.5 | 25.74 | 6261581.0 |
| 2011-09-27 10:00:00 | MSFT | Stock | 25.73 | 25.82 | 25.53 | 25.59 | 5844103.0 |
| 2011-09-27 10:30:00 | MSFT | Stock | 25.59 | 25.62 | 25.45 | 25.55 | 4265448.0 |
| 2011-09-27 11:00:00 | MSFT | Stock | 25.56 | 25.68 | 25.53 | 25.61 | 3647951.0 |
| 2011-09-27 11:30:00 | MSFT | Stock | 25.61 | 25.69 | 25.55 | 25.58 | 2706445.0 |
| 2011-09-27 12:00:00 | MSFT | Stock | 25.575 | 25.76 | 25.56 | 25.7 | 2319156.0 |
| 2011-09-27 12:30:00 | MSFT | Stock | 25.698 | 25.709 | 25.63 | 25.665 | 1734552.0 |
| 2011-09-27 13:00:00 | MSFT | Stock | 25.67 | 25.79 | 25.64 | 25.78 | 2178502.0 |
| 2011-09-27 13:30:00 | MSFT | Stock | 25.775 | 25.88 | 25.73 | 25.84 | 2174072.0 |
| 2011-09-27 14:00:00 | MSFT | Stock | 25.84 | 25.92 | 25.8 | 25.8 | 2372837.0 |
| 2011-09-27 14:30:00 | MSFT | Stock | 25.8 | 25.88 | 25.78 | 25.845 | 2546519.0 |
| 2011-09-27 15:00:00 | MSFT | Stock | 25.841 | 25.845 | 25.64 | 25.71 | 3566544.0 |
| 2011-09-27 15:30:00 | MSFT | Stock | 25.71 | 25.75 | 25.48 | 25.67 | 11407758.0 |
> showing 50 of 76,470 rows — these rows as CSV