PREVIEW / stock_5min / 2007-08-17

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-08-17.parquet
  size:    4.4 MB
  rows:    314,962
  symbols: 3,145

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-08-17 09:30:00	AAPL	Stock	4.3575	4.3929	4.3311	4.3814	102145904.0
2007-08-17 09:35:00	AAPL	Stock	4.3807	4.3929	4.35	4.3925	32908176.0
2007-08-17 09:40:00	AAPL	Stock	4.3925	4.3964	4.3525	4.3634	29518496.0
2007-08-17 09:45:00	AAPL	Stock	4.3629	4.3637	4.3121	4.3304	33093452.0
2007-08-17 09:50:00	AAPL	Stock	4.3314	4.335	4.3032	4.3114	23771608.0
2007-08-17 09:55:00	AAPL	Stock	4.3096	4.3257	4.2936	4.3068	23673804.0
2007-08-17 10:00:00	AAPL	Stock	4.3068	4.3121	4.2857	4.3093	18560248.0
2007-08-17 10:05:00	AAPL	Stock	4.3089	4.3389	4.3044	4.3296	22386756.0
2007-08-17 10:10:00	AAPL	Stock	4.33	4.335	4.3125	4.3214	18967116.0
2007-08-17 10:15:00	AAPL	Stock	4.3214	4.3354	4.3032	4.3104	25324096.0
2007-08-17 10:20:00	AAPL	Stock	4.31	4.3179	4.2964	4.3079	17069948.0
2007-08-17 10:25:00	AAPL	Stock	4.3079	4.3171	4.2996	4.3104	14236236.0
2007-08-17 10:30:00	AAPL	Stock	4.3104	4.3311	4.3025	4.3186	18893728.0
2007-08-17 10:35:00	AAPL	Stock	4.3186	4.3343	4.3125	4.3225	17997644.0
2007-08-17 10:40:00	AAPL	Stock	4.3229	4.3229	4.2871	4.2882	16230088.0
2007-08-17 10:45:00	AAPL	Stock	4.2882	4.3021	4.2811	4.2818	15750448.0
2007-08-17 10:50:00	AAPL	Stock	4.2814	4.325	4.2793	4.3136	21019544.0
2007-08-17 10:55:00	AAPL	Stock	4.3125	4.3225	4.3021	4.3029	14736540.0
2007-08-17 11:00:00	AAPL	Stock	4.3039	4.3204	4.2925	4.3056	14011760.0
2007-08-17 11:05:00	AAPL	Stock	4.305	4.3182	4.2907	4.2996	10367756.0
2007-08-17 11:10:00	AAPL	Stock	4.3004	4.3129	4.2886	4.3125	10338076.0
2007-08-17 11:15:00	AAPL	Stock	4.3129	4.3168	4.2911	4.3029	10104808.0
2007-08-17 11:20:00	AAPL	Stock	4.3032	4.3096	4.2968	4.3046	6936748.0
2007-08-17 11:25:00	AAPL	Stock	4.3054	4.3164	4.3039	4.3111	5448800.0
2007-08-17 11:30:00	AAPL	Stock	4.3107	4.3143	4.3011	4.3096	6337940.0
2007-08-17 11:35:00	AAPL	Stock	4.3096	4.3361	4.3086	4.3257	13706952.0
2007-08-17 11:40:00	AAPL	Stock	4.325	4.3339	4.315	4.3325	11226768.0
2007-08-17 11:45:00	AAPL	Stock	4.3318	4.3354	4.3232	4.3268	8466836.0
2007-08-17 11:50:00	AAPL	Stock	4.3268	4.3389	4.3268	4.33	8317624.0
2007-08-17 11:55:00	AAPL	Stock	4.3305	4.3354	4.3193	4.3229	8715504.0
2007-08-17 12:00:00	AAPL	Stock	4.3236	4.3304	4.315	4.3193	8998024.0
2007-08-17 12:05:00	AAPL	Stock	4.3193	4.3282	4.3143	4.3164	8674512.0
2007-08-17 12:10:00	AAPL	Stock	4.3161	4.3269	4.3146	4.3268	5240984.0
2007-08-17 12:15:00	AAPL	Stock	4.3268	4.3311	4.3179	4.3239	7295960.0
2007-08-17 12:20:00	AAPL	Stock	4.3246	4.3311	4.3201	4.325	5064192.0
2007-08-17 12:25:00	AAPL	Stock	4.325	4.3286	4.3179	4.325	4415460.0
2007-08-17 12:30:00	AAPL	Stock	4.3246	4.3357	4.3225	4.3304	5565448.0
2007-08-17 12:35:00	AAPL	Stock	4.3307	4.3346	4.3229	4.3236	6547632.0
2007-08-17 12:40:00	AAPL	Stock	4.3229	4.33	4.3204	4.3275	4662952.0
2007-08-17 12:45:00	AAPL	Stock	4.3271	4.3304	4.3243	4.3275	3500056.0
2007-08-17 12:50:00	AAPL	Stock	4.3264	4.3275	4.3196	4.3232	5741428.0
2007-08-17 12:55:00	AAPL	Stock	4.3232	4.325	4.3171	4.3204	5429256.0
2007-08-17 13:00:00	AAPL	Stock	4.3214	4.3286	4.3207	4.3286	5652724.0
2007-08-17 13:05:00	AAPL	Stock	4.3285	4.3321	4.3254	4.3314	7309092.0
2007-08-17 13:10:00	AAPL	Stock	4.332	4.3485	4.3311	4.3464	14353696.0
2007-08-17 13:15:00	AAPL	Stock	4.3461	4.3561	4.3454	4.3525	11378500.0
2007-08-17 13:20:00	AAPL	Stock	4.3521	4.3725	4.3521	4.3571	17086384.0
2007-08-17 13:25:00	AAPL	Stock	4.3564	4.3607	4.3504	4.3518	8541036.0
2007-08-17 13:30:00	AAPL	Stock	4.3511	4.36	4.3493	4.3575	5911724.0
2007-08-17 13:35:00	AAPL	Stock	4.3571	4.3618	4.3521	4.3586	6843424.0

> showing 50 of 314,962 rows — these rows as CSV

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