PREVIEW / stock_30min / 2008-10-27
file: by_date/stock_30min/2008/2008-10-27.parquet size: 1.2 MB rows: 69,166 symbols: 3,335
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-27 07:00:00 | AAPL | Stock | 3.3536 | 3.3596 | 3.34 | 3.34 | 71120.0 |
| 2008-10-27 07:30:00 | AAPL | Stock | 3.3536 | 3.3679 | 3.3536 | 3.3679 | 185780.0 |
| 2008-10-27 08:00:00 | AAPL | Stock | 3.3711 | 3.3829 | 3.3425 | 3.3625 | 1623496.0 |
| 2008-10-27 08:30:00 | AAPL | Stock | 3.3643 | 3.4236 | 3.3571 | 3.4221 | 1624084.0 |
| 2008-10-27 09:00:00 | AAPL | Stock | 3.4204 | 3.4375 | 3.3968 | 3.4 | 3091732.0 |
| 2008-10-27 09:30:00 | AAPL | Stock | 3.4 | 3.4761 | 3.3929 | 3.4496 | 156512972.0 |
| 2008-10-27 10:00:00 | AAPL | Stock | 3.4489 | 3.4868 | 3.4046 | 3.4107 | 124038796.0 |
| 2008-10-27 10:30:00 | AAPL | Stock | 3.4111 | 3.4211 | 3.3661 | 3.4107 | 96555256.0 |
| 2008-10-27 11:00:00 | AAPL | Stock | 3.4107 | 3.4382 | 3.3864 | 3.4139 | 74513348.0 |
| 2008-10-27 11:30:00 | AAPL | Stock | 3.4136 | 3.4225 | 3.375 | 3.3982 | 71177876.0 |
| 2008-10-27 12:00:00 | AAPL | Stock | 3.3975 | 3.4286 | 3.3896 | 3.3979 | 64128736.0 |
| 2008-10-27 12:30:00 | AAPL | Stock | 3.3989 | 3.4643 | 3.3946 | 3.4618 | 70743876.0 |
| 2008-10-27 13:00:00 | AAPL | Stock | 3.4621 | 3.4643 | 3.425 | 3.4593 | 59360616.0 |
| 2008-10-27 13:30:00 | AAPL | Stock | 3.4589 | 3.4743 | 3.4418 | 3.4472 | 63135408.0 |
| 2008-10-27 14:00:00 | AAPL | Stock | 3.4482 | 3.46 | 3.4075 | 3.4107 | 67268124.0 |
| 2008-10-27 14:30:00 | AAPL | Stock | 3.4096 | 3.4239 | 3.3675 | 3.3729 | 81139156.0 |
| 2008-10-27 15:00:00 | AAPL | Stock | 3.3725 | 3.4125 | 3.3682 | 3.3893 | 89472040.0 |
| 2008-10-27 15:30:00 | AAPL | Stock | 3.3886 | 3.3943 | 3.2807 | 3.2893 | 143716356.0 |
| 2008-10-27 16:00:00 | AAPL | Stock | 3.2879 | 3.4106 | 3.2814 | 3.2875 | 17879120.0 |
| 2008-10-27 16:30:00 | AAPL | Stock | 3.2861 | 3.3036 | 3.2821 | 3.2861 | 3053036.0 |
| 2008-10-27 17:00:00 | AAPL | Stock | 3.2929 | 3.2975 | 3.2861 | 3.2893 | 8828932.0 |
| 2008-10-27 17:30:00 | AAPL | Stock | 3.2893 | 3.4671 | 3.2821 | 3.2854 | 414456.0 |
| 2008-10-27 18:00:00 | AAPL | Stock | 3.2825 | 3.285 | 3.2768 | 3.2768 | 437248.0 |
| 2008-10-27 18:30:00 | AAPL | Stock | 3.2754 | 3.2814 | 3.275 | 3.2786 | 125608.0 |
| 2008-10-27 19:00:00 | AAPL | Stock | 3.2786 | 3.2846 | 3.2786 | 3.2804 | 124320.0 |
| 2008-10-27 19:30:00 | AAPL | Stock | 3.2857 | 3.2932 | 3.2786 | 3.2786 | 209552.0 |
| 2008-10-27 20:00:00 | AAPL | Stock | 3.3986 | 3.3986 | 3.3986 | 3.3986 | 51072.0 |
| 2008-10-27 08:00:00 | MSFT | Stock | 21.74 | 21.77 | 21.4 | 21.65 | 28867.0 |
| 2008-10-27 08:30:00 | MSFT | Stock | 21.65 | 21.79 | 21.65 | 21.79 | 76843.0 |
| 2008-10-27 09:00:00 | MSFT | Stock | 21.8 | 21.98 | 21.55 | 21.67 | 183414.0 |
| 2008-10-27 09:30:00 | MSFT | Stock | 21.67 | 21.68 | 21.26 | 21.419 | 10313542.0 |
| 2008-10-27 10:00:00 | MSFT | Stock | 21.42 | 21.67 | 21.23 | 21.27 | 8842611.0 |
| 2008-10-27 10:30:00 | MSFT | Stock | 21.27 | 21.32 | 21.12 | 21.3 | 6278085.0 |
| 2008-10-27 11:00:00 | MSFT | Stock | 21.29 | 21.41 | 21.1 | 21.15 | 7270612.0 |
| 2008-10-27 11:30:00 | MSFT | Stock | 21.15 | 21.19 | 21.03 | 21.158 | 4972210.0 |
| 2008-10-27 12:00:00 | MSFT | Stock | 21.15 | 21.32 | 21.12 | 21.158 | 6180996.0 |
| 2008-10-27 12:30:00 | MSFT | Stock | 21.17 | 21.5 | 21.14 | 21.5 | 6746861.0 |
| 2008-10-27 13:00:00 | MSFT | Stock | 21.495 | 21.54 | 21.31 | 21.53 | 6057856.0 |
| 2008-10-27 13:30:00 | MSFT | Stock | 21.53 | 21.9 | 21.501 | 21.85 | 6795446.0 |
| 2008-10-27 14:00:00 | MSFT | Stock | 21.85 | 21.92 | 21.41 | 21.43 | 7038392.0 |
| 2008-10-27 14:30:00 | MSFT | Stock | 21.42 | 21.6 | 21.35 | 21.36 | 6088870.0 |
| 2008-10-27 15:00:00 | MSFT | Stock | 21.37 | 21.55 | 21.35 | 21.54 | 8045726.0 |
| 2008-10-27 15:30:00 | MSFT | Stock | 21.54 | 21.96 | 21.02 | 21.17 | 22291501.0 |
| 2008-10-27 16:00:00 | MSFT | Stock | 21.16 | 21.642 | 21.03 | 21.07 | 7571049.0 |
| 2008-10-27 16:30:00 | MSFT | Stock | 21.07 | 21.408 | 21.02 | 21.13 | 284892.0 |
| 2008-10-27 17:00:00 | MSFT | Stock | 21.15 | 21.18 | 21.09 | 21.16 | 48123.0 |
| 2008-10-27 17:30:00 | MSFT | Stock | 21.1 | 21.41 | 21.08 | 21.08 | 26240.0 |
| 2008-10-27 18:00:00 | MSFT | Stock | 21.08 | 21.13 | 21.01 | 21.01 | 16101.0 |
| 2008-10-27 18:30:00 | MSFT | Stock | 21.04 | 21.14 | 21.01 | 21.1 | 5788.0 |
| 2008-10-27 19:00:00 | MSFT | Stock | 21.08 | 21.11 | 21.04 | 21.04 | 10750.0 |
> showing 50 of 69,166 rows — these rows as CSV