PREVIEW / stock_5min / 2008-10-08
file: by_date/stock_5min/2008/2008-10-08.parquet size: 5.0 MB rows: 344,471 symbols: 3,384
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-08 04:15:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.0214 | 3.0214 | 25200.0 |
| 2008-10-08 04:20:00 | AAPL | Stock | 3.0357 | 3.05 | 3.0357 | 3.05 | 42000.0 |
| 2008-10-08 04:25:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 14000.0 |
| 2008-10-08 04:30:00 | AAPL | Stock | 3.0464 | 3.0464 | 3.0464 | 3.0464 | 14000.0 |
| 2008-10-08 04:50:00 | AAPL | Stock | 3.0446 | 3.0464 | 3.0446 | 3.0464 | 30800.0 |
| 2008-10-08 04:55:00 | AAPL | Stock | 3.0464 | 3.0532 | 3.0461 | 3.0532 | 8680.0 |
| 2008-10-08 05:00:00 | AAPL | Stock | 3.0529 | 3.0532 | 3.0529 | 3.0532 | 8400.0 |
| 2008-10-08 05:10:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 9800.0 |
| 2008-10-08 05:15:00 | AAPL | Stock | 3.0607 | 3.0643 | 3.0607 | 3.0643 | 9660.0 |
| 2008-10-08 05:50:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2008-10-08 06:00:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-10-08 06:10:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2008-10-08 06:15:00 | AAPL | Stock | 3.0536 | 3.0643 | 3.0536 | 3.0643 | 25200.0 |
| 2008-10-08 06:20:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0679 | 3.0679 | 8400.0 |
| 2008-10-08 06:25:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 14000.0 |
| 2008-10-08 06:30:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 11200.0 |
| 2008-10-08 06:35:00 | AAPL | Stock | 3.0786 | 3.1 | 3.0786 | 3.1 | 55188.0 |
| 2008-10-08 06:40:00 | AAPL | Stock | 3.1 | 3.1071 | 3.1 | 3.1071 | 86800.0 |
| 2008-10-08 06:50:00 | AAPL | Stock | 3.1 | 3.1 | 3.1 | 3.1 | 47600.0 |
| 2008-10-08 06:55:00 | AAPL | Stock | 3.1 | 3.1 | 3.1 | 3.1 | 53480.0 |
| 2008-10-08 07:00:00 | AAPL | Stock | 3.1214 | 3.3071 | 3.1214 | 3.2982 | 630812.0 |
| 2008-10-08 07:05:00 | AAPL | Stock | 3.2982 | 3.2982 | 3.25 | 3.25 | 143024.0 |
| 2008-10-08 07:10:00 | AAPL | Stock | 3.2504 | 3.2618 | 3.2182 | 3.2411 | 482524.0 |
| 2008-10-08 07:15:00 | AAPL | Stock | 3.2343 | 3.2607 | 3.2239 | 3.225 | 380548.0 |
| 2008-10-08 07:20:00 | AAPL | Stock | 3.2332 | 3.2571 | 3.2332 | 3.25 | 185556.0 |
| 2008-10-08 07:25:00 | AAPL | Stock | 3.2411 | 3.2761 | 3.2411 | 3.2761 | 98952.0 |
| 2008-10-08 07:30:00 | AAPL | Stock | 3.2768 | 3.2982 | 3.2732 | 3.2857 | 267904.0 |
| 2008-10-08 07:35:00 | AAPL | Stock | 3.2893 | 3.2893 | 3.2857 | 3.2875 | 88788.0 |
| 2008-10-08 07:40:00 | AAPL | Stock | 3.2954 | 3.2954 | 3.25 | 3.2857 | 216244.0 |
| 2008-10-08 07:45:00 | AAPL | Stock | 3.275 | 3.2836 | 3.2607 | 3.2625 | 152432.0 |
| 2008-10-08 07:50:00 | AAPL | Stock | 3.27 | 3.2907 | 3.25 | 3.2679 | 290388.0 |
| 2008-10-08 07:55:00 | AAPL | Stock | 3.2714 | 3.2875 | 3.2618 | 3.2814 | 80360.0 |
| 2008-10-08 08:00:00 | AAPL | Stock | 3.2775 | 3.3214 | 3.25 | 3.2946 | 1549940.0 |
| 2008-10-08 08:05:00 | AAPL | Stock | 3.2964 | 3.3036 | 3.2857 | 3.2886 | 567252.0 |
| 2008-10-08 08:10:00 | AAPL | Stock | 3.2875 | 3.2893 | 3.2596 | 3.2664 | 449764.0 |
| 2008-10-08 08:15:00 | AAPL | Stock | 3.2668 | 3.2793 | 3.2539 | 3.2539 | 666512.0 |
| 2008-10-08 08:20:00 | AAPL | Stock | 3.2546 | 3.2579 | 3.2429 | 3.2429 | 440496.0 |
| 2008-10-08 08:25:00 | AAPL | Stock | 3.2411 | 3.2429 | 3.2061 | 3.2143 | 1220744.0 |
| 2008-10-08 08:30:00 | AAPL | Stock | 3.2121 | 3.2418 | 3.2118 | 3.2143 | 1198540.0 |
| 2008-10-08 08:35:00 | AAPL | Stock | 3.2143 | 3.2146 | 3.1625 | 3.1714 | 1128540.0 |
| 2008-10-08 08:40:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1132 | 3.125 | 1176532.0 |
| 2008-10-08 08:45:00 | AAPL | Stock | 3.1286 | 3.1429 | 3.0579 | 3.0839 | 1671936.0 |
| 2008-10-08 08:50:00 | AAPL | Stock | 3.0871 | 3.1075 | 3.0714 | 3.1071 | 1232504.0 |
| 2008-10-08 08:55:00 | AAPL | Stock | 3.1061 | 3.1193 | 3.0982 | 3.0982 | 633136.0 |
| 2008-10-08 09:00:00 | AAPL | Stock | 3.0957 | 3.1107 | 3.0832 | 3.1107 | 600572.0 |
| 2008-10-08 09:05:00 | AAPL | Stock | 3.1111 | 3.1111 | 3.0714 | 3.075 | 1165556.0 |
| 2008-10-08 09:10:00 | AAPL | Stock | 3.075 | 3.085 | 3.0411 | 3.0579 | 2180808.0 |
| 2008-10-08 09:15:00 | AAPL | Stock | 3.0579 | 3.0718 | 3.0554 | 3.0714 | 891100.0 |
| 2008-10-08 09:20:00 | AAPL | Stock | 3.0714 | 3.1057 | 3.0714 | 3.0989 | 735868.0 |
| 2008-10-08 09:25:00 | AAPL | Stock | 3.0989 | 3.1175 | 3.05 | 3.0714 | 1767276.0 |
> showing 50 of 344,471 rows — these rows as CSV