PREVIEW / stock_30min / 2008-10-28
file: by_date/stock_30min/2008/2008-10-28.parquet size: 1.2 MB rows: 71,102 symbols: 3,368
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-10-28 04:00:00 | AAPL | Stock | 3.3264 | 3.4221 | 3.3264 | 3.4107 | 16800.0 |
| 2008-10-28 05:00:00 | AAPL | Stock | 3.3857 | 3.3857 | 3.3857 | 3.3857 | 8400.0 |
| 2008-10-28 05:30:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.375 | 3.3929 | 55916.0 |
| 2008-10-28 06:00:00 | AAPL | Stock | 3.4096 | 3.4096 | 3.4096 | 3.4096 | 19600.0 |
| 2008-10-28 06:30:00 | AAPL | Stock | 3.3661 | 3.3661 | 3.3661 | 3.3661 | 28000.0 |
| 2008-10-28 07:00:00 | AAPL | Stock | 3.4014 | 3.4321 | 3.4014 | 3.4286 | 266868.0 |
| 2008-10-28 07:30:00 | AAPL | Stock | 3.4286 | 3.4357 | 3.3964 | 3.41 | 397600.0 |
| 2008-10-28 08:00:00 | AAPL | Stock | 3.4018 | 3.4107 | 3.3786 | 3.3946 | 4110456.0 |
| 2008-10-28 08:30:00 | AAPL | Stock | 3.3943 | 3.4025 | 3.3875 | 3.3975 | 1794940.0 |
| 2008-10-28 09:00:00 | AAPL | Stock | 3.3971 | 3.4175 | 3.3857 | 3.4093 | 3346364.0 |
| 2008-10-28 09:30:00 | AAPL | Stock | 3.4086 | 3.4286 | 3.3671 | 3.4025 | 171498796.0 |
| 2008-10-28 10:00:00 | AAPL | Stock | 3.4029 | 3.4143 | 3.35 | 3.35 | 145363792.0 |
| 2008-10-28 10:30:00 | AAPL | Stock | 3.3507 | 3.3796 | 3.2989 | 3.3121 | 135203628.0 |
| 2008-10-28 11:00:00 | AAPL | Stock | 3.3118 | 3.3661 | 3.3089 | 3.3596 | 99285452.0 |
| 2008-10-28 11:30:00 | AAPL | Stock | 3.3579 | 3.3821 | 3.3304 | 3.3411 | 80289748.0 |
| 2008-10-28 12:00:00 | AAPL | Stock | 3.3411 | 3.3718 | 3.3271 | 3.3389 | 61173784.0 |
| 2008-10-28 12:30:00 | AAPL | Stock | 3.3376 | 3.375 | 3.3364 | 3.3629 | 60683644.0 |
| 2008-10-28 13:00:00 | AAPL | Stock | 3.3625 | 3.3875 | 3.3557 | 3.3671 | 76421828.0 |
| 2008-10-28 13:30:00 | AAPL | Stock | 3.3672 | 3.3711 | 3.3182 | 3.3254 | 65255120.0 |
| 2008-10-28 14:00:00 | AAPL | Stock | 3.3254 | 3.3836 | 3.3221 | 3.3807 | 81480084.0 |
| 2008-10-28 14:30:00 | AAPL | Stock | 3.3811 | 3.4414 | 3.375 | 3.4346 | 145569004.0 |
| 2008-10-28 15:00:00 | AAPL | Stock | 3.4343 | 3.5029 | 3.4143 | 3.49 | 185785488.0 |
| 2008-10-28 15:30:00 | AAPL | Stock | 3.4896 | 3.5875 | 3.4546 | 3.5771 | 229891424.0 |
| 2008-10-28 16:00:00 | AAPL | Stock | 3.5757 | 3.5957 | 3.4039 | 3.5804 | 49408828.0 |
| 2008-10-28 16:30:00 | AAPL | Stock | 3.5807 | 3.5879 | 3.5714 | 3.575 | 14756028.0 |
| 2008-10-28 17:00:00 | AAPL | Stock | 3.5721 | 3.5764 | 3.5714 | 3.5732 | 578200.0 |
| 2008-10-28 17:30:00 | AAPL | Stock | 3.5754 | 3.5804 | 3.5714 | 3.5804 | 366744.0 |
| 2008-10-28 18:00:00 | AAPL | Stock | 3.5804 | 3.6196 | 3.5804 | 3.6079 | 2969680.0 |
| 2008-10-28 18:30:00 | AAPL | Stock | 3.6111 | 3.6111 | 3.5982 | 3.6 | 333844.0 |
| 2008-10-28 19:00:00 | AAPL | Stock | 3.6 | 3.6064 | 3.5893 | 3.5929 | 482468.0 |
| 2008-10-28 19:30:00 | AAPL | Stock | 3.5964 | 3.6 | 3.5875 | 3.5893 | 598220.0 |
| 2008-10-28 07:00:00 | MSFT | Stock | 21.75 | 21.78 | 21.75 | 21.75 | 4550.0 |
| 2008-10-28 07:30:00 | MSFT | Stock | 21.7 | 21.73 | 21.7 | 21.73 | 18545.0 |
| 2008-10-28 08:00:00 | MSFT | Stock | 21.67 | 21.75 | 21.57 | 21.67 | 129190.0 |
| 2008-10-28 08:30:00 | MSFT | Stock | 21.66 | 21.67 | 21.55 | 21.65 | 83329.0 |
| 2008-10-28 09:00:00 | MSFT | Stock | 21.65 | 21.74 | 21.55 | 21.67 | 92983.0 |
| 2008-10-28 09:30:00 | MSFT | Stock | 21.62 | 22.2 | 21.6 | 22.02 | 11683868.0 |
| 2008-10-28 10:00:00 | MSFT | Stock | 22.02 | 22.06 | 21.77 | 22.01 | 10065934.0 |
| 2008-10-28 10:30:00 | MSFT | Stock | 22.01 | 22.08 | 21.34 | 21.43 | 9538999.0 |
| 2008-10-28 11:00:00 | MSFT | Stock | 21.43 | 21.61 | 21.38 | 21.47 | 6703080.0 |
| 2008-10-28 11:30:00 | MSFT | Stock | 21.48 | 21.7 | 21.46 | 21.56 | 4907891.0 |
| 2008-10-28 12:00:00 | MSFT | Stock | 21.54 | 21.71 | 21.44 | 21.692 | 4420695.0 |
| 2008-10-28 12:30:00 | MSFT | Stock | 21.69 | 21.89 | 21.66 | 21.78 | 5540751.0 |
| 2008-10-28 13:00:00 | MSFT | Stock | 21.77 | 22.0 | 21.758 | 21.87 | 4449669.0 |
| 2008-10-28 13:30:00 | MSFT | Stock | 21.87 | 21.91 | 21.62 | 21.69 | 4171929.0 |
| 2008-10-28 14:00:00 | MSFT | Stock | 21.69 | 22.03 | 21.66 | 22.02 | 4928402.0 |
| 2008-10-28 14:30:00 | MSFT | Stock | 22.02 | 22.43 | 21.99 | 22.36 | 9664047.0 |
| 2008-10-28 15:00:00 | MSFT | Stock | 22.36 | 22.86 | 22.26 | 22.68 | 16249497.0 |
| 2008-10-28 15:30:00 | MSFT | Stock | 22.68 | 23.21 | 22.47 | 23.14 | 21712518.0 |
| 2008-10-28 16:00:00 | MSFT | Stock | 23.14 | 23.21 | 22.242 | 22.96 | 14139407.0 |
> showing 50 of 71,102 rows — these rows as CSV