PREVIEW / stock_5min / 2000-09-19
file: by_date/stock_5min/2000/2000-09-19.parquet size: 1.2 MB rows: 92,096 symbols: 1,224
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 |
|---|---|---|---|---|---|---|---|
| 2000-09-19 08:00:00 | AAPL | Stock | 1.0536 | 1.0831 | 1.0536 | 1.0536 | 134400.0 |
| 2000-09-19 08:15:00 | AAPL | Stock | 1.0826 | 1.0826 | 1.0826 | 1.0826 | 39200.0 |
| 2000-09-19 08:25:00 | AAPL | Stock | 1.0558 | 1.0848 | 1.0558 | 1.0714 | 246400.0 |
| 2000-09-19 08:30:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.067 | 1.067 | 84000.0 |
| 2000-09-19 08:45:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.067 | 1.067 | 95200.0 |
| 2000-09-19 08:50:00 | AAPL | Stock | 1.067 | 1.0725 | 1.067 | 1.0714 | 263200.0 |
| 2000-09-19 08:55:00 | AAPL | Stock | 1.0804 | 1.0804 | 1.0742 | 1.0804 | 117600.0 |
| 2000-09-19 09:00:00 | AAPL | Stock | 1.0804 | 1.0804 | 1.0804 | 1.0804 | 145600.0 |
| 2000-09-19 09:05:00 | AAPL | Stock | 1.0804 | 1.0804 | 1.0804 | 1.0804 | 100800.0 |
| 2000-09-19 09:10:00 | AAPL | Stock | 1.0737 | 1.0759 | 1.0737 | 1.0737 | 112000.0 |
| 2000-09-19 09:15:00 | AAPL | Stock | 1.0804 | 1.0804 | 1.0737 | 1.0759 | 257600.0 |
| 2000-09-19 09:20:00 | AAPL | Stock | 1.0759 | 1.077 | 1.0714 | 1.0748 | 436800.0 |
| 2000-09-19 09:25:00 | AAPL | Stock | 1.0748 | 1.0748 | 1.0681 | 1.0681 | 644000.0 |
| 2000-09-19 09:30:00 | AAPL | Stock | 1.067 | 1.0714 | 1.0491 | 1.0536 | 11278400.0 |
| 2000-09-19 09:35:00 | AAPL | Stock | 1.0536 | 1.0647 | 1.0458 | 1.0469 | 8360800.0 |
| 2000-09-19 09:40:00 | AAPL | Stock | 1.0458 | 1.058 | 1.0458 | 1.058 | 5633600.0 |
| 2000-09-19 09:45:00 | AAPL | Stock | 1.0569 | 1.0658 | 1.0569 | 1.0658 | 4995200.0 |
| 2000-09-19 09:50:00 | AAPL | Stock | 1.0658 | 1.0792 | 1.0636 | 1.0748 | 9049600.0 |
| 2000-09-19 09:55:00 | AAPL | Stock | 1.0748 | 1.0792 | 1.0692 | 1.0692 | 5443200.0 |
| 2000-09-19 10:00:00 | AAPL | Stock | 1.0692 | 1.0703 | 1.0681 | 1.0692 | 2912000.0 |
| 2000-09-19 10:05:00 | AAPL | Stock | 1.0692 | 1.0737 | 1.0681 | 1.0692 | 6994400.0 |
| 2000-09-19 10:10:00 | AAPL | Stock | 1.0692 | 1.0703 | 1.0658 | 1.0658 | 3785600.0 |
| 2000-09-19 10:15:00 | AAPL | Stock | 1.0658 | 1.0692 | 1.0592 | 1.0592 | 4838400.0 |
| 2000-09-19 10:20:00 | AAPL | Stock | 1.0592 | 1.0636 | 1.0513 | 1.0558 | 4177600.0 |
| 2000-09-19 10:25:00 | AAPL | Stock | 1.0558 | 1.0625 | 1.0558 | 1.0592 | 4384800.0 |
| 2000-09-19 10:30:00 | AAPL | Stock | 1.058 | 1.0614 | 1.058 | 1.0603 | 2290400.0 |
| 2000-09-19 10:35:00 | AAPL | Stock | 1.0592 | 1.0603 | 1.0536 | 1.0592 | 2279200.0 |
| 2000-09-19 10:40:00 | AAPL | Stock | 1.0603 | 1.0603 | 1.0536 | 1.0558 | 1926400.0 |
| 2000-09-19 10:45:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0458 | 1.0491 | 3085600.0 |
| 2000-09-19 10:50:00 | AAPL | Stock | 1.048 | 1.0558 | 1.0469 | 1.0525 | 3914400.0 |
| 2000-09-19 10:55:00 | AAPL | Stock | 1.0513 | 1.0625 | 1.0513 | 1.0625 | 4261600.0 |
| 2000-09-19 11:00:00 | AAPL | Stock | 1.0625 | 1.0714 | 1.0603 | 1.0714 | 6423200.0 |
| 2000-09-19 11:05:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.0636 | 1.0686 | 2514400.0 |
| 2000-09-19 11:10:00 | AAPL | Stock | 1.0686 | 1.0804 | 1.0686 | 1.0748 | 7840000.0 |
| 2000-09-19 11:15:00 | AAPL | Stock | 1.0759 | 1.0759 | 1.0681 | 1.0692 | 7604800.0 |
| 2000-09-19 11:20:00 | AAPL | Stock | 1.0692 | 1.0737 | 1.0681 | 1.0709 | 3169600.0 |
| 2000-09-19 11:25:00 | AAPL | Stock | 1.0703 | 1.0714 | 1.0692 | 1.0703 | 2262400.0 |
| 2000-09-19 11:30:00 | AAPL | Stock | 1.0714 | 1.077 | 1.0692 | 1.0725 | 2710400.0 |
| 2000-09-19 11:35:00 | AAPL | Stock | 1.0714 | 1.0737 | 1.0681 | 1.0692 | 2262400.0 |
| 2000-09-19 11:40:00 | AAPL | Stock | 1.0686 | 1.0703 | 1.0681 | 1.0703 | 1512000.0 |
| 2000-09-19 11:45:00 | AAPL | Stock | 1.0692 | 1.0703 | 1.067 | 1.0703 | 2128000.0 |
| 2000-09-19 11:50:00 | AAPL | Stock | 1.0703 | 1.0714 | 1.0692 | 1.0692 | 2458400.0 |
| 2000-09-19 11:55:00 | AAPL | Stock | 1.0703 | 1.0714 | 1.0692 | 1.0709 | 1148000.0 |
| 2000-09-19 12:00:00 | AAPL | Stock | 1.0703 | 1.0714 | 1.0692 | 1.0714 | 750400.0 |
| 2000-09-19 12:05:00 | AAPL | Stock | 1.0692 | 1.0714 | 1.0692 | 1.0703 | 2850400.0 |
| 2000-09-19 12:10:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.0692 | 1.0692 | 1226400.0 |
| 2000-09-19 12:15:00 | AAPL | Stock | 1.0692 | 1.0698 | 1.0658 | 1.067 | 991200.0 |
| 2000-09-19 12:20:00 | AAPL | Stock | 1.067 | 1.067 | 1.0625 | 1.0625 | 1159200.0 |
| 2000-09-19 12:25:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0603 | 1.0603 | 2290400.0 |
| 2000-09-19 12:30:00 | AAPL | Stock | 1.0614 | 1.0614 | 1.0592 | 1.0592 | 1590400.0 |
> showing 50 of 92,096 rows — these rows as CSV