PREVIEW / stock_5min / 2007-04-23
file: by_date/stock_5min/2007/2007-04-23.parquet size: 3.6 MB rows: 258,469 symbols: 2,592
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-23 05:05:00 | AAPL | Stock | 3.2607 | 3.2607 | 3.2607 | 3.2607 | 2800.0 |
| 2007-04-23 07:15:00 | AAPL | Stock | 3.25 | 3.25 | 3.25 | 3.25 | 2800.0 |
| 2007-04-23 07:30:00 | AAPL | Stock | 3.2571 | 3.2571 | 3.2571 | 3.2571 | 8400.0 |
| 2007-04-23 07:35:00 | AAPL | Stock | 3.26 | 3.2821 | 3.26 | 3.2789 | 259000.0 |
| 2007-04-23 07:40:00 | AAPL | Stock | 3.2771 | 3.285 | 3.2768 | 3.2768 | 331800.0 |
| 2007-04-23 07:45:00 | AAPL | Stock | 3.2718 | 3.2718 | 3.2714 | 3.2714 | 42000.0 |
| 2007-04-23 07:55:00 | AAPL | Stock | 3.2732 | 3.2732 | 3.2732 | 3.2732 | 28000.0 |
| 2007-04-23 08:00:00 | AAPL | Stock | 3.2761 | 3.2768 | 3.2661 | 3.2682 | 787640.0 |
| 2007-04-23 08:05:00 | AAPL | Stock | 3.2696 | 3.2754 | 3.2696 | 3.275 | 243796.0 |
| 2007-04-23 08:10:00 | AAPL | Stock | 3.275 | 3.2768 | 3.2729 | 3.2761 | 223440.0 |
| 2007-04-23 08:15:00 | AAPL | Stock | 3.2743 | 3.2768 | 3.2743 | 3.2768 | 168000.0 |
| 2007-04-23 08:20:00 | AAPL | Stock | 3.275 | 3.2768 | 3.275 | 3.2768 | 217952.0 |
| 2007-04-23 08:25:00 | AAPL | Stock | 3.2764 | 3.2768 | 3.2714 | 3.2729 | 151032.0 |
| 2007-04-23 08:30:00 | AAPL | Stock | 3.2732 | 3.2732 | 3.2714 | 3.2714 | 47600.0 |
| 2007-04-23 08:35:00 | AAPL | Stock | 3.2718 | 3.2732 | 3.2714 | 3.2732 | 252532.0 |
| 2007-04-23 08:40:00 | AAPL | Stock | 3.275 | 3.275 | 3.2743 | 3.2743 | 19600.0 |
| 2007-04-23 08:45:00 | AAPL | Stock | 3.2732 | 3.2743 | 3.2714 | 3.2714 | 144200.0 |
| 2007-04-23 08:50:00 | AAPL | Stock | 3.2714 | 3.2754 | 3.2714 | 3.2754 | 64400.0 |
| 2007-04-23 08:55:00 | AAPL | Stock | 3.2754 | 3.2754 | 3.2489 | 3.2696 | 118300.0 |
| 2007-04-23 09:00:00 | AAPL | Stock | 3.2686 | 3.2732 | 3.2682 | 3.2732 | 125468.0 |
| 2007-04-23 09:05:00 | AAPL | Stock | 3.27 | 3.2729 | 3.2696 | 3.2725 | 95620.0 |
| 2007-04-23 09:10:00 | AAPL | Stock | 3.2707 | 3.2746 | 3.2696 | 3.2696 | 358036.0 |
| 2007-04-23 09:15:00 | AAPL | Stock | 3.2732 | 3.2732 | 3.2707 | 3.2732 | 1515360.0 |
| 2007-04-23 09:20:00 | AAPL | Stock | 3.2732 | 3.2732 | 3.2675 | 3.2675 | 558180.0 |
| 2007-04-23 09:25:00 | AAPL | Stock | 3.2675 | 3.2714 | 3.2646 | 3.2714 | 1985116.0 |
| 2007-04-23 09:30:00 | AAPL | Stock | 3.2729 | 3.2739 | 3.2657 | 3.2668 | 21866320.0 |
| 2007-04-23 09:35:00 | AAPL | Stock | 3.2661 | 3.2857 | 3.265 | 3.2821 | 19124924.0 |
| 2007-04-23 09:40:00 | AAPL | Stock | 3.2821 | 3.2929 | 3.2793 | 3.2872 | 25362624.0 |
| 2007-04-23 09:45:00 | AAPL | Stock | 3.2875 | 3.3036 | 3.2857 | 3.3014 | 20582968.0 |
| 2007-04-23 09:50:00 | AAPL | Stock | 3.3018 | 3.3132 | 3.3011 | 3.3064 | 28347536.0 |
| 2007-04-23 09:55:00 | AAPL | Stock | 3.3064 | 3.3129 | 3.3064 | 3.3082 | 11366068.0 |
| 2007-04-23 10:00:00 | AAPL | Stock | 3.3086 | 3.3093 | 3.2979 | 3.3 | 19836992.0 |
| 2007-04-23 10:05:00 | AAPL | Stock | 3.2999 | 3.3057 | 3.2982 | 3.3019 | 12945548.0 |
| 2007-04-23 10:10:00 | AAPL | Stock | 3.3018 | 3.3036 | 3.2957 | 3.3014 | 9439360.0 |
| 2007-04-23 10:15:00 | AAPL | Stock | 3.3014 | 3.3039 | 3.2982 | 3.3004 | 11112080.0 |
| 2007-04-23 10:20:00 | AAPL | Stock | 3.3003 | 3.3004 | 3.2929 | 3.2968 | 8208312.0 |
| 2007-04-23 10:25:00 | AAPL | Stock | 3.2971 | 3.3014 | 3.2709 | 3.3009 | 6318368.0 |
| 2007-04-23 10:30:00 | AAPL | Stock | 3.3007 | 3.3071 | 3.3 | 3.3064 | 11417672.0 |
| 2007-04-23 10:35:00 | AAPL | Stock | 3.3064 | 3.3071 | 3.3036 | 3.3071 | 7216524.0 |
| 2007-04-23 10:40:00 | AAPL | Stock | 3.3071 | 3.31 | 3.3021 | 3.3021 | 8918980.0 |
| 2007-04-23 10:45:00 | AAPL | Stock | 3.3018 | 3.3079 | 3.3018 | 3.3067 | 7174216.0 |
| 2007-04-23 10:50:00 | AAPL | Stock | 3.3068 | 3.3089 | 3.3043 | 3.3082 | 6935096.0 |
| 2007-04-23 10:55:00 | AAPL | Stock | 3.3089 | 3.3125 | 3.3071 | 3.3104 | 11347000.0 |
| 2007-04-23 11:00:00 | AAPL | Stock | 3.3104 | 3.3125 | 3.3089 | 3.3119 | 9815064.0 |
| 2007-04-23 11:05:00 | AAPL | Stock | 3.3118 | 3.3146 | 3.3089 | 3.3096 | 12040028.0 |
| 2007-04-23 11:10:00 | AAPL | Stock | 3.3096 | 3.3139 | 3.3075 | 3.3125 | 7437248.0 |
| 2007-04-23 11:15:00 | AAPL | Stock | 3.3127 | 3.3179 | 3.3114 | 3.3179 | 7430444.0 |
| 2007-04-23 11:20:00 | AAPL | Stock | 3.3175 | 3.3304 | 3.3157 | 3.3286 | 17242960.0 |
| 2007-04-23 11:25:00 | AAPL | Stock | 3.3289 | 3.3289 | 3.3239 | 3.3261 | 13360172.0 |
| 2007-04-23 11:30:00 | AAPL | Stock | 3.3264 | 3.3268 | 3.3193 | 3.3264 | 11173960.0 |
> showing 50 of 258,469 rows — these rows as CSV