PREVIEW / stock_5min / 2010-03-09
file: by_date/stock_5min/2010/2010-03-09.parquet size: 4.8 MB rows: 324,383 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 |
|---|---|---|---|---|---|---|---|
| 2010-03-09 05:50:00 | AAPL | Stock | 7.7857 | 7.7857 | 7.7857 | 7.7857 | 5628.0 |
| 2010-03-09 06:55:00 | AAPL | Stock | 7.785 | 7.785 | 7.785 | 7.785 | 2800.0 |
| 2010-03-09 07:00:00 | AAPL | Stock | 7.7686 | 7.7768 | 7.7686 | 7.7768 | 62328.0 |
| 2010-03-09 07:05:00 | AAPL | Stock | 7.7689 | 7.7811 | 7.7689 | 7.7811 | 21280.0 |
| 2010-03-09 07:15:00 | AAPL | Stock | 7.7864 | 7.7864 | 7.7864 | 7.7864 | 2800.0 |
| 2010-03-09 07:20:00 | AAPL | Stock | 7.7861 | 7.7861 | 7.7861 | 7.7861 | 2800.0 |
| 2010-03-09 07:40:00 | AAPL | Stock | 7.7961 | 7.7961 | 7.7961 | 7.7961 | 7000.0 |
| 2010-03-09 07:45:00 | AAPL | Stock | 7.7946 | 7.7946 | 7.7946 | 7.7946 | 11200.0 |
| 2010-03-09 07:50:00 | AAPL | Stock | 7.7979 | 7.7982 | 7.7929 | 7.7929 | 15400.0 |
| 2010-03-09 07:55:00 | AAPL | Stock | 7.7932 | 7.7982 | 7.7932 | 7.7964 | 11200.0 |
| 2010-03-09 08:00:00 | AAPL | Stock | 7.7993 | 7.7993 | 7.7939 | 7.7968 | 89208.0 |
| 2010-03-09 08:05:00 | AAPL | Stock | 7.7982 | 7.8071 | 7.7982 | 7.8061 | 149660.0 |
| 2010-03-09 08:10:00 | AAPL | Stock | 7.8057 | 7.815 | 7.8039 | 7.8071 | 236040.0 |
| 2010-03-09 08:15:00 | AAPL | Stock | 7.8079 | 7.8111 | 7.8057 | 7.8107 | 71064.0 |
| 2010-03-09 08:20:00 | AAPL | Stock | 7.8107 | 7.815 | 7.8089 | 7.81 | 120960.0 |
| 2010-03-09 08:25:00 | AAPL | Stock | 7.8061 | 7.8064 | 7.7996 | 7.8004 | 58800.0 |
| 2010-03-09 08:30:00 | AAPL | Stock | 7.8 | 7.8036 | 7.8 | 7.8011 | 39872.0 |
| 2010-03-09 08:35:00 | AAPL | Stock | 7.8036 | 7.8061 | 7.8036 | 7.8061 | 21952.0 |
| 2010-03-09 08:40:00 | AAPL | Stock | 7.8025 | 7.8043 | 7.8018 | 7.8029 | 37240.0 |
| 2010-03-09 08:45:00 | AAPL | Stock | 7.8061 | 7.81 | 7.8039 | 7.81 | 112560.0 |
| 2010-03-09 08:50:00 | AAPL | Stock | 7.81 | 7.81 | 7.8043 | 7.8082 | 72800.0 |
| 2010-03-09 08:55:00 | AAPL | Stock | 7.805 | 7.8121 | 7.805 | 7.8075 | 108584.0 |
| 2010-03-09 09:00:00 | AAPL | Stock | 7.8107 | 7.8118 | 7.8086 | 7.8107 | 36400.0 |
| 2010-03-09 09:05:00 | AAPL | Stock | 7.8093 | 7.8107 | 7.8093 | 7.8107 | 55160.0 |
| 2010-03-09 09:10:00 | AAPL | Stock | 7.81 | 7.81 | 7.7968 | 7.7982 | 162400.0 |
| 2010-03-09 09:15:00 | AAPL | Stock | 7.7964 | 7.8029 | 7.7964 | 7.8029 | 26460.0 |
| 2010-03-09 09:20:00 | AAPL | Stock | 7.7975 | 7.8 | 7.7975 | 7.7996 | 34944.0 |
| 2010-03-09 09:25:00 | AAPL | Stock | 7.7996 | 7.8046 | 7.7929 | 7.7936 | 354760.0 |
| 2010-03-09 09:30:00 | AAPL | Stock | 7.7968 | 7.8214 | 7.7818 | 7.8196 | 18939844.0 |
| 2010-03-09 09:35:00 | AAPL | Stock | 7.8189 | 7.8246 | 7.7986 | 7.8008 | 12668432.0 |
| 2010-03-09 09:40:00 | AAPL | Stock | 7.8014 | 7.8346 | 7.8007 | 7.8304 | 12509644.0 |
| 2010-03-09 09:45:00 | AAPL | Stock | 7.8296 | 7.8418 | 7.8257 | 7.84 | 11505564.0 |
| 2010-03-09 09:50:00 | AAPL | Stock | 7.8404 | 7.8436 | 7.8214 | 7.8307 | 9217320.0 |
| 2010-03-09 09:55:00 | AAPL | Stock | 7.8307 | 7.8411 | 7.8225 | 7.8382 | 6709752.0 |
| 2010-03-09 10:00:00 | AAPL | Stock | 7.8368 | 7.8368 | 7.8218 | 7.8257 | 6195616.0 |
| 2010-03-09 10:05:00 | AAPL | Stock | 7.8267 | 7.8357 | 7.8257 | 7.8314 | 5629512.0 |
| 2010-03-09 10:10:00 | AAPL | Stock | 7.8314 | 7.8607 | 7.8307 | 7.8554 | 19058536.0 |
| 2010-03-09 10:15:00 | AAPL | Stock | 7.8554 | 7.8786 | 7.8532 | 7.8732 | 17789408.0 |
| 2010-03-09 10:20:00 | AAPL | Stock | 7.8732 | 7.9011 | 7.8729 | 7.9 | 21196784.0 |
| 2010-03-09 10:25:00 | AAPL | Stock | 7.8994 | 7.9161 | 7.8936 | 7.9089 | 19021744.0 |
| 2010-03-09 10:30:00 | AAPL | Stock | 7.9089 | 7.9121 | 7.8993 | 7.9068 | 13644736.0 |
| 2010-03-09 10:35:00 | AAPL | Stock | 7.9061 | 7.9239 | 7.9043 | 7.9186 | 12197248.0 |
| 2010-03-09 10:40:00 | AAPL | Stock | 7.9186 | 7.9625 | 7.9161 | 7.9596 | 23368072.0 |
| 2010-03-09 10:45:00 | AAPL | Stock | 7.9601 | 7.9754 | 7.9518 | 7.9564 | 28915852.0 |
| 2010-03-09 10:50:00 | AAPL | Stock | 7.9571 | 7.9857 | 7.9564 | 7.9825 | 16107616.0 |
| 2010-03-09 10:55:00 | AAPL | Stock | 7.9825 | 8.0061 | 7.9815 | 7.9893 | 24568880.0 |
| 2010-03-09 11:00:00 | AAPL | Stock | 7.9907 | 7.9939 | 7.9571 | 7.9575 | 23917824.0 |
| 2010-03-09 11:05:00 | AAPL | Stock | 7.9571 | 7.9643 | 7.9464 | 7.9568 | 18467736.0 |
| 2010-03-09 11:10:00 | AAPL | Stock | 7.9571 | 7.9671 | 7.9536 | 7.9607 | 11582816.0 |
| 2010-03-09 11:15:00 | AAPL | Stock | 7.9607 | 7.975 | 7.9482 | 7.9721 | 11976580.0 |
> showing 50 of 324,383 rows — these rows as CSV