PREVIEW / stock_5min / 2010-09-30
file: by_date/stock_5min/2010/2010-09-30.parquet size: 4.8 MB rows: 327,767 symbols: 3,495
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-09-30 04:20:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-30 07:40:00 | AAPL | Stock | 10.2611 | 10.2611 | 10.2589 | 10.2589 | 9856.0 |
| 2010-09-30 08:00:00 | AAPL | Stock | 10.2586 | 10.2586 | 10.2475 | 10.2475 | 16940.0 |
| 2010-09-30 08:05:00 | AAPL | Stock | 10.2579 | 10.2589 | 10.2475 | 10.2589 | 94080.0 |
| 2010-09-30 08:10:00 | AAPL | Stock | 10.2579 | 10.2671 | 10.2571 | 10.2671 | 90440.0 |
| 2010-09-30 08:15:00 | AAPL | Stock | 10.2668 | 10.2668 | 10.2607 | 10.2611 | 105000.0 |
| 2010-09-30 08:20:00 | AAPL | Stock | 10.2664 | 10.2796 | 10.2643 | 10.2732 | 350560.0 |
| 2010-09-30 08:25:00 | AAPL | Stock | 10.2739 | 10.275 | 10.2643 | 10.2643 | 131124.0 |
| 2010-09-30 08:30:00 | AAPL | Stock | 10.2679 | 10.3143 | 10.2679 | 10.3093 | 1451632.0 |
| 2010-09-30 08:35:00 | AAPL | Stock | 10.3093 | 10.3282 | 10.3093 | 10.3161 | 632408.0 |
| 2010-09-30 08:40:00 | AAPL | Stock | 10.3161 | 10.3204 | 10.3036 | 10.3204 | 96460.0 |
| 2010-09-30 08:45:00 | AAPL | Stock | 10.3179 | 10.3211 | 10.3129 | 10.3143 | 225316.0 |
| 2010-09-30 08:50:00 | AAPL | Stock | 10.3157 | 10.3171 | 10.3054 | 10.3064 | 165984.0 |
| 2010-09-30 08:55:00 | AAPL | Stock | 10.3079 | 10.3093 | 10.3004 | 10.3071 | 167104.0 |
| 2010-09-30 09:00:00 | AAPL | Stock | 10.3125 | 10.3304 | 10.3118 | 10.3304 | 353920.0 |
| 2010-09-30 09:05:00 | AAPL | Stock | 10.3304 | 10.3332 | 10.3264 | 10.3289 | 285600.0 |
| 2010-09-30 09:10:00 | AAPL | Stock | 10.3293 | 10.3304 | 10.3161 | 10.3179 | 330064.0 |
| 2010-09-30 09:15:00 | AAPL | Stock | 10.3179 | 10.3229 | 10.3164 | 10.3179 | 68460.0 |
| 2010-09-30 09:20:00 | AAPL | Stock | 10.3182 | 10.3214 | 10.3161 | 10.3214 | 97328.0 |
| 2010-09-30 09:25:00 | AAPL | Stock | 10.3214 | 10.3354 | 10.3179 | 10.3268 | 703920.0 |
| 2010-09-30 09:30:00 | AAPL | Stock | 10.3218 | 10.3571 | 10.3179 | 10.3389 | 18172112.0 |
| 2010-09-30 09:35:00 | AAPL | Stock | 10.3375 | 10.3407 | 10.2929 | 10.2986 | 15431724.0 |
| 2010-09-30 09:40:00 | AAPL | Stock | 10.2979 | 10.3357 | 10.2786 | 10.3125 | 16655800.0 |
| 2010-09-30 09:45:00 | AAPL | Stock | 10.3139 | 10.3275 | 10.2857 | 10.3036 | 11814852.0 |
| 2010-09-30 09:50:00 | AAPL | Stock | 10.3037 | 10.3114 | 10.2829 | 10.3107 | 13426616.0 |
| 2010-09-30 09:55:00 | AAPL | Stock | 10.3114 | 10.3214 | 10.3061 | 10.3146 | 13585852.0 |
| 2010-09-30 10:00:00 | AAPL | Stock | 10.3136 | 10.3179 | 10.2871 | 10.305 | 11654272.0 |
| 2010-09-30 10:05:00 | AAPL | Stock | 10.305 | 10.3196 | 10.3021 | 10.3079 | 7020636.0 |
| 2010-09-30 10:10:00 | AAPL | Stock | 10.3079 | 10.3114 | 10.2857 | 10.2971 | 11412436.0 |
| 2010-09-30 10:15:00 | AAPL | Stock | 10.2965 | 10.3107 | 10.2886 | 10.2957 | 6452124.0 |
| 2010-09-30 10:20:00 | AAPL | Stock | 10.2957 | 10.3021 | 10.2679 | 10.2771 | 12098884.0 |
| 2010-09-30 10:25:00 | AAPL | Stock | 10.2757 | 10.2886 | 10.2661 | 10.2807 | 6720896.0 |
| 2010-09-30 10:30:00 | AAPL | Stock | 10.2804 | 10.2925 | 10.2789 | 10.2875 | 6862660.0 |
| 2010-09-30 10:35:00 | AAPL | Stock | 10.2879 | 10.2921 | 10.2693 | 10.2707 | 5460364.0 |
| 2010-09-30 10:40:00 | AAPL | Stock | 10.2696 | 10.2921 | 10.2679 | 10.2807 | 3555944.0 |
| 2010-09-30 10:45:00 | AAPL | Stock | 10.2821 | 10.2821 | 10.2507 | 10.2572 | 9955232.0 |
| 2010-09-30 10:50:00 | AAPL | Stock | 10.2571 | 10.28 | 10.2454 | 10.2457 | 6900824.0 |
| 2010-09-30 10:55:00 | AAPL | Stock | 10.2475 | 10.2546 | 10.2246 | 10.225 | 8890952.0 |
| 2010-09-30 11:00:00 | AAPL | Stock | 10.2243 | 10.2245 | 10.1857 | 10.2018 | 16349032.0 |
| 2010-09-30 11:05:00 | AAPL | Stock | 10.2014 | 10.2039 | 10.1489 | 10.1629 | 16676072.0 |
| 2010-09-30 11:10:00 | AAPL | Stock | 10.1607 | 10.1675 | 10.1193 | 10.1243 | 16843568.0 |
| 2010-09-30 11:15:00 | AAPL | Stock | 10.1244 | 10.1244 | 10.0771 | 10.1129 | 24826256.0 |
| 2010-09-30 11:20:00 | AAPL | Stock | 10.1125 | 10.1304 | 10.0446 | 10.0596 | 23832676.0 |
| 2010-09-30 11:25:00 | AAPL | Stock | 10.0596 | 10.1071 | 10.0489 | 10.0932 | 21401940.0 |
| 2010-09-30 11:30:00 | AAPL | Stock | 10.0932 | 10.1104 | 10.0807 | 10.0964 | 11076744.0 |
| 2010-09-30 11:35:00 | AAPL | Stock | 10.095 | 10.1214 | 10.0721 | 10.1107 | 11804548.0 |
| 2010-09-30 11:40:00 | AAPL | Stock | 10.1107 | 10.1304 | 10.1018 | 10.1286 | 8416408.0 |
| 2010-09-30 11:45:00 | AAPL | Stock | 10.1293 | 10.1474 | 10.1232 | 10.1443 | 8904364.0 |
| 2010-09-30 11:50:00 | AAPL | Stock | 10.1446 | 10.1607 | 10.1432 | 10.1507 | 14080892.0 |
| 2010-09-30 11:55:00 | AAPL | Stock | 10.1507 | 10.1554 | 10.1421 | 10.1514 | 8298472.0 |
> showing 50 of 327,767 rows — these rows as CSV