PREVIEW / stock_30min / 2009-12-08
file: by_date/stock_30min/2009/2009-12-08.parquet size: 1.3 MB rows: 71,870 symbols: 3,416
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-08 04:00:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7679 | 6.7679 | 22400.0 |
| 2009-12-08 05:00:00 | AAPL | Stock | 6.7668 | 6.7668 | 6.7668 | 6.7668 | 5600.0 |
| 2009-12-08 05:30:00 | AAPL | Stock | 6.7643 | 6.7668 | 6.7643 | 6.7668 | 5600.0 |
| 2009-12-08 06:00:00 | AAPL | Stock | 6.7593 | 6.7593 | 6.7589 | 6.7589 | 5600.0 |
| 2009-12-08 06:30:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7321 | 6.7321 | 8400.0 |
| 2009-12-08 07:00:00 | AAPL | Stock | 6.7271 | 6.7271 | 6.715 | 6.715 | 11200.0 |
| 2009-12-08 07:30:00 | AAPL | Stock | 6.7246 | 6.7321 | 6.7218 | 6.7286 | 142436.0 |
| 2009-12-08 08:00:00 | AAPL | Stock | 6.7304 | 6.7511 | 6.7221 | 6.7275 | 1414028.0 |
| 2009-12-08 08:30:00 | AAPL | Stock | 6.7264 | 6.7268 | 6.7054 | 6.7093 | 1893192.0 |
| 2009-12-08 09:00:00 | AAPL | Stock | 6.7096 | 6.7854 | 6.7089 | 6.7554 | 4204620.0 |
| 2009-12-08 09:30:00 | AAPL | Stock | 6.7564 | 6.7982 | 6.7393 | 6.7668 | 130807236.0 |
| 2009-12-08 10:00:00 | AAPL | Stock | 6.7668 | 6.8071 | 6.7436 | 6.8021 | 85716596.0 |
| 2009-12-08 10:30:00 | AAPL | Stock | 6.8036 | 6.8189 | 6.7771 | 6.7856 | 49588812.0 |
| 2009-12-08 11:00:00 | AAPL | Stock | 6.7857 | 6.8389 | 6.7786 | 6.8389 | 51266908.0 |
| 2009-12-08 11:30:00 | AAPL | Stock | 6.8389 | 6.8696 | 6.8329 | 6.8415 | 56579460.0 |
| 2009-12-08 12:00:00 | AAPL | Stock | 6.8411 | 6.8496 | 6.8225 | 6.8257 | 20058220.0 |
| 2009-12-08 12:30:00 | AAPL | Stock | 6.8261 | 6.8368 | 6.8089 | 6.8296 | 24826760.0 |
| 2009-12-08 13:00:00 | AAPL | Stock | 6.8293 | 6.8304 | 6.7961 | 6.7986 | 21751548.0 |
| 2009-12-08 13:30:00 | AAPL | Stock | 6.7986 | 6.8321 | 6.7979 | 6.8246 | 26395348.0 |
| 2009-12-08 14:00:00 | AAPL | Stock | 6.8243 | 6.8275 | 6.7864 | 6.7946 | 25128264.0 |
| 2009-12-08 14:30:00 | AAPL | Stock | 6.795 | 6.8029 | 6.7771 | 6.7835 | 28782544.0 |
| 2009-12-08 15:00:00 | AAPL | Stock | 6.7832 | 6.8043 | 6.7768 | 6.7943 | 32204648.0 |
| 2009-12-08 15:30:00 | AAPL | Stock | 6.7943 | 6.7989 | 6.7721 | 6.7796 | 45530828.0 |
| 2009-12-08 16:00:00 | AAPL | Stock | 6.7793 | 6.8225 | 6.7511 | 6.7814 | 8176504.0 |
| 2009-12-08 16:30:00 | AAPL | Stock | 6.8399 | 6.8399 | 6.7768 | 6.7779 | 469784.0 |
| 2009-12-08 17:00:00 | AAPL | Stock | 6.7789 | 6.7832 | 6.7786 | 6.7811 | 155736.0 |
| 2009-12-08 17:30:00 | AAPL | Stock | 6.7804 | 6.7821 | 6.7782 | 6.7821 | 108920.0 |
| 2009-12-08 18:00:00 | AAPL | Stock | 6.7814 | 6.7821 | 6.7786 | 6.7804 | 46228.0 |
| 2009-12-08 18:30:00 | AAPL | Stock | 6.7814 | 6.7854 | 6.7786 | 6.785 | 176400.0 |
| 2009-12-08 19:00:00 | AAPL | Stock | 6.7839 | 6.7843 | 6.7725 | 6.7802 | 330400.0 |
| 2009-12-08 19:30:00 | AAPL | Stock | 6.7768 | 6.7837 | 6.7464 | 6.7596 | 1140888.0 |
| 2009-12-08 07:30:00 | MSFT | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 1724.0 |
| 2009-12-08 08:00:00 | MSFT | Stock | 29.68 | 29.79 | 29.55 | 29.56 | 18900.0 |
| 2009-12-08 08:30:00 | MSFT | Stock | 29.54 | 29.59 | 29.5 | 29.59 | 4320.0 |
| 2009-12-08 09:00:00 | MSFT | Stock | 29.59 | 29.6 | 29.49 | 29.51 | 60387.0 |
| 2009-12-08 09:30:00 | MSFT | Stock | 29.52 | 29.61 | 29.38 | 29.51 | 7352975.0 |
| 2009-12-08 10:00:00 | MSFT | Stock | 29.52 | 29.74 | 29.49 | 29.64 | 4166359.0 |
| 2009-12-08 10:30:00 | MSFT | Stock | 29.64 | 29.66 | 29.48 | 29.54 | 2711288.0 |
| 2009-12-08 11:00:00 | MSFT | Stock | 29.55 | 29.65 | 29.52 | 29.61 | 1982284.0 |
| 2009-12-08 11:30:00 | MSFT | Stock | 29.61 | 29.68 | 29.58 | 29.62 | 1661466.0 |
| 2009-12-08 12:00:00 | MSFT | Stock | 29.62 | 29.63 | 29.6 | 29.609 | 1253864.0 |
| 2009-12-08 12:30:00 | MSFT | Stock | 29.605 | 29.65 | 29.6 | 29.64 | 1229849.0 |
| 2009-12-08 13:00:00 | MSFT | Stock | 29.635 | 29.64 | 29.55 | 29.55 | 1077453.0 |
| 2009-12-08 13:30:00 | MSFT | Stock | 29.55 | 29.59 | 29.55 | 29.57 | 1566946.0 |
| 2009-12-08 14:00:00 | MSFT | Stock | 29.567 | 29.58 | 29.54 | 29.55 | 1483480.0 |
| 2009-12-08 14:30:00 | MSFT | Stock | 29.55 | 29.58 | 29.53 | 29.569 | 2594094.0 |
| 2009-12-08 15:00:00 | MSFT | Stock | 29.56 | 29.665 | 29.56 | 29.66 | 1896275.0 |
| 2009-12-08 15:30:00 | MSFT | Stock | 29.651 | 29.69 | 29.57 | 29.57 | 5438174.0 |
| 2009-12-08 16:00:00 | MSFT | Stock | 29.57 | 29.61 | 29.55 | 29.57 | 2029209.0 |
| 2009-12-08 16:30:00 | MSFT | Stock | 29.616 | 29.616 | 29.54 | 29.54 | 50089.0 |
> showing 50 of 71,870 rows — these rows as CSV