PREVIEW / stock_5min / 2008-09-18
file: by_date/stock_5min/2008/2008-09-18.parquet size: 5.1 MB rows: 352,385 symbols: 3,359
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-18 05:00:00 | AAPL | Stock | 4.6957 | 4.75 | 4.6957 | 4.75 | 13860.0 |
| 2008-09-18 05:05:00 | AAPL | Stock | 4.7643 | 4.7786 | 4.6071 | 4.6071 | 33600.0 |
| 2008-09-18 05:20:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 6860.0 |
| 2008-09-18 06:45:00 | AAPL | Stock | 4.6896 | 4.6904 | 4.6786 | 4.6786 | 67200.0 |
| 2008-09-18 06:50:00 | AAPL | Stock | 4.6786 | 4.6893 | 4.6786 | 4.6893 | 42000.0 |
| 2008-09-18 06:55:00 | AAPL | Stock | 4.6782 | 4.6786 | 4.6782 | 4.6786 | 30800.0 |
| 2008-09-18 07:00:00 | AAPL | Stock | 4.675 | 4.6786 | 4.675 | 4.6786 | 16800.0 |
| 2008-09-18 07:05:00 | AAPL | Stock | 4.6786 | 4.6929 | 4.6786 | 4.6929 | 37100.0 |
| 2008-09-18 07:10:00 | AAPL | Stock | 4.6925 | 4.6925 | 4.6925 | 4.6925 | 2800.0 |
| 2008-09-18 07:15:00 | AAPL | Stock | 4.6911 | 4.6911 | 4.6911 | 4.6911 | 2800.0 |
| 2008-09-18 07:20:00 | AAPL | Stock | 4.6911 | 4.6929 | 4.6911 | 4.6929 | 23940.0 |
| 2008-09-18 07:25:00 | AAPL | Stock | 4.6964 | 4.6964 | 4.6786 | 4.6875 | 79520.0 |
| 2008-09-18 07:30:00 | AAPL | Stock | 4.6875 | 4.6875 | 4.6821 | 4.6821 | 42000.0 |
| 2008-09-18 07:35:00 | AAPL | Stock | 4.6821 | 4.6925 | 4.6714 | 4.6714 | 120792.0 |
| 2008-09-18 07:40:00 | AAPL | Stock | 4.6786 | 4.6939 | 4.6761 | 4.6761 | 473200.0 |
| 2008-09-18 07:45:00 | AAPL | Stock | 4.675 | 4.675 | 4.675 | 4.675 | 14000.0 |
| 2008-09-18 07:50:00 | AAPL | Stock | 4.6782 | 4.6786 | 4.6714 | 4.6782 | 204400.0 |
| 2008-09-18 07:55:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.67 | 4.675 | 44800.0 |
| 2008-09-18 08:00:00 | AAPL | Stock | 4.6707 | 4.6786 | 4.6386 | 4.6429 | 604604.0 |
| 2008-09-18 08:05:00 | AAPL | Stock | 4.6404 | 4.6782 | 4.6393 | 4.6464 | 300468.0 |
| 2008-09-18 08:10:00 | AAPL | Stock | 4.6475 | 4.6568 | 4.6446 | 4.6446 | 156800.0 |
| 2008-09-18 08:15:00 | AAPL | Stock | 4.6446 | 4.6446 | 4.6068 | 4.6068 | 429212.0 |
| 2008-09-18 08:20:00 | AAPL | Stock | 4.6071 | 4.6264 | 4.5893 | 4.625 | 603372.0 |
| 2008-09-18 08:25:00 | AAPL | Stock | 4.6336 | 4.6336 | 4.6071 | 4.6243 | 145152.0 |
| 2008-09-18 08:30:00 | AAPL | Stock | 4.6218 | 4.64 | 4.6218 | 4.635 | 217476.0 |
| 2008-09-18 08:35:00 | AAPL | Stock | 4.6354 | 4.6357 | 4.625 | 4.6286 | 260960.0 |
| 2008-09-18 08:40:00 | AAPL | Stock | 4.6271 | 4.6357 | 4.625 | 4.6339 | 157808.0 |
| 2008-09-18 08:45:00 | AAPL | Stock | 4.6339 | 4.6407 | 4.6239 | 4.6243 | 314692.0 |
| 2008-09-18 08:50:00 | AAPL | Stock | 4.6161 | 4.6321 | 4.6071 | 4.625 | 250432.0 |
| 2008-09-18 08:55:00 | AAPL | Stock | 4.6321 | 4.6386 | 4.6314 | 4.6382 | 223608.0 |
| 2008-09-18 09:00:00 | AAPL | Stock | 4.6386 | 4.6407 | 4.6304 | 4.6304 | 136192.0 |
| 2008-09-18 09:05:00 | AAPL | Stock | 4.6282 | 4.6282 | 4.5693 | 4.5746 | 983528.0 |
| 2008-09-18 09:10:00 | AAPL | Stock | 4.5754 | 4.6089 | 4.5754 | 4.6057 | 209636.0 |
| 2008-09-18 09:15:00 | AAPL | Stock | 4.6014 | 4.6161 | 4.5904 | 4.6161 | 194908.0 |
| 2008-09-18 09:20:00 | AAPL | Stock | 4.6139 | 4.65 | 4.6079 | 4.65 | 489580.0 |
| 2008-09-18 09:25:00 | AAPL | Stock | 4.6496 | 4.6764 | 4.6404 | 4.6636 | 2566816.0 |
| 2008-09-18 09:30:00 | AAPL | Stock | 4.6632 | 4.6939 | 4.6339 | 4.6446 | 35959112.0 |
| 2008-09-18 09:35:00 | AAPL | Stock | 4.6471 | 4.6643 | 4.6182 | 4.6307 | 17475892.0 |
| 2008-09-18 09:40:00 | AAPL | Stock | 4.63 | 4.6786 | 4.6229 | 4.6314 | 23095772.0 |
| 2008-09-18 09:45:00 | AAPL | Stock | 4.6307 | 4.6525 | 4.6129 | 4.6186 | 21019516.0 |
| 2008-09-18 09:50:00 | AAPL | Stock | 4.6211 | 4.6614 | 4.6179 | 4.6429 | 18717496.0 |
| 2008-09-18 09:55:00 | AAPL | Stock | 4.6421 | 4.6864 | 4.6407 | 4.6782 | 21596260.0 |
| 2008-09-18 10:00:00 | AAPL | Stock | 4.6775 | 4.7204 | 4.6679 | 4.7 | 27640984.0 |
| 2008-09-18 10:05:00 | AAPL | Stock | 4.6993 | 4.7375 | 4.6982 | 4.7179 | 18669392.0 |
| 2008-09-18 10:10:00 | AAPL | Stock | 4.7168 | 4.7207 | 4.6914 | 4.7 | 15040816.0 |
| 2008-09-18 10:15:00 | AAPL | Stock | 4.6996 | 4.7039 | 4.6686 | 4.6768 | 17208100.0 |
| 2008-09-18 10:20:00 | AAPL | Stock | 4.6757 | 4.6961 | 4.6607 | 4.6932 | 15029812.0 |
| 2008-09-18 10:25:00 | AAPL | Stock | 4.6943 | 4.6943 | 4.6746 | 4.6786 | 10311308.0 |
| 2008-09-18 10:30:00 | AAPL | Stock | 4.6786 | 4.6789 | 4.6436 | 4.6632 | 12898172.0 |
| 2008-09-18 10:35:00 | AAPL | Stock | 4.6639 | 4.6729 | 4.6196 | 4.6243 | 14985292.0 |
> showing 50 of 352,385 rows — these rows as CSV