PREVIEW / stock_5min / 2009-08-17
file: by_date/stock_5min/2009/2009-08-17.parquet size: 4.6 MB rows: 317,884 symbols: 3,367
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-17 04:15:00 | AAPL | Stock | 5.8843 | 5.8843 | 5.8286 | 5.8286 | 36400.0 |
| 2009-08-17 06:30:00 | AAPL | Stock | 5.8318 | 5.8318 | 5.8318 | 5.8318 | 5600.0 |
| 2009-08-17 06:35:00 | AAPL | Stock | 5.8543 | 5.8543 | 5.8543 | 5.8543 | 11200.0 |
| 2009-08-17 06:50:00 | AAPL | Stock | 5.8318 | 5.8318 | 5.8318 | 5.8318 | 11200.0 |
| 2009-08-17 07:00:00 | AAPL | Stock | 5.8425 | 5.8425 | 5.8425 | 5.8425 | 2800.0 |
| 2009-08-17 07:05:00 | AAPL | Stock | 5.8314 | 5.8314 | 5.8314 | 5.8314 | 8400.0 |
| 2009-08-17 07:15:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 5600.0 |
| 2009-08-17 07:20:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 2800.0 |
| 2009-08-17 07:30:00 | AAPL | Stock | 5.8393 | 5.8521 | 5.8393 | 5.8393 | 70280.0 |
| 2009-08-17 07:35:00 | AAPL | Stock | 5.8218 | 5.8218 | 5.8214 | 5.8214 | 8400.0 |
| 2009-08-17 07:40:00 | AAPL | Stock | 5.8225 | 5.8225 | 5.8225 | 5.8225 | 2800.0 |
| 2009-08-17 07:45:00 | AAPL | Stock | 5.825 | 5.825 | 5.825 | 5.825 | 2800.0 |
| 2009-08-17 07:50:00 | AAPL | Stock | 5.8411 | 5.8411 | 5.8411 | 5.8411 | 12180.0 |
| 2009-08-17 07:55:00 | AAPL | Stock | 5.8375 | 5.8375 | 5.8332 | 5.8332 | 36400.0 |
| 2009-08-17 08:00:00 | AAPL | Stock | 5.8371 | 5.8614 | 5.8286 | 5.8321 | 586796.0 |
| 2009-08-17 08:05:00 | AAPL | Stock | 5.8375 | 5.8425 | 5.8325 | 5.8393 | 94836.0 |
| 2009-08-17 08:10:00 | AAPL | Stock | 5.8493 | 5.8521 | 5.8321 | 5.8521 | 137368.0 |
| 2009-08-17 08:15:00 | AAPL | Stock | 5.8529 | 5.8529 | 5.8396 | 5.8496 | 42532.0 |
| 2009-08-17 08:20:00 | AAPL | Stock | 5.8404 | 5.8479 | 5.8404 | 5.8407 | 38052.0 |
| 2009-08-17 08:25:00 | AAPL | Stock | 5.8421 | 5.8532 | 5.8421 | 5.8454 | 68768.0 |
| 2009-08-17 08:30:00 | AAPL | Stock | 5.85 | 5.8518 | 5.8436 | 5.8518 | 89824.0 |
| 2009-08-17 08:35:00 | AAPL | Stock | 5.8507 | 5.8518 | 5.8475 | 5.85 | 38640.0 |
| 2009-08-17 08:40:00 | AAPL | Stock | 5.85 | 5.8571 | 5.85 | 5.8571 | 343196.0 |
| 2009-08-17 08:45:00 | AAPL | Stock | 5.8571 | 5.8621 | 5.8536 | 5.8571 | 140392.0 |
| 2009-08-17 08:50:00 | AAPL | Stock | 5.8575 | 5.8593 | 5.8536 | 5.8536 | 230580.0 |
| 2009-08-17 08:55:00 | AAPL | Stock | 5.8518 | 5.8536 | 5.8511 | 5.8525 | 39340.0 |
| 2009-08-17 09:00:00 | AAPL | Stock | 5.8539 | 5.855 | 5.8518 | 5.8532 | 26600.0 |
| 2009-08-17 09:05:00 | AAPL | Stock | 5.8543 | 5.8543 | 5.8507 | 5.8543 | 47600.0 |
| 2009-08-17 09:10:00 | AAPL | Stock | 5.8525 | 5.8543 | 5.8514 | 5.8536 | 56056.0 |
| 2009-08-17 09:15:00 | AAPL | Stock | 5.8536 | 5.8554 | 5.8536 | 5.8536 | 81928.0 |
| 2009-08-17 09:20:00 | AAPL | Stock | 5.8554 | 5.8554 | 5.8464 | 5.8464 | 108724.0 |
| 2009-08-17 09:25:00 | AAPL | Stock | 5.8496 | 5.8561 | 5.8411 | 5.8411 | 507584.0 |
| 2009-08-17 09:30:00 | AAPL | Stock | 5.8425 | 5.8429 | 5.7857 | 5.7975 | 28401996.0 |
| 2009-08-17 09:35:00 | AAPL | Stock | 5.7986 | 5.8064 | 5.7921 | 5.7982 | 9400020.0 |
| 2009-08-17 09:40:00 | AAPL | Stock | 5.7982 | 5.8114 | 5.7929 | 5.7975 | 12006456.0 |
| 2009-08-17 09:45:00 | AAPL | Stock | 5.7982 | 5.815 | 5.7929 | 5.8121 | 7794976.0 |
| 2009-08-17 09:50:00 | AAPL | Stock | 5.8125 | 5.8214 | 5.8075 | 5.8187 | 7125132.0 |
| 2009-08-17 09:55:00 | AAPL | Stock | 5.82 | 5.8257 | 5.8132 | 5.8211 | 11388720.0 |
| 2009-08-17 10:00:00 | AAPL | Stock | 5.8209 | 5.825 | 5.8111 | 5.8161 | 7403844.0 |
| 2009-08-17 10:05:00 | AAPL | Stock | 5.8157 | 5.8168 | 5.8068 | 5.8089 | 7915600.0 |
| 2009-08-17 10:10:00 | AAPL | Stock | 5.8089 | 5.8125 | 5.8011 | 5.8047 | 6490736.0 |
| 2009-08-17 10:15:00 | AAPL | Stock | 5.8039 | 5.8107 | 5.8 | 5.8039 | 3868816.0 |
| 2009-08-17 10:20:00 | AAPL | Stock | 5.8036 | 5.805 | 5.7986 | 5.8018 | 4854864.0 |
| 2009-08-17 10:25:00 | AAPL | Stock | 5.8018 | 5.8029 | 5.7982 | 5.7989 | 3039232.0 |
| 2009-08-17 10:30:00 | AAPL | Stock | 5.7989 | 5.8039 | 5.7964 | 5.7991 | 4980360.0 |
| 2009-08-17 10:35:00 | AAPL | Stock | 5.7982 | 5.8046 | 5.7954 | 5.7968 | 4667404.0 |
| 2009-08-17 10:40:00 | AAPL | Stock | 5.7964 | 5.8054 | 5.7943 | 5.7968 | 3927448.0 |
| 2009-08-17 10:45:00 | AAPL | Stock | 5.7971 | 5.8011 | 5.7954 | 5.8 | 3277008.0 |
| 2009-08-17 10:50:00 | AAPL | Stock | 5.7996 | 5.8007 | 5.7929 | 5.7932 | 2628500.0 |
| 2009-08-17 10:55:00 | AAPL | Stock | 5.7932 | 5.7943 | 5.7854 | 5.7904 | 10278884.0 |
> showing 50 of 317,884 rows — these rows as CSV