PREVIEW / stock_5min / 2007-06-27

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-06-27.parquet
  size:    4.1 MB
  rows:    295,858
  symbols: 3,050

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-06-27 09:30:00	AAPL	Stock	4.3075	4.31	4.2746	4.2857	33643316.0
2007-06-27 09:35:00	AAPL	Stock	4.2857	4.3161	4.2843	4.3064	36779232.0
2007-06-27 09:40:00	AAPL	Stock	4.3057	4.3243	4.3	4.3107	29572060.0
2007-06-27 09:45:00	AAPL	Stock	4.3114	4.3229	4.3107	4.3189	19101824.0
2007-06-27 09:50:00	AAPL	Stock	4.3189	4.3375	4.3164	4.3293	24681048.0
2007-06-27 09:55:00	AAPL	Stock	4.3293	4.3314	4.3007	4.305	25238500.0
2007-06-27 10:00:00	AAPL	Stock	4.3046	4.3071	4.2918	4.3014	17617740.0
2007-06-27 10:05:00	AAPL	Stock	4.3011	4.3121	4.2936	4.2996	17842468.0
2007-06-27 10:10:00	AAPL	Stock	4.3	4.3018	4.2732	4.2793	23993732.0
2007-06-27 10:15:00	AAPL	Stock	4.2793	4.2907	4.2704	4.2746	19983432.0
2007-06-27 10:20:00	AAPL	Stock	4.2743	4.2793	4.2625	4.2661	19658996.0
2007-06-27 10:25:00	AAPL	Stock	4.2661	4.2857	4.2593	4.2729	20932576.0
2007-06-27 10:30:00	AAPL	Stock	4.2725	4.2979	4.2707	4.2964	19652948.0
2007-06-27 10:35:00	AAPL	Stock	4.2968	4.3	4.2754	4.2821	16234596.0
2007-06-27 10:40:00	AAPL	Stock	4.2828	4.2861	4.2736	4.275	9868572.0
2007-06-27 10:45:00	AAPL	Stock	4.2761	4.2761	4.2604	4.264	10971044.0
2007-06-27 10:50:00	AAPL	Stock	4.2643	4.2786	4.2625	4.2754	10622920.0
2007-06-27 10:55:00	AAPL	Stock	4.275	4.2864	4.2739	4.2796	10227616.0
2007-06-27 11:00:00	AAPL	Stock	4.2796	4.2929	4.2679	4.2904	13610912.0
2007-06-27 11:05:00	AAPL	Stock	4.2907	4.3025	4.2889	4.3025	16417576.0
2007-06-27 11:10:00	AAPL	Stock	4.3018	4.3214	4.297	4.3107	19710516.0
2007-06-27 11:15:00	AAPL	Stock	4.3104	4.3214	4.3086	4.3121	18679920.0
2007-06-27 11:20:00	AAPL	Stock	4.3121	4.3157	4.3014	4.305	8394344.0
2007-06-27 11:25:00	AAPL	Stock	4.3046	4.3086	4.3039	4.3057	5403160.0
2007-06-27 11:30:00	AAPL	Stock	4.3064	4.3068	4.2975	4.2975	7313908.0
2007-06-27 11:35:00	AAPL	Stock	4.2975	4.3011	4.2914	4.2993	7797048.0
2007-06-27 11:40:00	AAPL	Stock	4.2993	4.3025	4.2921	4.2971	7402948.0
2007-06-27 11:45:00	AAPL	Stock	4.2964	4.3007	4.2954	4.2986	4124932.0
2007-06-27 11:50:00	AAPL	Stock	4.2979	4.3	4.2907	4.2946	6291824.0
2007-06-27 11:55:00	AAPL	Stock	4.2946	4.2996	4.2929	4.2939	4599700.0
2007-06-27 12:00:00	AAPL	Stock	4.2936	4.3046	4.2936	4.3029	9673496.0
2007-06-27 12:05:00	AAPL	Stock	4.3025	4.3125	4.3014	4.31	7958664.0
2007-06-27 12:10:00	AAPL	Stock	4.31	4.3104	4.2982	4.3014	4899972.0
2007-06-27 12:15:00	AAPL	Stock	4.3018	4.3021	4.295	4.2975	5081440.0
2007-06-27 12:20:00	AAPL	Stock	4.2975	4.3018	4.2954	4.3	3535112.0
2007-06-27 12:25:00	AAPL	Stock	4.3	4.3032	4.2946	4.3029	5787992.0
2007-06-27 12:30:00	AAPL	Stock	4.3025	4.3025	4.2968	4.2971	4432148.0
2007-06-27 12:35:00	AAPL	Stock	4.2968	4.3089	4.2961	4.3079	7494172.0
2007-06-27 12:40:00	AAPL	Stock	4.3079	4.3079	4.2982	4.3039	3827768.0
2007-06-27 12:45:00	AAPL	Stock	4.3039	4.3089	4.3007	4.3021	3733492.0
2007-06-27 12:50:00	AAPL	Stock	4.3025	4.3086	4.3004	4.3057	3236772.0
2007-06-27 12:55:00	AAPL	Stock	4.3066	4.3107	4.3057	4.31	3479840.0
2007-06-27 13:00:00	AAPL	Stock	4.3104	4.3179	4.3096	4.3154	6237112.0
2007-06-27 13:05:00	AAPL	Stock	4.3157	4.3175	4.3082	4.3096	5298356.0
2007-06-27 13:10:00	AAPL	Stock	4.3089	4.3096	4.3011	4.3036	5889184.0
2007-06-27 13:15:00	AAPL	Stock	4.3039	4.3057	4.3014	4.3043	4472412.0
2007-06-27 13:20:00	AAPL	Stock	4.3043	4.31	4.3043	4.307	4873988.0
2007-06-27 13:25:00	AAPL	Stock	4.307	4.3143	4.3054	4.3064	3707312.0
2007-06-27 13:30:00	AAPL	Stock	4.3064	4.3075	4.3007	4.3014	5873448.0
2007-06-27 13:35:00	AAPL	Stock	4.3016	4.3071	4.3011	4.3043	5770828.0

> showing 50 of 295,858 rows — these rows as CSV

> unlock the full archive -- $79 one-time