PREVIEW / stock_5min / 2010-07-01
file: by_date/stock_5min/2010/2010-07-01.parquet size: 4.9 MB rows: 335,503 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-01 04:15:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 5600.0 |
| 2010-07-01 04:35:00 | AAPL | Stock | 9.0357 | 9.0357 | 9.0357 | 9.0357 | 14000.0 |
| 2010-07-01 04:45:00 | AAPL | Stock | 9.05 | 9.05 | 9.05 | 9.05 | 16800.0 |
| 2010-07-01 05:00:00 | AAPL | Stock | 9.0532 | 9.0532 | 9.0532 | 9.0532 | 9408.0 |
| 2010-07-01 05:05:00 | AAPL | Stock | 9.0321 | 9.0321 | 9.0321 | 9.0321 | 2800.0 |
| 2010-07-01 06:25:00 | AAPL | Stock | 9.0686 | 9.0686 | 9.0686 | 9.0686 | 14000.0 |
| 2010-07-01 06:30:00 | AAPL | Stock | 9.0686 | 9.0686 | 9.0686 | 9.0686 | 12180.0 |
| 2010-07-01 06:35:00 | AAPL | Stock | 9.0614 | 9.0614 | 9.0614 | 9.0614 | 30800.0 |
| 2010-07-01 06:50:00 | AAPL | Stock | 9.0836 | 9.0907 | 9.0836 | 9.0907 | 9380.0 |
| 2010-07-01 06:55:00 | AAPL | Stock | 9.1079 | 9.1079 | 9.1079 | 9.1079 | 2800.0 |
| 2010-07-01 07:00:00 | AAPL | Stock | 9.1 | 9.1 | 9.0718 | 9.0718 | 44604.0 |
| 2010-07-01 07:05:00 | AAPL | Stock | 9.0554 | 9.0575 | 9.0464 | 9.0536 | 75600.0 |
| 2010-07-01 07:10:00 | AAPL | Stock | 9.0468 | 9.0468 | 9.0464 | 9.0464 | 83244.0 |
| 2010-07-01 07:15:00 | AAPL | Stock | 9.0461 | 9.0461 | 9.0461 | 9.0461 | 14000.0 |
| 2010-07-01 07:20:00 | AAPL | Stock | 9.05 | 9.0536 | 9.0493 | 9.05 | 67200.0 |
| 2010-07-01 07:25:00 | AAPL | Stock | 9.0536 | 9.0636 | 9.0396 | 9.0636 | 64456.0 |
| 2010-07-01 07:30:00 | AAPL | Stock | 9.05 | 9.05 | 8.9911 | 8.9911 | 129220.0 |
| 2010-07-01 07:35:00 | AAPL | Stock | 9.0004 | 9.0279 | 9.0004 | 9.0246 | 100268.0 |
| 2010-07-01 07:40:00 | AAPL | Stock | 9.035 | 9.0464 | 9.0325 | 9.0375 | 229852.0 |
| 2010-07-01 07:45:00 | AAPL | Stock | 9.0375 | 9.0536 | 9.0357 | 9.0529 | 145740.0 |
| 2010-07-01 07:50:00 | AAPL | Stock | 9.0529 | 9.0529 | 9.0268 | 9.0364 | 55888.0 |
| 2010-07-01 07:55:00 | AAPL | Stock | 9.0321 | 9.0336 | 9.0286 | 9.0336 | 30800.0 |
| 2010-07-01 08:00:00 | AAPL | Stock | 9.0286 | 9.0357 | 8.9832 | 9.0179 | 582232.0 |
| 2010-07-01 08:05:00 | AAPL | Stock | 9.0146 | 9.0246 | 9.0039 | 9.0179 | 372120.0 |
| 2010-07-01 08:10:00 | AAPL | Stock | 9.0175 | 9.025 | 9.0107 | 9.0139 | 354452.0 |
| 2010-07-01 08:15:00 | AAPL | Stock | 9.0161 | 9.0239 | 9.0114 | 9.0164 | 242620.0 |
| 2010-07-01 08:20:00 | AAPL | Stock | 9.0164 | 9.0196 | 9.015 | 9.0157 | 144060.0 |
| 2010-07-01 08:25:00 | AAPL | Stock | 9.0161 | 9.0239 | 9.0114 | 9.0239 | 441700.0 |
| 2010-07-01 08:30:00 | AAPL | Stock | 9.02 | 9.0236 | 8.9832 | 8.9982 | 2069732.0 |
| 2010-07-01 08:35:00 | AAPL | Stock | 8.9975 | 9.0 | 8.9907 | 8.9946 | 485548.0 |
| 2010-07-01 08:40:00 | AAPL | Stock | 8.9946 | 9.0089 | 8.9936 | 9.0079 | 388640.0 |
| 2010-07-01 08:45:00 | AAPL | Stock | 9.0068 | 9.0496 | 8.9832 | 9.0429 | 1327564.0 |
| 2010-07-01 08:50:00 | AAPL | Stock | 9.0457 | 9.0621 | 9.0089 | 9.0511 | 1880144.0 |
| 2010-07-01 08:55:00 | AAPL | Stock | 9.0536 | 9.0686 | 9.0468 | 9.0679 | 1029168.0 |
| 2010-07-01 09:00:00 | AAPL | Stock | 9.0686 | 9.0982 | 9.0643 | 9.0961 | 1291556.0 |
| 2010-07-01 09:05:00 | AAPL | Stock | 9.0961 | 9.1168 | 9.0893 | 9.1107 | 2264920.0 |
| 2010-07-01 09:10:00 | AAPL | Stock | 9.1107 | 9.1214 | 9.0982 | 9.1029 | 1108576.0 |
| 2010-07-01 09:15:00 | AAPL | Stock | 9.1004 | 9.1036 | 9.0843 | 9.0871 | 830816.0 |
| 2010-07-01 09:20:00 | AAPL | Stock | 9.0864 | 9.0929 | 9.0804 | 9.0929 | 466088.0 |
| 2010-07-01 09:25:00 | AAPL | Stock | 9.0914 | 9.1061 | 9.0768 | 9.0811 | 756336.0 |
| 2010-07-01 09:30:00 | AAPL | Stock | 9.0821 | 9.0929 | 9.0357 | 9.0632 | 26833128.0 |
| 2010-07-01 09:35:00 | AAPL | Stock | 9.063 | 9.1 | 9.0539 | 9.0693 | 26173560.0 |
| 2010-07-01 09:40:00 | AAPL | Stock | 9.0688 | 9.0714 | 9.0275 | 9.0439 | 18440548.0 |
| 2010-07-01 09:45:00 | AAPL | Stock | 9.0458 | 9.0478 | 8.9514 | 8.9596 | 28207536.0 |
| 2010-07-01 09:50:00 | AAPL | Stock | 8.9586 | 8.9746 | 8.9329 | 8.9539 | 28462644.0 |
| 2010-07-01 09:55:00 | AAPL | Stock | 8.9546 | 8.9732 | 8.935 | 8.9532 | 17780616.0 |
| 2010-07-01 10:00:00 | AAPL | Stock | 8.9532 | 8.9561 | 8.8429 | 8.8589 | 51258788.0 |
| 2010-07-01 10:05:00 | AAPL | Stock | 8.8593 | 8.9107 | 8.8504 | 8.9043 | 23886268.0 |
| 2010-07-01 10:10:00 | AAPL | Stock | 8.905 | 8.905 | 8.8115 | 8.8261 | 23800000.0 |
| 2010-07-01 10:15:00 | AAPL | Stock | 8.8261 | 8.8389 | 8.7929 | 8.8336 | 25587772.0 |
> showing 50 of 335,503 rows — these rows as CSV