PREVIEW / stock_5min / 2007-09-06
file: by_date/stock_5min/2007/2007-09-06.parquet size: 3.9 MB rows: 292,119 symbols: 3,108
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-06 09:30:00 | AAPL | Stock | 4.8414 | 4.8707 | 4.8125 | 4.8268 | 81600204.0 |
| 2007-09-06 09:35:00 | AAPL | Stock | 4.8275 | 4.8507 | 4.8057 | 4.8271 | 49137116.0 |
| 2007-09-06 09:40:00 | AAPL | Stock | 4.8268 | 4.8486 | 4.7814 | 4.7875 | 60220720.0 |
| 2007-09-06 09:45:00 | AAPL | Stock | 4.7875 | 4.7986 | 4.7643 | 4.7796 | 44977884.0 |
| 2007-09-06 09:50:00 | AAPL | Stock | 4.7796 | 4.7921 | 4.7611 | 4.7861 | 36561056.0 |
| 2007-09-06 09:55:00 | AAPL | Stock | 4.7861 | 4.7961 | 4.75 | 4.7561 | 44993816.0 |
| 2007-09-06 10:00:00 | AAPL | Stock | 4.7568 | 4.7679 | 4.7396 | 4.7486 | 46224192.0 |
| 2007-09-06 10:05:00 | AAPL | Stock | 4.7486 | 4.7757 | 4.7468 | 4.7714 | 32713520.0 |
| 2007-09-06 10:10:00 | AAPL | Stock | 4.7707 | 4.7836 | 4.7596 | 4.77 | 28526792.0 |
| 2007-09-06 10:15:00 | AAPL | Stock | 4.77 | 4.7714 | 4.7468 | 4.7636 | 25900532.0 |
| 2007-09-06 10:20:00 | AAPL | Stock | 4.7629 | 4.7729 | 4.7446 | 4.7721 | 26143404.0 |
| 2007-09-06 10:25:00 | AAPL | Stock | 4.7718 | 4.79 | 4.765 | 4.7729 | 25454632.0 |
| 2007-09-06 10:30:00 | AAPL | Stock | 4.7732 | 4.7893 | 4.7643 | 4.7871 | 24573752.0 |
| 2007-09-06 10:35:00 | AAPL | Stock | 4.7871 | 4.7986 | 4.7829 | 4.7921 | 25036732.0 |
| 2007-09-06 10:40:00 | AAPL | Stock | 4.7925 | 4.7964 | 4.775 | 4.7775 | 20488076.0 |
| 2007-09-06 10:45:00 | AAPL | Stock | 4.7779 | 4.7996 | 4.775 | 4.7964 | 18654440.0 |
| 2007-09-06 10:50:00 | AAPL | Stock | 4.7954 | 4.8229 | 4.7954 | 4.8164 | 35858704.0 |
| 2007-09-06 10:55:00 | AAPL | Stock | 4.8161 | 4.8211 | 4.8054 | 4.8096 | 21378868.0 |
| 2007-09-06 11:00:00 | AAPL | Stock | 4.81 | 4.8104 | 4.7975 | 4.8039 | 15320088.0 |
| 2007-09-06 11:05:00 | AAPL | Stock | 4.8039 | 4.8046 | 4.7807 | 4.7814 | 21819000.0 |
| 2007-09-06 11:10:00 | AAPL | Stock | 4.7811 | 4.7907 | 4.7768 | 4.7857 | 19003320.0 |
| 2007-09-06 11:15:00 | AAPL | Stock | 4.7854 | 4.7954 | 4.7782 | 4.7954 | 16277996.0 |
| 2007-09-06 11:20:00 | AAPL | Stock | 4.7954 | 4.8054 | 4.7939 | 4.7986 | 16553880.0 |
| 2007-09-06 11:25:00 | AAPL | Stock | 4.7986 | 4.8039 | 4.7936 | 4.8021 | 10765384.0 |
| 2007-09-06 11:30:00 | AAPL | Stock | 4.8018 | 4.81 | 4.7993 | 4.8039 | 18367300.0 |
| 2007-09-06 11:35:00 | AAPL | Stock | 4.8036 | 4.805 | 4.79 | 4.7975 | 13282276.0 |
| 2007-09-06 11:40:00 | AAPL | Stock | 4.7979 | 4.8075 | 4.7954 | 4.8036 | 10722012.0 |
| 2007-09-06 11:45:00 | AAPL | Stock | 4.8025 | 4.8054 | 4.7971 | 4.7986 | 12264140.0 |
| 2007-09-06 11:50:00 | AAPL | Stock | 4.7982 | 4.8071 | 4.7946 | 4.8014 | 12611452.0 |
| 2007-09-06 11:55:00 | AAPL | Stock | 4.8018 | 4.8096 | 4.8011 | 4.8032 | 13842360.0 |
| 2007-09-06 12:00:00 | AAPL | Stock | 4.8032 | 4.8036 | 4.7946 | 4.8029 | 9532488.0 |
| 2007-09-06 12:05:00 | AAPL | Stock | 4.8025 | 4.8254 | 4.8011 | 4.8157 | 26874260.0 |
| 2007-09-06 12:10:00 | AAPL | Stock | 4.8151 | 4.8389 | 4.8107 | 4.8321 | 21092932.0 |
| 2007-09-06 12:15:00 | AAPL | Stock | 4.8332 | 4.8571 | 4.8307 | 4.8468 | 33866868.0 |
| 2007-09-06 12:20:00 | AAPL | Stock | 4.8475 | 4.8488 | 4.8304 | 4.8379 | 17661308.0 |
| 2007-09-06 12:25:00 | AAPL | Stock | 4.8375 | 4.8382 | 4.8179 | 4.8311 | 16590336.0 |
| 2007-09-06 12:30:00 | AAPL | Stock | 4.8314 | 4.8321 | 4.8121 | 4.8179 | 17126284.0 |
| 2007-09-06 12:35:00 | AAPL | Stock | 4.8182 | 4.8286 | 4.8175 | 4.8279 | 13417236.0 |
| 2007-09-06 12:40:00 | AAPL | Stock | 4.8279 | 4.8289 | 4.8129 | 4.8157 | 9225664.0 |
| 2007-09-06 12:45:00 | AAPL | Stock | 4.8146 | 4.8186 | 4.8089 | 4.8168 | 12565196.0 |
| 2007-09-06 12:50:00 | AAPL | Stock | 4.8171 | 4.8186 | 4.7993 | 4.8039 | 12335428.0 |
| 2007-09-06 12:55:00 | AAPL | Stock | 4.8039 | 4.8179 | 4.8021 | 4.8179 | 9506336.0 |
| 2007-09-06 13:00:00 | AAPL | Stock | 4.8182 | 4.8304 | 4.8146 | 4.8279 | 10193092.0 |
| 2007-09-06 13:05:00 | AAPL | Stock | 4.8278 | 4.83 | 4.8068 | 4.8107 | 11708816.0 |
| 2007-09-06 13:10:00 | AAPL | Stock | 4.8111 | 4.8164 | 4.8014 | 4.8093 | 11651640.0 |
| 2007-09-06 13:15:00 | AAPL | Stock | 4.8093 | 4.8146 | 4.8029 | 4.8096 | 6619956.0 |
| 2007-09-06 13:20:00 | AAPL | Stock | 4.8096 | 4.815 | 4.8014 | 4.8126 | 7094668.0 |
| 2007-09-06 13:25:00 | AAPL | Stock | 4.8129 | 4.8134 | 4.8054 | 4.8068 | 3628436.0 |
| 2007-09-06 13:30:00 | AAPL | Stock | 4.8064 | 4.8075 | 4.8004 | 4.8064 | 8366624.0 |
| 2007-09-06 13:35:00 | AAPL | Stock | 4.8071 | 4.8146 | 4.8039 | 4.8075 | 7172816.0 |
> showing 50 of 292,119 rows — these rows as CSV