PREVIEW / stock_1min / 2010-06-10
file: by_date/stock_1min/2010/2010-06-10.parquet size: 12.6 MB rows: 969,795 symbols: 2,803
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-06-10 04:53:00 | AAPL | Stock | 8.7746 | 8.7746 | 8.7746 | 8.7746 | 2800.0 |
| 2010-06-10 05:16:00 | AAPL | Stock | 8.8114 | 8.8114 | 8.8114 | 8.8114 | 7644.0 |
| 2010-06-10 05:20:00 | AAPL | Stock | 8.8114 | 8.8114 | 8.8114 | 8.8114 | 9156.0 |
| 2010-06-10 05:22:00 | AAPL | Stock | 8.7979 | 8.7979 | 8.7979 | 8.7979 | 5600.0 |
| 2010-06-10 05:28:00 | AAPL | Stock | 8.8018 | 8.8018 | 8.8018 | 8.8018 | 2800.0 |
| 2010-06-10 05:36:00 | AAPL | Stock | 8.7911 | 8.7911 | 8.7911 | 8.7911 | 2800.0 |
| 2010-06-10 05:41:00 | AAPL | Stock | 8.8018 | 8.8018 | 8.8018 | 8.8018 | 2800.0 |
| 2010-06-10 05:48:00 | AAPL | Stock | 8.8018 | 8.8018 | 8.8018 | 8.8018 | 2800.0 |
| 2010-06-10 06:27:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 8400.0 |
| 2010-06-10 06:28:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 33600.0 |
| 2010-06-10 07:01:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 16800.0 |
| 2010-06-10 07:02:00 | AAPL | Stock | 8.7407 | 8.7857 | 8.7407 | 8.7857 | 5600.0 |
| 2010-06-10 07:06:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 16800.0 |
| 2010-06-10 07:08:00 | AAPL | Stock | 8.7857 | 8.7929 | 8.7857 | 8.7929 | 9380.0 |
| 2010-06-10 07:09:00 | AAPL | Stock | 8.7786 | 8.7786 | 8.7786 | 8.7786 | 14000.0 |
| 2010-06-10 07:11:00 | AAPL | Stock | 8.7839 | 8.7839 | 8.7839 | 8.7839 | 2800.0 |
| 2010-06-10 07:19:00 | AAPL | Stock | 8.775 | 8.775 | 8.775 | 8.775 | 2800.0 |
| 2010-06-10 07:21:00 | AAPL | Stock | 8.7761 | 8.7761 | 8.7761 | 8.7761 | 2800.0 |
| 2010-06-10 07:22:00 | AAPL | Stock | 8.7871 | 8.7914 | 8.7857 | 8.7857 | 56000.0 |
| 2010-06-10 07:23:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 25200.0 |
| 2010-06-10 07:25:00 | AAPL | Stock | 8.7761 | 8.7821 | 8.7757 | 8.7821 | 53480.0 |
| 2010-06-10 07:29:00 | AAPL | Stock | 8.7814 | 8.7821 | 8.7814 | 8.7821 | 14392.0 |
| 2010-06-10 07:30:00 | AAPL | Stock | 8.7814 | 8.7857 | 8.7814 | 8.7814 | 68600.0 |
| 2010-06-10 07:36:00 | AAPL | Stock | 8.7721 | 8.7721 | 8.7721 | 8.7721 | 2800.0 |
| 2010-06-10 07:37:00 | AAPL | Stock | 8.7714 | 8.7714 | 8.7714 | 8.7714 | 14000.0 |
| 2010-06-10 07:39:00 | AAPL | Stock | 8.7618 | 8.7721 | 8.7571 | 8.7607 | 84756.0 |
| 2010-06-10 07:40:00 | AAPL | Stock | 8.7507 | 8.7557 | 8.75 | 8.7554 | 117600.0 |
| 2010-06-10 07:41:00 | AAPL | Stock | 8.7607 | 8.7607 | 8.7607 | 8.7607 | 3640.0 |
| 2010-06-10 07:42:00 | AAPL | Stock | 8.7525 | 8.7575 | 8.75 | 8.7575 | 58800.0 |
| 2010-06-10 07:43:00 | AAPL | Stock | 8.7304 | 8.7304 | 8.7296 | 8.7296 | 28000.0 |
| 2010-06-10 07:45:00 | AAPL | Stock | 8.7304 | 8.7304 | 8.715 | 8.715 | 28000.0 |
| 2010-06-10 07:47:00 | AAPL | Stock | 8.7311 | 8.7318 | 8.7286 | 8.7286 | 28000.0 |
| 2010-06-10 07:48:00 | AAPL | Stock | 8.7196 | 8.7196 | 8.7096 | 8.7143 | 58800.0 |
| 2010-06-10 07:49:00 | AAPL | Stock | 8.7304 | 8.7304 | 8.7304 | 8.7304 | 2800.0 |
| 2010-06-10 07:50:00 | AAPL | Stock | 8.7239 | 8.7239 | 8.7193 | 8.7214 | 20132.0 |
| 2010-06-10 07:51:00 | AAPL | Stock | 8.7125 | 8.7125 | 8.6964 | 8.6964 | 66640.0 |
| 2010-06-10 07:52:00 | AAPL | Stock | 8.6929 | 8.7032 | 8.6929 | 8.7032 | 16800.0 |
| 2010-06-10 07:53:00 | AAPL | Stock | 8.705 | 8.705 | 8.6968 | 8.7036 | 11200.0 |
| 2010-06-10 07:54:00 | AAPL | Stock | 8.7032 | 8.7146 | 8.7018 | 8.7143 | 44268.0 |
| 2010-06-10 07:55:00 | AAPL | Stock | 8.7421 | 8.7421 | 8.7421 | 8.7421 | 2800.0 |
| 2010-06-10 07:56:00 | AAPL | Stock | 8.7271 | 8.7271 | 8.7271 | 8.7271 | 12376.0 |
| 2010-06-10 07:58:00 | AAPL | Stock | 8.7289 | 8.7289 | 8.7286 | 8.7286 | 8400.0 |
| 2010-06-10 07:59:00 | AAPL | Stock | 8.7286 | 8.7286 | 8.7161 | 8.7179 | 31976.0 |
| 2010-06-10 08:00:00 | AAPL | Stock | 8.7143 | 8.7371 | 8.7064 | 8.7339 | 244020.0 |
| 2010-06-10 08:01:00 | AAPL | Stock | 8.7321 | 8.7357 | 8.7255 | 8.7325 | 138684.0 |
| 2010-06-10 08:02:00 | AAPL | Stock | 8.7375 | 8.7411 | 8.7325 | 8.735 | 34020.0 |
| 2010-06-10 08:03:00 | AAPL | Stock | 8.7375 | 8.7375 | 8.7257 | 8.7257 | 196672.0 |
| 2010-06-10 08:04:00 | AAPL | Stock | 8.7296 | 8.7296 | 8.7221 | 8.7257 | 86800.0 |
| 2010-06-10 08:05:00 | AAPL | Stock | 8.725 | 8.7375 | 8.725 | 8.7375 | 109928.0 |
| 2010-06-10 08:06:00 | AAPL | Stock | 8.7393 | 8.7468 | 8.7393 | 8.7443 | 301700.0 |
> showing 50 of 969,795 rows — these rows as CSV