PREVIEW / stock_5min / 2011-04-11
file: by_date/stock_5min/2011/2011-04-11.parquet size: 4.9 MB rows: 329,329 symbols: 3,552
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-11 04:00:00 | AAPL | Stock | 12.0029 | 12.0029 | 12.0029 | 12.0029 | 5600.0 |
| 2011-04-11 04:05:00 | AAPL | Stock | 11.9996 | 11.9996 | 11.9996 | 11.9996 | 2800.0 |
| 2011-04-11 04:30:00 | AAPL | Stock | 11.9875 | 11.9929 | 11.9875 | 11.9929 | 8400.0 |
| 2011-04-11 04:40:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 5600.0 |
| 2011-04-11 04:45:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 5600.0 |
| 2011-04-11 04:55:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 2800.0 |
| 2011-04-11 05:00:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9821 | 11.9857 | 8400.0 |
| 2011-04-11 05:10:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 5600.0 |
| 2011-04-11 05:35:00 | AAPL | Stock | 11.9846 | 11.9846 | 11.9846 | 11.9846 | 2800.0 |
| 2011-04-11 05:55:00 | AAPL | Stock | 11.9839 | 11.9839 | 11.9839 | 11.9839 | 2800.0 |
| 2011-04-11 06:00:00 | AAPL | Stock | 11.9836 | 11.9857 | 11.9836 | 11.9857 | 10920.0 |
| 2011-04-11 06:10:00 | AAPL | Stock | 11.9679 | 11.9857 | 11.9679 | 11.9857 | 19600.0 |
| 2011-04-11 06:15:00 | AAPL | Stock | 11.9996 | 12.0332 | 11.9996 | 12.0332 | 12040.0 |
| 2011-04-11 06:20:00 | AAPL | Stock | 12.0161 | 12.0304 | 12.0161 | 12.0304 | 16800.0 |
| 2011-04-11 06:25:00 | AAPL | Stock | 12.0339 | 12.0354 | 12.0339 | 12.0354 | 11200.0 |
| 2011-04-11 06:30:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-04-11 06:40:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-04-11 07:00:00 | AAPL | Stock | 12.0011 | 12.0011 | 12.0011 | 12.0011 | 2800.0 |
| 2011-04-11 07:05:00 | AAPL | Stock | 11.9925 | 11.9925 | 11.9904 | 11.9904 | 5600.0 |
| 2011-04-11 07:10:00 | AAPL | Stock | 11.9875 | 12.0068 | 11.9875 | 12.0068 | 5600.0 |
| 2011-04-11 07:15:00 | AAPL | Stock | 12.0143 | 12.0268 | 11.9996 | 12.0004 | 39620.0 |
| 2011-04-11 07:20:00 | AAPL | Stock | 11.9879 | 12.0246 | 11.9879 | 12.02 | 11200.0 |
| 2011-04-11 07:25:00 | AAPL | Stock | 12.0179 | 12.0179 | 12.0179 | 12.0179 | 7896.0 |
| 2011-04-11 07:30:00 | AAPL | Stock | 12.0089 | 12.0089 | 12.0089 | 12.0089 | 8400.0 |
| 2011-04-11 07:40:00 | AAPL | Stock | 12.0 | 12.0018 | 12.0 | 12.0018 | 16800.0 |
| 2011-04-11 07:45:00 | AAPL | Stock | 11.9911 | 12.0089 | 11.9911 | 12.0089 | 27664.0 |
| 2011-04-11 07:50:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0068 | 12.0068 | 2800.0 |
| 2011-04-11 07:55:00 | AAPL | Stock | 11.9918 | 11.9918 | 11.9918 | 11.9918 | 2800.0 |
| 2011-04-11 08:00:00 | AAPL | Stock | 11.9979 | 11.9979 | 11.9679 | 11.9679 | 147168.0 |
| 2011-04-11 08:05:00 | AAPL | Stock | 11.9696 | 11.9696 | 11.9686 | 11.9696 | 25200.0 |
| 2011-04-11 08:10:00 | AAPL | Stock | 11.9686 | 11.9686 | 11.9536 | 11.9607 | 62552.0 |
| 2011-04-11 08:15:00 | AAPL | Stock | 11.9625 | 11.9643 | 11.9536 | 11.9536 | 113820.0 |
| 2011-04-11 08:20:00 | AAPL | Stock | 11.9554 | 11.9696 | 11.9464 | 11.9696 | 48384.0 |
| 2011-04-11 08:25:00 | AAPL | Stock | 11.9693 | 11.9714 | 11.9643 | 11.9714 | 91140.0 |
| 2011-04-11 08:30:00 | AAPL | Stock | 11.9679 | 11.9679 | 11.9589 | 11.9643 | 69888.0 |
| 2011-04-11 08:35:00 | AAPL | Stock | 11.9643 | 11.9661 | 11.9543 | 11.9543 | 18900.0 |
| 2011-04-11 08:40:00 | AAPL | Stock | 11.9571 | 11.9643 | 11.9536 | 11.9643 | 79940.0 |
| 2011-04-11 08:45:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9639 | 11.9643 | 159404.0 |
| 2011-04-11 08:50:00 | AAPL | Stock | 11.9636 | 11.9661 | 11.9554 | 11.9643 | 79744.0 |
| 2011-04-11 08:55:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9607 | 11.9607 | 74928.0 |
| 2011-04-11 09:00:00 | AAPL | Stock | 11.9571 | 11.9571 | 11.9339 | 11.9389 | 216860.0 |
| 2011-04-11 09:05:00 | AAPL | Stock | 11.9364 | 12.1516 | 11.935 | 11.9379 | 121520.0 |
| 2011-04-11 09:10:00 | AAPL | Stock | 11.9446 | 11.9461 | 11.9393 | 11.9432 | 113596.0 |
| 2011-04-11 09:15:00 | AAPL | Stock | 11.9429 | 11.9464 | 11.9429 | 11.945 | 119000.0 |
| 2011-04-11 09:20:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9461 | 11.9464 | 264516.0 |
| 2011-04-11 09:25:00 | AAPL | Stock | 11.9464 | 11.9511 | 11.9271 | 11.9307 | 295512.0 |
| 2011-04-11 09:30:00 | AAPL | Stock | 11.9282 | 11.9882 | 11.92 | 11.9321 | 12767356.0 |
| 2011-04-11 09:35:00 | AAPL | Stock | 11.9332 | 11.935 | 11.9052 | 11.9186 | 10737580.0 |
| 2011-04-11 09:40:00 | AAPL | Stock | 11.92 | 11.92 | 11.8671 | 11.8811 | 13488720.0 |
| 2011-04-11 09:45:00 | AAPL | Stock | 11.8807 | 11.9079 | 11.8689 | 11.9065 | 10449432.0 |
> showing 50 of 329,329 rows — these rows as CSV