PREVIEW / stock_30min / 2008-09-09
file: by_date/stock_30min/2008/2008-09-09.parquet size: 1.3 MB rows: 70,060 symbols: 3,333
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-09-09 05:00:00 | AAPL | Stock | 5.66 | 5.66 | 5.66 | 5.66 | 8400.0 |
| 2008-09-09 06:30:00 | AAPL | Stock | 5.6782 | 5.6782 | 5.6782 | 5.6782 | 5600.0 |
| 2008-09-09 07:00:00 | AAPL | Stock | 5.6768 | 5.6768 | 5.6768 | 5.6768 | 18200.0 |
| 2008-09-09 07:30:00 | AAPL | Stock | 5.6696 | 5.6732 | 5.6696 | 5.6696 | 46340.0 |
| 2008-09-09 08:00:00 | AAPL | Stock | 5.6786 | 5.6843 | 5.6146 | 5.6214 | 1105664.0 |
| 2008-09-09 08:30:00 | AAPL | Stock | 5.62 | 5.6268 | 5.5893 | 5.5893 | 606704.0 |
| 2008-09-09 09:00:00 | AAPL | Stock | 5.5875 | 5.6071 | 5.5664 | 5.6043 | 1491224.0 |
| 2008-09-09 09:30:00 | AAPL | Stock | 5.6021 | 5.71 | 5.5536 | 5.6654 | 109604824.0 |
| 2008-09-09 10:00:00 | AAPL | Stock | 5.6646 | 5.6696 | 5.6182 | 5.6507 | 71044876.0 |
| 2008-09-09 10:30:00 | AAPL | Stock | 5.6514 | 5.6921 | 5.6296 | 5.6564 | 67096344.0 |
| 2008-09-09 11:00:00 | AAPL | Stock | 5.6564 | 5.675 | 5.5964 | 5.6536 | 61983208.0 |
| 2008-09-09 11:30:00 | AAPL | Stock | 5.6539 | 5.6779 | 5.6236 | 5.6314 | 34959372.0 |
| 2008-09-09 12:00:00 | AAPL | Stock | 5.6314 | 5.6393 | 5.5689 | 5.5811 | 44106888.0 |
| 2008-09-09 12:30:00 | AAPL | Stock | 5.5814 | 5.6629 | 5.5782 | 5.6111 | 53987724.0 |
| 2008-09-09 13:00:00 | AAPL | Stock | 5.6099 | 5.7129 | 5.4911 | 5.5254 | 161981624.0 |
| 2008-09-09 13:30:00 | AAPL | Stock | 5.5243 | 5.5329 | 5.4214 | 5.4539 | 146709304.0 |
| 2008-09-09 14:00:00 | AAPL | Stock | 5.4543 | 5.5093 | 5.4457 | 5.4857 | 94594612.0 |
| 2008-09-09 14:30:00 | AAPL | Stock | 5.4854 | 5.4932 | 5.3929 | 5.4107 | 134464568.0 |
| 2008-09-09 15:00:00 | AAPL | Stock | 5.4107 | 5.4286 | 5.3496 | 5.4271 | 113562484.0 |
| 2008-09-09 15:30:00 | AAPL | Stock | 5.4286 | 5.445 | 5.3968 | 5.4118 | 112625212.0 |
| 2008-09-09 16:00:00 | AAPL | Stock | 5.4129 | 5.5364 | 5.4066 | 5.4164 | 22043168.0 |
| 2008-09-09 16:30:00 | AAPL | Stock | 5.4186 | 5.4321 | 5.4111 | 5.4268 | 6596156.0 |
| 2008-09-09 17:00:00 | AAPL | Stock | 5.425 | 5.425 | 5.4114 | 5.4129 | 246288.0 |
| 2008-09-09 17:30:00 | AAPL | Stock | 5.4161 | 5.4193 | 5.4071 | 5.4125 | 213332.0 |
| 2008-09-09 18:00:00 | AAPL | Stock | 5.4075 | 5.4121 | 5.4057 | 5.4057 | 114940.0 |
| 2008-09-09 18:30:00 | AAPL | Stock | 5.4104 | 5.4286 | 5.4104 | 5.4286 | 219380.0 |
| 2008-09-09 19:00:00 | AAPL | Stock | 5.4286 | 5.4357 | 5.4286 | 5.4357 | 77000.0 |
| 2008-09-09 19:30:00 | AAPL | Stock | 5.4343 | 5.4364 | 5.4293 | 5.4357 | 275352.0 |
| 2008-09-09 07:00:00 | MSFT | Stock | 26.32 | 26.32 | 26.32 | 26.32 | 100.0 |
| 2008-09-09 07:30:00 | MSFT | Stock | 26.29 | 26.29 | 26.29 | 26.29 | 100.0 |
| 2008-09-09 08:00:00 | MSFT | Stock | 26.23 | 26.26 | 26.15 | 26.26 | 4921.0 |
| 2008-09-09 08:30:00 | MSFT | Stock | 26.26 | 26.26 | 26.16 | 26.16 | 4271.0 |
| 2008-09-09 09:00:00 | MSFT | Stock | 26.17 | 26.22 | 26.16 | 26.2 | 22200.0 |
| 2008-09-09 09:30:00 | MSFT | Stock | 26.2 | 26.6 | 26.16 | 26.56 | 8877413.0 |
| 2008-09-09 10:00:00 | MSFT | Stock | 26.56 | 26.595 | 26.33 | 26.37 | 10297014.0 |
| 2008-09-09 10:30:00 | MSFT | Stock | 26.375 | 26.47 | 26.33 | 26.42 | 7831710.0 |
| 2008-09-09 11:00:00 | MSFT | Stock | 26.42 | 26.47 | 26.32 | 26.4 | 4248314.0 |
| 2008-09-09 11:30:00 | MSFT | Stock | 26.4 | 26.45 | 26.24 | 26.24 | 3966402.0 |
| 2008-09-09 12:00:00 | MSFT | Stock | 26.25 | 26.43 | 26.18 | 26.36 | 4959523.0 |
| 2008-09-09 12:30:00 | MSFT | Stock | 26.36 | 26.49 | 26.3 | 26.408 | 2986066.0 |
| 2008-09-09 13:00:00 | MSFT | Stock | 26.409 | 26.55 | 26.35 | 26.39 | 4761078.0 |
| 2008-09-09 13:30:00 | MSFT | Stock | 26.39 | 26.43 | 26.29 | 26.35 | 3565122.0 |
| 2008-09-09 14:00:00 | MSFT | Stock | 26.35 | 26.47 | 26.31 | 26.4 | 3873248.0 |
| 2008-09-09 14:30:00 | MSFT | Stock | 26.402 | 26.43 | 26.33 | 26.392 | 6084890.0 |
| 2008-09-09 15:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.23 | 26.34 | 6140488.0 |
| 2008-09-09 15:30:00 | MSFT | Stock | 26.34 | 26.43 | 26.05 | 26.1 | 11572995.0 |
| 2008-09-09 16:00:00 | MSFT | Stock | 26.1 | 26.36 | 26.015 | 26.06 | 3973934.0 |
| 2008-09-09 16:30:00 | MSFT | Stock | 26.11 | 26.16 | 26.08 | 26.12 | 563658.0 |
| 2008-09-09 17:00:00 | MSFT | Stock | 26.12 | 26.12 | 26.12 | 26.12 | 100.0 |
| 2008-09-09 17:30:00 | MSFT | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 950.0 |
> showing 50 of 70,060 rows — these rows as CSV