PREVIEW / stock_5min / 2013-02-11
file: by_date/stock_5min/2013/2013-02-11.parquet size: 4.8 MB rows: 321,357 symbols: 3,482
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-11 04:00:00 | AAPL | Stock | 17.0393 | 17.0393 | 17.0357 | 17.0357 | 58240.0 |
| 2013-02-11 04:05:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 2800.0 |
| 2013-02-11 04:10:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0893 | 17.0893 | 9380.0 |
| 2013-02-11 04:20:00 | AAPL | Stock | 17.0871 | 17.0893 | 17.0871 | 17.0893 | 19600.0 |
| 2013-02-11 04:30:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0893 | 17.0893 | 4620.0 |
| 2013-02-11 04:40:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0804 | 17.0804 | 16800.0 |
| 2013-02-11 05:00:00 | AAPL | Stock | 17.0718 | 17.0718 | 17.0718 | 17.0718 | 7000.0 |
| 2013-02-11 05:15:00 | AAPL | Stock | 17.0739 | 17.0739 | 17.0536 | 17.0536 | 28000.0 |
| 2013-02-11 05:20:00 | AAPL | Stock | 17.0536 | 17.0589 | 17.0536 | 17.0589 | 8400.0 |
| 2013-02-11 05:30:00 | AAPL | Stock | 17.0464 | 17.0464 | 17.0464 | 17.0464 | 8400.0 |
| 2013-02-11 05:40:00 | AAPL | Stock | 17.0689 | 17.0689 | 17.0689 | 17.0689 | 5040.0 |
| 2013-02-11 05:55:00 | AAPL | Stock | 17.0668 | 17.0668 | 17.0668 | 17.0668 | 2800.0 |
| 2013-02-11 06:00:00 | AAPL | Stock | 17.0689 | 17.0689 | 17.0689 | 17.0689 | 2800.0 |
| 2013-02-11 06:10:00 | AAPL | Stock | 17.0711 | 17.0711 | 17.0579 | 17.0579 | 14000.0 |
| 2013-02-11 06:15:00 | AAPL | Stock | 17.0643 | 17.0643 | 17.0625 | 17.0625 | 5600.0 |
| 2013-02-11 06:20:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 5600.0 |
| 2013-02-11 06:25:00 | AAPL | Stock | 17.0571 | 17.0571 | 17.0571 | 17.0571 | 5600.0 |
| 2013-02-11 06:30:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 2800.0 |
| 2013-02-11 06:35:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 5600.0 |
| 2013-02-11 06:55:00 | AAPL | Stock | 17.0696 | 17.0696 | 17.0696 | 17.0696 | 5600.0 |
| 2013-02-11 07:00:00 | AAPL | Stock | 17.0696 | 17.0714 | 17.0543 | 17.0543 | 193200.0 |
| 2013-02-11 07:05:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0393 | 17.0393 | 85400.0 |
| 2013-02-11 07:10:00 | AAPL | Stock | 17.0379 | 17.0536 | 17.0321 | 17.0536 | 87136.0 |
| 2013-02-11 07:15:00 | AAPL | Stock | 17.0536 | 17.0696 | 17.0536 | 17.0696 | 96936.0 |
| 2013-02-11 07:20:00 | AAPL | Stock | 17.0696 | 17.0696 | 17.0643 | 17.0679 | 57848.0 |
| 2013-02-11 07:25:00 | AAPL | Stock | 17.0675 | 17.0679 | 17.0429 | 17.0429 | 50008.0 |
| 2013-02-11 07:30:00 | AAPL | Stock | 17.0496 | 17.0532 | 17.0439 | 17.0532 | 27188.0 |
| 2013-02-11 07:35:00 | AAPL | Stock | 17.0639 | 17.0639 | 17.0607 | 17.0607 | 10500.0 |
| 2013-02-11 07:40:00 | AAPL | Stock | 17.0636 | 17.0636 | 17.045 | 17.0464 | 45360.0 |
| 2013-02-11 07:45:00 | AAPL | Stock | 17.04 | 17.0493 | 17.0261 | 17.0261 | 108220.0 |
| 2013-02-11 07:50:00 | AAPL | Stock | 17.0393 | 17.0393 | 17.0179 | 17.0179 | 141008.0 |
| 2013-02-11 07:55:00 | AAPL | Stock | 17.0161 | 17.02 | 17.0021 | 17.0118 | 212800.0 |
| 2013-02-11 08:00:00 | AAPL | Stock | 17.0096 | 17.0696 | 17.0096 | 17.0361 | 1010576.0 |
| 2013-02-11 08:05:00 | AAPL | Stock | 17.0396 | 17.0536 | 17.0321 | 17.0457 | 340732.0 |
| 2013-02-11 08:10:00 | AAPL | Stock | 17.0446 | 17.0536 | 17.0414 | 17.0511 | 304948.0 |
| 2013-02-11 08:15:00 | AAPL | Stock | 17.0507 | 17.0529 | 17.0361 | 17.0361 | 211512.0 |
| 2013-02-11 08:20:00 | AAPL | Stock | 17.0364 | 17.0364 | 17.0093 | 17.0214 | 194320.0 |
| 2013-02-11 08:25:00 | AAPL | Stock | 17.0214 | 17.0357 | 17.0179 | 17.0329 | 133952.0 |
| 2013-02-11 08:30:00 | AAPL | Stock | 17.03 | 17.0329 | 17.0221 | 17.0286 | 168784.0 |
| 2013-02-11 08:35:00 | AAPL | Stock | 17.0254 | 17.0329 | 17.0011 | 17.0043 | 499184.0 |
| 2013-02-11 08:40:00 | AAPL | Stock | 17.0021 | 17.0107 | 17.0 | 17.0054 | 504700.0 |
| 2013-02-11 08:45:00 | AAPL | Stock | 17.0018 | 17.0257 | 16.9636 | 17.0175 | 245000.0 |
| 2013-02-11 08:50:00 | AAPL | Stock | 17.0171 | 17.0171 | 17.0143 | 17.0157 | 40236.0 |
| 2013-02-11 08:55:00 | AAPL | Stock | 17.0161 | 17.0243 | 17.0107 | 17.0196 | 493248.0 |
| 2013-02-11 09:00:00 | AAPL | Stock | 17.0186 | 17.0196 | 17.0104 | 17.0143 | 159740.0 |
| 2013-02-11 09:05:00 | AAPL | Stock | 17.0179 | 17.0239 | 17.0161 | 17.0189 | 86436.0 |
| 2013-02-11 09:10:00 | AAPL | Stock | 17.0186 | 17.0196 | 17.0071 | 17.0118 | 131908.0 |
| 2013-02-11 09:15:00 | AAPL | Stock | 17.0118 | 17.0139 | 16.995 | 16.995 | 429240.0 |
| 2013-02-11 09:20:00 | AAPL | Stock | 16.9932 | 17.0107 | 16.9893 | 17.01 | 359576.0 |
| 2013-02-11 09:25:00 | AAPL | Stock | 17.0118 | 17.0464 | 17.0107 | 17.02 | 1869196.0 |
> showing 50 of 321,357 rows — these rows as CSV