PREVIEW / stock_5min / 2013-01-04
file: by_date/stock_5min/2013/2013-01-04.parquet size: 4.8 MB rows: 325,912 symbols: 3,460
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-04 04:00:00 | AAPL | Stock | 19.3361 | 19.3714 | 19.3361 | 19.3714 | 8400.0 |
| 2013-01-04 04:40:00 | AAPL | Stock | 19.3714 | 19.3714 | 19.3714 | 19.3714 | 2800.0 |
| 2013-01-04 05:25:00 | AAPL | Stock | 19.3821 | 19.3821 | 19.3821 | 19.3821 | 2800.0 |
| 2013-01-04 06:10:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 5600.0 |
| 2013-01-04 07:00:00 | AAPL | Stock | 19.3875 | 19.3875 | 19.3875 | 19.3875 | 2800.0 |
| 2013-01-04 07:05:00 | AAPL | Stock | 19.4107 | 19.4296 | 19.4107 | 19.4286 | 21728.0 |
| 2013-01-04 07:20:00 | AAPL | Stock | 19.4279 | 19.4279 | 19.4168 | 19.4168 | 5600.0 |
| 2013-01-04 07:25:00 | AAPL | Stock | 19.4179 | 19.4179 | 19.4157 | 19.4164 | 14000.0 |
| 2013-01-04 07:30:00 | AAPL | Stock | 19.4107 | 19.4143 | 19.4107 | 19.4143 | 47152.0 |
| 2013-01-04 07:40:00 | AAPL | Stock | 19.4139 | 19.4296 | 19.4139 | 19.4296 | 36400.0 |
| 2013-01-04 07:45:00 | AAPL | Stock | 19.4182 | 19.4371 | 19.4182 | 19.4286 | 65800.0 |
| 2013-01-04 07:50:00 | AAPL | Stock | 19.43 | 19.4321 | 19.4286 | 19.4286 | 29260.0 |
| 2013-01-04 07:55:00 | AAPL | Stock | 19.4161 | 19.4314 | 19.4071 | 19.4071 | 37800.0 |
| 2013-01-04 08:00:00 | AAPL | Stock | 19.4071 | 19.4375 | 19.3768 | 19.4161 | 198632.0 |
| 2013-01-04 08:05:00 | AAPL | Stock | 19.4161 | 19.4214 | 19.4107 | 19.4161 | 165228.0 |
| 2013-01-04 08:10:00 | AAPL | Stock | 19.4211 | 19.4339 | 19.4093 | 19.4104 | 159740.0 |
| 2013-01-04 08:15:00 | AAPL | Stock | 19.405 | 19.4121 | 19.4004 | 19.4121 | 114800.0 |
| 2013-01-04 08:20:00 | AAPL | Stock | 19.4143 | 19.4279 | 19.4139 | 19.4257 | 141400.0 |
| 2013-01-04 08:25:00 | AAPL | Stock | 19.425 | 19.4464 | 19.4179 | 19.4464 | 389060.0 |
| 2013-01-04 08:30:00 | AAPL | Stock | 19.4443 | 19.4521 | 19.3971 | 19.4089 | 552608.0 |
| 2013-01-04 08:35:00 | AAPL | Stock | 19.4236 | 19.4243 | 19.2936 | 19.2936 | 1543332.0 |
| 2013-01-04 08:40:00 | AAPL | Stock | 19.2914 | 19.3 | 19.2325 | 19.2771 | 1146656.0 |
| 2013-01-04 08:45:00 | AAPL | Stock | 19.2643 | 19.2714 | 19.2221 | 19.2607 | 810348.0 |
| 2013-01-04 08:50:00 | AAPL | Stock | 19.2604 | 19.2679 | 19.2186 | 19.2579 | 1265292.0 |
| 2013-01-04 08:55:00 | AAPL | Stock | 19.2589 | 19.2679 | 19.1764 | 19.2032 | 1425144.0 |
| 2013-01-04 09:00:00 | AAPL | Stock | 19.1946 | 19.2079 | 19.1643 | 19.1964 | 684460.0 |
| 2013-01-04 09:05:00 | AAPL | Stock | 19.2007 | 19.2007 | 19.1661 | 19.1661 | 788592.0 |
| 2013-01-04 09:10:00 | AAPL | Stock | 19.1718 | 19.2064 | 19.1657 | 19.1707 | 694008.0 |
| 2013-01-04 09:15:00 | AAPL | Stock | 19.1696 | 19.1786 | 19.1536 | 19.1746 | 720412.0 |
| 2013-01-04 09:20:00 | AAPL | Stock | 19.1729 | 19.1964 | 19.17 | 19.1732 | 659260.0 |
| 2013-01-04 09:25:00 | AAPL | Stock | 19.1768 | 19.2054 | 19.1625 | 19.1696 | 761908.0 |
| 2013-01-04 09:30:00 | AAPL | Stock | 19.1725 | 19.2368 | 19.1429 | 19.1829 | 20273344.0 |
| 2013-01-04 09:35:00 | AAPL | Stock | 19.1829 | 19.2075 | 19.1174 | 19.135 | 14750204.0 |
| 2013-01-04 09:40:00 | AAPL | Stock | 19.1339 | 19.1929 | 19.1314 | 19.1836 | 10857056.0 |
| 2013-01-04 09:45:00 | AAPL | Stock | 19.1836 | 19.1882 | 19.1446 | 19.1544 | 8945272.0 |
| 2013-01-04 09:50:00 | AAPL | Stock | 19.15 | 19.1546 | 19.1143 | 19.1329 | 9790592.0 |
| 2013-01-04 09:55:00 | AAPL | Stock | 19.1304 | 19.1693 | 19.1232 | 19.1389 | 6468420.0 |
| 2013-01-04 10:00:00 | AAPL | Stock | 19.1414 | 19.1564 | 19.0536 | 19.0568 | 18770192.0 |
| 2013-01-04 10:05:00 | AAPL | Stock | 19.0607 | 19.065 | 18.9854 | 18.9982 | 19076512.0 |
| 2013-01-04 10:10:00 | AAPL | Stock | 18.9957 | 19.025 | 18.9946 | 19.0107 | 12639340.0 |
| 2013-01-04 10:15:00 | AAPL | Stock | 19.0093 | 19.0115 | 18.9339 | 18.95 | 19231380.0 |
| 2013-01-04 10:20:00 | AAPL | Stock | 18.9518 | 18.9721 | 18.8834 | 18.9007 | 13981604.0 |
| 2013-01-04 10:25:00 | AAPL | Stock | 18.9007 | 18.9271 | 18.8629 | 18.9074 | 17665172.0 |
| 2013-01-04 10:30:00 | AAPL | Stock | 18.9075 | 18.9121 | 18.8393 | 18.8539 | 13601112.0 |
| 2013-01-04 10:35:00 | AAPL | Stock | 18.8543 | 18.8975 | 18.8268 | 18.88 | 13710508.0 |
| 2013-01-04 10:40:00 | AAPL | Stock | 18.8854 | 18.9039 | 18.8575 | 18.8586 | 7948948.0 |
| 2013-01-04 10:45:00 | AAPL | Stock | 18.8625 | 18.9125 | 18.8575 | 18.8964 | 6741280.0 |
| 2013-01-04 10:50:00 | AAPL | Stock | 18.8954 | 18.9157 | 18.8771 | 18.8929 | 7367220.0 |
| 2013-01-04 10:55:00 | AAPL | Stock | 18.8904 | 18.8961 | 18.8146 | 18.82 | 13237112.0 |
| 2013-01-04 11:00:00 | AAPL | Stock | 18.8268 | 18.8643 | 18.8111 | 18.8497 | 6009556.0 |
> showing 50 of 325,912 rows — these rows as CSV