PREVIEW / stock_5min / 2001-03-06
file: by_date/stock_5min/2001/2001-03-06.parquet size: 1.4 MB rows: 99,137 symbols: 1,270
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-06 08:00:00 | AAPL | Stock | 0.3633 | 0.3633 | 0.3633 | 0.3633 | 1467200.0 |
| 2001-03-06 08:05:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 196000.0 |
| 2001-03-06 08:10:00 | AAPL | Stock | 0.365 | 0.3795 | 0.365 | 0.3772 | 252000.0 |
| 2001-03-06 08:15:00 | AAPL | Stock | 0.3756 | 0.3795 | 0.3756 | 0.3795 | 84000.0 |
| 2001-03-06 08:20:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3772 | 0.3772 | 50400.0 |
| 2001-03-06 08:25:00 | AAPL | Stock | 0.3772 | 0.3772 | 0.3772 | 0.3772 | 168000.0 |
| 2001-03-06 08:30:00 | AAPL | Stock | 0.3783 | 0.3783 | 0.3783 | 0.3783 | 5600.0 |
| 2001-03-06 08:35:00 | AAPL | Stock | 0.3705 | 0.3717 | 0.3672 | 0.3717 | 61600.0 |
| 2001-03-06 08:45:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3683 | 0.3683 | 117600.0 |
| 2001-03-06 08:50:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 39200.0 |
| 2001-03-06 08:55:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 39200.0 |
| 2001-03-06 09:00:00 | AAPL | Stock | 0.3717 | 0.3717 | 0.3717 | 0.3717 | 5600.0 |
| 2001-03-06 09:05:00 | AAPL | Stock | 0.3728 | 0.3728 | 0.3717 | 0.3728 | 123200.0 |
| 2001-03-06 09:10:00 | AAPL | Stock | 0.3728 | 0.3728 | 0.3728 | 0.3728 | 33600.0 |
| 2001-03-06 09:15:00 | AAPL | Stock | 0.3728 | 0.3728 | 0.3705 | 0.3705 | 229600.0 |
| 2001-03-06 09:20:00 | AAPL | Stock | 0.3694 | 0.3705 | 0.3683 | 0.3683 | 296800.0 |
| 2001-03-06 09:25:00 | AAPL | Stock | 0.3683 | 0.3705 | 0.3683 | 0.3694 | 722400.0 |
| 2001-03-06 09:30:00 | AAPL | Stock | 0.37 | 0.375 | 0.3694 | 0.3728 | 18720800.0 |
| 2001-03-06 09:35:00 | AAPL | Stock | 0.3728 | 0.3783 | 0.3728 | 0.3761 | 31186400.0 |
| 2001-03-06 09:40:00 | AAPL | Stock | 0.3761 | 0.3817 | 0.3761 | 0.3806 | 9923200.0 |
| 2001-03-06 09:45:00 | AAPL | Stock | 0.3817 | 0.3828 | 0.3728 | 0.3817 | 24315200.0 |
| 2001-03-06 09:50:00 | AAPL | Stock | 0.3817 | 0.3828 | 0.3817 | 0.3828 | 6927200.0 |
| 2001-03-06 09:55:00 | AAPL | Stock | 0.3828 | 0.3895 | 0.3817 | 0.3895 | 15293600.0 |
| 2001-03-06 10:00:00 | AAPL | Stock | 0.3895 | 0.3917 | 0.3873 | 0.3906 | 22002400.0 |
| 2001-03-06 10:05:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3895 | 0.3917 | 16900800.0 |
| 2001-03-06 10:10:00 | AAPL | Stock | 0.3917 | 0.3929 | 0.3895 | 0.3917 | 14112000.0 |
| 2001-03-06 10:15:00 | AAPL | Stock | 0.3917 | 0.394 | 0.3906 | 0.3929 | 18552800.0 |
| 2001-03-06 10:20:00 | AAPL | Stock | 0.3929 | 0.394 | 0.3906 | 0.3906 | 8988000.0 |
| 2001-03-06 10:25:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3906 | 0.3906 | 13451200.0 |
| 2001-03-06 10:30:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3895 | 0.3929 | 6664000.0 |
| 2001-03-06 10:35:00 | AAPL | Stock | 0.3917 | 0.3929 | 0.3917 | 0.3917 | 5084800.0 |
| 2001-03-06 10:40:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3906 | 0.3917 | 17259200.0 |
| 2001-03-06 10:45:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3906 | 0.3906 | 2245600.0 |
| 2001-03-06 10:50:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3884 | 0.3895 | 14845600.0 |
| 2001-03-06 10:55:00 | AAPL | Stock | 0.3884 | 0.3906 | 0.3884 | 0.3895 | 5219200.0 |
| 2001-03-06 11:00:00 | AAPL | Stock | 0.3884 | 0.3895 | 0.385 | 0.3862 | 8254400.0 |
| 2001-03-06 11:05:00 | AAPL | Stock | 0.3862 | 0.3884 | 0.3839 | 0.3884 | 40784800.0 |
| 2001-03-06 11:10:00 | AAPL | Stock | 0.3873 | 0.3884 | 0.385 | 0.3862 | 9004800.0 |
| 2001-03-06 11:15:00 | AAPL | Stock | 0.385 | 0.3884 | 0.3817 | 0.3817 | 20535200.0 |
| 2001-03-06 11:20:00 | AAPL | Stock | 0.3828 | 0.3839 | 0.3817 | 0.3817 | 14968800.0 |
| 2001-03-06 11:25:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3783 | 0.3795 | 12583200.0 |
| 2001-03-06 11:30:00 | AAPL | Stock | 0.3783 | 0.3828 | 0.3783 | 0.3817 | 2615200.0 |
| 2001-03-06 11:35:00 | AAPL | Stock | 0.3817 | 0.3828 | 0.3806 | 0.3817 | 9200800.0 |
| 2001-03-06 11:40:00 | AAPL | Stock | 0.3806 | 0.3806 | 0.3795 | 0.3806 | 3701600.0 |
| 2001-03-06 11:45:00 | AAPL | Stock | 0.3806 | 0.3828 | 0.3795 | 0.3823 | 14834400.0 |
| 2001-03-06 11:50:00 | AAPL | Stock | 0.3817 | 0.3839 | 0.3806 | 0.3828 | 6865600.0 |
| 2001-03-06 11:55:00 | AAPL | Stock | 0.3828 | 0.3828 | 0.3806 | 0.3806 | 3740800.0 |
| 2001-03-06 12:00:00 | AAPL | Stock | 0.3817 | 0.3828 | 0.3806 | 0.3817 | 6087200.0 |
| 2001-03-06 12:05:00 | AAPL | Stock | 0.3828 | 0.3828 | 0.3806 | 0.3806 | 2525600.0 |
| 2001-03-06 12:10:00 | AAPL | Stock | 0.3817 | 0.3839 | 0.3806 | 0.3828 | 4116000.0 |
> showing 50 of 99,137 rows — these rows as CSV