PREVIEW / stock_1min / 2011-04-11
file: by_date/stock_1min/2011/2011-04-11.parquet size: 13.2 MB rows: 984,425 symbols: 2,879
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:07:00 | AAPL | Stock | 11.9996 | 11.9996 | 11.9996 | 11.9996 | 2800.0 |
| 2011-04-11 04:31:00 | AAPL | Stock | 11.9875 | 11.9875 | 11.9875 | 11.9875 | 2800.0 |
| 2011-04-11 04:32:00 | AAPL | Stock | 11.9875 | 11.9929 | 11.9875 | 11.9929 | 5600.0 |
| 2011-04-11 04:43:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 5600.0 |
| 2011-04-11 04:48:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 5600.0 |
| 2011-04-11 04:57: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.9821 | 5600.0 |
| 2011-04-11 05:04:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 2800.0 |
| 2011-04-11 05:11:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 5600.0 |
| 2011-04-11 05:37: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:04:00 | AAPL | Stock | 11.9836 | 11.9857 | 11.9836 | 11.9857 | 10920.0 |
| 2011-04-11 06:14: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:21:00 | AAPL | Stock | 12.0161 | 12.0161 | 12.0161 | 12.0161 | 2800.0 |
| 2011-04-11 06:23:00 | AAPL | Stock | 12.0161 | 12.0161 | 12.0161 | 12.0161 | 2800.0 |
| 2011-04-11 06:24:00 | AAPL | Stock | 12.0196 | 12.0304 | 12.0196 | 12.0304 | 11200.0 |
| 2011-04-11 06:25:00 | AAPL | Stock | 12.0339 | 12.0354 | 12.0339 | 12.0354 | 11200.0 |
| 2011-04-11 06:31:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-04-11 06:43:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-04-11 07:02: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.9925 | 11.9925 | 2800.0 |
| 2011-04-11 07:08:00 | AAPL | Stock | 11.9904 | 11.9904 | 11.9904 | 11.9904 | 2800.0 |
| 2011-04-11 07:12:00 | AAPL | Stock | 11.9875 | 11.9875 | 11.9875 | 11.9875 | 2800.0 |
| 2011-04-11 07:13:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0068 | 12.0068 | 2800.0 |
| 2011-04-11 07:18:00 | AAPL | Stock | 12.0143 | 12.0268 | 12.0143 | 12.0268 | 34020.0 |
| 2011-04-11 07:19:00 | AAPL | Stock | 11.9996 | 12.0004 | 11.9996 | 12.0004 | 5600.0 |
| 2011-04-11 07:20:00 | AAPL | Stock | 11.9879 | 11.9879 | 11.9879 | 11.9879 | 2800.0 |
| 2011-04-11 07:22:00 | AAPL | Stock | 12.0179 | 12.0246 | 12.0179 | 12.0246 | 5600.0 |
| 2011-04-11 07:24:00 | AAPL | Stock | 12.02 | 12.02 | 12.02 | 12.02 | 2800.0 |
| 2011-04-11 07:26:00 | AAPL | Stock | 12.0179 | 12.0179 | 12.0179 | 12.0179 | 7896.0 |
| 2011-04-11 07:31:00 | AAPL | Stock | 12.0089 | 12.0089 | 12.0089 | 12.0089 | 8400.0 |
| 2011-04-11 07:41:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-04-11 07:44:00 | AAPL | Stock | 12.0018 | 12.0018 | 12.0018 | 12.0018 | 14000.0 |
| 2011-04-11 07:45:00 | AAPL | Stock | 11.9911 | 11.9911 | 11.9911 | 11.9911 | 5600.0 |
| 2011-04-11 07:47:00 | AAPL | Stock | 11.9996 | 11.9996 | 11.9996 | 11.9996 | 2800.0 |
| 2011-04-11 07:48:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0068 | 12.0068 | 11284.0 |
| 2011-04-11 07:49:00 | AAPL | Stock | 12.0068 | 12.0089 | 12.0068 | 12.0089 | 7980.0 |
| 2011-04-11 07:53:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0068 | 12.0068 | 2800.0 |
| 2011-04-11 07:58: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.9821 | 11.9821 | 80528.0 |
| 2011-04-11 08:02:00 | AAPL | Stock | 11.9839 | 11.9839 | 11.9839 | 11.9839 | 2800.0 |
| 2011-04-11 08:03:00 | AAPL | Stock | 11.9825 | 11.9825 | 11.9804 | 11.9804 | 19880.0 |
| 2011-04-11 08:04:00 | AAPL | Stock | 11.9775 | 11.9821 | 11.9679 | 11.9679 | 43960.0 |
| 2011-04-11 08:06:00 | AAPL | Stock | 11.9696 | 11.9696 | 11.9696 | 11.9696 | 14000.0 |
| 2011-04-11 08:07:00 | AAPL | Stock | 11.9686 | 11.9696 | 11.9686 | 11.9696 | 11200.0 |
| 2011-04-11 08:11:00 | AAPL | Stock | 11.9686 | 11.9686 | 11.9607 | 11.9607 | 40432.0 |
| 2011-04-11 08:12:00 | AAPL | Stock | 11.9536 | 11.9536 | 11.9536 | 11.9536 | 8400.0 |
| 2011-04-11 08:13:00 | AAPL | Stock | 11.9607 | 11.9607 | 11.9579 | 11.9579 | 10920.0 |
> showing 50 of 984,425 rows — these rows as CSV