PREVIEW / stock_30min / 2012-12-03
file: by_date/stock_30min/2012/2012-12-03.parquet size: 1.4 MB rows: 76,285 symbols: 3,502
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-03 04:00:00 | AAPL | Stock | 21.0536 | 21.0789 | 21.0471 | 21.0789 | 18060.0 |
| 2012-12-03 04:30:00 | AAPL | Stock | 21.0679 | 21.0714 | 21.0396 | 21.0714 | 16800.0 |
| 2012-12-03 05:00:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0357 | 21.0364 | 42560.0 |
| 2012-12-03 05:30:00 | AAPL | Stock | 21.0379 | 21.0429 | 21.0379 | 21.0429 | 14000.0 |
| 2012-12-03 06:00:00 | AAPL | Stock | 21.0429 | 21.0536 | 21.0429 | 21.0429 | 19600.0 |
| 2012-12-03 06:30:00 | AAPL | Stock | 21.0439 | 21.0439 | 21.0439 | 21.0439 | 2800.0 |
| 2012-12-03 07:00:00 | AAPL | Stock | 21.0625 | 21.0893 | 21.0536 | 21.0854 | 157556.0 |
| 2012-12-03 07:30:00 | AAPL | Stock | 21.0839 | 21.1339 | 21.0679 | 21.1036 | 496916.0 |
| 2012-12-03 08:00:00 | AAPL | Stock | 21.1036 | 21.1246 | 21.0625 | 21.0804 | 1308776.0 |
| 2012-12-03 08:30:00 | AAPL | Stock | 21.0804 | 21.1232 | 20.9029 | 21.1182 | 1148028.0 |
| 2012-12-03 09:00:00 | AAPL | Stock | 21.1179 | 21.2143 | 21.1146 | 21.2004 | 3881612.0 |
| 2012-12-03 09:30:00 | AAPL | Stock | 21.2018 | 21.2354 | 21.1304 | 21.1571 | 68291524.0 |
| 2012-12-03 10:00:00 | AAPL | Stock | 21.1536 | 21.1571 | 21.0536 | 21.0954 | 45979948.0 |
| 2012-12-03 10:30:00 | AAPL | Stock | 21.1011 | 21.1096 | 20.9829 | 21.0082 | 33174848.0 |
| 2012-12-03 11:00:00 | AAPL | Stock | 21.0082 | 21.0807 | 20.9807 | 21.0225 | 19477304.0 |
| 2012-12-03 11:30:00 | AAPL | Stock | 21.0243 | 21.1025 | 21.0 | 21.0889 | 20587084.0 |
| 2012-12-03 12:00:00 | AAPL | Stock | 21.0889 | 21.1029 | 21.0543 | 21.0914 | 10226272.0 |
| 2012-12-03 12:30:00 | AAPL | Stock | 21.0916 | 21.0964 | 21.0196 | 21.0307 | 10508456.0 |
| 2012-12-03 13:00:00 | AAPL | Stock | 21.0221 | 21.05 | 20.9889 | 21.0425 | 11794748.0 |
| 2012-12-03 13:30:00 | AAPL | Stock | 21.0389 | 21.0482 | 20.9643 | 21.03 | 19218612.0 |
| 2012-12-03 14:00:00 | AAPL | Stock | 21.0246 | 21.0729 | 20.997 | 21.0196 | 14751380.0 |
| 2012-12-03 14:30:00 | AAPL | Stock | 21.0168 | 21.0311 | 20.955 | 20.9911 | 17217620.0 |
| 2012-12-03 15:00:00 | AAPL | Stock | 20.9907 | 21.0429 | 20.9286 | 20.9625 | 26273800.0 |
| 2012-12-03 15:30:00 | AAPL | Stock | 20.9586 | 20.9807 | 20.9107 | 20.9318 | 33495616.0 |
| 2012-12-03 16:00:00 | AAPL | Stock | 20.9321 | 21.0694 | 20.9029 | 20.9243 | 7697256.0 |
| 2012-12-03 16:30:00 | AAPL | Stock | 20.9232 | 21.098 | 20.9032 | 20.9032 | 693728.0 |
| 2012-12-03 17:00:00 | AAPL | Stock | 20.9032 | 20.9071 | 20.8761 | 20.8814 | 300272.0 |
| 2012-12-03 17:30:00 | AAPL | Stock | 20.8889 | 20.8889 | 20.8604 | 20.8714 | 177632.0 |
| 2012-12-03 18:00:00 | AAPL | Stock | 20.875 | 20.8893 | 20.875 | 20.8761 | 89208.0 |
| 2012-12-03 18:30:00 | AAPL | Stock | 20.8854 | 20.8929 | 20.8825 | 20.8921 | 81760.0 |
| 2012-12-03 19:00:00 | AAPL | Stock | 20.8786 | 20.8825 | 20.8657 | 20.8657 | 59416.0 |
| 2012-12-03 19:30:00 | AAPL | Stock | 20.8661 | 20.8661 | 20.8539 | 20.8571 | 213808.0 |
| 2012-12-03 07:00:00 | MSFT | Stock | 26.75 | 26.77 | 26.71 | 26.77 | 3880.0 |
| 2012-12-03 07:30:00 | MSFT | Stock | 26.75 | 26.77 | 26.72 | 26.75 | 16890.0 |
| 2012-12-03 08:00:00 | MSFT | Stock | 26.73 | 26.79 | 26.73 | 26.79 | 84902.0 |
| 2012-12-03 08:30:00 | MSFT | Stock | 26.79 | 26.79 | 26.76 | 26.76 | 21369.0 |
| 2012-12-03 09:00:00 | MSFT | Stock | 26.77 | 26.85 | 26.72 | 26.79 | 65895.0 |
| 2012-12-03 09:30:00 | MSFT | Stock | 26.78 | 26.82 | 26.65 | 26.725 | 5588909.0 |
| 2012-12-03 10:00:00 | MSFT | Stock | 26.72 | 26.735 | 26.59 | 26.61 | 4420618.0 |
| 2012-12-03 10:30:00 | MSFT | Stock | 26.61 | 26.62 | 26.48 | 26.525 | 5763780.0 |
| 2012-12-03 11:00:00 | MSFT | Stock | 26.52 | 26.56 | 26.49 | 26.54 | 4414552.0 |
| 2012-12-03 11:30:00 | MSFT | Stock | 26.54 | 26.59 | 26.51 | 26.58 | 2277429.0 |
| 2012-12-03 12:00:00 | MSFT | Stock | 26.575 | 26.59 | 26.51 | 26.55 | 2294230.0 |
| 2012-12-03 12:30:00 | MSFT | Stock | 26.541 | 26.55 | 26.49 | 26.506 | 2696238.0 |
| 2012-12-03 13:00:00 | MSFT | Stock | 26.5 | 26.52 | 26.49 | 26.505 | 2487112.0 |
| 2012-12-03 13:30:00 | MSFT | Stock | 26.5 | 26.51 | 26.475 | 26.5 | 2288627.0 |
| 2012-12-03 14:00:00 | MSFT | Stock | 26.495 | 26.52 | 26.48 | 26.485 | 1928050.0 |
| 2012-12-03 14:30:00 | MSFT | Stock | 26.48 | 26.5 | 26.41 | 26.47 | 3636746.0 |
| 2012-12-03 15:00:00 | MSFT | Stock | 26.475 | 26.52 | 26.4 | 26.45 | 5609348.0 |
| 2012-12-03 15:30:00 | MSFT | Stock | 26.45 | 26.51 | 26.4 | 26.42 | 6044564.0 |
> showing 50 of 76,285 rows — these rows as CSV