PREVIEW / stock_1min / 2009-08-20
file: by_date/stock_1min/2009/2009-08-20.parquet size: 12.0 MB rows: 922,304 symbols: 2,732
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-20 07:02:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9071 | 5.9071 | 31360.0 |
| 2009-08-20 07:08:00 | AAPL | Stock | 5.9179 | 5.9196 | 5.9179 | 5.9196 | 8400.0 |
| 2009-08-20 07:12:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9071 | 5.9071 | 11900.0 |
| 2009-08-20 07:13:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9071 | 5.9071 | 11200.0 |
| 2009-08-20 07:14:00 | AAPL | Stock | 5.9071 | 5.9107 | 5.9071 | 5.9107 | 39200.0 |
| 2009-08-20 07:48:00 | AAPL | Stock | 5.8982 | 5.8982 | 5.8982 | 5.8982 | 2800.0 |
| 2009-08-20 07:49:00 | AAPL | Stock | 5.8986 | 5.8986 | 5.8986 | 5.8986 | 2800.0 |
| 2009-08-20 07:51:00 | AAPL | Stock | 5.9018 | 5.9046 | 5.9018 | 5.9046 | 22400.0 |
| 2009-08-20 08:00:00 | AAPL | Stock | 5.9046 | 5.9046 | 5.8968 | 5.9046 | 37856.0 |
| 2009-08-20 08:01:00 | AAPL | Stock | 5.9 | 5.9086 | 5.9 | 5.9086 | 75320.0 |
| 2009-08-20 08:02:00 | AAPL | Stock | 5.9079 | 5.9079 | 5.9057 | 5.9057 | 19068.0 |
| 2009-08-20 08:03:00 | AAPL | Stock | 5.9086 | 5.9089 | 5.9086 | 5.9089 | 14000.0 |
| 2009-08-20 08:04:00 | AAPL | Stock | 5.9089 | 5.9089 | 5.9089 | 5.9089 | 14700.0 |
| 2009-08-20 08:06:00 | AAPL | Stock | 5.9086 | 5.9089 | 5.9086 | 5.9089 | 8400.0 |
| 2009-08-20 08:07:00 | AAPL | Stock | 5.91 | 5.91 | 5.9089 | 5.9089 | 22400.0 |
| 2009-08-20 08:08:00 | AAPL | Stock | 5.9089 | 5.9104 | 5.9089 | 5.9104 | 18200.0 |
| 2009-08-20 08:09:00 | AAPL | Stock | 5.9104 | 5.9125 | 5.9104 | 5.9125 | 107800.0 |
| 2009-08-20 08:10:00 | AAPL | Stock | 5.9093 | 5.9093 | 5.9093 | 5.9093 | 2800.0 |
| 2009-08-20 08:12:00 | AAPL | Stock | 5.9154 | 5.9161 | 5.9154 | 5.9154 | 38108.0 |
| 2009-08-20 08:13:00 | AAPL | Stock | 5.9146 | 5.9146 | 5.9146 | 5.9146 | 11200.0 |
| 2009-08-20 08:14:00 | AAPL | Stock | 5.9146 | 5.915 | 5.9146 | 5.915 | 12600.0 |
| 2009-08-20 08:15:00 | AAPL | Stock | 5.915 | 5.915 | 5.915 | 5.915 | 13132.0 |
| 2009-08-20 08:18:00 | AAPL | Stock | 5.915 | 5.915 | 5.915 | 5.915 | 12068.0 |
| 2009-08-20 08:19:00 | AAPL | Stock | 5.9139 | 5.9139 | 5.9136 | 5.9136 | 9800.0 |
| 2009-08-20 08:20:00 | AAPL | Stock | 5.9146 | 5.9146 | 5.9146 | 5.9146 | 8036.0 |
| 2009-08-20 08:21:00 | AAPL | Stock | 5.9096 | 5.9096 | 5.9096 | 5.9096 | 2800.0 |
| 2009-08-20 08:24:00 | AAPL | Stock | 5.9125 | 5.9143 | 5.9125 | 5.9143 | 8176.0 |
| 2009-08-20 08:25:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9107 | 5.9143 | 29820.0 |
| 2009-08-20 08:27:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 11200.0 |
| 2009-08-20 08:28:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9171 | 5.9171 | 8960.0 |
| 2009-08-20 08:30:00 | AAPL | Stock | 5.9107 | 5.9118 | 5.9096 | 5.9107 | 323904.0 |
| 2009-08-20 08:31:00 | AAPL | Stock | 5.9075 | 5.9179 | 5.8989 | 5.8989 | 245168.0 |
| 2009-08-20 08:32:00 | AAPL | Stock | 5.8982 | 5.9 | 5.8982 | 5.8986 | 123340.0 |
| 2009-08-20 08:33:00 | AAPL | Stock | 5.9032 | 5.9071 | 5.9032 | 5.9071 | 11200.0 |
| 2009-08-20 08:34:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9018 | 5.9021 | 31444.0 |
| 2009-08-20 08:35:00 | AAPL | Stock | 5.9104 | 5.9107 | 5.9104 | 5.9107 | 67200.0 |
| 2009-08-20 08:38:00 | AAPL | Stock | 5.9079 | 5.9107 | 5.9071 | 5.9107 | 61600.0 |
| 2009-08-20 08:39:00 | AAPL | Stock | 5.9096 | 5.9096 | 5.9089 | 5.9089 | 33152.0 |
| 2009-08-20 08:40:00 | AAPL | Stock | 5.9089 | 5.9089 | 5.9 | 5.9004 | 17304.0 |
| 2009-08-20 08:41:00 | AAPL | Stock | 5.9086 | 5.9139 | 5.9004 | 5.9054 | 158200.0 |
| 2009-08-20 08:42:00 | AAPL | Stock | 5.9057 | 5.9057 | 5.9043 | 5.9043 | 5600.0 |
| 2009-08-20 08:44:00 | AAPL | Stock | 5.9054 | 5.9064 | 5.9054 | 5.9054 | 24220.0 |
| 2009-08-20 08:45:00 | AAPL | Stock | 5.9082 | 5.9082 | 5.9082 | 5.9082 | 2800.0 |
| 2009-08-20 08:46:00 | AAPL | Stock | 5.9043 | 5.9043 | 5.9018 | 5.9018 | 43680.0 |
| 2009-08-20 08:47:00 | AAPL | Stock | 5.9004 | 5.9004 | 5.8971 | 5.8982 | 239540.0 |
| 2009-08-20 08:48:00 | AAPL | Stock | 5.8982 | 5.8982 | 5.8964 | 5.8982 | 148400.0 |
| 2009-08-20 08:49:00 | AAPL | Stock | 5.8982 | 5.9029 | 5.8982 | 5.9018 | 96040.0 |
| 2009-08-20 08:50:00 | AAPL | Stock | 5.9061 | 5.9107 | 5.9004 | 5.9004 | 206360.0 |
| 2009-08-20 08:51:00 | AAPL | Stock | 5.9064 | 5.9107 | 5.9064 | 5.9086 | 176400.0 |
| 2009-08-20 08:53:00 | AAPL | Stock | 5.9071 | 5.9107 | 5.9061 | 5.9061 | 92400.0 |
> showing 50 of 922,304 rows — these rows as CSV