PREVIEW / stock_5min / 2011-03-09
file: by_date/stock_5min/2011/2011-03-09.parquet size: 4.8 MB rows: 324,907 symbols: 3,532
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-03-09 04:20:00 | AAPL | Stock | 12.7104 | 12.7111 | 12.7104 | 12.7111 | 8400.0 |
| 2011-03-09 04:30:00 | AAPL | Stock | 12.7193 | 12.7193 | 12.7193 | 12.7193 | 2800.0 |
| 2011-03-09 06:15:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 5600.0 |
| 2011-03-09 06:30:00 | AAPL | Stock | 12.7661 | 12.7675 | 12.7661 | 12.7661 | 33600.0 |
| 2011-03-09 06:35:00 | AAPL | Stock | 12.7661 | 12.7661 | 12.7661 | 12.7661 | 2800.0 |
| 2011-03-09 07:00:00 | AAPL | Stock | 12.7639 | 12.7639 | 12.7614 | 12.7614 | 5600.0 |
| 2011-03-09 07:05:00 | AAPL | Stock | 12.7429 | 12.7429 | 12.7429 | 12.7429 | 8400.0 |
| 2011-03-09 07:10:00 | AAPL | Stock | 12.745 | 12.75 | 12.745 | 12.75 | 22400.0 |
| 2011-03-09 07:15:00 | AAPL | Stock | 12.745 | 12.745 | 12.7321 | 12.7321 | 5600.0 |
| 2011-03-09 07:25:00 | AAPL | Stock | 12.7393 | 12.7429 | 12.7321 | 12.7321 | 34580.0 |
| 2011-03-09 07:35:00 | AAPL | Stock | 12.7325 | 12.7393 | 12.7318 | 12.7393 | 42000.0 |
| 2011-03-09 07:40:00 | AAPL | Stock | 12.7389 | 12.7482 | 12.7382 | 12.7482 | 48468.0 |
| 2011-03-09 07:45:00 | AAPL | Stock | 12.7414 | 12.7414 | 12.7414 | 12.7414 | 11200.0 |
| 2011-03-09 07:55:00 | AAPL | Stock | 12.7411 | 12.7464 | 12.7411 | 12.7464 | 15260.0 |
| 2011-03-09 08:00:00 | AAPL | Stock | 12.7464 | 12.7496 | 12.7257 | 12.74 | 182588.0 |
| 2011-03-09 08:05:00 | AAPL | Stock | 12.7386 | 12.7393 | 12.7321 | 12.7321 | 22568.0 |
| 2011-03-09 08:10:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7268 | 12.7282 | 86660.0 |
| 2011-03-09 08:15:00 | AAPL | Stock | 12.7325 | 12.7389 | 12.7325 | 12.7389 | 42000.0 |
| 2011-03-09 08:20:00 | AAPL | Stock | 12.7375 | 12.7375 | 12.7304 | 12.7321 | 92400.0 |
| 2011-03-09 08:25:00 | AAPL | Stock | 12.7289 | 12.7357 | 12.7282 | 12.7304 | 250880.0 |
| 2011-03-09 08:30:00 | AAPL | Stock | 12.7336 | 12.7336 | 12.7154 | 12.7175 | 225960.0 |
| 2011-03-09 08:35:00 | AAPL | Stock | 12.7261 | 12.7268 | 12.7064 | 12.7064 | 53620.0 |
| 2011-03-09 08:40:00 | AAPL | Stock | 12.7061 | 12.7214 | 12.6993 | 12.7214 | 68124.0 |
| 2011-03-09 08:50:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7018 | 12.7121 | 81676.0 |
| 2011-03-09 08:55:00 | AAPL | Stock | 12.7143 | 12.7157 | 12.7079 | 12.7079 | 79352.0 |
| 2011-03-09 09:00:00 | AAPL | Stock | 12.7082 | 12.7082 | 12.7 | 12.7036 | 110992.0 |
| 2011-03-09 09:05:00 | AAPL | Stock | 12.7036 | 12.7036 | 12.6964 | 12.6964 | 98700.0 |
| 2011-03-09 09:10:00 | AAPL | Stock | 12.6936 | 12.6986 | 12.69 | 12.6964 | 26208.0 |
| 2011-03-09 09:15:00 | AAPL | Stock | 12.6961 | 12.7014 | 12.6961 | 12.7014 | 16800.0 |
| 2011-03-09 09:20:00 | AAPL | Stock | 12.7 | 12.7014 | 12.6982 | 12.7014 | 68880.0 |
| 2011-03-09 09:25:00 | AAPL | Stock | 12.7007 | 12.7014 | 12.6614 | 12.6664 | 538916.0 |
| 2011-03-09 09:30:00 | AAPL | Stock | 12.6679 | 12.67 | 12.6279 | 12.6471 | 12861100.0 |
| 2011-03-09 09:35:00 | AAPL | Stock | 12.6436 | 12.6457 | 12.5871 | 12.6029 | 10912384.0 |
| 2011-03-09 09:40:00 | AAPL | Stock | 12.6018 | 12.6064 | 12.5532 | 12.6021 | 14685860.0 |
| 2011-03-09 09:45:00 | AAPL | Stock | 12.6021 | 12.6354 | 12.5832 | 12.6025 | 11522308.0 |
| 2011-03-09 09:50:00 | AAPL | Stock | 12.6032 | 12.6496 | 12.5893 | 12.6071 | 8490356.0 |
| 2011-03-09 09:55:00 | AAPL | Stock | 12.6093 | 12.6227 | 12.6014 | 12.6036 | 4555544.0 |
| 2011-03-09 10:00:00 | AAPL | Stock | 12.6014 | 12.6057 | 12.5811 | 12.6043 | 55082132.0 |
| 2011-03-09 10:05:00 | AAPL | Stock | 12.6014 | 12.6357 | 12.5893 | 12.6164 | 5039664.0 |
| 2011-03-09 10:10:00 | AAPL | Stock | 12.6164 | 12.6204 | 12.5964 | 12.5993 | 4055352.0 |
| 2011-03-09 10:15:00 | AAPL | Stock | 12.5982 | 12.6071 | 12.5893 | 12.6054 | 7239316.0 |
| 2011-03-09 10:20:00 | AAPL | Stock | 12.6055 | 12.6321 | 12.6055 | 12.6282 | 6846168.0 |
| 2011-03-09 10:25:00 | AAPL | Stock | 12.6304 | 12.6364 | 12.6036 | 12.6036 | 6324360.0 |
| 2011-03-09 10:30:00 | AAPL | Stock | 12.6036 | 12.6146 | 12.5886 | 12.5942 | 8374324.0 |
| 2011-03-09 10:35:00 | AAPL | Stock | 12.5921 | 12.6025 | 12.5768 | 12.5993 | 9467052.0 |
| 2011-03-09 10:40:00 | AAPL | Stock | 12.6004 | 12.6004 | 12.5718 | 12.5725 | 7568512.0 |
| 2011-03-09 10:45:00 | AAPL | Stock | 12.5725 | 12.5865 | 12.5714 | 12.5757 | 7432908.0 |
| 2011-03-09 10:50:00 | AAPL | Stock | 12.577 | 12.5839 | 12.5532 | 12.5627 | 17510976.0 |
| 2011-03-09 10:55:00 | AAPL | Stock | 12.5625 | 12.575 | 12.5479 | 12.5707 | 12109664.0 |
| 2011-03-09 11:00:00 | AAPL | Stock | 12.5707 | 12.5829 | 12.5489 | 12.5668 | 6345668.0 |
> showing 50 of 324,907 rows — these rows as CSV