PREVIEW / stock_5min / 2012-04-19
file: by_date/stock_5min/2012/2012-04-19.parquet size: 4.8 MB rows: 323,765 symbols: 3,506
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-19 04:00:00 | AAPL | Stock | 21.6818 | 21.75 | 21.6818 | 21.7218 | 21840.0 |
| 2012-04-19 04:05:00 | AAPL | Stock | 21.7214 | 21.7214 | 21.7214 | 21.7214 | 2800.0 |
| 2012-04-19 04:15:00 | AAPL | Stock | 21.7304 | 21.7321 | 21.7304 | 21.7321 | 5600.0 |
| 2012-04-19 04:25:00 | AAPL | Stock | 21.7482 | 21.7482 | 21.7482 | 21.7482 | 2800.0 |
| 2012-04-19 04:35:00 | AAPL | Stock | 21.7421 | 21.7421 | 21.7421 | 21.7421 | 7980.0 |
| 2012-04-19 04:40:00 | AAPL | Stock | 21.7482 | 21.7482 | 21.7343 | 21.7343 | 11200.0 |
| 2012-04-19 04:45:00 | AAPL | Stock | 21.7339 | 21.7339 | 21.7339 | 21.7339 | 5600.0 |
| 2012-04-19 04:50:00 | AAPL | Stock | 21.6964 | 21.7 | 21.6964 | 21.7 | 28000.0 |
| 2012-04-19 04:55:00 | AAPL | Stock | 21.6911 | 21.6911 | 21.6764 | 21.6764 | 14840.0 |
| 2012-04-19 05:00:00 | AAPL | Stock | 21.6893 | 21.6893 | 21.6893 | 21.6893 | 10332.0 |
| 2012-04-19 05:05:00 | AAPL | Stock | 21.6714 | 21.6714 | 21.6714 | 21.6714 | 11200.0 |
| 2012-04-19 05:20:00 | AAPL | Stock | 21.6871 | 21.6871 | 21.6871 | 21.6871 | 2800.0 |
| 2012-04-19 05:25:00 | AAPL | Stock | 21.6432 | 21.6432 | 21.6429 | 21.6429 | 8400.0 |
| 2012-04-19 05:30:00 | AAPL | Stock | 21.6361 | 21.6361 | 21.6357 | 21.6357 | 5600.0 |
| 2012-04-19 05:40:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 5600.0 |
| 2012-04-19 05:45:00 | AAPL | Stock | 21.6821 | 21.6875 | 21.6821 | 21.6875 | 30800.0 |
| 2012-04-19 05:55:00 | AAPL | Stock | 21.7139 | 21.7143 | 21.7139 | 21.7143 | 14000.0 |
| 2012-04-19 06:00:00 | AAPL | Stock | 21.7139 | 21.7139 | 21.7139 | 21.7139 | 11200.0 |
| 2012-04-19 06:05:00 | AAPL | Stock | 21.7389 | 21.7389 | 21.7389 | 21.7389 | 2800.0 |
| 2012-04-19 06:15:00 | AAPL | Stock | 21.7232 | 21.7232 | 21.7232 | 21.7232 | 13440.0 |
| 2012-04-19 06:20:00 | AAPL | Stock | 21.725 | 21.725 | 21.725 | 21.725 | 2800.0 |
| 2012-04-19 06:25:00 | AAPL | Stock | 21.7482 | 21.75 | 21.7482 | 21.75 | 15848.0 |
| 2012-04-19 06:30:00 | AAPL | Stock | 21.75 | 21.75 | 21.75 | 21.75 | 4200.0 |
| 2012-04-19 06:45:00 | AAPL | Stock | 21.7254 | 21.7254 | 21.6982 | 21.6982 | 13720.0 |
| 2012-04-19 06:50:00 | AAPL | Stock | 21.725 | 21.725 | 21.725 | 21.725 | 8708.0 |
| 2012-04-19 06:55:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 11172.0 |
| 2012-04-19 07:00:00 | AAPL | Stock | 21.7143 | 21.7496 | 21.6968 | 21.7496 | 72800.0 |
| 2012-04-19 07:05:00 | AAPL | Stock | 21.7496 | 21.7857 | 21.7496 | 21.7821 | 189532.0 |
| 2012-04-19 07:10:00 | AAPL | Stock | 21.7818 | 21.8214 | 21.7736 | 21.7857 | 227640.0 |
| 2012-04-19 07:15:00 | AAPL | Stock | 21.7754 | 21.7925 | 21.7714 | 21.7925 | 98000.0 |
| 2012-04-19 07:20:00 | AAPL | Stock | 21.7929 | 21.7929 | 21.7146 | 21.7214 | 93800.0 |
| 2012-04-19 07:25:00 | AAPL | Stock | 21.7225 | 21.7321 | 21.6807 | 21.7143 | 143556.0 |
| 2012-04-19 07:30:00 | AAPL | Stock | 21.7046 | 21.7264 | 21.6861 | 21.7004 | 65800.0 |
| 2012-04-19 07:35:00 | AAPL | Stock | 21.7225 | 21.7225 | 21.6518 | 21.6518 | 207200.0 |
| 2012-04-19 07:40:00 | AAPL | Stock | 21.6732 | 21.6932 | 21.6536 | 21.6839 | 89600.0 |
| 2012-04-19 07:45:00 | AAPL | Stock | 21.6786 | 21.6946 | 21.6786 | 21.6829 | 90216.0 |
| 2012-04-19 07:50:00 | AAPL | Stock | 21.6979 | 21.7214 | 21.6857 | 21.7143 | 137340.0 |
| 2012-04-19 07:55:00 | AAPL | Stock | 21.7054 | 21.7164 | 21.7054 | 21.7143 | 88200.0 |
| 2012-04-19 08:00:00 | AAPL | Stock | 21.7143 | 21.7854 | 21.6964 | 21.6971 | 684264.0 |
| 2012-04-19 08:05:00 | AAPL | Stock | 21.7168 | 21.7571 | 21.7054 | 21.7182 | 292824.0 |
| 2012-04-19 08:10:00 | AAPL | Stock | 21.7186 | 21.7254 | 21.7036 | 21.7082 | 290500.0 |
| 2012-04-19 08:15:00 | AAPL | Stock | 21.7139 | 21.7207 | 21.6929 | 21.6929 | 158760.0 |
| 2012-04-19 08:20:00 | AAPL | Stock | 21.7018 | 21.7025 | 21.6507 | 21.6786 | 572992.0 |
| 2012-04-19 08:25:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6521 | 21.6521 | 610092.0 |
| 2012-04-19 08:30:00 | AAPL | Stock | 21.6539 | 21.6607 | 21.5911 | 21.6093 | 809228.0 |
| 2012-04-19 08:35:00 | AAPL | Stock | 21.6214 | 21.6214 | 21.5646 | 21.5646 | 480284.0 |
| 2012-04-19 08:40:00 | AAPL | Stock | 21.5646 | 21.5854 | 21.5357 | 21.5714 | 854308.0 |
| 2012-04-19 08:45:00 | AAPL | Stock | 21.5711 | 21.5796 | 21.4861 | 21.4861 | 1213072.0 |
| 2012-04-19 08:50:00 | AAPL | Stock | 21.4893 | 21.5 | 21.4025 | 21.4243 | 2414748.0 |
| 2012-04-19 08:55:00 | AAPL | Stock | 21.4225 | 21.4464 | 21.3857 | 21.4211 | 1972824.0 |
> showing 50 of 323,765 rows — these rows as CSV