PREVIEW / stock_5min / 2014-02-24
file: by_date/stock_5min/2014/2014-02-24.parquet size: 5.6 MB rows: 363,130 symbols: 3,548
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-24 04:00:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7786 | 18.7786 | 14000.0 |
| 2014-02-24 04:05:00 | AAPL | Stock | 18.775 | 18.775 | 18.775 | 18.775 | 5600.0 |
| 2014-02-24 04:10:00 | AAPL | Stock | 18.7671 | 18.7754 | 18.7671 | 18.7754 | 39200.0 |
| 2014-02-24 04:35:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7714 | 18.7714 | 5600.0 |
| 2014-02-24 04:45:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 5600.0 |
| 2014-02-24 04:50:00 | AAPL | Stock | 18.7468 | 18.7468 | 18.7468 | 18.7468 | 2800.0 |
| 2014-02-24 04:55:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2014-02-24 05:05:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.6907 | 18.6907 | 2800.0 |
| 2014-02-24 06:00:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.69 | 18.69 | 5600.0 |
| 2014-02-24 06:05:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.6907 | 18.6907 | 2800.0 |
| 2014-02-24 06:10:00 | AAPL | Stock | 18.6818 | 18.6821 | 18.6736 | 18.6736 | 16800.0 |
| 2014-02-24 06:15:00 | AAPL | Stock | 18.6732 | 18.6732 | 18.6661 | 18.6661 | 8400.0 |
| 2014-02-24 06:25:00 | AAPL | Stock | 18.65 | 18.65 | 18.6446 | 18.6482 | 53200.0 |
| 2014-02-24 06:30:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6368 | 18.6368 | 11200.0 |
| 2014-02-24 06:50:00 | AAPL | Stock | 18.6432 | 18.6446 | 18.6432 | 18.6446 | 5600.0 |
| 2014-02-24 06:55:00 | AAPL | Stock | 18.6586 | 18.6643 | 18.6586 | 18.6643 | 39900.0 |
| 2014-02-24 07:00:00 | AAPL | Stock | 18.6711 | 18.6882 | 18.6711 | 18.6882 | 50400.0 |
| 2014-02-24 07:05:00 | AAPL | Stock | 18.7143 | 18.7211 | 18.7143 | 18.7211 | 58800.0 |
| 2014-02-24 07:10:00 | AAPL | Stock | 18.6968 | 18.6968 | 18.6968 | 18.6968 | 2800.0 |
| 2014-02-24 07:20:00 | AAPL | Stock | 18.7029 | 18.7136 | 18.6929 | 18.6929 | 61964.0 |
| 2014-02-24 07:30:00 | AAPL | Stock | 18.6946 | 18.6979 | 18.6946 | 18.6979 | 5600.0 |
| 2014-02-24 07:35:00 | AAPL | Stock | 18.7111 | 18.7143 | 18.7111 | 18.7143 | 45976.0 |
| 2014-02-24 07:40:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7082 | 18.7082 | 95676.0 |
| 2014-02-24 07:45:00 | AAPL | Stock | 18.6986 | 18.6986 | 18.6786 | 18.6786 | 27104.0 |
| 2014-02-24 07:50:00 | AAPL | Stock | 18.6771 | 18.6796 | 18.6643 | 18.6796 | 26152.0 |
| 2014-02-24 07:55:00 | AAPL | Stock | 18.6789 | 18.7157 | 18.6789 | 18.7143 | 175504.0 |
| 2014-02-24 08:00:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.6521 | 18.6696 | 280028.0 |
| 2014-02-24 08:05:00 | AAPL | Stock | 18.655 | 18.6786 | 18.655 | 18.6696 | 78820.0 |
| 2014-02-24 08:10:00 | AAPL | Stock | 18.6743 | 18.6775 | 18.6696 | 18.6725 | 16800.0 |
| 2014-02-24 08:15:00 | AAPL | Stock | 18.6696 | 18.6775 | 18.6614 | 18.6775 | 55412.0 |
| 2014-02-24 08:20:00 | AAPL | Stock | 18.6761 | 18.7075 | 18.6761 | 18.7054 | 233128.0 |
| 2014-02-24 08:25:00 | AAPL | Stock | 18.7086 | 18.7218 | 18.7068 | 18.7161 | 162624.0 |
| 2014-02-24 08:30:00 | AAPL | Stock | 18.7143 | 18.7157 | 18.71 | 18.71 | 16240.0 |
| 2014-02-24 08:35:00 | AAPL | Stock | 18.71 | 18.71 | 18.7054 | 18.7054 | 14000.0 |
| 2014-02-24 08:40:00 | AAPL | Stock | 18.7054 | 18.7054 | 18.7029 | 18.7029 | 8400.0 |
| 2014-02-24 08:45:00 | AAPL | Stock | 18.7021 | 18.7089 | 18.7021 | 18.7021 | 56112.0 |
| 2014-02-24 08:50:00 | AAPL | Stock | 18.7004 | 18.7004 | 18.6982 | 18.6982 | 29540.0 |
| 2014-02-24 08:55:00 | AAPL | Stock | 18.6982 | 18.7143 | 18.6961 | 18.7107 | 181300.0 |
| 2014-02-24 09:00:00 | AAPL | Stock | 18.7057 | 18.7143 | 18.6986 | 18.7143 | 18760.0 |
| 2014-02-24 09:05:00 | AAPL | Stock | 18.7007 | 18.7236 | 18.7 | 18.715 | 135660.0 |
| 2014-02-24 09:10:00 | AAPL | Stock | 18.715 | 18.7193 | 18.7125 | 18.7143 | 109368.0 |
| 2014-02-24 09:15:00 | AAPL | Stock | 18.7129 | 18.715 | 18.7121 | 18.715 | 79828.0 |
| 2014-02-24 09:20:00 | AAPL | Stock | 18.7093 | 18.7146 | 18.7054 | 18.7146 | 25200.0 |
| 2014-02-24 09:25:00 | AAPL | Stock | 18.7157 | 18.7157 | 18.6814 | 18.6829 | 386120.0 |
| 2014-02-24 09:30:00 | AAPL | Stock | 18.6836 | 18.7699 | 18.6579 | 18.739 | 19510036.0 |
| 2014-02-24 09:35:00 | AAPL | Stock | 18.7254 | 18.8064 | 18.7232 | 18.7868 | 9244872.0 |
| 2014-02-24 09:40:00 | AAPL | Stock | 18.79 | 18.8092 | 18.7714 | 18.7952 | 4325244.0 |
| 2014-02-24 09:45:00 | AAPL | Stock | 18.7961 | 18.8654 | 18.7952 | 18.8405 | 7114968.0 |
| 2014-02-24 09:50:00 | AAPL | Stock | 18.8398 | 18.8864 | 18.8386 | 18.8529 | 5937904.0 |
| 2014-02-24 09:55:00 | AAPL | Stock | 18.8543 | 18.8825 | 18.8418 | 18.8768 | 3645376.0 |
> showing 50 of 363,130 rows — these rows as CSV