PREVIEW / stock_5min / 2001-03-23
file: by_date/stock_5min/2001/2001-03-23.parquet size: 1.5 MB rows: 102,197 symbols: 1,283
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-23 08:00:00 | AAPL | Stock | 0.3951 | 0.3973 | 0.3862 | 0.3929 | 845600.0 |
| 2001-03-23 08:05:00 | AAPL | Stock | 0.3973 | 0.4007 | 0.3973 | 0.4007 | 952000.0 |
| 2001-03-23 08:10:00 | AAPL | Stock | 0.4018 | 0.4018 | 0.3973 | 0.3973 | 112000.0 |
| 2001-03-23 08:15:00 | AAPL | Stock | 0.3951 | 0.3973 | 0.3951 | 0.3973 | 44800.0 |
| 2001-03-23 08:20:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 106400.0 |
| 2001-03-23 08:25:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 134400.0 |
| 2001-03-23 08:35:00 | AAPL | Stock | 0.4001 | 0.4012 | 0.3996 | 0.4007 | 229600.0 |
| 2001-03-23 08:40:00 | AAPL | Stock | 0.4012 | 0.4012 | 0.4007 | 0.4007 | 201600.0 |
| 2001-03-23 08:45:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.3996 | 0.3996 | 285600.0 |
| 2001-03-23 08:50:00 | AAPL | Stock | 0.3996 | 0.3996 | 0.3973 | 0.3973 | 492800.0 |
| 2001-03-23 08:55:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3962 | 0.3962 | 408800.0 |
| 2001-03-23 09:00:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.3962 | 0.3962 | 229600.0 |
| 2001-03-23 09:05:00 | AAPL | Stock | 0.3951 | 0.3962 | 0.3929 | 0.3929 | 224000.0 |
| 2001-03-23 09:10:00 | AAPL | Stock | 0.3951 | 0.3984 | 0.3929 | 0.3984 | 313600.0 |
| 2001-03-23 09:15:00 | AAPL | Stock | 0.3973 | 0.3996 | 0.3929 | 0.3929 | 1450400.0 |
| 2001-03-23 09:20:00 | AAPL | Stock | 0.3951 | 0.3951 | 0.3929 | 0.3951 | 207200.0 |
| 2001-03-23 09:25:00 | AAPL | Stock | 0.3929 | 0.3951 | 0.3929 | 0.394 | 1881600.0 |
| 2001-03-23 09:30:00 | AAPL | Stock | 0.394 | 0.4018 | 0.3929 | 0.4018 | 30004800.0 |
| 2001-03-23 09:35:00 | AAPL | Stock | 0.4018 | 0.4063 | 0.3973 | 0.404 | 43411200.0 |
| 2001-03-23 09:40:00 | AAPL | Stock | 0.404 | 0.4063 | 0.4018 | 0.4018 | 31914400.0 |
| 2001-03-23 09:45:00 | AAPL | Stock | 0.4018 | 0.4051 | 0.3984 | 0.3984 | 15937600.0 |
| 2001-03-23 09:50:00 | AAPL | Stock | 0.3996 | 0.3996 | 0.3951 | 0.3973 | 7610400.0 |
| 2001-03-23 09:55:00 | AAPL | Stock | 0.3973 | 0.4007 | 0.3962 | 0.3996 | 16822400.0 |
| 2001-03-23 10:00:00 | AAPL | Stock | 0.3984 | 0.4063 | 0.3973 | 0.4063 | 18995200.0 |
| 2001-03-23 10:05:00 | AAPL | Stock | 0.4063 | 0.4074 | 0.404 | 0.4063 | 19577600.0 |
| 2001-03-23 10:10:00 | AAPL | Stock | 0.4063 | 0.4085 | 0.4029 | 0.4085 | 17578400.0 |
| 2001-03-23 10:15:00 | AAPL | Stock | 0.4085 | 0.4107 | 0.4051 | 0.4051 | 11435200.0 |
| 2001-03-23 10:20:00 | AAPL | Stock | 0.4051 | 0.4051 | 0.4018 | 0.4018 | 17595200.0 |
| 2001-03-23 10:25:00 | AAPL | Stock | 0.4018 | 0.4063 | 0.4018 | 0.404 | 11648000.0 |
| 2001-03-23 10:30:00 | AAPL | Stock | 0.404 | 0.4063 | 0.4029 | 0.404 | 6188000.0 |
| 2001-03-23 10:35:00 | AAPL | Stock | 0.404 | 0.4063 | 0.4029 | 0.4051 | 6792800.0 |
| 2001-03-23 10:40:00 | AAPL | Stock | 0.4051 | 0.4074 | 0.404 | 0.4063 | 9559200.0 |
| 2001-03-23 10:45:00 | AAPL | Stock | 0.4063 | 0.4085 | 0.4051 | 0.4085 | 10684800.0 |
| 2001-03-23 10:50:00 | AAPL | Stock | 0.4085 | 0.4085 | 0.4063 | 0.4063 | 11468800.0 |
| 2001-03-23 10:55:00 | AAPL | Stock | 0.4063 | 0.4085 | 0.4051 | 0.4085 | 9240000.0 |
| 2001-03-23 11:00:00 | AAPL | Stock | 0.4085 | 0.4096 | 0.4074 | 0.4096 | 8657600.0 |
| 2001-03-23 11:05:00 | AAPL | Stock | 0.4096 | 0.4118 | 0.4085 | 0.4118 | 34344800.0 |
| 2001-03-23 11:10:00 | AAPL | Stock | 0.4096 | 0.4118 | 0.4051 | 0.4051 | 15030400.0 |
| 2001-03-23 11:15:00 | AAPL | Stock | 0.4063 | 0.4074 | 0.404 | 0.4063 | 4519200.0 |
| 2001-03-23 11:20:00 | AAPL | Stock | 0.4063 | 0.4074 | 0.4051 | 0.4051 | 3936800.0 |
| 2001-03-23 11:25:00 | AAPL | Stock | 0.4057 | 0.4063 | 0.4029 | 0.4051 | 8243200.0 |
| 2001-03-23 11:30:00 | AAPL | Stock | 0.404 | 0.4063 | 0.404 | 0.4063 | 2195200.0 |
| 2001-03-23 11:35:00 | AAPL | Stock | 0.4051 | 0.4074 | 0.404 | 0.4051 | 5975200.0 |
| 2001-03-23 11:40:00 | AAPL | Stock | 0.404 | 0.4063 | 0.404 | 0.404 | 5432000.0 |
| 2001-03-23 11:45:00 | AAPL | Stock | 0.4051 | 0.4051 | 0.4029 | 0.4051 | 3500000.0 |
| 2001-03-23 11:50:00 | AAPL | Stock | 0.4051 | 0.4063 | 0.4029 | 0.4063 | 11793600.0 |
| 2001-03-23 11:55:00 | AAPL | Stock | 0.4029 | 0.4063 | 0.4029 | 0.404 | 4026400.0 |
| 2001-03-23 12:00:00 | AAPL | Stock | 0.404 | 0.4051 | 0.4018 | 0.4018 | 8069600.0 |
| 2001-03-23 12:05:00 | AAPL | Stock | 0.4018 | 0.404 | 0.4018 | 0.4029 | 9100000.0 |
| 2001-03-23 12:10:00 | AAPL | Stock | 0.4029 | 0.404 | 0.3996 | 0.4018 | 2973600.0 |
> showing 50 of 102,197 rows — these rows as CSV