PREVIEW / stock_5min / 2011-08-03
file: by_date/stock_5min/2011/2011-08-03.parquet size: 5.1 MB rows: 340,823 symbols: 3,530
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-08-03 04:00:00 | AAPL | Stock | 13.9254 | 13.9254 | 13.9254 | 13.9254 | 2800.0 |
| 2011-08-03 04:05:00 | AAPL | Stock | 13.9054 | 13.9054 | 13.9054 | 13.9054 | 2800.0 |
| 2011-08-03 04:15:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-03 04:20:00 | AAPL | Stock | 13.9364 | 13.9368 | 13.9364 | 13.9368 | 5600.0 |
| 2011-08-03 04:25:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9464 | 13.9464 | 2800.0 |
| 2011-08-03 04:30:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9357 | 13.9357 | 8400.0 |
| 2011-08-03 04:35:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9357 | 13.9407 | 14000.0 |
| 2011-08-03 04:40:00 | AAPL | Stock | 13.9411 | 13.9411 | 13.9368 | 13.9368 | 8400.0 |
| 2011-08-03 04:45:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 5600.0 |
| 2011-08-03 04:50:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 8400.0 |
| 2011-08-03 05:05:00 | AAPL | Stock | 13.9446 | 13.9446 | 13.9446 | 13.9446 | 2800.0 |
| 2011-08-03 05:15:00 | AAPL | Stock | 13.9446 | 13.9518 | 13.9446 | 13.9518 | 11200.0 |
| 2011-08-03 05:25:00 | AAPL | Stock | 13.9536 | 13.9568 | 13.9536 | 13.9568 | 5600.0 |
| 2011-08-03 05:30:00 | AAPL | Stock | 13.9571 | 13.9571 | 13.9571 | 13.9571 | 2800.0 |
| 2011-08-03 05:40:00 | AAPL | Stock | 13.9571 | 13.9571 | 13.9571 | 13.9571 | 2800.0 |
| 2011-08-03 05:45:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9 | 13.9 | 57400.0 |
| 2011-08-03 05:55:00 | AAPL | Stock | 13.9293 | 13.9293 | 13.9293 | 13.9293 | 2800.0 |
| 2011-08-03 06:00:00 | AAPL | Stock | 13.9304 | 13.9571 | 13.9304 | 13.9571 | 33600.0 |
| 2011-08-03 06:10:00 | AAPL | Stock | 13.9229 | 13.9229 | 13.9229 | 13.9229 | 2800.0 |
| 2011-08-03 06:15:00 | AAPL | Stock | 13.9393 | 13.9429 | 13.9296 | 13.9296 | 19600.0 |
| 2011-08-03 06:20:00 | AAPL | Stock | 13.9329 | 13.9329 | 13.9329 | 13.9329 | 2800.0 |
| 2011-08-03 06:30:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9346 | 13.9346 | 11480.0 |
| 2011-08-03 06:35:00 | AAPL | Stock | 13.9493 | 13.975 | 13.9493 | 13.975 | 65772.0 |
| 2011-08-03 06:40:00 | AAPL | Stock | 13.975 | 14.0093 | 13.975 | 14.0007 | 48188.0 |
| 2011-08-03 06:45:00 | AAPL | Stock | 13.9821 | 13.9846 | 13.9821 | 13.9846 | 11200.0 |
| 2011-08-03 06:50:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.975 | 13.975 | 22400.0 |
| 2011-08-03 06:55:00 | AAPL | Stock | 13.975 | 13.9786 | 13.975 | 13.975 | 25340.0 |
| 2011-08-03 07:00:00 | AAPL | Stock | 13.975 | 13.98 | 13.9643 | 13.9643 | 62972.0 |
| 2011-08-03 07:05:00 | AAPL | Stock | 13.9643 | 13.9754 | 13.9643 | 13.9696 | 61684.0 |
| 2011-08-03 07:10:00 | AAPL | Stock | 13.9686 | 13.975 | 13.9643 | 13.9675 | 25732.0 |
| 2011-08-03 07:15:00 | AAPL | Stock | 13.9675 | 13.9679 | 13.9554 | 13.9643 | 53844.0 |
| 2011-08-03 07:20:00 | AAPL | Stock | 13.9625 | 13.9643 | 13.9571 | 13.9571 | 19600.0 |
| 2011-08-03 07:25:00 | AAPL | Stock | 13.9536 | 13.9536 | 13.9471 | 13.95 | 38500.0 |
| 2011-08-03 07:30:00 | AAPL | Stock | 13.9514 | 13.9514 | 13.9339 | 13.9464 | 94584.0 |
| 2011-08-03 07:35:00 | AAPL | Stock | 13.9496 | 13.9496 | 13.9414 | 13.9414 | 8400.0 |
| 2011-08-03 07:40:00 | AAPL | Stock | 13.9404 | 13.9454 | 13.9354 | 13.9454 | 58044.0 |
| 2011-08-03 07:45:00 | AAPL | Stock | 13.9443 | 13.9443 | 13.9375 | 13.9404 | 14000.0 |
| 2011-08-03 07:50:00 | AAPL | Stock | 13.9393 | 13.9393 | 13.9286 | 13.9286 | 72828.0 |
| 2011-08-03 07:55:00 | AAPL | Stock | 13.9286 | 13.9468 | 13.9279 | 13.9464 | 115052.0 |
| 2011-08-03 08:00:00 | AAPL | Stock | 13.9532 | 13.9607 | 13.945 | 13.9607 | 421876.0 |
| 2011-08-03 08:05:00 | AAPL | Stock | 13.9464 | 13.95 | 13.9357 | 13.95 | 113176.0 |
| 2011-08-03 08:10:00 | AAPL | Stock | 13.9525 | 13.9525 | 13.925 | 13.925 | 130760.0 |
| 2011-08-03 08:15:00 | AAPL | Stock | 13.925 | 14.0082 | 13.9207 | 14.0 | 780192.0 |
| 2011-08-03 08:20:00 | AAPL | Stock | 14.0046 | 14.0168 | 13.9857 | 13.9921 | 352184.0 |
| 2011-08-03 08:25:00 | AAPL | Stock | 13.9954 | 14.0064 | 13.9875 | 14.0064 | 416780.0 |
| 2011-08-03 08:30:00 | AAPL | Stock | 14.0068 | 14.0118 | 13.9936 | 14.0118 | 146412.0 |
| 2011-08-03 08:35:00 | AAPL | Stock | 14.0068 | 14.0146 | 14.0064 | 14.0107 | 190540.0 |
| 2011-08-03 08:40:00 | AAPL | Stock | 14.0089 | 14.0125 | 14.0018 | 14.0036 | 113400.0 |
| 2011-08-03 08:45:00 | AAPL | Stock | 14.0039 | 14.0236 | 14.0039 | 14.0089 | 224000.0 |
| 2011-08-03 08:50:00 | AAPL | Stock | 14.0107 | 14.0171 | 14.0089 | 14.0143 | 140336.0 |
> showing 50 of 340,823 rows — these rows as CSV