PREVIEW / stock_30min / 2008-08-08
file: by_date/stock_30min/2008/2008-08-08.parquet size: 1.3 MB rows: 69,287 symbols: 3,341
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-08-08 06:30:00 | AAPL | Stock | 5.8607 | 5.8607 | 5.8571 | 5.8571 | 10584.0 |
| 2008-08-08 07:00:00 | AAPL | Stock | 5.9061 | 5.9061 | 5.8982 | 5.8982 | 6300.0 |
| 2008-08-08 07:30:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.85 | 5.85 | 257600.0 |
| 2008-08-08 08:00:00 | AAPL | Stock | 5.8543 | 5.8675 | 5.8507 | 5.8554 | 883064.0 |
| 2008-08-08 08:30:00 | AAPL | Stock | 5.8536 | 5.8711 | 5.8536 | 5.8679 | 773388.0 |
| 2008-08-08 09:00:00 | AAPL | Stock | 5.8664 | 5.8693 | 5.845 | 5.8482 | 1746388.0 |
| 2008-08-08 09:30:00 | AAPL | Stock | 5.8482 | 5.9532 | 5.8482 | 5.945 | 103019168.0 |
| 2008-08-08 10:00:00 | AAPL | Stock | 5.9446 | 5.9725 | 5.9375 | 5.9607 | 77437416.0 |
| 2008-08-08 10:30:00 | AAPL | Stock | 5.9611 | 5.9714 | 5.9439 | 5.953 | 49454328.0 |
| 2008-08-08 11:00:00 | AAPL | Stock | 5.9532 | 5.9857 | 5.9411 | 5.9789 | 50207388.0 |
| 2008-08-08 11:30:00 | AAPL | Stock | 5.9789 | 5.99 | 5.9686 | 5.9804 | 30486316.0 |
| 2008-08-08 12:00:00 | AAPL | Stock | 5.9804 | 6.0089 | 5.9721 | 6.0046 | 50393588.0 |
| 2008-08-08 12:30:00 | AAPL | Stock | 6.0046 | 6.0246 | 5.9971 | 6.0136 | 44608676.0 |
| 2008-08-08 13:00:00 | AAPL | Stock | 6.0145 | 6.0292 | 6.0011 | 6.0157 | 43023932.0 |
| 2008-08-08 13:30:00 | AAPL | Stock | 6.0171 | 6.025 | 6.0046 | 6.0211 | 34653976.0 |
| 2008-08-08 14:00:00 | AAPL | Stock | 6.0207 | 6.0425 | 6.0143 | 6.0339 | 39656232.0 |
| 2008-08-08 14:30:00 | AAPL | Stock | 6.0346 | 6.0393 | 6.0196 | 6.0229 | 30879604.0 |
| 2008-08-08 15:00:00 | AAPL | Stock | 6.0225 | 6.0339 | 6.0025 | 6.0275 | 43667008.0 |
| 2008-08-08 15:30:00 | AAPL | Stock | 6.0275 | 6.0589 | 6.0243 | 6.0529 | 91555884.0 |
| 2008-08-08 16:00:00 | AAPL | Stock | 6.0511 | 6.0554 | 5.9877 | 6.0471 | 16823212.0 |
| 2008-08-08 16:30:00 | AAPL | Stock | 6.0479 | 6.0479 | 6.04 | 6.0404 | 136416.0 |
| 2008-08-08 17:00:00 | AAPL | Stock | 6.0404 | 6.0429 | 6.04 | 6.0411 | 74508.0 |
| 2008-08-08 17:30:00 | AAPL | Stock | 6.0375 | 6.0393 | 6.0361 | 6.0393 | 117152.0 |
| 2008-08-08 18:00:00 | AAPL | Stock | 6.0379 | 6.0457 | 6.0375 | 6.0457 | 167496.0 |
| 2008-08-08 18:30:00 | AAPL | Stock | 6.0432 | 6.0464 | 6.0432 | 6.0464 | 5600.0 |
| 2008-08-08 19:00:00 | AAPL | Stock | 6.0468 | 6.0471 | 6.0468 | 6.0468 | 16548.0 |
| 2008-08-08 19:30:00 | AAPL | Stock | 6.0496 | 6.0554 | 6.0496 | 6.0539 | 206360.0 |
| 2008-08-08 08:00:00 | MSFT | Stock | 27.51 | 27.51 | 27.51 | 27.51 | 100.0 |
| 2008-08-08 08:30:00 | MSFT | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 500.0 |
| 2008-08-08 09:00:00 | MSFT | Stock | 27.4 | 27.42 | 27.31 | 27.32 | 41057.0 |
| 2008-08-08 09:30:00 | MSFT | Stock | 27.32 | 27.73 | 27.19 | 27.67 | 9123030.0 |
| 2008-08-08 10:00:00 | MSFT | Stock | 27.68 | 28.23 | 27.65 | 28.09 | 13202678.0 |
| 2008-08-08 10:30:00 | MSFT | Stock | 28.09 | 28.11 | 27.81 | 27.86 | 7630055.0 |
| 2008-08-08 11:00:00 | MSFT | Stock | 27.87 | 27.99 | 27.82 | 27.978 | 3423353.0 |
| 2008-08-08 11:30:00 | MSFT | Stock | 27.98 | 28.06 | 27.92 | 28.0 | 3310677.0 |
| 2008-08-08 12:00:00 | MSFT | Stock | 28.0 | 28.1 | 27.9 | 28.05 | 2202091.0 |
| 2008-08-08 12:30:00 | MSFT | Stock | 28.05 | 28.06 | 27.96 | 27.99 | 2709560.0 |
| 2008-08-08 13:00:00 | MSFT | Stock | 27.995 | 28.09 | 27.94 | 28.065 | 2698037.0 |
| 2008-08-08 13:30:00 | MSFT | Stock | 28.06 | 28.15 | 28.01 | 28.07 | 5608305.0 |
| 2008-08-08 14:00:00 | MSFT | Stock | 28.06 | 28.18 | 28.05 | 28.141 | 4507881.0 |
| 2008-08-08 14:30:00 | MSFT | Stock | 28.15 | 28.17 | 28.06 | 28.08 | 3407978.0 |
| 2008-08-08 15:00:00 | MSFT | Stock | 28.08 | 28.12 | 27.96 | 28.0 | 6366351.0 |
| 2008-08-08 15:30:00 | MSFT | Stock | 28.01 | 28.19 | 27.99 | 28.07 | 10671106.0 |
| 2008-08-08 16:00:00 | MSFT | Stock | 28.09 | 28.13 | 27.96 | 28.08 | 4569567.0 |
| 2008-08-08 16:30:00 | MSFT | Stock | 28.06 | 28.06 | 27.31 | 27.31 | 600.0 |
| 2008-08-08 17:00:00 | MSFT | Stock | 28.06 | 28.07 | 28.01 | 28.07 | 2800.0 |
| 2008-08-08 17:30:00 | MSFT | Stock | 28.07 | 28.07 | 28.07 | 28.07 | 100.0 |
| 2008-08-08 18:00:00 | MSFT | Stock | 28.07 | 28.07 | 28.07 | 28.07 | 500.0 |
| 2008-08-08 18:30:00 | MSFT | Stock | 28.07 | 28.08 | 28.07 | 28.08 | 1412.0 |
| 2008-08-08 19:00:00 | MSFT | Stock | 28.09 | 28.09 | 28.09 | 28.09 | 200.0 |
> showing 50 of 69,287 rows — these rows as CSV