PREVIEW / stock_5min / 2013-02-01
file: by_date/stock_5min/2013/2013-02-01.parquet size: 5.0 MB rows: 337,733 symbols: 3,461
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-01 04:00:00 | AAPL | Stock | 16.3886 | 16.3929 | 16.3886 | 16.3929 | 14000.0 |
| 2013-02-01 04:55:00 | AAPL | Stock | 16.3907 | 16.3907 | 16.3907 | 16.3907 | 2800.0 |
| 2013-02-01 06:05:00 | AAPL | Stock | 16.3525 | 16.3525 | 16.3525 | 16.3525 | 2800.0 |
| 2013-02-01 06:10:00 | AAPL | Stock | 16.3525 | 16.3525 | 16.3525 | 16.3525 | 2800.0 |
| 2013-02-01 06:25:00 | AAPL | Stock | 16.3564 | 16.3564 | 16.3564 | 16.3564 | 5600.0 |
| 2013-02-01 06:35:00 | AAPL | Stock | 16.3429 | 16.3429 | 16.3429 | 16.3429 | 2800.0 |
| 2013-02-01 06:45:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 2800.0 |
| 2013-02-01 07:00:00 | AAPL | Stock | 16.3214 | 16.3571 | 16.3214 | 16.3571 | 26600.0 |
| 2013-02-01 07:05:00 | AAPL | Stock | 16.3521 | 16.3521 | 16.3511 | 16.3511 | 8400.0 |
| 2013-02-01 07:10:00 | AAPL | Stock | 16.3571 | 16.3929 | 16.3571 | 16.3836 | 26040.0 |
| 2013-02-01 07:15:00 | AAPL | Stock | 16.3854 | 16.3854 | 16.385 | 16.385 | 11200.0 |
| 2013-02-01 07:20:00 | AAPL | Stock | 16.375 | 16.3929 | 16.3571 | 16.3929 | 128940.0 |
| 2013-02-01 07:30:00 | AAPL | Stock | 16.3929 | 16.3975 | 16.3929 | 16.3975 | 41440.0 |
| 2013-02-01 07:35:00 | AAPL | Stock | 16.3929 | 16.4007 | 16.3804 | 16.3925 | 75852.0 |
| 2013-02-01 07:40:00 | AAPL | Stock | 16.4018 | 16.4018 | 16.3929 | 16.3929 | 7700.0 |
| 2013-02-01 07:45:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3893 | 16.3893 | 22400.0 |
| 2013-02-01 07:50:00 | AAPL | Stock | 16.3886 | 16.3886 | 16.365 | 16.365 | 19600.0 |
| 2013-02-01 07:55:00 | AAPL | Stock | 16.37 | 16.37 | 16.3679 | 16.3679 | 11200.0 |
| 2013-02-01 08:00:00 | AAPL | Stock | 16.3661 | 16.3864 | 16.3571 | 16.3643 | 97860.0 |
| 2013-02-01 08:05:00 | AAPL | Stock | 16.3571 | 16.3879 | 16.3571 | 16.3714 | 50596.0 |
| 2013-02-01 08:10:00 | AAPL | Stock | 16.3714 | 16.3786 | 16.3571 | 16.3571 | 160468.0 |
| 2013-02-01 08:15:00 | AAPL | Stock | 16.3571 | 16.3689 | 16.3571 | 16.3596 | 123592.0 |
| 2013-02-01 08:20:00 | AAPL | Stock | 16.36 | 16.3746 | 16.3575 | 16.3746 | 80640.0 |
| 2013-02-01 08:25:00 | AAPL | Stock | 16.3589 | 16.3807 | 16.3571 | 16.3571 | 158732.0 |
| 2013-02-01 08:30:00 | AAPL | Stock | 16.3571 | 16.3993 | 16.325 | 16.3311 | 636552.0 |
| 2013-02-01 08:35:00 | AAPL | Stock | 16.3357 | 16.3657 | 16.3325 | 16.3568 | 154084.0 |
| 2013-02-01 08:40:00 | AAPL | Stock | 16.3571 | 16.3836 | 16.3571 | 16.3821 | 179396.0 |
| 2013-02-01 08:45:00 | AAPL | Stock | 16.3821 | 16.4089 | 16.3821 | 16.4018 | 470148.0 |
| 2013-02-01 08:50:00 | AAPL | Stock | 16.4068 | 16.4107 | 16.4036 | 16.4054 | 288708.0 |
| 2013-02-01 08:55:00 | AAPL | Stock | 16.41 | 16.4107 | 16.3929 | 16.3929 | 136836.0 |
| 2013-02-01 09:00:00 | AAPL | Stock | 16.3889 | 16.4018 | 16.3825 | 16.3825 | 253484.0 |
| 2013-02-01 09:05:00 | AAPL | Stock | 16.3804 | 16.41 | 16.3804 | 16.4089 | 159488.0 |
| 2013-02-01 09:10:00 | AAPL | Stock | 16.4089 | 16.4089 | 16.3889 | 16.3943 | 271460.0 |
| 2013-02-01 09:15:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3714 | 16.3714 | 213332.0 |
| 2013-02-01 09:20:00 | AAPL | Stock | 16.3782 | 16.3911 | 16.3782 | 16.3875 | 81340.0 |
| 2013-02-01 09:25:00 | AAPL | Stock | 16.3836 | 16.4079 | 16.3821 | 16.4079 | 370328.0 |
| 2013-02-01 09:30:00 | AAPL | Stock | 16.4075 | 16.41 | 16.2986 | 16.3168 | 17601052.0 |
| 2013-02-01 09:35:00 | AAPL | Stock | 16.315 | 16.33 | 16.2536 | 16.2568 | 15778028.0 |
| 2013-02-01 09:40:00 | AAPL | Stock | 16.2582 | 16.2782 | 16.1725 | 16.2207 | 19088496.0 |
| 2013-02-01 09:45:00 | AAPL | Stock | 16.2199 | 16.245 | 16.1607 | 16.1654 | 13207656.0 |
| 2013-02-01 09:50:00 | AAPL | Stock | 16.1668 | 16.2125 | 16.1464 | 16.1964 | 10114580.0 |
| 2013-02-01 09:55:00 | AAPL | Stock | 16.1932 | 16.2043 | 16.12 | 16.1332 | 9623544.0 |
| 2013-02-01 10:00:00 | AAPL | Stock | 16.135 | 16.2077 | 16.135 | 16.1996 | 8384404.0 |
| 2013-02-01 10:05:00 | AAPL | Stock | 16.2029 | 16.2246 | 16.1932 | 16.2057 | 8837248.0 |
| 2013-02-01 10:10:00 | AAPL | Stock | 16.2032 | 16.2129 | 16.1564 | 16.1821 | 6836928.0 |
| 2013-02-01 10:15:00 | AAPL | Stock | 16.1804 | 16.2064 | 16.1711 | 16.1773 | 4893980.0 |
| 2013-02-01 10:20:00 | AAPL | Stock | 16.1775 | 16.2111 | 16.1743 | 16.1889 | 3826172.0 |
| 2013-02-01 10:25:00 | AAPL | Stock | 16.1886 | 16.1918 | 16.1289 | 16.1396 | 9587900.0 |
| 2013-02-01 10:30:00 | AAPL | Stock | 16.1411 | 16.1557 | 16.0918 | 16.105 | 11177936.0 |
| 2013-02-01 10:35:00 | AAPL | Stock | 16.1046 | 16.1429 | 16.0968 | 16.1061 | 7191520.0 |
> showing 50 of 337,733 rows — these rows as CSV