PREVIEW / stock_5min / 2009-08-20
file: by_date/stock_5min/2009/2009-08-20.parquet size: 4.4 MB rows: 310,702 symbols: 3,367
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:00:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9071 | 5.9071 | 31360.0 |
| 2009-08-20 07:05:00 | AAPL | Stock | 5.9179 | 5.9196 | 5.9179 | 5.9196 | 8400.0 |
| 2009-08-20 07:10:00 | AAPL | Stock | 5.9071 | 5.9107 | 5.9071 | 5.9107 | 62300.0 |
| 2009-08-20 07:45:00 | AAPL | Stock | 5.8982 | 5.8986 | 5.8982 | 5.8986 | 5600.0 |
| 2009-08-20 07:50:00 | AAPL | Stock | 5.9018 | 5.9046 | 5.9018 | 5.9046 | 22400.0 |
| 2009-08-20 08:00:00 | AAPL | Stock | 5.9046 | 5.9089 | 5.8968 | 5.9089 | 160944.0 |
| 2009-08-20 08:05:00 | AAPL | Stock | 5.9086 | 5.9125 | 5.9086 | 5.9125 | 156800.0 |
| 2009-08-20 08:10:00 | AAPL | Stock | 5.9093 | 5.9161 | 5.9093 | 5.915 | 64708.0 |
| 2009-08-20 08:15:00 | AAPL | Stock | 5.915 | 5.915 | 5.9136 | 5.9136 | 35000.0 |
| 2009-08-20 08:20:00 | AAPL | Stock | 5.9146 | 5.9146 | 5.9096 | 5.9143 | 19012.0 |
| 2009-08-20 08:25:00 | AAPL | Stock | 5.9143 | 5.9171 | 5.9107 | 5.9171 | 49980.0 |
| 2009-08-20 08:30:00 | AAPL | Stock | 5.9107 | 5.9179 | 5.8982 | 5.9021 | 735056.0 |
| 2009-08-20 08:35:00 | AAPL | Stock | 5.9104 | 5.9107 | 5.9071 | 5.9089 | 161952.0 |
| 2009-08-20 08:40:00 | AAPL | Stock | 5.9089 | 5.9139 | 5.9 | 5.9054 | 205324.0 |
| 2009-08-20 08:45:00 | AAPL | Stock | 5.9082 | 5.9082 | 5.8964 | 5.9018 | 530460.0 |
| 2009-08-20 08:50:00 | AAPL | Stock | 5.9061 | 5.9107 | 5.9004 | 5.9061 | 475160.0 |
| 2009-08-20 08:55:00 | AAPL | Stock | 5.9086 | 5.9125 | 5.9061 | 5.9125 | 362684.0 |
| 2009-08-20 09:00:00 | AAPL | Stock | 5.9114 | 5.9114 | 5.8975 | 5.8982 | 414540.0 |
| 2009-08-20 09:05:00 | AAPL | Stock | 5.8968 | 5.8975 | 5.8886 | 5.8911 | 655340.0 |
| 2009-08-20 09:10:00 | AAPL | Stock | 5.8896 | 5.8971 | 5.8896 | 5.8918 | 187600.0 |
| 2009-08-20 09:15:00 | AAPL | Stock | 5.8939 | 5.8964 | 5.8925 | 5.8943 | 25200.0 |
| 2009-08-20 09:20:00 | AAPL | Stock | 5.8921 | 5.8929 | 5.8911 | 5.8911 | 61040.0 |
| 2009-08-20 09:25:00 | AAPL | Stock | 5.8936 | 5.8936 | 5.8911 | 5.8921 | 258944.0 |
| 2009-08-20 09:30:00 | AAPL | Stock | 5.8925 | 5.8971 | 5.8789 | 5.8875 | 12368440.0 |
| 2009-08-20 09:35:00 | AAPL | Stock | 5.8871 | 5.9154 | 5.8871 | 5.915 | 10312680.0 |
| 2009-08-20 09:40:00 | AAPL | Stock | 5.915 | 5.9257 | 5.9136 | 5.9154 | 10883684.0 |
| 2009-08-20 09:45:00 | AAPL | Stock | 5.9146 | 5.9229 | 5.9139 | 5.9161 | 7195328.0 |
| 2009-08-20 09:50:00 | AAPL | Stock | 5.9161 | 5.9229 | 5.9136 | 5.9198 | 5434520.0 |
| 2009-08-20 09:55:00 | AAPL | Stock | 5.9171 | 5.9286 | 5.9161 | 5.9286 | 6675732.0 |
| 2009-08-20 10:00:00 | AAPL | Stock | 5.9282 | 5.9357 | 5.9218 | 5.9339 | 10859968.0 |
| 2009-08-20 10:05:00 | AAPL | Stock | 5.9336 | 5.9343 | 5.9236 | 5.9268 | 11913216.0 |
| 2009-08-20 10:10:00 | AAPL | Stock | 5.9282 | 5.9357 | 5.9236 | 5.9307 | 5128592.0 |
| 2009-08-20 10:15:00 | AAPL | Stock | 5.9296 | 5.9336 | 5.9229 | 5.9286 | 5675796.0 |
| 2009-08-20 10:20:00 | AAPL | Stock | 5.9289 | 5.9321 | 5.9243 | 5.9268 | 3919860.0 |
| 2009-08-20 10:25:00 | AAPL | Stock | 5.9264 | 5.9307 | 5.9239 | 5.9286 | 3220784.0 |
| 2009-08-20 10:30:00 | AAPL | Stock | 5.9282 | 5.9339 | 5.9275 | 5.9321 | 4347196.0 |
| 2009-08-20 10:35:00 | AAPL | Stock | 5.9321 | 5.9339 | 5.9289 | 5.9307 | 3227028.0 |
| 2009-08-20 10:40:00 | AAPL | Stock | 5.9311 | 5.9421 | 5.9232 | 5.9417 | 6814836.0 |
| 2009-08-20 10:45:00 | AAPL | Stock | 5.9411 | 5.9418 | 5.9336 | 5.9354 | 2657788.0 |
| 2009-08-20 10:50:00 | AAPL | Stock | 5.9354 | 5.9354 | 5.9268 | 5.9309 | 4111548.0 |
| 2009-08-20 10:55:00 | AAPL | Stock | 5.9314 | 5.9357 | 5.9275 | 5.93 | 2726164.0 |
| 2009-08-20 11:00:00 | AAPL | Stock | 5.93 | 5.9329 | 5.9257 | 5.93 | 2833488.0 |
| 2009-08-20 11:05:00 | AAPL | Stock | 5.93 | 5.9332 | 5.9282 | 5.9296 | 3058776.0 |
| 2009-08-20 11:10:00 | AAPL | Stock | 5.9289 | 5.9329 | 5.9261 | 5.9304 | 2266824.0 |
| 2009-08-20 11:15:00 | AAPL | Stock | 5.93 | 5.9307 | 5.9268 | 5.9268 | 2352952.0 |
| 2009-08-20 11:20:00 | AAPL | Stock | 5.9271 | 5.9311 | 5.925 | 5.9289 | 2410884.0 |
| 2009-08-20 11:25:00 | AAPL | Stock | 5.9286 | 5.9318 | 5.9271 | 5.9314 | 2044168.0 |
| 2009-08-20 11:30:00 | AAPL | Stock | 5.9314 | 5.9321 | 5.925 | 5.9273 | 3852212.0 |
| 2009-08-20 11:35:00 | AAPL | Stock | 5.9264 | 5.9275 | 5.9179 | 5.9232 | 4663428.0 |
| 2009-08-20 11:40:00 | AAPL | Stock | 5.9232 | 5.9236 | 5.9211 | 5.9218 | 2933168.0 |
> showing 50 of 310,702 rows — these rows as CSV