PREVIEW / stock_5min / 2012-05-16
file: by_date/stock_5min/2012/2012-05-16.parquet size: 4.9 MB rows: 329,780 symbols: 3,531
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-05-16 04:00:00 | AAPL | Stock | 19.7036 | 19.7261 | 19.7036 | 19.7254 | 29736.0 |
| 2012-05-16 04:05:00 | AAPL | Stock | 19.7261 | 19.7261 | 19.69 | 19.7179 | 19572.0 |
| 2012-05-16 04:10:00 | AAPL | Stock | 19.7179 | 19.7179 | 19.7179 | 19.7179 | 7000.0 |
| 2012-05-16 04:15:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 5628.0 |
| 2012-05-16 04:20:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 14000.0 |
| 2012-05-16 04:25:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 8400.0 |
| 2012-05-16 04:30:00 | AAPL | Stock | 19.7496 | 19.7496 | 19.7496 | 19.7496 | 2800.0 |
| 2012-05-16 04:50:00 | AAPL | Stock | 19.7214 | 19.7214 | 19.7214 | 19.7214 | 8400.0 |
| 2012-05-16 05:15:00 | AAPL | Stock | 19.7393 | 19.7393 | 19.7393 | 19.7393 | 5600.0 |
| 2012-05-16 06:20:00 | AAPL | Stock | 19.7357 | 19.7357 | 19.7357 | 19.7357 | 5460.0 |
| 2012-05-16 06:30:00 | AAPL | Stock | 19.7768 | 19.7782 | 19.7768 | 19.7779 | 20020.0 |
| 2012-05-16 06:35:00 | AAPL | Stock | 19.7779 | 19.7779 | 19.7779 | 19.7779 | 5600.0 |
| 2012-05-16 07:00:00 | AAPL | Stock | 19.785 | 19.8 | 19.785 | 19.7932 | 30800.0 |
| 2012-05-16 07:10:00 | AAPL | Stock | 19.7982 | 19.8286 | 19.7946 | 19.8286 | 123312.0 |
| 2012-05-16 07:15:00 | AAPL | Stock | 19.8382 | 19.8446 | 19.8146 | 19.8443 | 54600.0 |
| 2012-05-16 07:20:00 | AAPL | Stock | 19.8443 | 19.8661 | 19.84 | 19.8571 | 115360.0 |
| 2012-05-16 07:25:00 | AAPL | Stock | 19.8668 | 19.8707 | 19.8439 | 19.8571 | 103152.0 |
| 2012-05-16 07:30:00 | AAPL | Stock | 19.8571 | 19.8657 | 19.8543 | 19.8571 | 67200.0 |
| 2012-05-16 07:35:00 | AAPL | Stock | 19.8571 | 19.8668 | 19.8571 | 19.8604 | 64400.0 |
| 2012-05-16 07:40:00 | AAPL | Stock | 19.8611 | 19.8789 | 19.8571 | 19.8789 | 201460.0 |
| 2012-05-16 07:45:00 | AAPL | Stock | 19.8793 | 19.8929 | 19.8793 | 19.8889 | 337512.0 |
| 2012-05-16 07:50:00 | AAPL | Stock | 19.8889 | 19.9211 | 19.8857 | 19.9107 | 123424.0 |
| 2012-05-16 07:55:00 | AAPL | Stock | 19.8986 | 19.8986 | 19.8754 | 19.8929 | 83160.0 |
| 2012-05-16 08:00:00 | AAPL | Stock | 19.8754 | 19.8971 | 19.8 | 19.8936 | 553588.0 |
| 2012-05-16 08:05:00 | AAPL | Stock | 19.8929 | 19.9029 | 19.8821 | 19.8929 | 171780.0 |
| 2012-05-16 08:10:00 | AAPL | Stock | 19.89 | 19.89 | 19.875 | 19.8871 | 50288.0 |
| 2012-05-16 08:15:00 | AAPL | Stock | 19.8857 | 19.8925 | 19.87 | 19.87 | 91980.0 |
| 2012-05-16 08:20:00 | AAPL | Stock | 19.8746 | 19.8811 | 19.8643 | 19.8775 | 88060.0 |
| 2012-05-16 08:25:00 | AAPL | Stock | 19.865 | 19.8654 | 19.85 | 19.8571 | 152880.0 |
| 2012-05-16 08:30:00 | AAPL | Stock | 19.8618 | 19.8714 | 19.8475 | 19.8525 | 125580.0 |
| 2012-05-16 08:35:00 | AAPL | Stock | 19.8557 | 19.8643 | 19.8461 | 19.8643 | 257180.0 |
| 2012-05-16 08:40:00 | AAPL | Stock | 19.8564 | 19.8625 | 19.8332 | 19.8354 | 244860.0 |
| 2012-05-16 08:45:00 | AAPL | Stock | 19.8393 | 19.8393 | 19.7746 | 19.7946 | 566720.0 |
| 2012-05-16 08:50:00 | AAPL | Stock | 19.8029 | 19.8029 | 19.7786 | 19.7875 | 204736.0 |
| 2012-05-16 08:55:00 | AAPL | Stock | 19.7875 | 19.7971 | 19.7775 | 19.7857 | 300692.0 |
| 2012-05-16 09:00:00 | AAPL | Stock | 19.7961 | 19.8157 | 19.7946 | 19.8086 | 78400.0 |
| 2012-05-16 09:05:00 | AAPL | Stock | 19.8 | 19.8182 | 19.7946 | 19.8182 | 182224.0 |
| 2012-05-16 09:10:00 | AAPL | Stock | 19.82 | 19.8211 | 19.8075 | 19.8179 | 287504.0 |
| 2012-05-16 09:15:00 | AAPL | Stock | 19.8179 | 19.835 | 19.8179 | 19.8221 | 226520.0 |
| 2012-05-16 09:20:00 | AAPL | Stock | 19.8221 | 19.8321 | 19.8214 | 19.8254 | 158676.0 |
| 2012-05-16 09:25:00 | AAPL | Stock | 19.8307 | 19.8375 | 19.7929 | 19.7929 | 786436.0 |
| 2012-05-16 09:30:00 | AAPL | Stock | 19.7875 | 19.8889 | 19.7511 | 19.8169 | 15821652.0 |
| 2012-05-16 09:35:00 | AAPL | Stock | 19.8175 | 19.8411 | 19.7679 | 19.7864 | 9912980.0 |
| 2012-05-16 09:40:00 | AAPL | Stock | 19.7879 | 19.8124 | 19.7404 | 19.7832 | 12309528.0 |
| 2012-05-16 09:45:00 | AAPL | Stock | 19.7831 | 19.8214 | 19.7418 | 19.8025 | 8453004.0 |
| 2012-05-16 09:50:00 | AAPL | Stock | 19.8001 | 19.8486 | 19.7889 | 19.8114 | 9810192.0 |
| 2012-05-16 09:55:00 | AAPL | Stock | 19.8108 | 19.8271 | 19.7696 | 19.782 | 6135836.0 |
| 2012-05-16 10:00:00 | AAPL | Stock | 19.7846 | 19.8036 | 19.7286 | 19.7314 | 9585436.0 |
| 2012-05-16 10:05:00 | AAPL | Stock | 19.7314 | 19.7857 | 19.7271 | 19.7757 | 6829480.0 |
| 2012-05-16 10:10:00 | AAPL | Stock | 19.7761 | 19.7761 | 19.7007 | 19.7187 | 7493080.0 |
> showing 50 of 329,780 rows — these rows as CSV