PREVIEW / stock_30min / 2009-08-04
file: by_date/stock_30min/2009/2009-08-04.parquet size: 1.3 MB rows: 72,402 symbols: 3,381
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-08-04 04:30:00 | AAPL | Stock | 5.9364 | 5.9364 | 5.9364 | 5.9364 | 2800.0 |
| 2009-08-04 06:00:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 8400.0 |
| 2009-08-04 06:30:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 5600.0 |
| 2009-08-04 07:00:00 | AAPL | Stock | 5.8936 | 5.9161 | 5.8929 | 5.9161 | 58800.0 |
| 2009-08-04 07:30:00 | AAPL | Stock | 5.9154 | 5.9179 | 5.9154 | 5.9179 | 16800.0 |
| 2009-08-04 08:00:00 | AAPL | Stock | 5.9107 | 5.925 | 5.9082 | 5.9107 | 1072932.0 |
| 2009-08-04 08:30:00 | AAPL | Stock | 5.9079 | 5.9232 | 5.9 | 5.9107 | 420896.0 |
| 2009-08-04 09:00:00 | AAPL | Stock | 5.9125 | 5.9125 | 5.8918 | 5.8921 | 1319528.0 |
| 2009-08-04 09:30:00 | AAPL | Stock | 5.8925 | 5.9132 | 5.8707 | 5.8957 | 70403312.0 |
| 2009-08-04 10:00:00 | AAPL | Stock | 5.8957 | 5.9032 | 5.8736 | 5.8785 | 42196616.0 |
| 2009-08-04 10:30:00 | AAPL | Stock | 5.8793 | 5.8925 | 5.8689 | 5.8925 | 24638880.0 |
| 2009-08-04 11:00:00 | AAPL | Stock | 5.8918 | 5.9007 | 5.8889 | 5.8923 | 21689640.0 |
| 2009-08-04 11:30:00 | AAPL | Stock | 5.8925 | 5.9071 | 5.8861 | 5.9025 | 20435996.0 |
| 2009-08-04 12:00:00 | AAPL | Stock | 5.9018 | 5.91 | 5.8968 | 5.8993 | 21184492.0 |
| 2009-08-04 12:30:00 | AAPL | Stock | 5.8989 | 5.9071 | 5.8896 | 5.9046 | 21685496.0 |
| 2009-08-04 13:00:00 | AAPL | Stock | 5.9054 | 5.9114 | 5.8918 | 5.8979 | 18000724.0 |
| 2009-08-04 13:30:00 | AAPL | Stock | 5.8979 | 5.8986 | 5.8714 | 5.8754 | 19687248.0 |
| 2009-08-04 14:00:00 | AAPL | Stock | 5.8754 | 5.8857 | 5.8707 | 5.8843 | 19159056.0 |
| 2009-08-04 14:30:00 | AAPL | Stock | 5.8836 | 5.8929 | 5.8746 | 5.8764 | 19184452.0 |
| 2009-08-04 15:00:00 | AAPL | Stock | 5.8768 | 5.8943 | 5.8729 | 5.8789 | 23746828.0 |
| 2009-08-04 15:30:00 | AAPL | Stock | 5.8793 | 5.9125 | 5.8646 | 5.9107 | 51744000.0 |
| 2009-08-04 16:00:00 | AAPL | Stock | 5.9107 | 5.9143 | 5.8911 | 5.9071 | 13033664.0 |
| 2009-08-04 16:30:00 | AAPL | Stock | 5.9113 | 5.9146 | 5.9071 | 5.9125 | 3373944.0 |
| 2009-08-04 17:00:00 | AAPL | Stock | 5.9439 | 5.9439 | 5.9121 | 5.9161 | 267792.0 |
| 2009-08-04 17:30:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9107 | 5.9107 | 172424.0 |
| 2009-08-04 18:00:00 | AAPL | Stock | 5.9125 | 5.9129 | 5.9111 | 5.9111 | 240268.0 |
| 2009-08-04 18:30:00 | AAPL | Stock | 5.9111 | 5.9111 | 5.9075 | 5.9075 | 94948.0 |
| 2009-08-04 19:00:00 | AAPL | Stock | 5.9121 | 5.9121 | 5.9071 | 5.9107 | 68320.0 |
| 2009-08-04 19:30:00 | AAPL | Stock | 5.9125 | 5.9204 | 5.9125 | 5.9189 | 122640.0 |
| 2009-08-04 07:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 1200.0 |
| 2009-08-04 08:00:00 | MSFT | Stock | 23.7 | 23.74 | 23.69 | 23.72 | 8267.0 |
| 2009-08-04 08:30:00 | MSFT | Stock | 23.72 | 23.72 | 23.63 | 23.65 | 12923.0 |
| 2009-08-04 09:00:00 | MSFT | Stock | 23.67 | 23.72 | 23.62 | 23.66 | 23873.0 |
| 2009-08-04 09:30:00 | MSFT | Stock | 23.68 | 23.75 | 23.6 | 23.7 | 4613977.0 |
| 2009-08-04 10:00:00 | MSFT | Stock | 23.7 | 23.75 | 23.61 | 23.63 | 5028199.0 |
| 2009-08-04 10:30:00 | MSFT | Stock | 23.63 | 23.64 | 23.55 | 23.55 | 3919516.0 |
| 2009-08-04 11:00:00 | MSFT | Stock | 23.55 | 23.64 | 23.53 | 23.53 | 3449233.0 |
| 2009-08-04 11:30:00 | MSFT | Stock | 23.53 | 23.62 | 23.53 | 23.55 | 2897266.0 |
| 2009-08-04 12:00:00 | MSFT | Stock | 23.55 | 23.6 | 23.54 | 23.57 | 2650465.0 |
| 2009-08-04 12:30:00 | MSFT | Stock | 23.58 | 23.67 | 23.57 | 23.65 | 2547392.0 |
| 2009-08-04 13:00:00 | MSFT | Stock | 23.65 | 23.665 | 23.59 | 23.65 | 2251531.0 |
| 2009-08-04 13:30:00 | MSFT | Stock | 23.648 | 23.7 | 23.59 | 23.62 | 2669364.0 |
| 2009-08-04 14:00:00 | MSFT | Stock | 23.62 | 23.65 | 23.57 | 23.63 | 3170359.0 |
| 2009-08-04 14:30:00 | MSFT | Stock | 23.63 | 23.68 | 23.58 | 23.6 | 1936227.0 |
| 2009-08-04 15:00:00 | MSFT | Stock | 23.6 | 23.65 | 23.56 | 23.59 | 2184638.0 |
| 2009-08-04 15:30:00 | MSFT | Stock | 23.59 | 23.77 | 23.57 | 23.76 | 6809844.0 |
| 2009-08-04 16:00:00 | MSFT | Stock | 23.76 | 23.8 | 23.622 | 23.77 | 2579340.0 |
| 2009-08-04 16:30:00 | MSFT | Stock | 23.75 | 23.765 | 23.632 | 23.76 | 912720.0 |
| 2009-08-04 17:00:00 | MSFT | Stock | 23.58 | 23.83 | 23.58 | 23.79 | 71904.0 |
| 2009-08-04 17:30:00 | MSFT | Stock | 23.79 | 23.84 | 23.79 | 23.83 | 29109.0 |
> showing 50 of 72,402 rows — these rows as CSV