PREVIEW / stock_30min / 2005-08-24
file: by_date/stock_30min/2005/2005-08-24.parquet size: 830 KB rows: 44,775 symbols: 2,064
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-24 08:00:00 | AAPL | Stock | 1.625 | 1.6279 | 1.6232 | 1.6279 | 116760.0 |
| 2005-08-24 08:30:00 | AAPL | Stock | 1.6275 | 1.6336 | 1.625 | 1.6336 | 855064.0 |
| 2005-08-24 09:00:00 | AAPL | Stock | 1.6254 | 1.6289 | 1.6232 | 1.6286 | 661388.0 |
| 2005-08-24 09:30:00 | AAPL | Stock | 1.6286 | 1.6539 | 1.6282 | 1.6511 | 79177224.0 |
| 2005-08-24 10:00:00 | AAPL | Stock | 1.6511 | 1.6604 | 1.6457 | 1.6496 | 48599964.0 |
| 2005-08-24 10:30:00 | AAPL | Stock | 1.6504 | 1.6771 | 1.6486 | 1.6711 | 70477932.0 |
| 2005-08-24 11:00:00 | AAPL | Stock | 1.6711 | 1.6768 | 1.6664 | 1.6711 | 43104740.0 |
| 2005-08-24 11:30:00 | AAPL | Stock | 1.6711 | 1.6768 | 1.6679 | 1.6764 | 30440508.0 |
| 2005-08-24 12:00:00 | AAPL | Stock | 1.6761 | 1.6786 | 1.6714 | 1.6786 | 26058172.0 |
| 2005-08-24 12:30:00 | AAPL | Stock | 1.6782 | 1.6829 | 1.6757 | 1.6782 | 38668700.0 |
| 2005-08-24 13:00:00 | AAPL | Stock | 1.6768 | 1.6786 | 1.6697 | 1.6718 | 22825180.0 |
| 2005-08-24 13:30:00 | AAPL | Stock | 1.6718 | 1.6739 | 1.6625 | 1.6671 | 27413260.0 |
| 2005-08-24 14:00:00 | AAPL | Stock | 1.6671 | 1.67 | 1.6571 | 1.665 | 32200616.0 |
| 2005-08-24 14:30:00 | AAPL | Stock | 1.665 | 1.6654 | 1.6532 | 1.6536 | 23489956.0 |
| 2005-08-24 15:00:00 | AAPL | Stock | 1.6536 | 1.6557 | 1.6336 | 1.6411 | 57983408.0 |
| 2005-08-24 15:30:00 | AAPL | Stock | 1.6407 | 1.6454 | 1.6296 | 1.635 | 59547796.0 |
| 2005-08-24 16:00:00 | AAPL | Stock | 1.6368 | 1.6382 | 1.6316 | 1.6357 | 2682960.0 |
| 2005-08-24 16:30:00 | AAPL | Stock | 1.6354 | 1.6379 | 1.6346 | 1.6379 | 420392.0 |
| 2005-08-24 17:00:00 | AAPL | Stock | 1.6361 | 1.6393 | 1.6361 | 1.6386 | 66220.0 |
| 2005-08-24 17:30:00 | AAPL | Stock | 1.6375 | 1.6379 | 1.6361 | 1.6361 | 155400.0 |
| 2005-08-24 18:00:00 | AAPL | Stock | 1.6393 | 1.6393 | 1.6375 | 1.6375 | 99540.0 |
| 2005-08-24 08:00:00 | MSFT | Stock | 26.8 | 26.87 | 26.78 | 26.87 | 2255095.0 |
| 2005-08-24 08:30:00 | MSFT | Stock | 26.8 | 26.87 | 26.76 | 26.87 | 48569.0 |
| 2005-08-24 09:00:00 | MSFT | Stock | 26.78 | 26.86 | 26.78 | 26.84 | 24165.0 |
| 2005-08-24 09:30:00 | MSFT | Stock | 26.84 | 27.0 | 26.81 | 26.98 | 4039332.0 |
| 2005-08-24 10:00:00 | MSFT | Stock | 26.98 | 27.04 | 26.96 | 26.979 | 3138450.0 |
| 2005-08-24 10:30:00 | MSFT | Stock | 26.98 | 27.12 | 26.97 | 27.09 | 5370622.0 |
| 2005-08-24 11:00:00 | MSFT | Stock | 27.09 | 27.1 | 27.01 | 27.08 | 2721372.0 |
| 2005-08-24 11:30:00 | MSFT | Stock | 27.08 | 27.16 | 27.02 | 27.15 | 3541260.0 |
| 2005-08-24 12:00:00 | MSFT | Stock | 27.14 | 27.15 | 27.09 | 27.14 | 1884211.0 |
| 2005-08-24 12:30:00 | MSFT | Stock | 27.14 | 27.15 | 27.08 | 27.081 | 1515478.0 |
| 2005-08-24 13:00:00 | MSFT | Stock | 27.08 | 27.13 | 27.03 | 27.1 | 4094993.0 |
| 2005-08-24 13:30:00 | MSFT | Stock | 27.1 | 27.13 | 27.06 | 27.112 | 2194633.0 |
| 2005-08-24 14:00:00 | MSFT | Stock | 27.12 | 27.13 | 27.05 | 27.07 | 2445693.0 |
| 2005-08-24 14:30:00 | MSFT | Stock | 27.07 | 27.09 | 26.93 | 26.96 | 4263017.0 |
| 2005-08-24 15:00:00 | MSFT | Stock | 26.96 | 27.06 | 26.78 | 26.83 | 8067522.0 |
| 2005-08-24 15:30:00 | MSFT | Stock | 26.83 | 27.049 | 26.8 | 26.81 | 10683125.0 |
| 2005-08-24 16:00:00 | MSFT | Stock | 26.81 | 26.82 | 26.78 | 26.78 | 476974.0 |
| 2005-08-24 16:30:00 | MSFT | Stock | 26.8 | 26.81 | 26.78 | 26.81 | 60660.0 |
| 2005-08-24 17:00:00 | MSFT | Stock | 26.78 | 26.81 | 26.78 | 26.79 | 301500.0 |
| 2005-08-24 17:30:00 | MSFT | Stock | 26.81 | 26.81 | 26.8 | 26.81 | 655900.0 |
| 2005-08-24 18:00:00 | MSFT | Stock | 26.81 | 26.86 | 26.8 | 26.81 | 3000.0 |
| 2005-08-24 08:00:00 | NVDA | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 12480.0 |
| 2005-08-24 08:30:00 | NVDA | Stock | 0.2397 | 0.2429 | 0.2397 | 0.2429 | 12336000.0 |
| 2005-08-24 09:00:00 | NVDA | Stock | 0.2416 | 0.2422 | 0.2412 | 0.2416 | 180000.0 |
| 2005-08-24 09:30:00 | NVDA | Stock | 0.2413 | 0.2421 | 0.2402 | 0.2419 | 37952520.0 |
| 2005-08-24 10:00:00 | NVDA | Stock | 0.2419 | 0.2452 | 0.2415 | 0.2432 | 56522520.0 |
| 2005-08-24 10:30:00 | NVDA | Stock | 0.2432 | 0.245 | 0.2421 | 0.2448 | 40540440.0 |
| 2005-08-24 11:00:00 | NVDA | Stock | 0.2448 | 0.2458 | 0.2444 | 0.2455 | 30854640.0 |
| 2005-08-24 11:30:00 | NVDA | Stock | 0.2456 | 0.2457 | 0.2442 | 0.2454 | 23863200.0 |
> showing 50 of 44,775 rows — these rows as CSV