PREVIEW / stock_1min / 2010-11-19
file: by_date/stock_1min/2010/2010-11-19.parquet size: 12.2 MB rows: 920,430 symbols: 2,859
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-19 04:00:00 | AAPL | Stock | 11.0357 | 11.0357 | 11.0357 | 11.0357 | 2800.0 |
| 2010-11-19 04:02:00 | AAPL | Stock | 11.0357 | 11.0429 | 11.0357 | 11.0429 | 5600.0 |
| 2010-11-19 04:07:00 | AAPL | Stock | 11.0357 | 11.0357 | 11.0357 | 11.0357 | 2800.0 |
| 2010-11-19 04:38:00 | AAPL | Stock | 11.0093 | 11.0093 | 11.0093 | 11.0093 | 2800.0 |
| 2010-11-19 05:31:00 | AAPL | Stock | 11.0093 | 11.0093 | 11.0093 | 11.0093 | 2800.0 |
| 2010-11-19 05:32:00 | AAPL | Stock | 11.0061 | 11.0139 | 10.9971 | 11.0139 | 11200.0 |
| 2010-11-19 05:45:00 | AAPL | Stock | 11.025 | 11.025 | 11.025 | 11.025 | 2800.0 |
| 2010-11-19 05:55:00 | AAPL | Stock | 11.0332 | 11.0332 | 11.0332 | 11.0332 | 2800.0 |
| 2010-11-19 06:02:00 | AAPL | Stock | 11.0429 | 11.0429 | 11.0429 | 11.0429 | 2800.0 |
| 2010-11-19 06:03:00 | AAPL | Stock | 11.0479 | 11.0479 | 11.0479 | 11.0479 | 2800.0 |
| 2010-11-19 07:01:00 | AAPL | Stock | 11.0179 | 11.0179 | 11.0179 | 11.0179 | 2800.0 |
| 2010-11-19 07:03:00 | AAPL | Stock | 11.0375 | 11.0379 | 11.0375 | 11.0379 | 5600.0 |
| 2010-11-19 07:04:00 | AAPL | Stock | 11.0182 | 11.0182 | 11.0182 | 11.0182 | 2800.0 |
| 2010-11-19 07:05:00 | AAPL | Stock | 11.0182 | 11.0182 | 11.0179 | 11.0179 | 8400.0 |
| 2010-11-19 07:06:00 | AAPL | Stock | 11.0182 | 11.0182 | 11.0182 | 11.0182 | 2800.0 |
| 2010-11-19 07:09:00 | AAPL | Stock | 11.0064 | 11.0064 | 11.0064 | 11.0064 | 8400.0 |
| 2010-11-19 07:19:00 | AAPL | Stock | 11.0143 | 11.0143 | 11.0143 | 11.0143 | 8316.0 |
| 2010-11-19 07:20:00 | AAPL | Stock | 11.0143 | 11.0143 | 11.0061 | 11.0061 | 39284.0 |
| 2010-11-19 07:23:00 | AAPL | Stock | 10.9857 | 10.9857 | 10.9857 | 10.9857 | 2800.0 |
| 2010-11-19 07:28:00 | AAPL | Stock | 10.9789 | 10.9789 | 10.9789 | 10.9789 | 8400.0 |
| 2010-11-19 07:29:00 | AAPL | Stock | 10.9786 | 10.9786 | 10.9786 | 10.9786 | 7000.0 |
| 2010-11-19 07:34:00 | AAPL | Stock | 10.9579 | 10.9579 | 10.9579 | 10.9579 | 2800.0 |
| 2010-11-19 07:37:00 | AAPL | Stock | 10.9854 | 10.9854 | 10.9818 | 10.9818 | 11900.0 |
| 2010-11-19 07:48:00 | AAPL | Stock | 10.9893 | 10.9893 | 10.9893 | 10.9893 | 8400.0 |
| 2010-11-19 07:58:00 | AAPL | Stock | 10.9821 | 10.9864 | 10.9821 | 10.9864 | 16800.0 |
| 2010-11-19 08:00:00 | AAPL | Stock | 10.9857 | 10.9893 | 10.9754 | 10.9882 | 49084.0 |
| 2010-11-19 08:01:00 | AAPL | Stock | 10.9875 | 10.9893 | 10.9861 | 10.9893 | 74564.0 |
| 2010-11-19 08:02:00 | AAPL | Stock | 10.9893 | 10.9893 | 10.9857 | 10.9857 | 48160.0 |
| 2010-11-19 08:03:00 | AAPL | Stock | 10.9875 | 10.9893 | 10.9875 | 10.9893 | 47600.0 |
| 2010-11-19 08:04:00 | AAPL | Stock | 10.9907 | 10.9943 | 10.9907 | 10.9943 | 80192.0 |
| 2010-11-19 08:05:00 | AAPL | Stock | 10.9946 | 11.0 | 10.9918 | 10.9918 | 49000.0 |
| 2010-11-19 08:06:00 | AAPL | Stock | 10.9996 | 11.0 | 10.9996 | 11.0 | 13720.0 |
| 2010-11-19 08:07:00 | AAPL | Stock | 11.0 | 11.0071 | 11.0 | 11.0071 | 11200.0 |
| 2010-11-19 08:08:00 | AAPL | Stock | 11.0061 | 11.0082 | 11.0043 | 11.0082 | 33040.0 |
| 2010-11-19 08:09:00 | AAPL | Stock | 11.0064 | 11.0068 | 10.9964 | 11.0021 | 50400.0 |
| 2010-11-19 08:10:00 | AAPL | Stock | 11.005 | 11.0061 | 11.005 | 11.0061 | 88760.0 |
| 2010-11-19 08:11:00 | AAPL | Stock | 11.0043 | 11.0179 | 11.0043 | 11.0175 | 109760.0 |
| 2010-11-19 08:12:00 | AAPL | Stock | 11.0143 | 11.0143 | 11.0121 | 11.0121 | 38360.0 |
| 2010-11-19 08:13:00 | AAPL | Stock | 11.0175 | 11.0179 | 11.0161 | 11.0179 | 24500.0 |
| 2010-11-19 08:14:00 | AAPL | Stock | 11.0171 | 11.0171 | 11.0171 | 11.0171 | 2800.0 |
| 2010-11-19 08:15:00 | AAPL | Stock | 11.0161 | 11.0161 | 11.0093 | 11.0093 | 34160.0 |
| 2010-11-19 08:16:00 | AAPL | Stock | 11.0089 | 11.0089 | 11.0089 | 11.0089 | 2800.0 |
| 2010-11-19 08:17:00 | AAPL | Stock | 11.0129 | 11.0129 | 11.0129 | 11.0129 | 5600.0 |
| 2010-11-19 08:18:00 | AAPL | Stock | 11.0132 | 11.0132 | 11.0132 | 11.0132 | 22400.0 |
| 2010-11-19 08:19:00 | AAPL | Stock | 11.0132 | 11.0132 | 11.0132 | 11.0132 | 3920.0 |
| 2010-11-19 08:21:00 | AAPL | Stock | 11.0107 | 11.0107 | 11.0107 | 11.0107 | 2940.0 |
| 2010-11-19 08:23:00 | AAPL | Stock | 11.0107 | 11.0157 | 11.0107 | 11.0157 | 29512.0 |
| 2010-11-19 08:24:00 | AAPL | Stock | 11.0089 | 11.0089 | 11.0071 | 11.0071 | 46928.0 |
| 2010-11-19 08:25:00 | AAPL | Stock | 11.0018 | 11.0018 | 11.0018 | 11.0018 | 5600.0 |
| 2010-11-19 08:28:00 | AAPL | Stock | 11.0079 | 11.0136 | 11.0071 | 11.0071 | 15260.0 |
> showing 50 of 920,430 rows — these rows as CSV