PREVIEW / stock_5min / 2010-02-05
file: by_date/stock_5min/2010/2010-02-05.parquet size: 4.9 MB rows: 329,397 symbols: 3,429
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-02-05 04:30:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 2800.0 |
| 2010-02-05 04:40:00 | AAPL | Stock | 6.8604 | 6.8604 | 6.8604 | 6.8604 | 14000.0 |
| 2010-02-05 04:45:00 | AAPL | Stock | 6.8514 | 6.8514 | 6.8514 | 6.8514 | 14000.0 |
| 2010-02-05 05:30:00 | AAPL | Stock | 6.8375 | 6.8375 | 6.8375 | 6.8375 | 5600.0 |
| 2010-02-05 05:35:00 | AAPL | Stock | 6.8371 | 6.8371 | 6.8371 | 6.8371 | 5600.0 |
| 2010-02-05 05:55:00 | AAPL | Stock | 6.8196 | 6.8196 | 6.8193 | 6.8193 | 8820.0 |
| 2010-02-05 06:20:00 | AAPL | Stock | 6.7932 | 6.7932 | 6.7932 | 6.7932 | 5600.0 |
| 2010-02-05 06:25:00 | AAPL | Stock | 6.7936 | 6.7943 | 6.7929 | 6.7943 | 166432.0 |
| 2010-02-05 06:55:00 | AAPL | Stock | 6.8179 | 6.8179 | 6.8179 | 6.8179 | 2800.0 |
| 2010-02-05 07:00:00 | AAPL | Stock | 6.835 | 6.835 | 6.835 | 6.835 | 8400.0 |
| 2010-02-05 07:10:00 | AAPL | Stock | 6.8179 | 6.8286 | 6.8179 | 6.8214 | 33600.0 |
| 2010-02-05 07:15:00 | AAPL | Stock | 6.8218 | 6.8218 | 6.8218 | 6.8218 | 4004.0 |
| 2010-02-05 07:25:00 | AAPL | Stock | 6.825 | 6.8286 | 6.825 | 6.8286 | 15960.0 |
| 2010-02-05 07:30:00 | AAPL | Stock | 6.8275 | 6.8286 | 6.8275 | 6.8286 | 26768.0 |
| 2010-02-05 07:35:00 | AAPL | Stock | 6.8304 | 6.8346 | 6.8304 | 6.8332 | 32424.0 |
| 2010-02-05 07:40:00 | AAPL | Stock | 6.8354 | 6.8375 | 6.8332 | 6.8375 | 152600.0 |
| 2010-02-05 07:45:00 | AAPL | Stock | 6.8421 | 6.845 | 6.8368 | 6.8368 | 22400.0 |
| 2010-02-05 07:50:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8332 | 6.8332 | 32732.0 |
| 2010-02-05 08:00:00 | AAPL | Stock | 6.8232 | 6.8393 | 6.8014 | 6.8136 | 312816.0 |
| 2010-02-05 08:05:00 | AAPL | Stock | 6.8093 | 6.8093 | 6.7957 | 6.7975 | 333004.0 |
| 2010-02-05 08:10:00 | AAPL | Stock | 6.8032 | 6.8107 | 6.7979 | 6.8071 | 275576.0 |
| 2010-02-05 08:15:00 | AAPL | Stock | 6.8125 | 6.8157 | 6.8089 | 6.8157 | 197904.0 |
| 2010-02-05 08:20:00 | AAPL | Stock | 6.8118 | 6.8207 | 6.8107 | 6.8186 | 280112.0 |
| 2010-02-05 08:25:00 | AAPL | Stock | 6.8189 | 6.825 | 6.8136 | 6.8243 | 368452.0 |
| 2010-02-05 08:30:00 | AAPL | Stock | 6.8282 | 6.8857 | 6.8018 | 6.8832 | 3641288.0 |
| 2010-02-05 08:35:00 | AAPL | Stock | 6.8836 | 6.9 | 6.8679 | 6.8814 | 2895648.0 |
| 2010-02-05 08:40:00 | AAPL | Stock | 6.8811 | 6.8982 | 6.8661 | 6.8843 | 1979460.0 |
| 2010-02-05 08:45:00 | AAPL | Stock | 6.8843 | 6.8968 | 6.8839 | 6.8921 | 863296.0 |
| 2010-02-05 08:50:00 | AAPL | Stock | 6.8925 | 6.8954 | 6.8857 | 6.8946 | 497952.0 |
| 2010-02-05 08:55:00 | AAPL | Stock | 6.895 | 6.9204 | 6.895 | 6.92 | 1221360.0 |
| 2010-02-05 09:00:00 | AAPL | Stock | 6.9207 | 6.9286 | 6.9139 | 6.9214 | 1474424.0 |
| 2010-02-05 09:05:00 | AAPL | Stock | 6.9214 | 6.9232 | 6.9004 | 6.9029 | 1437072.0 |
| 2010-02-05 09:10:00 | AAPL | Stock | 6.9029 | 6.9029 | 6.8875 | 6.89 | 1503712.0 |
| 2010-02-05 09:15:00 | AAPL | Stock | 6.8911 | 6.8929 | 6.8839 | 6.8879 | 757764.0 |
| 2010-02-05 09:20:00 | AAPL | Stock | 6.8854 | 6.8893 | 6.8746 | 6.8854 | 816368.0 |
| 2010-02-05 09:25:00 | AAPL | Stock | 6.8846 | 6.8864 | 6.88 | 6.88 | 480088.0 |
| 2010-02-05 09:30:00 | AAPL | Stock | 6.8795 | 6.9107 | 6.8729 | 6.8936 | 26338648.0 |
| 2010-02-05 09:35:00 | AAPL | Stock | 6.8939 | 6.8986 | 6.8179 | 6.8361 | 34367592.0 |
| 2010-02-05 09:40:00 | AAPL | Stock | 6.8343 | 6.8729 | 6.8161 | 6.8661 | 29287076.0 |
| 2010-02-05 09:45:00 | AAPL | Stock | 6.8661 | 6.9071 | 6.8611 | 6.8716 | 21567868.0 |
| 2010-02-05 09:50:00 | AAPL | Stock | 6.8728 | 6.8839 | 6.8589 | 6.8657 | 14231812.0 |
| 2010-02-05 09:55:00 | AAPL | Stock | 6.8654 | 6.8857 | 6.8357 | 6.8764 | 16906624.0 |
| 2010-02-05 10:00:00 | AAPL | Stock | 6.8764 | 6.9096 | 6.875 | 6.8789 | 14450492.0 |
| 2010-02-05 10:05:00 | AAPL | Stock | 6.8793 | 6.8821 | 6.8446 | 6.8554 | 13975276.0 |
| 2010-02-05 10:10:00 | AAPL | Stock | 6.8568 | 6.8818 | 6.8429 | 6.8664 | 11282656.0 |
| 2010-02-05 10:15:00 | AAPL | Stock | 6.865 | 6.8993 | 6.8646 | 6.8769 | 11017608.0 |
| 2010-02-05 10:20:00 | AAPL | Stock | 6.8768 | 6.9418 | 6.875 | 6.9407 | 25169704.0 |
| 2010-02-05 10:25:00 | AAPL | Stock | 6.94 | 6.9643 | 6.9296 | 6.9539 | 25006688.0 |
| 2010-02-05 10:30:00 | AAPL | Stock | 6.9525 | 6.9643 | 6.9425 | 6.9493 | 18989208.0 |
| 2010-02-05 10:35:00 | AAPL | Stock | 6.9511 | 6.9543 | 6.9375 | 6.9391 | 9023420.0 |
> showing 50 of 329,397 rows — these rows as CSV